70 lines
2.7 KiB
C#
70 lines
2.7 KiB
C#
|
using Microsoft.AspNetCore.Hosting;
|
|||
|
|
using Microsoft.EntityFrameworkCore;
|
|||
|
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Threading.Tasks;
|
|||
|
|
|
|||
|
|
namespace ThAmCo.Stock.Data
|
|||
|
|
{
|
|||
|
|
public class StockDbContext : DbContext
|
|||
|
|
{
|
|||
|
|
public DbSet<Price> Prices { get; set; }
|
|||
|
|
public DbSet<ProductStock> ProductStocks { get; set; }
|
|||
|
|
|
|||
|
|
public DbSet<OrderRequest> OrderRequests { get; set; }
|
|||
|
|
|
|||
|
|
private IHostingEnvironment HostEnv { get; }
|
|||
|
|
|
|||
|
|
public StockDbContext(DbContextOptions<StockDbContext> options, IHostingEnvironment env) : base(options)
|
|||
|
|
{
|
|||
|
|
HostEnv = env;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
protected override void OnConfiguring(DbContextOptionsBuilder builder)
|
|||
|
|
{
|
|||
|
|
base.OnConfiguring(builder);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
protected override void OnModelCreating(ModelBuilder builder)
|
|||
|
|
{
|
|||
|
|
base.OnModelCreating(builder);
|
|||
|
|
|
|||
|
|
builder.Entity<Price>()
|
|||
|
|
.HasKey(p => p.Id);
|
|||
|
|
|
|||
|
|
builder.Entity<ProductStock>()
|
|||
|
|
.HasKey(ps => ps.Id);
|
|||
|
|
|
|||
|
|
builder.Entity<OrderRequest>()
|
|||
|
|
.HasKey(or => or.Id);
|
|||
|
|
|
|||
|
|
if (HostEnv != null && HostEnv.IsDevelopment())
|
|||
|
|
{
|
|||
|
|
builder.Entity<ProductStock>()
|
|||
|
|
.HasData(
|
|||
|
|
new ProductStock { Id = 1, ProductId = 1, PriceId = 2, Stock = 4 },
|
|||
|
|
new ProductStock { Id = 2, ProductId = 2, PriceId = 3, Stock = 42 },
|
|||
|
|
new ProductStock { Id = 3, ProductId = 3, PriceId = 4, Stock = 32 },
|
|||
|
|
new ProductStock { Id = 4, ProductId = 4, PriceId = 5, Stock = 13},
|
|||
|
|
new ProductStock { Id = 5, ProductId = 5, PriceId = 6, Stock = 0},
|
|||
|
|
new ProductStock { Id = 6, ProductId = 6, PriceId = 7, Stock = 1},
|
|||
|
|
new ProductStock { Id = 7, ProductId = 7, PriceId = 8, Stock = 49}
|
|||
|
|
);
|
|||
|
|
|
|||
|
|
builder.Entity<Price>()
|
|||
|
|
.HasData(
|
|||
|
|
new Price { Id = 1, ProductStockId = 1, ProductPrice = 9.99 },
|
|||
|
|
new Price { Id = 2, ProductStockId = 1, ProductPrice = 8.99 },
|
|||
|
|
new Price { Id = 3, ProductStockId = 2, ProductPrice = 17.99 },
|
|||
|
|
new Price { Id = 4, ProductStockId = 3, ProductPrice = 23.00},
|
|||
|
|
new Price { Id = 5, ProductStockId = 4, ProductPrice = 2.99},
|
|||
|
|
new Price { Id = 6, ProductStockId = 5, ProductPrice = 49.63},
|
|||
|
|
new Price { Id = 7, ProductStockId = 6, ProductPrice = 4.56},
|
|||
|
|
new Price { Id = 8, ProductStockId = 7, ProductPrice = 10.01}
|
|||
|
|
);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|