public void UpdateShop(Shop pre_shop, Shop current_shop)
{
using (var db = new IceCreamDB())
{
var query = from m in db.IceCreams
select m;
IEnumerable <IceCream> iceCreams = query.ToList <IceCream>().Where(x => x.ShopId == current_shop.Id);
foreach (var iceCream in iceCreams)
{
db.IceCreams.Attach(iceCream);
db.IceCreams.Remove(iceCream);
}
if (pre_shop != null)//if we get user from main it means he is saved in db..
{
db.Shops.Attach(pre_shop);
db.Shops.Remove(pre_shop);
db.SaveChanges();
}
db.Shops.Add(current_shop);
db.SaveChanges();
foreach (var iceCream in iceCreams)
{
db.IceCreams.Add(iceCream);
}
db.SaveChanges();
}
}
public void UpdateIceCream(IceCream pre_IC, IceCream current_IC)
{
using (var db = new IceCreamDB())
{
if (pre_IC != null)
{
db.IceCreams.Attach(pre_IC);
db.IceCreams.Remove(pre_IC);
db.SaveChanges();
}
db.IceCreams.Add(current_IC);
db.SaveChanges();
}
}
public void SaveShop(Shop s)
{
using (var db = new IceCreamDB())
{
db.Shops.Add(s);
db.SaveChanges();
}
}
public void AddIceCream(IceCream i)
{
using (var db = new IceCreamDB())
{
db.IceCreams.Add(i);
db.SaveChanges();
}
}
public void DeleteIceCream(IceCream iceCream)
{
using (var db = new IceCreamDB())
{
if (iceCream != null)
{
db.IceCreams.Attach(iceCream);
db.IceCreams.Remove(iceCream);
db.SaveChanges();
}
}
}
public void AddShop(Shop s)
{
var db = new IceCreamDB();
db.Shops.Add(s);
db.SaveChanges();
/* try
* {
* using (var db = new IceCreamDB())
* {
* db.Shops.Add(s);
* db.SaveChanges();
* }
* }
* catch (Exception e)
* {
* throw new Exception("Erreur");
* }
*/
}
