public SqlShop Add(string shopname)
{
SqlShop shop = new SqlShop()
{
Name = shopname,
CreatedOn = DateTime.Now
};
Context.SqlShops.Add(shop);
Context.SaveChanges();
return(shop);
}
public List <SqlItem> Get5(int id)
{
SqlShop shop = Context.SqlShops.Where(x => x.ShopID == id).FirstOrDefault();
List <SqlItem> items = Context.SqlItems.Where(x => x.ShopID == shop.ShopID).ToList();
foreach (SqlItem item in items)
{
item.SqlShop = shop;
}
return(items);
}
public List <SqlItem> Get2(string name)
{
SqlShop shop = Context.SqlShops.Where(x => x.Name == name).OrderBy(x => x.ShopID).LastOrDefault();
List <SqlItem> items = Context.SqlItems.Where(x => x.ShopID == shop.ShopID).ToList();
foreach (SqlItem item in items)
{
item.SqlShop = shop;
}
return(items);
}
public SqlItem Add2(string shopname, string itemname, double quantity)
{
SqlShop shop = Context.SqlShops.Where(x => x.Name.ToLower() == shopname.ToLower()).OrderBy(x => x.ShopID).LastOrDefault();
SqlItem item = new SqlItem()
{
ShopID = shop.ShopID,
Name = itemname,
Quantity = quantity
};
Context.SqlItems.Add(item);
Context.SaveChanges();
return(item);
}
public bool Remove(int id)
{
List <SqlItem> SqlItems = Context.SqlItems.Where(x => x.ShopID == id).ToList();
foreach (SqlItem item in SqlItems)
{
Context.SqlItems.Remove(item);
Context.SaveChanges();
}
SqlShop sqlShop = Context.SqlShops.Where(x => x.ShopID == id).FirstOrDefault();
Context.SqlShops.Remove(sqlShop);
Context.SaveChanges();
return(true);
}
