public void LoadStoreXmlDataToDb(Chain chain, IEnumerable <Store> stores)
{
using (SuperMarketDb context = new SuperMarketDb())
{
context.Chains.AddOrUpdate(chain);
context.SaveChanges();
foreach (var store in stores)
{
context.Stores.AddOrUpdate(s => new { s.StoreId, s.ChainId }, store);
context.SaveChanges();
}
}
}
private void CreatePrice(SuperMarketDb context, Item item, long storeID, long chainID, string unitQuantity, string quantity,
string isWeighted, double itemPrice)
{
Price price = new Price();
price.ItemPrice = itemPrice;
price.UnitQuantity = unitQuantity;
price.Quantity = quantity;
price.IsWeighted = isWeighted;
price.Item = context.Items.Find(item.ItemId);
price.Store = context.Stores.Find(storeID, chainID);
context.Prices.Add(price);
context.SaveChanges();
}
private Item CreateItem(SuperMarketDb context, long itemId, string itemType, string itemName, string itemDescription)
{
Item item = new Item()
{
ItemId = itemId,
ItemName = itemName,
ItemType = itemType,
ItemDescription = itemDescription
};
if (context.Items.Find(item.ItemId) != null)
{
return(item);
}
context.Items.AddOrUpdate(i => i.ItemId, item);
context.SaveChanges();
return(item);
}
public void ClearDb()
{
using (var context = new SuperMarketDb())
{
try
{
context.Chains.RemoveRange(context.Chains);
context.Stores.RemoveRange(context.Stores);
context.Items.RemoveRange(context.Items);
context.Prices.RemoveRange(context.Prices);
context.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("Removing Db has failed!!!" + e.Message);
}
}
}