public static void Initialize(IServiceProvider serviceProvider)
{
using (var _context = new OnlineGroceryStoreContext(
serviceProvider.GetRequiredService <DbContextOptions <OnlineGroceryStoreContext> >()))
{
PopulateData(_context);
}
}
public PlaceOrderDemoModel(OnlineGroceryStore.Models.OnlineGroceryStoreContext context)
{
_context = context;
}
public static void PopulateData(OnlineGroceryStoreContext _context)
{
if (_context.Inventory.Any())
{
return;
}
using (var transaction = _context.Database.BeginTransaction())
{
_context.Inventory.AddRange(
new Inventory
{
itemName = "Sliced Ham",
itemCode = "SH3",
},
new Inventory
{
itemName = "Yoghurt",
itemCode = "YT2",
},
new Inventory
{
itemName = "Toilet Rolls",
itemCode = "TR",
}
);
_context.SaveChanges();
var item_sh3 = _context.Inventory.Where(x => x.itemCode == "SH3").First();
_context.InventoryPackingConfigure.AddRange(
new InventoryPackingConfigure
{
inventory = item_sh3,
packSize = 3,
packPrice = 2.99
},
new InventoryPackingConfigure
{
inventory = item_sh3,
packSize = 5,
packPrice = 4.49
});
_context.SaveChanges();
var item_yt2 = _context.Inventory.Where(x => x.itemCode == "YT2").First();
_context.InventoryPackingConfigure.AddRange(
new InventoryPackingConfigure
{
inventory = item_yt2,
packSize = 4,
packPrice = 4.95
},
new InventoryPackingConfigure
{
inventory = item_yt2,
packSize = 10,
packPrice = 9.95
},
new InventoryPackingConfigure
{
inventory = item_yt2,
packSize = 15,
packPrice = 13.95
});
_context.SaveChanges();
var item_tr = _context.Inventory.Where(x => x.itemCode == "TR").First();
_context.InventoryPackingConfigure.AddRange(
new InventoryPackingConfigure
{
inventory = item_tr,
packSize = 3,
packPrice = 2.95
},
new InventoryPackingConfigure
{
inventory = item_tr,
packSize = 5,
packPrice = 4.45
},
new InventoryPackingConfigure
{
inventory = item_tr,
packSize = 9,
packPrice = 7.99
});
_context.SaveChanges();
transaction.Commit();
}
}