Restaurant-Management-Source-Code-Asp.Net-Core/Restaurant Management Asp.Net Core Source Code.txt at main · MyCodingProject77/Restaurant-Management-Source-Code-Asp.Net-Core · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88


         Packages to Install
          Microsoft.Entity.Framework Core
          Microsoft.Entity.Framework Core.SqlServer
          Microsoft Entity Framework Core.Tools


         Database Connection

         "DefaultConnection": "Server=DESKTOP-HEEKBHE\\SQLEXPRESS;Database=RestaurantDB;Trusted_Connection=True;TrustServerCertificate=True"


       Customers Class

       public int Id { get; set; }
public string Name { get; set; }
public string Phone { get; set; }
public string Address { get; set; }


     CustomersDbContext Class


     public class CustomersDbContext: DbContext
{
    public CustomersDbContext(DbContextOptions<CustomersDbContext> options)
        : base(options)
    {

    }

    public DbSet<Customers> Customer { get; set; }
}


    program.cs


    builder.Services.AddAuthentication(
    CookieAuthenticationDefaults.AuthenticationScheme)
    .AddCookie(option =>
    {
        option.LoginPath = "/Access/Login";
        option.ExpireTimeSpan = TimeSpan.FromMinutes(20);
    });

builder.Services.AddDbContext<CustomersDbContext>(options =>
{
    options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection"));
});

builder.Services.AddDbContext<ProductsDbContext>(actions =>
{
    actions.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection"));
});

builder.Services.AddDbContext<OrdersDbContext>(choices =>
{
    choices.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection"));
});

builder.Services.AddDbContext<PaymentsDbContext>(pickups =>
{
    pickups.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection"));
});


    Migration and update database

    add-migration first (first is name of the migration)

    update-database


    add-migration second -Context RestaurantManagement.Product.ProductsDbContext

        update-database -Context RestaurantManagement.Product.ProductDbContext