public void Create(Product item)
{
IEnumerable <Currency> currencies = db.Currency.ToList();
db.Product.Add(CreateCurrencyPriceInNewModel(item, currencies));
db.SaveChanges();
}
public void Create(Currency item)
{
if (item.Code != "EUR")
{
db.Currency.Add(item);
}
else if (item.Code == "EUR")
{
float UAHCourse = db.Currency.FirstOrDefault(x => x.Code == "UAH").Course;
db.Currency.Add(CalculationEuroCourse(item, UAHCourse));
}
db.SaveChanges();
}
public void Create(Category item)
{
db.Category.Add(item);
db.SaveChanges();
}
public void Add(TEntity obj)
{
ctx.Set <TEntity>().Add(obj);
ctx.SaveChanges();
}
public void Create(WarehouseProduct item)
{
db.WarehouseProducts.Add(item);
db.SaveChanges();
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new InventoryControlContext(
serviceProvider.GetRequiredService <
DbContextOptions <InventoryControlContext> >()))
{
return;
//if (context.Clients.Any())
//{
// return; // DB has been seeded
//}
context.Clients.AddRange(
new Client
{
Name = "橋本百貨店",
ClientNum = 100,
Address = "横浜1-1-1",
ReleaseDate = DateTime.Parse("2019-12-12")
},
new Client
{
Name = "山田商事",
ClientNum = 101,
Address = "浦賀1-1-1",
ReleaseDate = DateTime.Parse("2019-12-12")
},
new Client
{
Name = "田中デパート",
ClientNum = 102,
Address = "逗子1-1-1",
ReleaseDate = DateTime.Parse("2019-12-12")
},
new Client
{
Name = "佐藤商店",
ClientNum = 103,
Address = "三浦1-1-1",
ReleaseDate = DateTime.Parse("2019-12-12")
}
);
context.SaveChanges();
// if (context.Store.Any())
// {
// return; // DB has been seeded
// }
context.Stores.AddRange(
new Store
{
Name = "渋谷店",
ReleaseDate = DateTime.Parse("2019-12-12"),
StoreNum = 1,
Address = "渋谷2-2-2"
},
new Store
{
Name = "恵比寿店",
ReleaseDate = DateTime.Parse("2019-12-12"),
StoreNum = 2,
Address = "恵比寿2-2-2"
},
new Store
{
Name = "品川店",
ReleaseDate = DateTime.Parse("2019-12-12"),
StoreNum = 3,
Address = "品川2-2-2"
},
new Store
{
Name = "五反田店",
ReleaseDate = DateTime.Parse("2019-12-12"),
StoreNum = 4,
Address = "五反田2-2-2"
}
);
context.SaveChanges();
// if (context.Supplier.Any())
// {
// return; // DB has been seeded
// }
context.Suppliers.AddRange(
new Supplier
{
Name = "高橋商店",
SupplierNum = 200,
Address = "国立市1-1-1",
ReleaseDate = DateTime.Parse("2019-12-12")
},
new Supplier
{
Name = "北島商事",
SupplierNum = 201,
Address = "立川市1-1-1",
ReleaseDate = DateTime.Parse("2019-12-12")
},
new Supplier
{
Name = "川田商事",
SupplierNum = 202,
Address = "国分寺市1-1-1",
ReleaseDate = DateTime.Parse("2019-12-12")
},
new Supplier
{
Name = "後藤商事",
SupplierNum = 203,
Address = "武蔵野市1-1-1",
ReleaseDate = DateTime.Parse("2019-12-12")
}
);
context.SaveChanges();
//if (context.Warehouses.Any())
//{
// return; // DB has been seeded
//}
context.Warehouses.AddRange(
new Warehouse
{
Name = "渋谷倉庫",
ReleaseDate = DateTime.Parse("2019-12-12"),
WarehouseNum = 1,
Address = "渋谷2-2-2",
StoreId = 1
},
new Warehouse
{
Name = "恵比寿倉庫",
ReleaseDate = DateTime.Parse("2019-12-12"),
WarehouseNum = 2,
Address = "恵比寿2-2-2",
StoreId = 2
},
new Warehouse
{
Name = "品川倉庫",
ReleaseDate = DateTime.Parse("2019-12-12"),
WarehouseNum = 3,
Address = "品川2-2-2",
StoreId = 3
},
new Warehouse
{
Name = "五反田倉庫",
ReleaseDate = DateTime.Parse("2019-12-12"),
WarehouseNum = 4,
Address = "五反田2-2-2",
StoreId = 4
}
);
context.SaveChanges();
//if (context.Item.Any())
//{
// return; // DB has been seeded
//}
context.Items.AddRange(
new Item
{
Name = "椅子",
Lot = 10001,
ReleaseDate = DateTime.Parse("2019-12-12"),
Genre = "椅子",
PurchasePrice = 2000M,
SupplierId = 1
},
new Item
{
Name = "机",
Lot = 10002,
ReleaseDate = DateTime.Parse("2019-12-12"),
Genre = "机",
PurchasePrice = 10000,
SupplierId = 1
},
new Item
{
Name = "キッチン棚",
Lot = 10003,
ReleaseDate = DateTime.Parse("2019-12-12"),
Genre = "棚",
PurchasePrice = 15000,
SupplierId = 1
},
new Item
{
Name = "ソファ",
Lot = 10004,
ReleaseDate = DateTime.Parse("2019-12-12"),
Genre = "ソファ",
PurchasePrice = 100000,
SupplierId = 1
}
);
context.SaveChanges();
}
}
public void Create(Warehouse item)
{
db.Warehouses.Add(item);
db.SaveChanges();
}