ASP.NET MVC Archives - 12 중 8 번째 페이지

[C#/ASP.NET MVC/.NETCORE] EntityFrameworkServiceCollectionExtensions 클래스 : AddDbContext 확장 메소드를 사용해 DB 컨텍스트를 서비스로 등록하기

■ EntityFrameworkServiceCollectionExtensions 클래스의 AddDbContext 확장 메소드를 사용해 DB 컨텍스트를 서비스로 등록하는 방법을 보여준다. ▶ Startup.cs


using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;

using TestProject.Data;

namespace TestProject
{
    /// <summary>
    /// 시작
    /// </summary>
    public class Startup
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 구성 - Configuration

        /// <summary>
        /// 구성
        /// </summary>
        public IConfiguration Configuration { get; }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - Startup(configuration)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="configuration">구성</param>
        public Startup(IConfiguration configuration)
        {
            Configuration = configuration;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 서비스 컬렉션 구성하기 - ConfigureServices(services)

        /// <summary>
        /// 서비스 컬렉션 구성하기
        /// </summary>
        /// <param name="services">서비스 컬렉션</param>
        public void ConfigureServices(IServiceCollection services)
        {
            services.AddDbContext<DatabaseContext>(options => options.UseInMemoryDatabase("TestDB"));

            services.AddControllers();
        }

        #endregion
        #region 구성하기 - Configure(app, environment)

        /// <summary>
        /// 구성하기
        /// </summary>
        /// <param name="app">애플리케이션 빌더</param>
        /// <param name="environment">웹 호스트 환경</param>
        public void Configure(IApplicationBuilder app, IWebHostEnvironment environment)
        {
            if(environment.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
            }

            app.UseHttpsRedirection();

            app.UseRouting();

            app.UseAuthorization();

            app.UseEndpoints
            (
                endpointRouterBuilder =>
                {
                    endpointRouterBuilder.MapControllers();
                }
            );
        }

        #endregion
    }
}

using Microsoft.AspNetCore.Builder;

using Microsoft.AspNetCore.Hosting;

using Microsoft.EntityFrameworkCore;

using Microsoft.Extensions.Configuration;

using Microsoft.Extensions.DependencyInjection;

using Microsoft.Extensions.Hosting;

using TestProject.Data;

namespace TestProject

{

/// <summary>

/// 시작

/// </summary>

public class Startup

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 구성 - Configuration

/// <summary>

/// 구성

/// </summary>

public IConfiguration Configuration { get; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - Startup(configuration)

/// <summary>

/// 생성자

/// </summary>

/// <param name="configuration">구성</param>

public Startup(IConfiguration configuration)

{

Configuration = configuration;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 서비스 컬렉션 구성하기 - ConfigureServices(services)

/// <summary>

/// 서비스 컬렉션 구성하기

/// </summary>

/// <param name="services">서비스 컬렉션</param>

public void ConfigureServices(IServiceCollection services)

{

services.AddDbContext<DatabaseContext>(options => options.UseInMemoryDatabase("TestDB"));

services.AddControllers();

}

#endregion

#region 구성하기 - Configure(app, environment)

/// <summary>

/// 구성하기

/// </summary>

/// <param name="app">애플리케이션 빌더</param>

/// <param name="environment">웹 호스트 환경</param>

public void Configure(IApplicationBuilder app, IWebHostEnvironment environment)

{

if(environment.IsDevelopment())

{

app.UseDeveloperExceptionPage();

}

app.UseHttpsRedirection();

app.UseRouting();

app.UseAuthorization();

app.UseEndpoints

(

endpointRouterBuilder =>

{

endpointRouterBuilder.MapControllers();

}

);

}

#endregion

}

[C#/ASP.NET MVC/.NETCORE] WebHostBuilderExtensions 클래스 : UseStartup 확장 메소드를 사용해 웹 호스트에 의해 사용되는 시작 타입 설정하기

■ WebHostBuilderExtensions 클래스의 UseStartup 확장 메소드를 사용해 웹 호스트에 의해 사용되는 시작 타입을 설정하는 방법을 보여준다. ▶ Program.cs


using Microsoft.AspNetCore.Hosting;
using Microsoft.Extensions.Hosting;

namespace TestProject
{
    /// <summary>
    /// 프로그램
    /// </summary>
    public class Program
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Static
        //////////////////////////////////////////////////////////////////////////////// Public

        #region 프로그램 시작하기 - Main(argumentArray)

        /// <summary>
        /// 프로그램 시작하기
        /// </summary>
        /// <param name="argumentArray">인자 배열</param>
        public static void Main(string[] argumentArray)
        {
            CreateHostBuilder(argumentArray).Build().Run();
        }

        #endregion
        #region 호스트 빌더 생성하기 - CreateHostBuilder(argumentArray)

        /// <summary>
        /// 호스트 빌더 생성하기
        /// </summary>
        /// <param name="argumentArray">인자 배열</param>
        /// <returns>호스트 빌더</returns>
        public static IHostBuilder CreateHostBuilder(string[] argumentArray) =>
            Host.CreateDefaultBuilder(argumentArray)
                .ConfigureWebHostDefaults(builder => { builder.UseStartup<Startup>(); });

        #endregion
    }
}

using Microsoft.AspNetCore.Hosting;

using Microsoft.Extensions.Hosting;

namespace TestProject

{

/// <summary>

/// 프로그램

/// </summary>

public class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Public

#region 프로그램 시작하기 - Main(argumentArray)

/// <summary>

/// 프로그램 시작하기

/// </summary>

/// <param name="argumentArray">인자 배열</param>

public static void Main(string[] argumentArray)

{

CreateHostBuilder(argumentArray).Build().Run();

}

#endregion

#region 호스트 빌더 생성하기 - CreateHostBuilder(argumentArray)

/// <summary>

/// 호스트 빌더 생성하기

/// </summary>

/// <param name="argumentArray">인자 배열</param>

/// <returns>호스트 빌더</returns>

public static IHostBuilder CreateHostBuilder(string[] argumentArray) =>

Host.CreateDefaultBuilder(argumentArray)

.ConfigureWebHostDefaults(builder => { builder.UseStartup<Startup>(); });

#endregion

}

[C#/ASP.NET MVC/.NETCORE] Entity Framework Core를 사용해 인메모리 데이터베이스 접속하기

■ Entity Framework Core를 사용해 인메모리 데이터베이스를 접속하는 방법을 보여준다. ▶ Models/TestModel.cs


namespace TestProject.Models
{
    /// <summary>
    /// 테스트 모델
    /// </summary>
    public class TestModel
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region ID - ID

        /// <summary>
        /// ID
        /// </summary>
        public long ID { get; set; }

        #endregion
        #region 제목 - Name

        /// <summary>
        /// 제목
        /// </summary>
        public string Name { get; set; }

        #endregion
    }
}

namespace TestProject.Models

{

/// <summary>

/// 테스트 모델

/// </summary>

public class TestModel

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public long ID { get; set; }

#endregion

#region 제목 - Name

/// <summary>

/// 제목

/// </summary>

public string Name { get; set; }

#endregion

}

▶ Models/TestData.cs


using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using System;
using System.Linq;

using TestProject.Data;

namespace TestProject.Models
{
    /// <summary>
    /// 테스트 데이터
    /// </summary>
    public static class TestData
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Static
        //////////////////////////////////////////////////////////////////////////////// Public

        #region 초기화하기 - Initialize(serviceProvider)

        /// <summary>
        /// 초기화하기
        /// </summary>
        /// <param name="serviceProvider">서비스 제공자</param>
        public static void Initialize(IServiceProvider serviceProvider)
        {
            using(var context = new DatabaseContext(serviceProvider.GetRequiredService<DbContextOptions<DatabaseContext>>()))
            {
                if(context.Test.Any())
                {
                    return;
                }

                context.Test.AddRange
                (
                    new TestModel { ID = 1, Name = "테스트 1" },
                    new TestModel { ID = 2, Name = "테스트 2" },
                    new TestModel { ID = 3, Name = "테스트 3" },
                    new TestModel { ID = 4, Name = "테스트 4" },
                    new TestModel { ID = 5, Name = "테스트 5" }
                );

                context.SaveChanges();
            }
        }

        #endregion
    }
}

using Microsoft.EntityFrameworkCore;

using Microsoft.Extensions.DependencyInjection;

using System;

using System.Linq;

using TestProject.Data;

namespace TestProject.Models

{

/// <summary>

/// 테스트 데이터

/// </summary>

public static class TestData

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Public

#region 초기화하기 - Initialize(serviceProvider)

/// <summary>

/// 초기화하기

/// </summary>

/// <param name="serviceProvider">서비스 제공자</param>

public static void Initialize(IServiceProvider serviceProvider)

{

using(var context = new DatabaseContext(serviceProvider.GetRequiredService<DbContextOptions<DatabaseContext>>()))

{

if(context.Test.Any())

{

return;

}

context.Test.AddRange

(

new TestModel { ID = 1, Name = "테스트 1" },

new TestModel { ID = 2, Name = "테스트 2" },

new TestModel { ID = 3, Name = "테스트 3" },

new TestModel { ID = 4, Name = "테스트 4" },

new TestModel { ID = 5, Name = "테스트 5" }

);

context.SaveChanges();

}

#endregion

}

▶ Data/DatabaseContext.cs


using Microsoft.EntityFrameworkCore;

using TestProject.Models;

namespace TestProject.Data
{
    /// <summary>
    /// 데이터베이스 컨텍스트
    /// </summary>
    public class DatabaseContext : DbContext
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 테스트 - Test

        /// <summary>
        /// 테스트
        /// </summary>
        public DbSet<TestModel> Test { get; set; }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - DatabaseContext(options)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="options">옵션</param>
        public DatabaseContext(DbContextOptions<DatabaseContext> options) : base(options)
        {
        }

        #endregion
    }
}

using Microsoft.EntityFrameworkCore;

using TestProject.Models;

namespace TestProject.Data

{

/// <summary>

/// 데이터베이스 컨텍스트

/// </summary>

public class DatabaseContext : DbContext

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 테스트 - Test

/// <summary>

/// 테스트

/// </summary>

public DbSet<TestModel> Test { get; set; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - DatabaseContext(options)

/// <summary>

/// 생성자

/// </summary>

/// <param name="options">옵션</param>

public DatabaseContext(DbContextOptions<DatabaseContext> options) : base(options)

{

}

#endregion

}

▶ Startup.cs


using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;

using TestProject.Data;

namespace TestProject
{
    /// <summary>
    /// 시작
    /// </summary>
    public class Startup
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 구성 - Configuration

        /// <summary>
        /// 구성
        /// </summary>
        public IConfiguration Configuration { get; }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - Startup(configuration)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="configuration">구성</param>
        public Startup(IConfiguration configuration)
        {
            Configuration = configuration;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 서비스 컬렉션 구성하기 - ConfigureServices(services)

        /// <summary>
        /// 서비스 컬렉션 구성하기
        /// </summary>
        /// <param name="services">서비스 컬렉션</param>
        public void ConfigureServices(IServiceCollection services)
        {
            services.AddDbContext<DatabaseContext>(options => options.UseInMemoryDatabase("TestDB"));

            services.AddControllers();
        }

        #endregion
        #region 구성하기 - Configure(app, environment)

        /// <summary>
        /// 구성하기
        /// </summary>
        /// <param name="app">애플리케이션 빌더</param>
        /// <param name="environment">웹 호스트 환경</param>
        public void Configure(IApplicationBuilder app, IWebHostEnvironment environment)
        {
            if(environment.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
            }

            app.UseHttpsRedirection();

            app.UseRouting();

            app.UseAuthorization();

            app.UseEndpoints
            (
                endpointRouterBuilder =>
                {
                    endpointRouterBuilder.MapControllers();
                }
            );
        }

        #endregion
    }
}

using Microsoft.AspNetCore.Builder;

using Microsoft.AspNetCore.Hosting;

using Microsoft.EntityFrameworkCore;

using Microsoft.Extensions.Configuration;

using Microsoft.Extensions.DependencyInjection;

using Microsoft.Extensions.Hosting;

using TestProject.Data;

namespace TestProject

{

/// <summary>

/// 시작

/// </summary>

public class Startup

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 구성 - Configuration

/// <summary>

/// 구성

/// </summary>

public IConfiguration Configuration { get; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - Startup(configuration)

/// <summary>

/// 생성자

/// </summary>

/// <param name="configuration">구성</param>

public Startup(IConfiguration configuration)

{

Configuration = configuration;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 서비스 컬렉션 구성하기 - ConfigureServices(services)

/// <summary>

/// 서비스 컬렉션 구성하기

/// </summary>

/// <param name="services">서비스 컬렉션</param>

public void ConfigureServices(IServiceCollection services)

{

services.AddDbContext<DatabaseContext>(options => options.UseInMemoryDatabase("TestDB"));

services.AddControllers();

}

#endregion

#region 구성하기 - Configure(app, environment)

/// <summary>

/// 구성하기

/// </summary>

/// <param name="app">애플리케이션 빌더</param>

/// <param name="environment">웹 호스트 환경</param>

public void Configure(IApplicationBuilder app, IWebHostEnvironment environment)

{

if(environment.IsDevelopment())

{

app.UseDeveloperExceptionPage();

}

app.UseHttpsRedirection();

app.UseRouting();

app.UseAuthorization();

app.UseEndpoints

(

endpointRouterBuilder =>

{

endpointRouterBuilder.MapControllers();

}

);

}

#endregion

}

[C#/ASP.NET MVC/.NETCORE] RAZOR 구문에서 주석 사용하기

■ RAZOR 구문에서 주석을 사용하는 방법을 보여준다. ▶ 예제 코드 (CSHTML)


@* 주석 *@

@* 주석 *@

[C#/ASP.NET MVC/.NETCORE] 서버 재시작 없이 .cshtml 파일 변경 사항 반영하기

■ 서버 재시작 없이 .cshtml 파일의 변경 사항을 반영하는 방법을 보여준다. 1. 아래 누겟 패키지를 설치한다. ▶ 설치 누겟 패키지


Microsoft.AspNetCore.Mvc.Razor.RuntimeCompilation

Microsoft.AspNetCore.Mvc.Razor.RuntimeCompilation

[C#/ASP.NET MVC/.NETCORE] Microsoft.AspNetCore.Mvc.Razor.RuntimeCompilation 누겟 설치하기

■ Microsoft.AspNetCore.Mvc.Razor.RuntimeCompilation 누겟을 설치하는 방법을 보여준다. 1. Visual Studio를 실행한다. 2. [도구] / [NuGet 패키지 관리자] / [패키지 관리자 콘솔] 메뉴를 실행한다.

[C#/ASP.NET MVC/.NETCORE] 스캐폴딩 기능을 사용해 MVC 웹앱 만들기

■ 스캐폴딩 기능을 사용해 MVC 웹앱을 만드는 방법을 보여준다. ▶ Models/Movie.cs


using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace TestProject.Models
{
    /// <summary>
    /// 영화
    /// </summary>
    public class Movie
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region ID - ID

        /// <summary>
        /// ID
        /// </summary>
        public int ID { get; set; }

        #endregion
        #region 제목 - Title

        /// <summary>
        /// 제목
        /// </summary>
        [Required]
        [StringLength(60, MinimumLength = 3)]
        public string Title { get; set; }

        #endregion
        #region 릴리즈 일자 - ReleaseDate

        /// <summary>
        /// 릴리즈 일자
        /// </summary>
        [DataType(DataType.Date)]
        [Display(Name = "Release Date")]
        public DateTime ReleaseDate { get; set; }

        #endregion
        #region 장르 - Genre

        /// <summary>
        /// 장르
        /// </summary>
        [Required]
        [StringLength(30)]
        public string Genre { get; set; }

        #endregion
        #region 가격 - Price

        /// <summary>
        /// 가격
        /// </summary>
        [DataType(DataType.Currency)]
        [Column(TypeName = "decimal(18, 2)")]
        [Range(1, 100)]
        public decimal Price { get; set; }

        #endregion
        #region 등급 - Rating

        /// <summary>
        /// 등급
        /// </summary>
        [Required]
        [StringLength(5)]
        [RegularExpression(@"^[A-Z]+[a-zA-Z0-9""'\s-]*$")]
        public string Rating { get; set; }

        #endregion
    }
}

using System;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

namespace TestProject.Models

{

/// <summary>

/// 영화

/// </summary>

public class Movie

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 제목 - Title

/// <summary>

/// 제목

/// </summary>

[Required]

[StringLength(60, MinimumLength = 3)]

public string Title { get; set; }

#endregion

#region 릴리즈 일자 - ReleaseDate

/// <summary>

/// 릴리즈 일자

/// </summary>

[DataType(DataType.Date)]

[Display(Name = "Release Date")]

public DateTime ReleaseDate { get; set; }

#endregion

#region 장르 - Genre

/// <summary>

/// 장르

/// </summary>

[Required]

[StringLength(30)]

public string Genre { get; set; }

#endregion

#region 가격 - Price

/// <summary>

/// 가격

/// </summary>

[DataType(DataType.Currency)]

[Column(TypeName = "decimal(18, 2)")]

[Range(1, 100)]

public decimal Price { get; set; }

#endregion

#region 등급 - Rating

/// <summary>

/// 등급

/// </summary>

[Required]

[StringLength(5)]

[RegularExpression(@"^[A-Z]+[a-zA-Z0-9""'\s-]*$")]

public string Rating { get; set; }

#endregion

}

▶ Models/MovieData.cs


using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using System;
using System.Linq;

using TestProject.Data;

namespace TestProject.Models
{
    /// <summary>
    /// 영화 데이터
    /// </summary>
    public static class MovieData
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 초기화하기 - Initialize(serviceProvider)

        /// <summary>
        /// 초기화하기
        /// </summary>
        /// <param name="serviceProvider">서비스 제공자</param>
        public static void Initialize(IServiceProvider serviceProvider)
        {
            DbContextOptions<DatabaseContext> options = serviceProvider.GetRequiredService<DbContextOptions<DatabaseContext>>();

            using(DatabaseContext context = new DatabaseContext(options))
            {
                if(context.Movie.Any())
                {
                    return;
                }

                context.Movie.AddRange
                (
                    new Movie
                    {
                        Title       = "When Harry Met Sally",
                        ReleaseDate = DateTime.Parse("1989-2-12"),
                        Genre       = "Romantic Comedy",
                        Price       = 7.99M,
                        Rating      = "A"
                    },
                    new Movie
                    {
                        Title       = "Ghostbusters ",
                        ReleaseDate = DateTime.Parse("1984-3-13"),
                        Genre       = "Comedy",
                        Price       = 8.99M,
                        Rating      = "A"
                    },
                    new Movie
                    {
                        Title       = "Ghostbusters 2",
                        ReleaseDate = DateTime.Parse("1986-2-23"),
                        Genre       = "Comedy",
                        Price       = 9.99M,
                        Rating      = "A"
                    },
                    new Movie
                    {
                        Title       = "Rio Bravo",
                        ReleaseDate = DateTime.Parse("1959-4-15"),
                        Genre       = "Western",
                        Price       = 3.99M,
                        Rating      = "A"
                    }
                );

                context.SaveChanges();
            }
        }

        #endregion
    }
}

using Microsoft.EntityFrameworkCore;

using Microsoft.Extensions.DependencyInjection;

using System;

using System.Linq;

using TestProject.Data;

namespace TestProject.Models

{

/// <summary>

/// 영화 데이터

/// </summary>

public static class MovieData

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 초기화하기 - Initialize(serviceProvider)

/// <summary>

/// 초기화하기

/// </summary>

/// <param name="serviceProvider">서비스 제공자</param>

public static void Initialize(IServiceProvider serviceProvider)

{

DbContextOptions<DatabaseContext> options = serviceProvider.GetRequiredService<DbContextOptions<DatabaseContext>>();

using(DatabaseContext context = new DatabaseContext(options))

{

if(context.Movie.Any())

{

return;

}

context.Movie.AddRange

(

new Movie

{

Title = "When Harry Met Sally",

ReleaseDate = DateTime.Parse("1989-2-12"),

Genre = "Romantic Comedy",

Price = 7.99M,

Rating = "A"

new Movie

{

Title = "Ghostbusters ",

ReleaseDate = DateTime.Parse("1984-3-13"),

Genre = "Comedy",

Price = 8.99M,

Rating = "A"

new Movie

{

Title = "Ghostbusters 2",

ReleaseDate = DateTime.Parse("1986-2-23"),

Genre = "Comedy",

Price = 9.99M,

Rating = "A"

new Movie

{

Title = "Rio Bravo",

ReleaseDate = DateTime.Parse("1959-4-15"),

Genre = "Western",

Price = 3.99M,

Rating = "A"

}

);

context.SaveChanges();

}

#endregion

}

▶ Models/MovieGenre.cs


using Microsoft.AspNetCore.Mvc.Rendering;
using System.Collections.Generic;

namespace TestProject.Models
{
    /// <summary>
    /// 영화 장르
    /// </summary>
    public class MovieGenre
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 영화 리스트 - MovieList

        /// <summary>
        /// 영화 리스트
        /// </summary>
        public List<Movie> MovieList { get; set; }

        #endregion
        #region 장르 선택 리스트 - GenreSelectList

        /// <summary>
        /// 장르 선택 리스트
        /// </summary>
        public SelectList GenreSelectList { get; set; }

        #endregion
        #region 검색 장르 - SearchGenre

        /// <summary>
        /// 검색 장르
        /// </summary>
        public string SearchGenre { get; set; }

        #endregion
        #region 검색 문자열 - SearchString

        /// <summary>
        /// 검색 문자열
        /// </summary>
        public string SearchString { get; set; }

        #endregion
    }
}

using Microsoft.AspNetCore.Mvc.Rendering;

using System.Collections.Generic;

namespace TestProject.Models

{

/// <summary>

/// 영화 장르

/// </summary>

public class MovieGenre

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 영화 리스트 - MovieList

/// <summary>

/// 영화 리스트

/// </summary>

public List<Movie> MovieList { get; set; }

#endregion

#region 장르 선택 리스트 - GenreSelectList

/// <summary>

/// 장르 선택 리스트

/// </summary>

public SelectList GenreSelectList { get; set; }

#endregion

#region 검색 장르 - SearchGenre

/// <summary>

/// 검색 장르

/// </summary>

public string SearchGenre { get; set; }

#endregion

#region 검색 문자열 - SearchString

/// <summary>

/// 검색 문자열

/// </summary>

public string SearchString { get; set; }

#endregion

}

▶ Data/DatabaseContext.cs


using Microsoft.EntityFrameworkCore;

using TestProject.Models;

namespace TestProject.Data
{
    /// <summary>
    /// 데이터베이스 컨텍스트
    /// </summary>
    public class DatabaseContext : DbContext
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 영화 - Movie

        /// <summary>
        /// 영화
        /// </summary>
        public DbSet<Movie> Movie { get; set; }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - DatabaseContext(options)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="options">옵션</param>
        public DatabaseContext(DbContextOptions<DatabaseContext> options) : base(options)
        {
        }

        #endregion
    }
}

using Microsoft.EntityFrameworkCore;

using TestProject.Models;

namespace TestProject.Data

{

/// <summary>

/// 데이터베이스 컨텍스트

/// </summary>

public class DatabaseContext : DbContext

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 영화 - Movie

/// <summary>

/// 영화

/// </summary>

public DbSet<Movie> Movie { get; set; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - DatabaseContext(options)

/// <summary>

/// 생성자

/// </summary>

/// <param name="options">옵션</param>

public DatabaseContext(DbContextOptions<DatabaseContext> options) : base(options)

{

}

#endregion

}

▶

[C#/ASP.NET MVC/.NETCORE] ValidateAntiForgeryTokenAttribute 클래스 : 위조 방지 토큰 확인하기

■ ValidateAntiForgeryTokenAttribute 클래스를 사용해 위조 방지 토큰을 확인하는 방법을 보여준다. ▶ MovieController.cs


using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

using TestProject.Data;
using TestProject.Models;

namespace TestProject.Controllers
{
    /// <summary>
    /// 영화 컨트롤러
    /// </summary>
    public class MovieController : Controller
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 컨텍스트
        /// </summary>
        private readonly DatabaseContext context;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MovieController(context)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="context">컨텍스트</param>
        public MovieController(DatabaseContext context)
        {
            this.context = context;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 인덱스 페이지 처리하기 - Index()

        /// <summary>
        /// 인덱스 페이지 처리하기
        /// </summary>
        /// <returns>액션 결과 태스크</returns>
        public async Task<IActionResult> Index()
        {
            List<Movie> list = await this.context.Movie.ToListAsync();

            return View(list);
        }

        #endregion
        #region 상세 페이지 처리하기 - Details(id)

        /// <summary>
        /// 상세 페이지 처리하기
        /// </summary>
        /// <param name="id">ID</param>
        /// <returns>액션 결과 태스크</returns>
        public async Task<IActionResult> Details(int? id)
        {
            if(id == null)
            {
                return NotFound();
            }

            Movie movie = await this.context.Movie.FirstOrDefaultAsync(m => m.ID == id);

            if(movie == null)
            {
                return NotFound();
            }

            return View(movie);
        }

        #endregion
        #region 생성 페이지 처리하기 - Create()

        /// <summary>
        /// 생성 페이지 처리하기
        /// </summary>
        /// <returns>액션 결과</returns>
        public IActionResult Create()
        {
            return View();
        }

        #endregion
        #region 생성하기 - Create(movie)

        /// <summary>
        /// 생성하기
        /// </summary>
        /// <param name="movie">영화</param>
        /// <returns>액션 결과 태스크</returns>
        [HttpPost]
        [ValidateAntiForgeryToken]
        public async Task<IActionResult> Create([Bind("ID,Title,ReleaseDate,Genre,Price")] Movie movie)
        {
            if(ModelState.IsValid)
            {
                this.context.Add(movie);

                await this.context.SaveChangesAsync();

                return RedirectToAction(nameof(Index));
            }

            return View(movie);
        }

        #endregion
        #region 편집 페이지 처리하기 - Edit(id)

        /// <summary>
        /// 편집 페이지 처리하기
        /// </summary>
        /// <param name="id">ID</param>
        /// <returns>액션 결과 태스크</returns>
        public async Task<IActionResult> Edit(int? id)
        {
            if(id == null)
            {
                return NotFound();
            }

            Movie movie = await this.context.Movie.FindAsync(id);

            if(movie == null)
            {
                return NotFound();
            }

            return View(movie);
        }

        #endregion
        #region 편집 페이지 처리하기 - Edit(int id, movie)

        /// <summary>
        /// 편집 페이지 처리하기
        /// </summary>
        /// <param name="id">ID</param>
        /// <param name="movie">영화</param>
        /// <returns>액션 결과 태스크</returns>
        [HttpPost]
        [ValidateAntiForgeryToken]
        public async Task<IActionResult> Edit(int id, [Bind("ID,Title,ReleaseDate,Genre,Price")] Movie movie)
        {
            if(id != movie.ID)
            {
                return NotFound();
            }

            if(ModelState.IsValid)
            {
                try
                {
                    this.context.Update(movie);

                    await this.context.SaveChangesAsync();
                }
                catch(DbUpdateConcurrencyException)
                {
                    if(!MovieExists(movie.ID))
                    {
                        return NotFound();
                    }
                    else
                    {
                        throw;
                    }
                }

                return RedirectToAction(nameof(Index));
            }

            return View(movie);
        }

        #endregion
        #region 삭제 페이지 처리하기 - Delete(id)

        /// <summary>
        /// 삭제 페이지 처리하기
        /// </summary>
        /// <param name="id">ID</param>
        /// <returns>액션 결과 페이지</returns>
        public async Task<IActionResult> Delete(int? id)
        {
            if(id == null)
            {
                return NotFound();
            }

            Movie movie = await this.context.Movie.FirstOrDefaultAsync(m => m.ID == id);

            if(movie == null)
            {
                return NotFound();
            }

            return View(movie);
        }

        #endregion
        #region 삭제 완료시 페이지 처리하기 - DeleteConfirmed(id)

        /// <summary>
        /// 삭제 완료시 페이지 처리하기
        /// </summary>
        /// <param name="id">ID</param>
        /// <returns>액션 결과 태스크</returns>
        [HttpPost, ActionName("Delete")]
        [ValidateAntiForgeryToken]
        public async Task<IActionResult> DeleteConfirmed(int id)
        {
            Movie movie = await this.context.Movie.FindAsync(id);

            this.context.Movie.Remove(movie);

            await this.context.SaveChangesAsync();

            return RedirectToAction(nameof(Index));
        }

        #endregion

        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 영화 존재 여부 구하기 - MovieExists(id)

        /// <summary>
        /// 영화 존재 여부 구하기
        /// </summary>
        /// <param name="id">ID</param>
        /// <returns>영화 존재 여부</returns>
        private bool MovieExists(int id)
        {
            return this.context.Movie.Any(e => e.ID == id);
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

using Microsoft.AspNetCore.Mvc;

using Microsoft.EntityFrameworkCore;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using TestProject.Data;

using TestProject.Models;

namespace TestProject.Controllers

{

/// <summary>

/// 영화 컨트롤러

/// </summary>

public class MovieController : Controller

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 컨텍스트

/// </summary>

private readonly DatabaseContext context;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - MovieController(context)

/// <summary>

/// 생성자

/// </summary>

/// <param name="context">컨텍스트</param>

public MovieController(DatabaseContext context)

{

this.context = context;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 인덱스 페이지 처리하기 - Index()

/// <summary>

/// 인덱스 페이지 처리하기

/// </summary>

/// <returns>액션 결과 태스크</returns>

public async Task<IActionResult> Index()

{

List<Movie> list = await this.context.Movie.ToListAsync();

return View(list);

}

#endregion

#region 상세 페이지 처리하기 - Details(id)

/// <summary>

/// 상세 페이지 처리하기

/// </summary>

/// <param name="id">ID</param>

/// <returns>액션 결과 태스크</returns>

public async Task<IActionResult> Details(int? id)

{

if(id == null)

{

return NotFound();

}

Movie movie = await this.context.Movie.FirstOrDefaultAsync(m => m.ID == id);

if(movie == null)

{

return NotFound();

}

return View(movie);

}

#endregion

#region 생성 페이지 처리하기 - Create()

/// <summary>

/// 생성 페이지 처리하기

/// </summary>

/// <returns>액션 결과</returns>

public IActionResult Create()

{

return View();

}

#endregion

#region 생성하기 - Create(movie)

/// <summary>

/// 생성하기

/// </summary>

/// <param name="movie">영화</param>

/// <returns>액션 결과 태스크</returns>

[HttpPost]

[ValidateAntiForgeryToken]

public async Task<IActionResult> Create([Bind("ID,Title,ReleaseDate,Genre,Price")] Movie movie)

{

if(ModelState.IsValid)

{

this.context.Add(movie);

await this.context.SaveChangesAsync();

return RedirectToAction(nameof(Index));

}

return View(movie);

}

#endregion

#region 편집 페이지 처리하기 - Edit(id)

/// <summary>

/// 편집 페이지 처리하기

/// </summary>

/// <param name="id">ID</param>

/// <returns>액션 결과 태스크</returns>

public async Task<IActionResult> Edit(int? id)

{

if(id == null)

{

return NotFound();

}

Movie movie = await this.context.Movie.FindAsync(id);

if(movie == null)

{

return NotFound();

}

return View(movie);

}

#endregion

#region 편집 페이지 처리하기 - Edit(int id, movie)

/// <summary>

/// 편집 페이지 처리하기

/// </summary>

/// <param name="id">ID</param>

/// <param name="movie">영화</param>

/// <returns>액션 결과 태스크</returns>

[HttpPost]

[ValidateAntiForgeryToken]

public async Task<IActionResult> Edit(int id, [Bind("ID,Title,ReleaseDate,Genre,Price")] Movie movie)

{

if(id != movie.ID)

{

return NotFound();

}

if(ModelState.IsValid)

{

try

{

this.context.Update(movie);

await this.context.SaveChangesAsync();

}

catch(DbUpdateConcurrencyException)

{

if(!MovieExists(movie.ID))

{

return NotFound();

}

else

{

throw;

}

return RedirectToAction(nameof(Index));

}

return View(movie);

}

#endregion

#region 삭제 페이지 처리하기 - Delete(id)

/// <summary>

/// 삭제 페이지 처리하기

/// </summary>

/// <param name="id">ID</param>

/// <returns>액션 결과 페이지</returns>

public async Task<IActionResult> Delete(int? id)

{

if(id == null)

{

return NotFound();

}

Movie movie = await this.context.Movie.FirstOrDefaultAsync(m => m.ID == id);

if(movie == null)

{

return NotFound();

}

return View(movie);

}

#endregion

#region 삭제 완료시 페이지 처리하기 - DeleteConfirmed(id)

/// <summary>

/// 삭제 완료시 페이지 처리하기

/// </summary>

/// <param name="id">ID</param>

/// <returns>액션 결과 태스크</returns>

[HttpPost, ActionName("Delete")]

[ValidateAntiForgeryToken]

public async Task<IActionResult> DeleteConfirmed(int id)

{

Movie movie = await this.context.Movie.FindAsync(id);

this.context.Movie.Remove(movie);

await this.context.SaveChangesAsync();

return RedirectToAction(nameof(Index));

}

#endregion

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 영화 존재 여부 구하기 - MovieExists(id)

/// <summary>

/// 영화 존재 여부 구하기

/// </summary>

/// <param name="id">ID</param>

/// <returns>영화 존재 여부</returns>

private bool MovieExists(int id)

{

return this.context.Movie.Any(e => e.ID == id);

}

#endregion

}

[C#/ASP.NET MVC/.NETCORE] dotnet new mvc 명령 : MVC 웹앱 만들기

■ dotnet new mvc 명령을 사용해 MVC 웹앱을 만드는 방법을 보여준다. 1. [명령 프롬프트]를 실행한다. 2. [명령 프롬프트]에서 아래 명령을 실행한다. ▶

[C#/ASP.NET MVC/.NETCORE] 스캐폴딩 기능을 사용해 RAZOR 페이지 웹앱 만들기 (최종)

■ 스캐폴딩 기능을 사용해 RAZOR 페이지 웹앱을 만드는 방법을 보여준다. (최종) ▶ Models/Movie.cs


using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace TestProject.Models
{
    /// <summary>
    /// 영화
    /// </summary>
    public class Movie
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region ID - ID

        /// <summary>
        /// ID
        /// </summary>
        public int ID { get; set; }

        #endregion
        #region 제목 - Title

        /// <summary>
        /// 제목
        /// </summary>
        [Required]
        [StringLength(60, MinimumLength = 3)]
        public string Title { get; set; }

        #endregion
        #region 릴리즈 일자 - ReleaseDate

        /// <summary>
        /// 릴리즈 일자
        /// </summary>
        [DataType(DataType.Date)]
        [Display(Name = "Release Date")]
        public DateTime ReleaseDate { get; set; }

        #endregion
        #region 장르 - Genre

        /// <summary>
        /// 장르
        /// </summary>
        [Required]
        [StringLength(30)]
        public string Genre { get; set; }

        #endregion
        #region 가격 - Price

        /// <summary>
        /// 가격
        /// </summary>
        [DataType(DataType.Currency)]
        [Column(TypeName = "decimal(18, 2)")]
        [Range(1, 100)]
        public decimal Price { get; set; }

        #endregion
        #region 등급 - Rating

        /// <summary>
        /// 등급
        /// </summary>
        [Required]
        [StringLength(5)]
        [RegularExpression(@"^[A-Z]+[a-zA-Z0-9""'\s-]*$")]
        public string Rating { get; set; }

        #endregion
    }
}

using System;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

namespace TestProject.Models

{

/// <summary>

/// 영화

/// </summary>

public class Movie

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 제목 - Title

/// <summary>

/// 제목

/// </summary>

[Required]

[StringLength(60, MinimumLength = 3)]

public string Title { get; set; }

#endregion

#region 릴리즈 일자 - ReleaseDate

/// <summary>

/// 릴리즈 일자

/// </summary>

[DataType(DataType.Date)]

[Display(Name = "Release Date")]

public DateTime ReleaseDate { get; set; }

#endregion

#region 장르 - Genre

/// <summary>

/// 장르

/// </summary>

[Required]

[StringLength(30)]

public string Genre { get; set; }

#endregion

#region 가격 - Price

/// <summary>

/// 가격

/// </summary>

[DataType(DataType.Currency)]

[Column(TypeName = "decimal(18, 2)")]

[Range(1, 100)]

public decimal Price { get; set; }

#endregion

#region 등급 - Rating

/// <summary>

/// 등급

/// </summary>

[Required]

[StringLength(5)]

[RegularExpression(@"^[A-Z]+[a-zA-Z0-9""'\s-]*$")]

public string Rating { get; set; }

#endregion

}

▶ Models/MovieData.cs


using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using System;
using System.Linq;

using TestProject.Data;

namespace TestProject.Models
{
    /// <summary>
    /// 영화 데이터
    /// </summary>
    public static class MovieData
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Static
        //////////////////////////////////////////////////////////////////////////////// Public

        #region 초기화하기 - Initialize(serviceProvider)

        /// <summary>
        /// 초기화하기
        /// </summary>
        /// <param name="serviceProvider">서비스 제공자</param>
        public static void Initialize(IServiceProvider serviceProvider)
        {
            using(var context = new DatabaseContext(serviceProvider.GetRequiredService<DbContextOptions<DatabaseContext>>()))
            {
                if(context.Movie.Any())
                {
                    return;
                }

                context.Movie.AddRange
                (
                    new Movie
                    {
                        Title       = "When Harry Met Sally",
                        ReleaseDate = DateTime.Parse("1989-2-12"),
                        Genre       = "Romantic Comedy",
                        Price       = 7.99M,
                        Rating      = "R"
                    },
                    new Movie
                    {
                        Title       = "Ghostbusters ",
                        ReleaseDate = DateTime.Parse("1984-3-13"),
                        Genre       = "Comedy",
                        Price       = 8.99M,
                        Rating      = "R"
                    },
                    new Movie
                    {
                        Title       = "Ghostbusters 2",
                        ReleaseDate = DateTime.Parse("1986-2-23"),
                        Genre       = "Comedy",
                        Price       = 9.99M,
                        Rating      = "R"
                    },
                    new Movie
                    {
                        Title       = "Rio Bravo",
                        ReleaseDate = DateTime.Parse("1959-4-15"),
                        Genre       = "Western",
                        Price       = 3.99M,
                        Rating      = "R"
                    }
                );

                context.SaveChanges();
            }
        }

        #endregion
    }
}

using Microsoft.EntityFrameworkCore;

using Microsoft.Extensions.DependencyInjection;

using System;

using System.Linq;

using TestProject.Data;

namespace TestProject.Models

{

/// <summary>

/// 영화 데이터

/// </summary>

public static class MovieData

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Public

#region 초기화하기 - Initialize(serviceProvider)

/// <summary>

/// 초기화하기

/// </summary>

/// <param name="serviceProvider">서비스 제공자</param>

public static void Initialize(IServiceProvider serviceProvider)

{

using(var context = new DatabaseContext(serviceProvider.GetRequiredService<DbContextOptions<DatabaseContext>>()))

{

if(context.Movie.Any())

{

return;

}

context.Movie.AddRange

(

new Movie

{

Title = "When Harry Met Sally",

ReleaseDate = DateTime.Parse("1989-2-12"),

Genre = "Romantic Comedy",

Price = 7.99M,

Rating = "R"

new Movie

{

Title = "Ghostbusters ",

ReleaseDate = DateTime.Parse("1984-3-13"),

Genre = "Comedy",

Price = 8.99M,

Rating = "R"

new Movie

{

Title = "Ghostbusters 2",

ReleaseDate = DateTime.Parse("1986-2-23"),

Genre = "Comedy",

Price = 9.99M,

Rating = "R"

new Movie

{

Title = "Rio Bravo",

ReleaseDate = DateTime.Parse("1959-4-15"),

Genre = "Western",

Price = 3.99M,

Rating = "R"

}

);

context.SaveChanges();

}

#endregion

}

▶ Data/DatabaseContext.cs


using Microsoft.EntityFrameworkCore;

using TestProject.Models;

namespace TestProject.Data
{
    /// <summary>
    /// 데이터베이스 컨텍스트
    /// </summary>
    public class DatabaseContext : DbContext
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 영화 - Movie

        /// <summary>
        /// 영화
        /// </summary>
        public DbSet<Movie> Movie { get; set; }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - DatabaseContext(options)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="options">옵션</param>
        public DatabaseContext(DbContextOptions<DatabaseContext> options) : base(options)
        {
        }

        #endregion
    }
}

using Microsoft.EntityFrameworkCore;

using TestProject.Models;

namespace TestProject.Data

{

/// <summary>

/// 데이터베이스 컨텍스트

/// </summary>

public class DatabaseContext : DbContext

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 영화 - Movie

/// <summary>

/// 영화

/// </summary>

public DbSet<Movie> Movie { get; set; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - DatabaseContext(options)

/// <summary>

/// 생성자

/// </summary>

/// <param name="options">옵션</param>

public DatabaseContext(DbContextOptions<DatabaseContext> options) : base(options)

{

}

#endregion

}

▶ appsettings.json

[C#/ASP.NET MVC/.NETCORE] BindPropertyAttribute 클래스 : SupportsGet 속성 사용하기

■ BindPropertyAttribute 클래스의 SupportsGet 속성을 사용하는 방법을 보여준다. ▶ Pages/Movies/Index.cshtml


@page
@using TestProject.Models
@model TestProject.Pages.Movies.IndexModel
@{
    ViewData["Title"] = "Index";
}
<h1>Index</h1>
<p>
    <a asp-page="Create">Create New</a>
</p>
<form>
    <p>
        <select asp-for="MovieGenre" asp-items="Model.GenreSelectList">
            <option value="">All</option>
        </select>
        Title : <input type="text" asp-for="SearchString" />
        <input type="submit" value="Filter" />
    </p>
</form>
<table class="table">
    <thead>
        <tr>
            <th>
                @Html.DisplayNameFor(model => model.MovieList[0].Title)
            </th>
            <th>
                @Html.DisplayNameFor(model => model.MovieList[0].ReleaseDate)
            </th>
            <th>
                @Html.DisplayNameFor(model => model.MovieList[0].Genre)
            </th>
            <th>
                @Html.DisplayNameFor(model => model.MovieList[0].Price)
            </th>
            <th></th>
        </tr>
    </thead>
    <tbody>
@foreach(Movie movie in Model.MovieList)
{
        <tr>
            <td>
                @Html.DisplayFor(modelItem => movie.Title)
            </td>
            <td>
                @Html.DisplayFor(modelItem => movie.ReleaseDate)
            </td>
            <td>
                @Html.DisplayFor(modelItem => movie.Genre)
            </td>
            <td>
                @Html.DisplayFor(modelItem => movie.Price)
            </td>
            <td>
                <a asp-page="./Edit" asp-route-id="@movie.ID">Edit</a> |
                <a asp-page="./Details" asp-route-id="@movie.ID">Details</a> |
                <a asp-page="./Delete" asp-route-id="@movie.ID">Delete</a>
            </td>
        </tr>
}
    </tbody>
</table>

@page

@using TestProject.Models

@model TestProject.Pages.Movies.IndexModel

ViewData["Title"] = "Index";

}

<h1>Index</h1>

<p>

<a asp-page="Create">Create New</a>

</p>

<form>

<p>

</select>

Title : <input type="text" asp-for="SearchString" />

</p>

</form>

<thead>

<tr>

<th>

@Html.DisplayNameFor(model => model.MovieList[0].Title)

</th>

<th>

@Html.DisplayNameFor(model => model.MovieList[0].ReleaseDate)

</th>

<th>

@Html.DisplayNameFor(model => model.MovieList[0].Genre)

</th>

<th>

@Html.DisplayNameFor(model => model.MovieList[0].Price)

</th>

</tr>

</thead>

<tbody>

@foreach(Movie movie in Model.MovieList)

{

<tr>

<td>

@Html.DisplayFor(modelItem => movie.Title)

</td>

<td>

@Html.DisplayFor(modelItem => movie.ReleaseDate)

</td>

<td>

@Html.DisplayFor(modelItem => movie.Genre)

</td>

<td>

@Html.DisplayFor(modelItem => movie.Price)

</td>

<td>

<a asp-page="./Edit" asp-route-id="@movie.ID">Edit</a> |

<a asp-page="./Details" asp-route-id="@movie.ID">Details</a> |

<a asp-page="./Delete" asp-route-id="@movie.ID">Delete</a>

</td>

</tr>

}

</tbody>

</table>

▶ Pages/Movies/Index.cshtml.cs


using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Microsoft.AspNetCore.Mvc.Rendering;
using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

using TestProject.Data;
using TestProject.Models;

namespace TestProject.Pages.Movies
{
    /// <summary>
    /// 인덱스 모델
    /// </summary>
    public class IndexModel : PageModel
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 컨텍스트
        /// </summary>
        private readonly DatabaseContext context;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 영화 리스트 - MovieList

        /// <summary>
        /// 영화 리스트
        /// </summary>
        public IList<Movie> MovieList { get;set; }

        #endregion

        #region 검색 문자열 - SearchString

        /// <summary>
        /// 검색 문자열
        /// </summary>
        [BindProperty(SupportsGet = true)]
        public string SearchString { get; set; }

        #endregion
        #region 장르 선택 리스트 - GenreSelectList

        /// <summary>
        /// 장르 선택 리스트
        /// </summary>
        public SelectList GenreSelectList { get; set; }

        #endregion
        #region 영화 장르 - MovieGenre

        /// <summary>
        /// 영화 장르
        /// </summary>
        [BindProperty(SupportsGet = true)]
        public string MovieGenre { get; set; }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - IndexModel(context)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="context">컨텍스트</param>
        public IndexModel(DatabaseContext context)
        {
            this.context = context;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region GET 비동기 처리하기 - OnGetAsync()

        /// <summary>
        /// GET 비동기 처리하기
        /// </summary>
        /// <returns>태스크</returns>
        public async Task OnGetAsync()
        {
            var genreQueryable = from movie in this.context.Movie
                                 orderby movie.Genre
                                 select  movie.Genre;

            var movieQueryable = from movie in this.context.Movie
                                 select movie;

            if(!string.IsNullOrEmpty(SearchString))
            {
                movieQueryable = movieQueryable.Where(s => s.Title.Contains(SearchString));
            }

            if(!string.IsNullOrEmpty(MovieGenre))
            {
                movieQueryable = movieQueryable.Where(x => x.Genre == MovieGenre);
            }

            GenreSelectList = new SelectList(await genreQueryable.Distinct().ToListAsync());

            MovieList = await movieQueryable.ToListAsync();
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

using Microsoft.AspNetCore.Mvc;

using Microsoft.AspNetCore.Mvc.RazorPages;

using Microsoft.AspNetCore.Mvc.Rendering;

using Microsoft.EntityFrameworkCore;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using TestProject.Data;

using TestProject.Models;

namespace TestProject.Pages.Movies

{

/// <summary>

/// 인덱스 모델

/// </summary>

public class IndexModel : PageModel

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 컨텍스트

/// </summary>

private readonly DatabaseContext context;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 영화 리스트 - MovieList

/// <summary>

/// 영화 리스트

/// </summary>

public IList<Movie> MovieList { get;set; }

#endregion

#region 검색 문자열 - SearchString

/// <summary>

/// 검색 문자열

/// </summary>

[BindProperty(SupportsGet = true)]

public string SearchString { get; set; }

#endregion

#region 장르 선택 리스트 - GenreSelectList

/// <summary>

/// 장르 선택 리스트

/// </summary>

public SelectList GenreSelectList { get; set; }

#endregion

#region 영화 장르 - MovieGenre

/// <summary>

/// 영화 장르

/// </summary>

[BindProperty(SupportsGet = true)]

public string MovieGenre { get; set; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - IndexModel(context)

/// <summary>

/// 생성자

/// </summary>

/// <param name="context">컨텍스트</param>

public IndexModel(DatabaseContext context)

{

this.context = context;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Public

#region GET 비동기 처리하기 - OnGetAsync()

/// <summary>

/// GET 비동기 처리하기

/// </summary>

/// <returns>태스크</returns>

public async Task OnGetAsync()

{

var genreQueryable = from movie in this.context.Movie

orderby movie.Genre

select movie.Genre;

var movieQueryable = from movie in this.context.Movie

select movie;

if(!string.IsNullOrEmpty(SearchString))

{

movieQueryable = movieQueryable.Where(s => s.Title.Contains(SearchString));

}

if(!string.IsNullOrEmpty(MovieGenre))

{

movieQueryable = movieQueryable.Where(x => x.Genre == MovieGenre);

}

GenreSelectList = new SelectList(await genreQueryable.Distinct().ToListAsync());

MovieList = await movieQueryable.ToListAsync();

}

#endregion

}

※ TestDB 데이터베이스 생성 1. 비주얼 스튜디오를 실행한다.

[C#/ASP.NET MVC/.NETCORE] @page 지시문 : 경로 템플리트 추가하기

■ @page 지시문을 사용해 경로 템플리트를 추가하는 방법을 보여준다. ▶ Pages/Movies/Index.cshtml


@page "{SearchString?}"
@using TestProject.Models
@model TestProject.Pages.Movies.IndexModel
@{
    ViewData["Title"] = "Index";
}
<h1>Index</h1>
<p>
    <a asp-page="Create">Create New</a>
</p>
<table class="table">
    <thead>
        <tr>
            <th>
                @Html.DisplayNameFor(model => model.MovieList[0].Title)
            </th>
            <th>
                @Html.DisplayNameFor(model => model.MovieList[0].ReleaseDate)
            </th>
            <th>
                @Html.DisplayNameFor(model => model.MovieList[0].Genre)
            </th>
            <th>
                @Html.DisplayNameFor(model => model.MovieList[0].Price)
            </th>
            <th></th>
        </tr>
    </thead>
    <tbody>
@foreach(Movie movie in Model.MovieList)
{
        <tr>
            <td>
                @Html.DisplayFor(modelItem => movie.Title)
            </td>
            <td>
                @Html.DisplayFor(modelItem => movie.ReleaseDate)
            </td>
            <td>
                @Html.DisplayFor(modelItem => movie.Genre)
            </td>
            <td>
                @Html.DisplayFor(modelItem => movie.Price)
            </td>
            <td>
                <a asp-page="./Edit" asp-route-id="@movie.ID">Edit</a> |
                <a asp-page="./Details" asp-route-id="@movie.ID">Details</a> |
                <a asp-page="./Delete" asp-route-id="@movie.ID">Delete</a>
            </td>
        </tr>
}
    </tbody>
</table>

@page "{SearchString?}"

@using TestProject.Models

@model TestProject.Pages.Movies.IndexModel

ViewData["Title"] = "Index";

}

<h1>Index</h1>

<p>

<a asp-page="Create">Create New</a>

</p>

<thead>

<tr>

<th>

@Html.DisplayNameFor(model => model.MovieList[0].Title)

</th>

<th>

@Html.DisplayNameFor(model => model.MovieList[0].ReleaseDate)

</th>

<th>

@Html.DisplayNameFor(model => model.MovieList[0].Genre)

</th>

<th>

@Html.DisplayNameFor(model => model.MovieList[0].Price)

</th>

</tr>

</thead>

<tbody>

@foreach(Movie movie in Model.MovieList)

{

<tr>

<td>

@Html.DisplayFor(modelItem => movie.Title)

</td>

<td>

@Html.DisplayFor(modelItem => movie.ReleaseDate)

</td>

<td>

@Html.DisplayFor(modelItem => movie.Genre)

</td>

<td>

@Html.DisplayFor(modelItem => movie.Price)

</td>

<td>

<a asp-page="./Edit" asp-route-id="@movie.ID">Edit</a> |

<a asp-page="./Details" asp-route-id="@movie.ID">Details</a> |

<a asp-page="./Delete" asp-route-id="@movie.ID">Delete</a>

</td>

</tr>

}

</tbody>

</table>

▶ Pages/Movies/Index.cshtml.cs


using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Microsoft.AspNetCore.Mvc.Rendering;
using Microsoft.EntityFrameworkCore;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

using TestProject.Data;
using TestProject.Models;

namespace TestProject.Pages.Movies
{
    /// <summary>
    /// 인덱스 모델
    /// </summary>
    public class IndexModel : PageModel
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 컨텍스트
        /// </summary>
        private readonly DatabaseContext context;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 영화 리스트 - MovieList

        /// <summary>
        /// 영화 리스트
        /// </summary>
        public IList<Movie> MovieList { get;set; }

        #endregion

        #region 검색 문자열 - SearchString

        /// <summary>
        /// 검색 문자열
        /// </summary>
        [BindProperty(SupportsGet = true)]
        public string SearchString { get; set; }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - IndexModel(context)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="context">컨텍스트</param>
        public IndexModel(DatabaseContext context)
        {
            this.context = context;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region GET 비동기 처리하기 - OnGetAsync()

        /// <summary>
        /// GET 비동기 처리하기
        /// </summary>
        /// <returns>태스크</returns>
        public async Task OnGetAsync()
        {
            var movieQueryable = from movie in this.context.Movie select movie;

            if(!string.IsNullOrEmpty(SearchString))
            {
                movieQueryable = movieQueryable.Where(s => s.Title.Contains(SearchString));
            }

            MovieList = await movieQueryable.ToListAsync();
        }

        #endregion
    }
}

using Microsoft.AspNetCore.Mvc;

using Microsoft.AspNetCore.Mvc.RazorPages;

using Microsoft.AspNetCore.Mvc.Rendering;

using Microsoft.EntityFrameworkCore;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using TestProject.Data;

using TestProject.Models;

namespace TestProject.Pages.Movies

{

/// <summary>

/// 인덱스 모델

/// </summary>

public class IndexModel : PageModel

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 컨텍스트

/// </summary>

private readonly DatabaseContext context;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 영화 리스트 - MovieList

/// <summary>

/// 영화 리스트

/// </summary>

public IList<Movie> MovieList { get;set; }

#endregion

#region 검색 문자열 - SearchString

/// <summary>

/// 검색 문자열

/// </summary>

[BindProperty(SupportsGet = true)]

public string SearchString { get; set; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - IndexModel(context)

/// <summary>

/// 생성자

/// </summary>

/// <param name="context">컨텍스트</param>

public IndexModel(DatabaseContext context)

{

this.context = context;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Public

#region GET 비동기 처리하기 - OnGetAsync()

/// <summary>

/// GET 비동기 처리하기

/// </summary>

/// <returns>태스크</returns>

public async Task OnGetAsync()

{

var movieQueryable = from movie in this.context.Movie select movie;

if(!string.IsNullOrEmpty(SearchString))

{

movieQueryable = movieQueryable.Where(s => s.Title.Contains(SearchString));

}

MovieList = await movieQueryable.ToListAsync();

}

#endregion

}

※ TestDB 데이터베이스 생성 1. 비주얼 스튜디오를

[C#/ASP.NET MVC/.NETCORE] @page 지시문 : 경로 템플리트 추가하기

■ @page 지시문을 사용해 경로 템플리트를 추가하는 방법을 보여준다. ▶ Pages/Movies/Edit.cshtml


@page "{id:int}"
@model TestProject.Pages.Movies.EditModel
@{
    ViewData["Title"] = "Edit";
}
<h1>Edit</h1>
<h4>Movie</h4>
<hr />
<div class="row">
    <div class="col-md-4">
        <form method="post">
            <div asp-validation-summary="ModelOnly" class="text-danger"></div>
            <input type="hidden" asp-for="Movie.ID" />
            <div class="form-group">
                <label asp-for="Movie.Title" class="control-label"></label>
                <input asp-for="Movie.Title" class="form-control" />
                <span asp-validation-for="Movie.Title" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="Movie.ReleaseDate" class="control-label"></label>
                <input asp-for="Movie.ReleaseDate" class="form-control" />
                <span asp-validation-for="Movie.ReleaseDate" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="Movie.Genre" class="control-label"></label>
                <input asp-for="Movie.Genre" class="form-control" />
                <span asp-validation-for="Movie.Genre" class="text-danger"></span>
            </div>
            <div class="form-group">
                <label asp-for="Movie.Price" class="control-label"></label>
                <input asp-for="Movie.Price" class="form-control" />
                <span asp-validation-for="Movie.Price" class="text-danger"></span>
            </div>
            <div class="form-group">
                <input type="submit" value="Save" class="btn btn-primary" />
            </div>
        </form>
    </div>
</div>
<div>
    <a asp-page="./Index">Back to List</a>
</div>
@section Scripts {
    @{await Html.RenderPartialAsync("_ValidationScriptsPartial");}
}

@page "{id:int}"

@model TestProject.Pages.Movies.EditModel

ViewData["Title"] = "Edit";

}

<h4>Movie</h4>

<hr />

</div>

</div>

</div>

</div>

</div>

</form>

</div>

<div>

</div>

@section Scripts {

@{await Html.RenderPartialAsync("_ValidationScriptsPartial");}

}

▶ Pages/Movies/Edit.cshtml.cs


using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Microsoft.EntityFrameworkCore;
using System.Linq;
using System.Threading.Tasks;

using TestProject.Data;
using TestProject.Models;

namespace TestProject.Pages.Movies
{
    /// <summary>
    /// 편집 모델
    /// </summary>
    public class EditModel : PageModel
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 컨텍스트
        /// </summary>
        private readonly DatabaseContext context;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 영화 - Movie

        /// <summary>
        /// 영화
        /// </summary>
        [BindProperty]
        public Movie Movie { get; set; }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - EditModel(context)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="context">컨텍스트</param>
        public EditModel(DatabaseContext context)
        {
            this.context = context;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region GET 비동기 처리하기 - OnGetAsync(id)

        /// <summary>
        /// GET 비동기 처리하기
        /// </summary>
        /// <param name="id">ID</param>
        /// <returns>액션 결과 태스크</returns>
        public async Task<IActionResult> OnGetAsync(int id)
        {
            Movie = await this.context.Movie.FirstOrDefaultAsync(m => m.ID == id);

            if(Movie == null)
            {
                return NotFound();
            }

            return Page();
        }

        #endregion
        #region POST 비동기 처리하기 - OnPostAsync()

        /// <summary>
        /// POST 비동기 처리하기
        /// </summary>
        /// <returns>액션 결과 태스크</returns>
        public async Task<IActionResult> OnPostAsync()
        {
            if(!ModelState.IsValid)
            {
                return Page();
            }

            this.context.Attach(Movie).State = EntityState.Modified;

            try
            {
                await this.context.SaveChangesAsync();
            }
            catch(DbUpdateConcurrencyException)
            {
                if(!MovieExists(Movie.ID))
                {
                    return NotFound();
                }
                else
                {
                    throw;
                }
            }

            return RedirectToPage("./Index");
        }

        #endregion

        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 영화 존재 여부 구하기 - MovieExists(id)

        /// <summary>
        /// 영화 존재 여부 구하기
        /// </summary>
        /// <param name="id">ID</param>
        /// <returns>영화 존재 여부</returns>
        private bool MovieExists(int id)
        {
            return this.context.Movie.Any(e => e.ID == id);
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

using Microsoft.AspNetCore.Mvc;

using Microsoft.AspNetCore.Mvc.RazorPages;

using Microsoft.EntityFrameworkCore;

using System.Linq;

using System.Threading.Tasks;

using TestProject.Data;

using TestProject.Models;

namespace TestProject.Pages.Movies

{

/// <summary>

/// 편집 모델

/// </summary>

public class EditModel : PageModel

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 컨텍스트

/// </summary>

private readonly DatabaseContext context;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 영화 - Movie

/// <summary>

/// 영화

/// </summary>

[BindProperty]

public Movie Movie { get; set; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - EditModel(context)

/// <summary>

/// 생성자

/// </summary>

/// <param name="context">컨텍스트</param>

public EditModel(DatabaseContext context)

{

this.context = context;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Public

#region GET 비동기 처리하기 - OnGetAsync(id)

/// <summary>

/// GET 비동기 처리하기

/// </summary>

/// <param name="id">ID</param>

/// <returns>액션 결과 태스크</returns>

public async Task<IActionResult> OnGetAsync(int id)

{

Movie = await this.context.Movie.FirstOrDefaultAsync(m => m.ID == id);

if(Movie == null)

{

return NotFound();

}

return Page();

}

#endregion

#region POST 비동기 처리하기 - OnPostAsync()

/// <summary>

/// POST 비동기 처리하기

/// </summary>

/// <returns>액션 결과 태스크</returns>

public async Task<IActionResult> OnPostAsync()

{

if(!ModelState.IsValid)

{

return Page();

}

this.context.Attach(Movie).State = EntityState.Modified;

try

{

await this.context.SaveChangesAsync();

}

catch(DbUpdateConcurrencyException)

{

if(!MovieExists(Movie.ID))

{

return NotFound();

}

else

{

throw;

}

return RedirectToPage("./Index");

}

#endregion

////////////////////////////////////////////////////////////////////////////////////////// Private

#region 영화 존재 여부 구하기 - MovieExists(id)

/// <summary>

/// 영화 존재 여부 구하기

/// </summary>

/// <param name="id">ID</param>

/// <returns>영화 존재 여부</returns>

private bool MovieExists(int id)

{

return this.context.Movie.Any(e => e.ID == id);

}

#endregion

}

▶ Pages/Movies/Delete.cshtml


@page "{id:int}"
@model TestProject.Pages.Movies.DeleteModel
@{
    ViewData["Title"] = "Delete";
}
<h1>Delete</h1>
<h3>Are you sure you want to delete this?</h3>
<div>
    <h4>Movie</h4>
    <hr />
    <dl class="row">
        <dt class="col-sm-2">
            @Html.DisplayNameFor(model => model.Movie.Title)
        </dt>
        <dd class="col-sm-10">
            @Html.DisplayFor(model => model.Movie.Title)
        </dd>
        <dt class="col-sm-2">
            @Html.DisplayNameFor(model => model.Movie.ReleaseDate)
        </dt>
        <dd class="col-sm-10">
            @Html.DisplayFor(model => model.Movie.ReleaseDate)
        </dd>
        <dt class="col-sm-2">
            @Html.DisplayNameFor(model => model.Movie.Genre)
        </dt>
        <dd class="col-sm-10">
            @Html.DisplayFor(model => model.Movie.Genre)
        </dd>
        <dt class="col-sm-2">
            @Html.DisplayNameFor(model => model.Movie.Price)
        </dt>
        <dd class="col-sm-10">
            @Html.DisplayFor(model => model.Movie.Price)
        </dd>
    </dl>
    <form method="post">
        <input type="hidden" asp-for="Movie.ID" />
        <input type="submit" value="Delete" class="btn btn-danger" /> |
        <a asp-page="./Index">Back to List</a>
    </form>
</div>

@page "{id:int}"

@model TestProject.Pages.Movies.DeleteModel

ViewData["Title"] = "Delete";

}

<h1>Delete</h1>

<h3>Are you sure you want to delete this?</h3>

<div>

<h4>Movie</h4>

<hr />

@Html.DisplayNameFor(model => model.Movie.Title)

</dt>

@Html.DisplayFor(model => model.Movie.Title)

</dd>

@Html.DisplayNameFor(model => model.Movie.ReleaseDate)

</dt>

@Html.DisplayFor(model => model.Movie.ReleaseDate)

</dd>

@Html.DisplayNameFor(model => model.Movie.Genre)

</dt>

@Html.DisplayFor(model => model.Movie.Genre)

</dd>

@Html.DisplayNameFor(model => model.Movie.Price)

</dt>

@Html.DisplayFor(model => model.Movie.Price)

</dd>

</dl>

<input type="submit" value="Delete" class="btn btn-danger" /> |

</form>

</div>

▶ Pages/Movies/Delete.cshtml.cs


using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Microsoft.EntityFrameworkCore;
using System.Threading.Tasks;

using TestProject.Data;
using TestProject.Models;

namespace TestProject.Pages.Movies
{
    /// <summary>
    /// 삭제 모델
    /// </summary>
    public class DeleteModel : PageModel
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 컨텍스트
        /// </summary>
        private readonly DatabaseContext context;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 영화 - Movie

        /// <summary>
        /// 영화
        /// </summary>
        [BindProperty]
        public Movie Movie { get; set; }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - DeleteModel(context)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="context">컨텍스트</param>
        public DeleteModel(DatabaseContext context)
        {
            this.context = context;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region GET 비동기 처리하기 - OnGetAsync(id)

        /// <summary>
        /// GET 비동기 처리하기
        /// </summary>
        /// <param name="id">ID</param>
        /// <returns>액션 결과 태스크</returns>
        public async Task<IActionResult> OnGetAsync(int id)
        {
            Movie = await this.context.Movie.FirstOrDefaultAsync(m => m.ID == id);

            if(Movie == null)
            {
                return NotFound();
            }

            return Page();
        }

        #endregion
        #region POST 비동기 처리하기 - OnPostAsync(id)

        /// <summary>
        /// POST 비동기 처리하기
        /// </summary>
        /// <param name="id">ID</param>
        /// <returns>액션 결과 태스크</returns>
        public async Task<IActionResult> OnPostAsync(int id)
        {
            Movie = await this.context.Movie.FindAsync(id);

            if(Movie != null)
            {
                this.context.Movie.Remove(Movie);

                await this.context.SaveChangesAsync();
            }

            return RedirectToPage("./Index");
        }

        #endregion
    }
}

100

101

102

103

104

105

using Microsoft.AspNetCore.Mvc;

using Microsoft.AspNetCore.Mvc.RazorPages;

using Microsoft.EntityFrameworkCore;

using System.Threading.Tasks;

using TestProject.Data;

using TestProject.Models;

namespace TestProject.Pages.Movies

{

/// <summary>

/// 삭제 모델

/// </summary>

public class DeleteModel : PageModel

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Private

#region Field

/// <summary>

/// 컨텍스트

/// </summary>

private readonly DatabaseContext context;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 영화 - Movie

/// <summary>

/// 영화

/// </summary>

[BindProperty]

public Movie Movie { get; set; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - DeleteModel(context)

/// <summary>

/// 생성자

/// </summary>

/// <param name="context">컨텍스트</param>

public DeleteModel(DatabaseContext context)

{

this.context = context;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Public

#region GET 비동기 처리하기 - OnGetAsync(id)

/// <summary>

/// GET 비동기 처리하기

/// </summary>

/// <param name="id">ID</param>

/// <returns>액션 결과 태스크</returns>

public async Task<IActionResult> OnGetAsync(int id)

{

Movie = await this.context.Movie.FirstOrDefaultAsync(m => m.ID == id);

if(Movie == null)

{

return NotFound();

}

return Page();

}

#endregion

#region POST 비동기 처리하기 - OnPostAsync(id)

/// <summary>

/// POST 비동기 처리하기

/// </summary>

/// <param name="id">ID</param>

/// <returns>액션 결과 태스크</returns>

public async Task<IActionResult> OnPostAsync(int id)

{

Movie = await this.context.Movie.FindAsync(id);

if(Movie != null)

{

this.context.Movie.Remove(Movie);

await this.context.SaveChangesAsync();

}

return RedirectToPage("./Index");

}

#endregion

}

▶

[C#/ASP.NET MVC/.NETCORE] ServiceProviderServiceExtensions 클래스 : GetRequiredService 확장 메소드를 사용해 데이터베이스 컨텍스트 구하기

■ ServiceProviderServiceExtensions 클래스의 GetRequiredService<T> 확장 메소드를 사용해 데이터베이스 컨텍스트를 구하는 방법을 보여준다. ▶ Models/MovieData.cs


using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using System;
using System.Linq;

using TestProject.Data;

namespace TestProject.Models
{
    /// <summary>
    /// 영화 데이터
    /// </summary>
    public static class MovieData
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Static
        //////////////////////////////////////////////////////////////////////////////// Public

        #region 초기화하기 - Initialize(serviceProvider)

        /// <summary>
        /// 초기화하기
        /// </summary>
        /// <param name="serviceProvider">서비스 제공자</param>
        public static void Initialize(IServiceProvider serviceProvider)
        {
            using(var context = new DatabaseContext(serviceProvider.GetRequiredService<DbContextOptions<DatabaseContext>>()))
            {
                if(context.Movie.Any())
                {
                    return;
                }

                context.Movie.AddRange
                (
                    new Movie
                    {
                        Title       = "When Harry Met Sally",
                        ReleaseDate = DateTime.Parse("1989-2-12"),
                        Genre       = "Romantic Comedy",
                        Price       = 7.99M
                    },
                    new Movie
                    {
                        Title       = "Ghostbusters ",
                        ReleaseDate = DateTime.Parse("1984-3-13"),
                        Genre       = "Comedy",
                        Price       = 8.99M
                    },
                    new Movie
                    {
                        Title       = "Ghostbusters 2",
                        ReleaseDate = DateTime.Parse("1986-2-23"),
                        Genre       = "Comedy",
                        Price       = 9.99M
                    },
                    new Movie
                    {
                        Title       = "Rio Bravo",
                        ReleaseDate = DateTime.Parse("1959-4-15"),
                        Genre       = "Western",
                        Price       = 3.99M
                    }
                );

                context.SaveChanges();
            }
        }

        #endregion
    }
}

using Microsoft.EntityFrameworkCore;

using Microsoft.Extensions.DependencyInjection;

using System;

using System.Linq;

using TestProject.Data;

namespace TestProject.Models

{

/// <summary>

/// 영화 데이터

/// </summary>

public static class MovieData

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Public

#region 초기화하기 - Initialize(serviceProvider)

/// <summary>

/// 초기화하기

/// </summary>

/// <param name="serviceProvider">서비스 제공자</param>

public static void Initialize(IServiceProvider serviceProvider)

{

using(var context = new DatabaseContext(serviceProvider.GetRequiredService<DbContextOptions<DatabaseContext>>()))

{

if(context.Movie.Any())

{

return;

}

context.Movie.AddRange

(

new Movie

{

Title = "When Harry Met Sally",

ReleaseDate = DateTime.Parse("1989-2-12"),

Genre = "Romantic Comedy",

Price = 7.99M

new Movie

{

Title = "Ghostbusters ",

ReleaseDate = DateTime.Parse("1984-3-13"),

Genre = "Comedy",

Price = 8.99M

new Movie

{

Title = "Ghostbusters 2",

ReleaseDate = DateTime.Parse("1986-2-23"),

Genre = "Comedy",

Price = 9.99M

new Movie

{

Title = "Rio Bravo",

ReleaseDate = DateTime.Parse("1959-4-15"),

Genre = "Western",

Price = 3.99M

}

);

context.SaveChanges();

}

#endregion

}

▶ Program.cs


using Microsoft.AspNetCore.Hosting;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;
using Microsoft.Extensions.Logging;
using System;

using TestProject.Models;

namespace TestProject
{
    /// <summary>
    /// 프로그램
    /// </summary>
    public class Program
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Static
        //////////////////////////////////////////////////////////////////////////////// Public

        #region 프로그램 시작하기 - Main(argumentArray)

        /// <summary>
        /// 프로그램 시작하기
        /// </summary>
        /// <param name="argumentArray">인자 배열</param>
        public static void Main(string[] argumentArray)
        {
            IHost host = CreateHostBuilder(argumentArray).Build();

            using(IServiceScope scope = host.Services.CreateScope())
            {
                IServiceProvider serviceProvider = scope.ServiceProvider;

                try
                {
                    MovieData.Initialize(serviceProvider);
                }
                catch(Exception exception)
                {
                    ILogger<Program> logger = serviceProvider.GetRequiredService<ILogger<Program>>();

                    logger.LogError(exception, "데이터베이스에 데이터 추가시 에러가 발생했습니다.");
                }
            }

            host.Run();
        }

        #endregion
        #region 호스트 빌더 생성하기 - CreateHostBuilder(argumentArray)

        /// <summary>
        /// 호스트 빌더 생성하기
        /// </summary>
        /// <param name="argumentArray">인자 배열</param>
        /// <returns>호스트 빌더</returns>
        public static IHostBuilder CreateHostBuilder(string[] argumentArray) =>
            Host.CreateDefaultBuilder(argumentArray)
                .ConfigureWebHostDefaults
                (
                    builder =>
                    {
                        builder.UseStartup<Startup>();
                    }
                );

        #endregion
    }
}

using Microsoft.AspNetCore.Hosting;

using Microsoft.Extensions.DependencyInjection;

using Microsoft.Extensions.Hosting;

using Microsoft.Extensions.Logging;

using System;

using TestProject.Models;

namespace TestProject

{

/// <summary>

/// 프로그램

/// </summary>

public class Program

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Static

//////////////////////////////////////////////////////////////////////////////// Public

#region 프로그램 시작하기 - Main(argumentArray)

/// <summary>

/// 프로그램 시작하기

/// </summary>

/// <param name="argumentArray">인자 배열</param>

public static void Main(string[] argumentArray)

{

IHost host = CreateHostBuilder(argumentArray).Build();

using(IServiceScope scope = host.Services.CreateScope())

{

IServiceProvider serviceProvider = scope.ServiceProvider;

try

{

MovieData.Initialize(serviceProvider);

}

catch(Exception exception)

{

ILogger<Program> logger = serviceProvider.GetRequiredService<ILogger<Program>>();

logger.LogError(exception, "데이터베이스에 데이터 추가시 에러가 발생했습니다.");

}

host.Run();

}

#endregion

#region 호스트 빌더 생성하기 - CreateHostBuilder(argumentArray)

/// <summary>

/// 호스트 빌더 생성하기

/// </summary>

/// <param name="argumentArray">인자 배열</param>

/// <returns>호스트 빌더</returns>

public static IHostBuilder CreateHostBuilder(string[] argumentArray) =>

Host.CreateDefaultBuilder(argumentArray)

.ConfigureWebHostDefaults

(

builder =>

{

builder.UseStartup<Startup>();

}

);

#endregion

}

※ TestDB 데이터베이스 생성

[C#/ASP.NET MVC/.NETCORE] @model 지시문 사용하기

■ @model 지시문을 사용하는 방법을 보여준다. @model 지시문은 RAZOR 페이지에 전달되는 모델 형식을 지정한다. @model 지시문은 아래의 예제와 같이 RAZOR 페이지에서 PageModel

[C#/ASP.NET MVC/.NETCORE] @page 지시문 사용하기

■ @page 지시문을 사용하는 방법을 보여준다. 파일을 MVC 작업으로 만든다. – 이것은 요청을 처리할 수 있음을 의미한다. @page 지시문은 페이지의 첫 번째

[C#/ASP.NET MVC/.NETCORE] dotnet aspnet-codegenerator razorpage 명령 : 스캐폴딩 기능을 사용해 CRUD 페이지 추가하기

■ dotnet aspnet-codegenerator razorpage 명령을 사용해 스캐폴딩 기능을 사용해 RAZOR CRUD 페이지를 추가하는 방법을 보여준다. 1. [명령 프롬프트]를 실행한다. 2. [명령 프롬프트]에서

[C#/ASP.NET MVC/.NETCORE] dotnet aspnet-codegenerator razorpage 명령 : 도움말 보기

■ dotnet aspnet-codegenerator razorpage 명령을 사용해 도움말을 보는 방법을 보여준다. 1. [명령 프롬프트]를 실행한다. 2. [명령 프롬프트]에서 아래 명령을 실행한다. ▶ 실행

[C#/ASP.NET MVC/.NETCORE] Entity Framework Core를 사용해 SQL Server 접속하기

■ Entity Framework Core를 사용해 SQL Server 접속하기 1. 비주얼 스튜디오를 실행한다. 2. [Visual Studio 2019] 대화 상자에서 [새 프로젝트 만들기] 항목을

[C#/ASP.NET MVC/.NETCORE] 스캐폴딩 기능을 사용해 RAZOR 페이지 웹앱 만들기

■ 스캐폴딩 기능을 사용해 RAZOR 페이지 웹앱을 만드는 방법을 보여준다. ▶ Models/Movie.cs


using System;
using System.ComponentModel.DataAnnotations;

namespace TestProject.Models
{
    /// <summary>
    /// 영화
    /// </summary>
    public class Movie
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region ID - ID

        /// <summary>
        /// ID
        /// </summary>
        public int ID { get; set; }

        #endregion
        #region 제목 - Title

        /// <summary>
        /// 제목
        /// </summary>
        public string Title { get; set; }

        #endregion
        #region 릴리즈 일자 - ReleaseDate

        /// <summary>
        /// 릴리즈 일자
        /// </summary>
        [DataType(DataType.Date)]
        public DateTime ReleaseDate { get; set; }

        #endregion
        #region 장르 - Genre

        /// <summary>
        /// 장르
        /// </summary>
        public string Genre { get; set; }

        #endregion
        #region 가격 - Price

        /// <summary>
        /// 가격
        /// </summary>
        public decimal Price { get; set; }

        #endregion
    }
}

using System;

using System.ComponentModel.DataAnnotations;

namespace TestProject.Models

{

/// <summary>

/// 영화

/// </summary>

public class Movie

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region ID - ID

/// <summary>

/// ID

/// </summary>

public int ID { get; set; }

#endregion

#region 제목 - Title

/// <summary>

/// 제목

/// </summary>

public string Title { get; set; }

#endregion

#region 릴리즈 일자 - ReleaseDate

/// <summary>

/// 릴리즈 일자

/// </summary>

[DataType(DataType.Date)]

public DateTime ReleaseDate { get; set; }

#endregion

#region 장르 - Genre

/// <summary>

/// 장르

/// </summary>

public string Genre { get; set; }

#endregion

#region 가격 - Price

/// <summary>

/// 가격

/// </summary>

public decimal Price { get; set; }

#endregion

}

▶ Data/DatabaseContext.cs


using Microsoft.EntityFrameworkCore;

using TestProject.Models;

namespace TestProject.Data
{
    /// <summary>
    /// 데이터베이스 컨텍스트
    /// </summary>
    public class DatabaseContext : DbContext
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 영화 - Movie

        /// <summary>
        /// 영화
        /// </summary>
        public DbSet<Movie> Movie { get; set; }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - DatabaseContext(options)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="options">옵션</param>
        public DatabaseContext(DbContextOptions<DatabaseContext> options) : base(options)
        {
        }

        #endregion
    }
}

using Microsoft.EntityFrameworkCore;

using TestProject.Models;

namespace TestProject.Data

{

/// <summary>

/// 데이터베이스 컨텍스트

/// </summary>

public class DatabaseContext : DbContext

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 영화 - Movie

/// <summary>

/// 영화

/// </summary>

public DbSet<Movie> Movie { get; set; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - DatabaseContext(options)

/// <summary>

/// 생성자

/// </summary>

/// <param name="options">옵션</param>

public DatabaseContext(DbContextOptions<DatabaseContext> options) : base(options)

{

}

#endregion

}

▶ appsettings.json


{
    "Logging" :
    {
        "LogLevel" :
        {
            "Default"                    : "Information",
            "Microsoft"                  : "Warning",
            "Microsoft.Hosting.Lifetime" : "Information"
        }
    },
    "AllowedHosts"      : "*",
    "ConnectionStrings" :
    {
        "DefaultConnection" : "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=TestDB;Integrated Security=True;"
    }
}

{

"Logging" :

{

"LogLevel" :

{

"Default" : "Information",

"Microsoft" : "Warning",

"Microsoft.Hosting.Lifetime" : "Information"

}

"AllowedHosts" : "*",

"ConnectionStrings" :

{

"DefaultConnection" : "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=TestDB;Integrated Security=True;"

}

▶ Startup.cs


using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;

using TestProject.Data;

namespace TestProject
{
    /// <summary>
    /// 시작
    /// </summary>
    public class Startup
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 구성 - Configuration

        /// <summary>
        /// 구성
        /// </summary>
        public IConfiguration Configuration { get; }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - Startup(configuration)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="configuration">구성</param>
        public Startup(IConfiguration configuration)
        {
            Configuration = configuration;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 서비스 컬렉션 구성하기 - ConfigureServices(services)

        /// <summary>
        /// 서비스 컬렉션 구성하기
        /// </summary>
        /// <param name="services">서비스 컬렉션</param>
        public void ConfigureServices(IServiceCollection services)
        {
            services.AddDbContext<DatabaseContext>
            (
                options =>
                {
                    options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"));
                }
            );

            services.AddRazorPages();
        }

        #endregion
        #region 구성하기 - Configure(app, environment)

        /// <summary>
        /// 구성하기
        /// </summary>
        /// <param name="app">애플리케이션 빌더</param>
        /// <param name="environment">웹 호스트 환경</param>
        public void Configure(IApplicationBuilder app, IWebHostEnvironment environment)
        {
            if(environment.IsDevelopment())
            {
                app.UseDeveloperExceptionPage();
            }
            else
            {
                app.UseExceptionHandler("/Error");

                app.UseHsts();
            }

            app.UseHttpsRedirection();

            app.UseStaticFiles();

            app.UseRouting();

            app.UseAuthorization();

            app.UseEndpoints(endpoints =>
            {
                endpoints.MapRazorPages();
            });
        }

        #endregion
    }
}

100

101

102

103

104

105

106

using Microsoft.AspNetCore.Builder;

using Microsoft.AspNetCore.Hosting;

using Microsoft.EntityFrameworkCore;

using Microsoft.Extensions.Configuration;

using Microsoft.Extensions.DependencyInjection;

using Microsoft.Extensions.Hosting;

using TestProject.Data;

namespace TestProject

{

/// <summary>

/// 시작

/// </summary>

public class Startup

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 구성 - Configuration

/// <summary>

/// 구성

/// </summary>

public IConfiguration Configuration { get; }

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 생성자 - Startup(configuration)

/// <summary>

/// 생성자

/// </summary>

/// <param name="configuration">구성</param>

public Startup(IConfiguration configuration)

{

Configuration = configuration;

}

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 서비스 컬렉션 구성하기 - ConfigureServices(services)

/// <summary>

/// 서비스 컬렉션 구성하기

/// </summary>

/// <param name="services">서비스 컬렉션</param>

public void ConfigureServices(IServiceCollection services)

{

services.AddDbContext<DatabaseContext>

(

options =>

{

options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection"));

}

);

services.AddRazorPages();

}

#endregion

#region 구성하기 - Configure(app, environment)

/// <summary>

/// 구성하기

/// </summary>

/// <param name="app">애플리케이션 빌더</param>

/// <param name="environment">웹 호스트 환경</param>

public void Configure(IApplicationBuilder app, IWebHostEnvironment environment)

{

if(environment.IsDevelopment())

{

app.UseDeveloperExceptionPage();

}

else

{

app.UseExceptionHandler("/Error");

app.UseHsts();

}

app.UseHttpsRedirection();

app.UseStaticFiles();

app.UseRouting();

app.UseAuthorization();

app.UseEndpoints(endpoints =>

{

endpoints.MapRazorPages();

});

}

#endregion

}

[C#/ASP.NET MVC/.NETCORE] Microsoft.VisualStudio.Web.CodeGeneration.Design 누겟 설치하기

■ Microsoft.VisualStudio.Web.CodeGeneration.Design 누겟을 설치하는 방법을 보여준다. 1. Visual Studio를 실행한다. 2. [도구] / [NuGet 패키지 관리자] / [패키지 관리자 콘솔] 메뉴를 실행한다.

[C#/ASP.NET MVC/.NETCORE] dotnet tool install 명령 : 스캐폴딩 도구 설치하기

■ dotnet tool install 명령을 사용해 스캐폴딩 도구를 설치하는 방법을 보여준다. 1. [명령 프롬프트]를 실행한다. 2. [명령 프롬프트]에서 아래 명령을 실행한다. ▶

[C#/ASP.NET MVC/.NETCORE] dotnet dev-certs https 명령 : 개발 인증서 신뢰하기

■ dotnet dev-certs https 명령을 사용해 개발 인증서를 신뢰하는 방법을 보여준다. 1. [명령 프롬프트]를 실행한다. 2. [명령 프롬프트]에서 아래 명령을 실행한다. ▶

[C#/ASP.NET MVC/.NETCORE] dotnet new webapp 명령 : RAZOR 페이지 웹앱 만들기

■ dotnet new webapp 명령을 사용해 RAZOR 페이지 웹앱을 만드는 방법을 보여준다. 1. [명령 프롬프트]를 실행한다. 2. [명령 프롬프트]에서 아래 명령을 실행한다.

[C#/ASP.NET MVC/.NETCORE] ASP.NET CORE MVC 게시판 만들기

■ ASP.NET CORE 게시판을 만드는 방법을 보여준다. ▶ Properties/launchSettings.json


{
    "iisSettings" :
    {
        "windowsAuthentication"   : false,
        "anonymousAuthentication" : true,
        "iisExpress"              :
        {
            "applicationUrl" : "http://localhost:1795",
            "sslPort"        : 44306
        }
    },
    "profiles" :
    {
        "IIS Express" :
        {
            "commandName"          : "IISExpress",
            "launchBrowser"        : true,
            "launchUrl"            : "NoticeBoard",
            "environmentVariables" :
            {
                "ASPNETCORE_ENVIRONMENT" : "Development"
            }
        },
        "TestProject" :
        {
            "commandName"          : "Project",
            "launchBrowser"        : true,
            "launchUrl"            : "NoticeBoard",
            "applicationUrl"       : "https://localhost:5001;http://localhost:5000",
            "environmentVariables" :
            {
                "ASPNETCORE_ENVIRONMENT" : "Development"
            }
        }
    }
}

{

"iisSettings" :

{

"windowsAuthentication" : false,

"anonymousAuthentication" : true,

"iisExpress" :

{

"applicationUrl" : "http://localhost:1795",

"sslPort" : 44306

}

"profiles" :

{

"IIS Express" :

{

"commandName" : "IISExpress",

"launchBrowser" : true,

"launchUrl" : "NoticeBoard",

"environmentVariables" :

{

"ASPNETCORE_ENVIRONMENT" : "Development"

}

"TestProject" :

{

"commandName" : "Project",

"launchBrowser" : true,

"launchUrl" : "NoticeBoard",

"applicationUrl" : "https://localhost:5001;http://localhost:5000",

"environmentVariables" :

{

"ASPNETCORE_ENVIRONMENT" : "Development"

}

▶ appsettings.json


{
    "ConnectionStrings" :
    {
        "DefaultConnection" : "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=TestDB;Integrated Security=True;"
    },
    "Logging" :
    {
        "LogLevel" :
        {
            "Default"                    : "Information",
            "Microsoft"                  : "Warning",
            "Microsoft.Hosting.Lifetime" : "Information"
        }
    },
    "AllowedHosts" : "*",
    "MainSettings" :
    {

        "SiteAdministrator" : "admin"

    }
}

{

"ConnectionStrings" :

{

"DefaultConnection" : "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=TestDB;Integrated Security=True;"

"Logging" :

{

"LogLevel" :

{

"Default" : "Information",

"Microsoft" : "Warning",

"Microsoft.Hosting.Lifetime" : "Information"

}

"AllowedHosts" : "*",

"MainSettings" :

{

"SiteAdministrator" : "admin"

}

▶ Database/TestDB.sql


CREATE TABLE dbo.Notice
(
    ID            INT           IDENTITY(1, 1) NOT NULL PRIMARY KEY -- ID
   ,[Name]        NVARCHAR(25)  NOT NULL                            -- 작성자명
   ,MailAddress   NVARCHAR(100) NULL                                -- 메일 주소
   ,Title         NVARCHAR(150) NOT NULL                            -- 제목
   ,WriteDate     DATETIME      DEFAULT GETDATE() NOT NULL          -- 작성일
   ,WriteIP       NVARCHAR(15)  NULL                                -- 작성 IP
   ,Content       NTEXT         NOT NULL                            -- 내용
   ,[Password]    NVARCHAR(20)  NULL                                -- 패스워드
   ,ReadCount     INT           DEFAULT 0                           -- 조회 수
   ,[Encoding]    NVARCHAR(10)  NOT NULL                            -- 인코딩(HTML/TEXT)
   ,Homepage      NVARCHAR(100) NULL                                -- 홈페이지
   ,UpdateDate    DATETIME      NULL                                -- 수정일
   ,UpdateIP      NVARCHAR(15)  NULL                                -- 수정 IP
   ,[FileName]    NVARCHAR(255) NULL                                -- 파일명
   ,FileSize      INT           DEFAULT 0                           -- 파일 크기
   ,DownloadCount INT           DEFAULT 0                           -- 다운로드 수
   ,ReferenceID   INT           NOT NULL                            -- 참조 ID
   ,ReplyLevel    INT           DEFAULT 0                           -- 답변 레벨
   ,ReplyOrder    INT           DEFAULT 0                           -- 답변 순서
   ,ReplyCount    INT           DEFAULT 0                           -- 답변 수
   ,ParentID      INT           DEFAULT 0                           -- 부모 ID
   ,CommentCount  INT           DEFAULT 0                           -- 댓글 수
   ,Category      NVARCHAR(50)  Default('FREE') Null                -- 카테고리
)
GO

CREATE TABLE dbo.NoticeComment
(
    ID         INT            IDENTITY(1, 1) NOT NULL PRIMARY KEY -- ID
   ,NoticeID   INT            NOT NULL                            -- 게시판 ID
   ,[Name]     NVARCHAR(25)   NOT NULL                            -- 작성자명
   ,Comment    NVARCHAR(4000) NOT NULL                            -- 내용
   ,WriteDate  SMALLDATETIME  DEFAULT(GETDATE())                  -- 작성일
   ,[Password] NVARCHAR(20)   NOT NULL                            -- 패스워드
)
GO

CREATE PROCEDURE dbo.WriteNotice
    @Name        NVARCHAR(25)
   ,@MailAddress NVARCHAR(100)
   ,@Title       NVARCHAR(150)
   ,@WriteIP     NVARCHAR(15)
   ,@Content     NTEXT
   ,@Password    NVARCHAR(20)
   ,@Encoding    NVARCHAR(10)
   ,@Homepage    NVARCHAR(100)
   ,@FileName    NVARCHAR(255)
   ,@FileSize    INT
AS
    DECLARE @MaximumReferenceID INT;

    SELECT @MaximumReferenceID = MAX(ReferenceID) FROM dbo.Notice;

    IF @MaximumReferenceID IS NULL
    BEGIN
        SET @MaximumReferenceID = 1;
    END
    ELSE
    BEGIN
        SET @MaximumReferenceID = @MaximumReferenceID + 1;
    END

    INSERT INTO dbo.Notice
    (
        [Name]
       ,MailAddress
       ,Title
       ,WriteIP
       ,Content
       ,[Password]
       ,[Encoding]
       ,Homepage
       ,[ReferenceID]
       ,[FileName]
       ,[FileSize]
    )
    Values
    (
        @Name
       ,@MailAddress
       ,@Title
       ,@WriteIP
       ,@Content
       ,@Password
       ,@Encoding
       ,@Homepage
       ,@MaximumReferenceID
       ,@FileName
       ,@FileSize
    );
GO

CREATE PROCEDURE dbo.ListNotice
    @Page INT
AS
    WITH OrderedNoticeBoard
    AS
    (
        SELECT
            ID
           ,[Name]
           ,MailAddress
           ,Title
           ,WriteDate
           ,ReadCount
           ,ReferenceID
           ,ReplyLevel
           ,ReplyOrder
           ,ReplyCount
           ,ParentID
           ,CommentCount
           ,[FileName]
           ,FileSize
           ,DownloadCount
           ,ROW_NUMBER() OVER (ORDER BY ReferenceID DESC, ReplyOrder ASC) AS 'RowNumber'
        FROM dbo.Notice
    )
    SELECT *
    FROM   OrderedNoticeBoard
    WHERE  RowNumber BETWEEN @Page * 10 + 1 AND (@Page + 1) * 10;
GO

CREATE PROCEDURE dbo.ViewNotice
    @ID Int
As
    UPDATE dbo.Notice
    SET    ReadCount = ReadCount + 1
    WHERE  ID = @ID;

    SELECT *
    FROM   dbo.Notice
    WHERE  ID = @ID;
GO

CREATE PROCEDURE dbo.ReplyNotice
    @Name        NVARCHAR(25)
   ,@MailAddress NVARCHAR(100)
   ,@Title       NVARCHAR(150)
   ,@WriteIP     NVARCHAR(15)
   ,@Content     NTEXT
   ,@Password    NVARCHAR(20)
   ,@Encoding    NVARCHAR(10)
   ,@Homepage    NVARCHAR(100)
   ,@ParentID    INT
   ,@FileName    NVARCHAR(255)
   ,@FileSize    INT
AS
    DECLARE @MaximumReplyOrder INT;
    DECLARE @MaximumReplyCount INT;
    DECLARE @ParentReferenceID INT;
    DECLARE @ParentReplyLevel  INT;
    DECLARE @ParentReplyOrder  INT;

    UPDATE dbo.Notice
    Set    ReplyCount = ReplyCount + 1
    WHERE  ID = @ParentID;

    SELECT
        @MaximumReplyOrder = ReplyOrder
       ,@MaximumReplyCount = ReplyCount
    FROM  dbo.Notice
    WHERE ParentID   = @ParentID
    AND   ReplyOrder = (SELECT MAX(ReplyOrder) FROM dbo.Notice WHERE ParentID = @ParentID);

    IF @MaximumReplyOrder IS NULL
    BEGIN
        SELECT @MaximumReplyOrder = ReplyOrder
        FROM   dbo.Notice
        WHERE  ID = @ParentID;

        SET @MaximumReplyCount = 0;
    END

    SELECT
        @ParentReferenceID = ReferenceID
       ,@ParentReplyLevel  = ReplyLevel
    FROM  dbo.Notice
    WHERE ID = @ParentID;

    UPDATE dbo.Notice
    SET    ReplyOrder  = ReplyOrder + 1
    WHERE  ReferenceID = @ParentReferenceID And ReplyOrder > (@MaximumReplyOrder + @MaximumReplyCount);

    INSERT INTO dbo.Notice
    (
        [Name]
       ,MailAddress
       ,Title
       ,WriteIP
       ,Content
       ,[Password]
       ,[Encoding]
       ,Homepage
       ,ReferenceID
       ,ReplyLevel
       ,ReplyOrder
       ,ParentID
       ,[FileName]
       ,FileSize
    )
    VALUES
    (
        @Name
       ,@MailAddress
       ,@Title
       ,@WriteIP
       ,@Content
       ,@Password
       ,@Encoding
       ,@Homepage
       ,@ParentReferenceID
       ,@ParentReplyLevel + 1
       ,@MaximumReplyOrder + @MaximumReplyCount + 1
       ,@ParentID
       ,@FileName
       ,@FileSize
    );
GO

CREATE PROCEDURE dbo.GetNoticeCount
As
    Select Count(*) From dbo.Notice;
GO

CREATE PROCEDURE dbo.SearchNoticeCount
    @SearchField NVARCHAR(25)
   ,@SearchQuery NVARCHAR(25)
AS
    SET @SearchQuery = '%' + @SearchQuery + '%';

    SELECT COUNT(*)
    FROM   dbo.Notice
    WHERE
    (
        CASE @SearchField
            WHEN 'Name'    THEN [Name]
            WHEN 'Title'   THEN Title
            WHEN 'Content' THEN Content
            ELSE                @SearchQuery
        END
    )
    LIKE @SearchQuery;
GO

CREATE PROCEDURE dbo.DeleteNotice
    @ID       INT
   ,@Password NVARCHAR(30)
AS
    DECLARE @Count INT;

    SELECT @Count = COUNT(*)
    FROM   dbo.Notice
    WHERE  ID         = @ID
    AND    [Password] = @Password;

    IF @Count = 0
    BEGIN
        Return 0;
    END

    DECLARE @ReplyCount  INT;
    DECLARE @ReplyOrder  INT;
    DECLARE @ReferenceID INT;
    DECLARE @ParentID    INT;

    SELECT
        @ReplyCount  = ReplyCount
       ,@ReplyOrder  = ReplyOrder
       ,@ReferenceID = ReferenceID
       ,@ParentID    = ParentID
    FROM  dbo.Notice
    WHERE ID = @ID;

    IF @ReplyCount = 0
    BEGIN
        IF @ReplyOrder > 0
        BEGIN
            UPDATE dbo.Notice
            SET    ReplyOrder  = ReplyOrder - 1
            WHERE  ReferenceID = @ReferenceID
            AND    ReplyOrder  > @ReplyOrder;

            UPDATE Notice
            SET    ReplyCount = ReplyCount - 1
            WHERE  ID = @ParentID;
        END

        DELETE FROM dbo.Notice
        WHERE ID = @ID;

        DELETE FROM dbo.Notice
        WHERE  ID         = @ParentID
        AND    UpdateIP   = N'((DELETED))'
        AND    ReplyCount = 0;
    END
    ELSE
    BEGIN
        UPDATE dbo.Notice
        SET
            [Name]       = N'(Unknown)',
            MailAddress  = '',
            [Password]   = '',
            Title        = N'(삭제된 글입니다.)',
            Content      = N'(삭제된 글입니다. 현재 답변이 포함되어 있기 때문에 내용만 삭제되었습니다.)',
            UpdateIP     = N'((DELETED))',
            [FileName]   = '',
            FileSize     = 0,
            CommentCount = 0
        WHERE ID = @ID;
    END
GO

CREATE PROCEDURE dbo.UpdateNotice
    @Name        NVARCHAR(25)
   ,@MailAddress NVARCHAR(100)
   ,@Title       NVARCHAR(150)
   ,@UpdateIP    NVARCHAR(15)
   ,@Content     NTEXT
   ,@Password    NVARCHAR(30)
   ,@Encoding    NVARCHAR(10)
   ,@Homepage    NVARCHAR(100)
   ,@FileName    NVARCHAR(255)
   ,@FileSize    INT
   ,@ID          INT
AS
    DECLARE @Count INT

    SELECT @Count = Count(*)
    FROM   dbo.Notice
    WHERE  ID         = @ID
    AND    [Password] = @Password;

    IF @Count > 0
    BEGIN
        UPDATE dbo.Notice
        SET
            [Name]      = @Name
           ,MailAddress = @MailAddress
           ,Title       = @Title
           ,UpdateIP    = @UpdateIP
           ,UpdateDate  = GETDATE()
           ,Content     = @Content
           ,[Encoding]  = @Encoding
           ,Homepage    = @Homepage
           ,[FileName]  = @FileName
           ,FileSize    = @FileSize
        Where ID = @ID;

        SELECT '1';
    END
    ELSE
        SELECT '0';
GO

CREATE PROCEDURE dbo.SearchNotice
    @Page        INT
   ,@SearchField NVARCHAR(25)
   ,@SearchQuery NVARCHAR(25)
AS
    WITH OrderedNoticeBoard
    AS
    (
        SELECT
            ID
           ,[Name]
           ,MailAddress
           ,Title
           ,WriteDate
           ,ReadCount
           ,ReferenceID
           ,ReplyLevel
           ,ReplyOrder
           ,ReplyCount
           ,ParentID
           ,CommentCount
           ,[FileName]
           ,FileSize
           ,DownloadCount
           ,ROW_NUMBER() OVER (ORDER BY ReferenceID DESC, ReplyOrder ASC) AS 'RowNumber'
        FROM dbo.Notice
        WHERE
        (
            CASE @SearchField
                WHEN 'Name'    THEN [Name]
                WHEN 'Title'   THEN Title
                WHEN 'Content' THEN Content
                ELSE                @SearchQuery
            END
        )
        LIKE '%' + @SearchQuery + '%'
    )
    SELECT
        ID
       ,[Name]
       ,MailAddress
       ,Title
       ,WriteDate
       ,ReadCount
       ,ReferenceID
       ,ReplyLevel
       ,ReplyOrder
       ,ReplyCount
       ,ParentID
       ,CommentCount
       ,[FileName]
       ,FileSize
       ,DownloadCount
       ,RowNumber
    FROM  OrderedNoticeBoard
    WHERE RowNumber BETWEEN @Page * 10 + 1 AND (@Page + 1) * 10
    ORDER BY ID DESC;
GO

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

CREATE TABLE dbo.Notice

(

ID INT IDENTITY(1, 1) NOT NULL PRIMARY KEY -- ID

,[Name] NVARCHAR(25) NOT NULL -- 작성자명

,MailAddress NVARCHAR(100) NULL -- 메일 주소

,Title NVARCHAR(150) NOT NULL -- 제목

,WriteDate DATETIME DEFAULT GETDATE() NOT NULL -- 작성일

,WriteIP NVARCHAR(15) NULL -- 작성 IP

,Content NTEXT NOT NULL -- 내용

,[Password] NVARCHAR(20) NULL -- 패스워드

,ReadCount INT DEFAULT 0 -- 조회 수

,[Encoding] NVARCHAR(10) NOT NULL -- 인코딩(HTML/TEXT)

,Homepage NVARCHAR(100) NULL -- 홈페이지

,UpdateDate DATETIME NULL -- 수정일

,UpdateIP NVARCHAR(15) NULL -- 수정 IP

,[FileName] NVARCHAR(255) NULL -- 파일명

,FileSize INT DEFAULT 0 -- 파일 크기

,DownloadCount INT DEFAULT 0 -- 다운로드 수

,ReferenceID INT NOT NULL -- 참조 ID

,ReplyLevel INT DEFAULT 0 -- 답변 레벨

,ReplyOrder INT DEFAULT 0 -- 답변 순서

,ReplyCount INT DEFAULT 0 -- 답변 수

,ParentID INT DEFAULT 0 -- 부모 ID

,CommentCount INT DEFAULT 0 -- 댓글 수

,Category NVARCHAR(50) Default('FREE') Null -- 카테고리

)

CREATE TABLE dbo.NoticeComment

(

ID INT IDENTITY(1, 1) NOT NULL PRIMARY KEY -- ID

,NoticeID INT NOT NULL -- 게시판 ID

,[Name] NVARCHAR(25) NOT NULL -- 작성자명

,Comment NVARCHAR(4000) NOT NULL -- 내용

,WriteDate SMALLDATETIME DEFAULT(GETDATE()) -- 작성일

,[Password] NVARCHAR(20) NOT NULL -- 패스워드

)

CREATE PROCEDURE dbo.WriteNotice

@Name NVARCHAR(25)

,@MailAddress NVARCHAR(100)

,@Title NVARCHAR(150)

,@WriteIP NVARCHAR(15)

,@Content NTEXT

,@Password NVARCHAR(20)

,@Encoding NVARCHAR(10)

,@Homepage NVARCHAR(100)

,@FileName NVARCHAR(255)

,@FileSize INT

DECLARE @MaximumReferenceID INT;

SELECT @MaximumReferenceID = MAX(ReferenceID) FROM dbo.Notice;

IF @MaximumReferenceID IS NULL

BEGIN

SET @MaximumReferenceID = 1;

END

ELSE

BEGIN

SET @MaximumReferenceID = @MaximumReferenceID + 1;

END

INSERT INTO dbo.Notice

(

[Name]

,MailAddress

,Title

,WriteIP

,Content

,[Password]

,[Encoding]

,Homepage

,[ReferenceID]

,[FileName]

,[FileSize]

)

Values

(

@Name

,@MailAddress

,@Title

,@WriteIP

,@Content

,@Password

,@Encoding

,@Homepage

,@MaximumReferenceID

,@FileName

,@FileSize

);

CREATE PROCEDURE dbo.ListNotice

@Page INT

WITH OrderedNoticeBoard

(

SELECT

,[Name]

,MailAddress

,Title

,WriteDate

,ReadCount

,ReferenceID

,ReplyLevel

,ReplyOrder

,ReplyCount

,ParentID

,CommentCount

,[FileName]

,FileSize

,DownloadCount

,ROW_NUMBER() OVER (ORDER BY ReferenceID DESC, ReplyOrder ASC) AS 'RowNumber'

FROM dbo.Notice

)

SELECT *

FROM OrderedNoticeBoard

WHERE RowNumber BETWEEN @Page * 10 + 1 AND (@Page + 1) * 10;

CREATE PROCEDURE dbo.ViewNotice

@ID Int

UPDATE dbo.Notice

SET ReadCount = ReadCount + 1

WHERE ID = @ID;

SELECT *

FROM dbo.Notice

WHERE ID = @ID;

CREATE PROCEDURE dbo.ReplyNotice

@Name NVARCHAR(25)

,@MailAddress NVARCHAR(100)

,@Title NVARCHAR(150)

,@WriteIP NVARCHAR(15)

,@Content NTEXT

,@Password NVARCHAR(20)

,@Encoding NVARCHAR(10)

,@Homepage NVARCHAR(100)

,@ParentID INT

,@FileName NVARCHAR(255)

,@FileSize INT

DECLARE @MaximumReplyOrder INT;

DECLARE @MaximumReplyCount INT;

DECLARE @ParentReferenceID INT;

DECLARE @ParentReplyLevel INT;

DECLARE @ParentReplyOrder INT;

UPDATE dbo.Notice

Set ReplyCount = ReplyCount + 1

WHERE ID = @ParentID;

SELECT

@MaximumReplyOrder = ReplyOrder

,@MaximumReplyCount = ReplyCount

FROM dbo.Notice

WHERE ParentID = @ParentID

AND ReplyOrder = (SELECT MAX(ReplyOrder) FROM dbo.Notice WHERE ParentID = @ParentID);

IF @MaximumReplyOrder IS NULL

BEGIN

SELECT @MaximumReplyOrder = ReplyOrder

FROM dbo.Notice

WHERE ID = @ParentID;

SET @MaximumReplyCount = 0;

END

SELECT

@ParentReferenceID = ReferenceID

,@ParentReplyLevel = ReplyLevel

FROM dbo.Notice

WHERE ID = @ParentID;

UPDATE dbo.Notice

SET ReplyOrder = ReplyOrder + 1

WHERE ReferenceID = @ParentReferenceID And ReplyOrder > (@MaximumReplyOrder + @MaximumReplyCount);

INSERT INTO dbo.Notice

(

[Name]

,MailAddress

,Title

,WriteIP

,Content

,[Password]

,[Encoding]

,Homepage

,ReferenceID

,ReplyLevel

,ReplyOrder

,ParentID

,[FileName]

,FileSize

)

VALUES

(

@Name

,@MailAddress

,@Title

,@WriteIP

,@Content

,@Password

,@Encoding

,@Homepage

,@ParentReferenceID

,@ParentReplyLevel + 1

,@MaximumReplyOrder + @MaximumReplyCount + 1

,@ParentID

,@FileName

,@FileSize

);

CREATE PROCEDURE dbo.GetNoticeCount

Select Count(*) From dbo.Notice;

CREATE PROCEDURE dbo.SearchNoticeCount

@SearchField NVARCHAR(25)

,@SearchQuery NVARCHAR(25)

SET @SearchQuery = '%' + @SearchQuery + '%';

SELECT COUNT(*)

FROM dbo.Notice

WHERE

(

CASE @SearchField

WHEN 'Name' THEN [Name]

WHEN 'Title' THEN Title

WHEN 'Content' THEN Content

ELSE @SearchQuery

END

)

LIKE @SearchQuery;

CREATE PROCEDURE dbo.DeleteNotice

@ID INT

,@Password NVARCHAR(30)

DECLARE @Count INT;

SELECT @Count = COUNT(*)

FROM dbo.Notice

WHERE ID = @ID

AND [Password] = @Password;

IF @Count = 0

BEGIN

Return 0;

END

DECLARE @ReplyCount INT;

DECLARE @ReplyOrder INT;

DECLARE @ReferenceID INT;

DECLARE @ParentID INT;

SELECT

@ReplyCount = ReplyCount

,@ReplyOrder = ReplyOrder

,@ReferenceID = ReferenceID

,@ParentID = ParentID

FROM dbo.Notice

WHERE ID = @ID;

IF @ReplyCount = 0

BEGIN

IF @ReplyOrder > 0

BEGIN

UPDATE dbo.Notice

SET ReplyOrder = ReplyOrder - 1

WHERE ReferenceID = @ReferenceID

AND ReplyOrder > @ReplyOrder;

UPDATE Notice

SET ReplyCount = ReplyCount - 1

WHERE ID = @ParentID;

END

DELETE FROM dbo.Notice

WHERE ID = @ID;

DELETE FROM dbo.Notice

WHERE ID = @ParentID

AND UpdateIP = N'((DELETED))'

AND ReplyCount = 0;

END

ELSE

BEGIN

UPDATE dbo.Notice

SET

[Name] = N'(Unknown)',

MailAddress = '',

[Password] = '',

Title = N'(삭제된 글입니다.)',

Content = N'(삭제된 글입니다. 현재 답변이 포함되어 있기 때문에 내용만 삭제되었습니다.)',

UpdateIP = N'((DELETED))',

[FileName] = '',

FileSize = 0,

CommentCount = 0

WHERE ID = @ID;

END

CREATE PROCEDURE dbo.UpdateNotice

@Name NVARCHAR(25)

,@MailAddress NVARCHAR(100)

,@Title NVARCHAR(150)

,@UpdateIP NVARCHAR(15)

,@Content NTEXT

,@Password NVARCHAR(30)

,@Encoding NVARCHAR(10)

,@Homepage NVARCHAR(100)

,@FileName NVARCHAR(255)

,@FileSize INT

,@ID INT

DECLARE @Count INT

SELECT @Count = Count(*)

FROM dbo.Notice

WHERE ID = @ID

AND [Password] = @Password;

IF @Count > 0

BEGIN

UPDATE dbo.Notice

SET

[Name] = @Name

,MailAddress = @MailAddress

,Title = @Title

,UpdateIP = @UpdateIP

,UpdateDate = GETDATE()

,Content = @Content

,[Encoding] = @Encoding

,Homepage = @Homepage

,[FileName] = @FileName

,FileSize = @FileSize

Where ID = @ID;

SELECT '1';

END

ELSE

SELECT '0';

CREATE PROCEDURE dbo.SearchNotice

@Page INT

,@SearchField NVARCHAR(25)

,@SearchQuery NVARCHAR(25)

WITH OrderedNoticeBoard

(

SELECT

,[Name]

,MailAddress

,Title

,WriteDate

,ReadCount

,ReferenceID

,ReplyLevel

,ReplyOrder

,ReplyCount

,ParentID

,CommentCount

,[FileName]

,FileSize

,DownloadCount

,ROW_NUMBER() OVER (ORDER BY ReferenceID DESC, ReplyOrder ASC) AS 'RowNumber'

FROM dbo.Notice

WHERE

(

CASE @SearchField

WHEN 'Name' THEN [Name]

WHEN 'Title' THEN Title

WHEN 'Content' THEN Content

ELSE @SearchQuery

END

)

LIKE '%' + @SearchQuery + '%'

)

SELECT

,[Name]

,MailAddress

,Title

,WriteDate

,ReadCount

,ReferenceID

,ReplyLevel

,ReplyOrder

,ReplyCount

,ParentID

,CommentCount

,[FileName]

,FileSize

,DownloadCount

,RowNumber

FROM OrderedNoticeBoard

WHERE RowNumber BETWEEN @Page * 10 + 1 AND (@Page + 1) * 10

ORDER BY ID DESC;

▶ Setings/MainSettings.cs


namespace TestProject.Settings
{
    /// <summary>
    /// 메인 설정
    /// </summary>
    public class MainSettings
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 사이트 관리자 - SiteAdministrator

        /// <summary>
        /// 사이트 관리자
        /// </summary>
        public string SiteAdministrator { get; set; }

        #endregion
    }
}

namespace TestProject.Settings

{

/// <summary>

/// 메인 설정

/// </summary>

public class MainSettings

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

////////////////////////////////////////////////////////////////////////////////////////// Public

#region 사이트 관리자 - SiteAdministrator

/// <summary>

/// 사이트 관리자

/// </summary>

public string SiteAdministrator { get; set; }

#endregion

}

▶ FileHelper.cs


using System.IO;

namespace TestProject
{
    /// <summary>
    /// 파일 헬퍼
    /// </summary>
    public class FileHelper
    {
        ////////////////////////////////////////////////////////////////////////////////////////// Method
        //////////////////////////////////////////////////////////////////////////////// Static
        ////////////////////////////////////////////////////////////////////// Public

        #region 유니크 파일명 구하기 - GetUniqueFileName(sourceDirectoryPath, fileName)

        /// <summary>
        /// 유니크 파일명 구하기
        /// </summary>
        /// <param name="sourceDirectoryPath">소스 디렉토리 경로</param>
        /// <param name="fileName">파일명</param>
        /// <returns>유니크 파일명</returns>
        public static string GetUniqueFileName(string sourceDirectoryPath, string fileName)
        {
            string temporaryName = Path.GetFileNameWithoutExtension(fileName);
            string fileExtension = Path.GetExtension(fileName);

            bool exist = true;

            int i = 0;

            while(exist)
            {
                if(File.Exists(Path.Combine(sourceDirectoryPath, fileName)))
                {
                    fileName = temporaryName + "(" + ++i + ")" + fileExtension;
                }
                else
                {
                    exist = false;
                }
            }

            return fileName;
        }

        #endregion
    }
}

using System.IO;

namespace TestProject

{

/// <summary>

/// 파일 헬퍼

/// </summary>

public class FileHelper

{

////////////////////////////////////////////////////////////////////////////////////////// Method

//////////////////////////////////////////////////////////////////////////////// Static

////////////////////////////////////////////////////////////////////// Public

#region 유니크 파일명 구하기 - GetUniqueFileName(sourceDirectoryPath, fileName)

/// <summary>

/// 유니크 파일명 구하기

/// </summary>

/// <param name="sourceDirectoryPath">소스 디렉토리 경로</param>

/// <param name="fileName">파일명</param>

/// <returns>유니크 파일명</returns>

public static string GetUniqueFileName(string sourceDirectoryPath, string fileName)

{

string temporaryName = Path.GetFileNameWithoutExtension(fileName);

string fileExtension = Path.GetExtension(fileName);

bool exist = true;

int i = 0;

while(exist)

{

if(File.Exists(Path.Combine(sourceDirectoryPath, fileName)))

{

fileName = temporaryName + "(" + ++i + ")" + fileExtension;

}

else

{

exist = false;

}

return fileName;

}

#endregion

}