public static PanierView CreatePanier(this DBEntities DB, PanierView panierView) { Panier panier = panierView.ToPanier(); panier = DB.Paniers.Add(panier); DB.SaveChanges(); return(panier.ToPanierView()); }
public static bool DejaDansPanier(this DBEntities DB, int userId, int itemId) { Panier pan = DB.Paniers.Where(x => x.UserId.Equals(userId) && x.ItemId.Equals(itemId)).FirstOrDefault(); if (pan != null) { return(true); } return(false); }
public static PanierView ToPanierView(this Panier panier) { return(new PanierView() { Id = panier.Id, ItemId = panier.ItemId, UserId = panier.UserId, QuantiteAchat = panier.QuantiteAchat, }); }
public static bool RemovePanier(this DBEntities DB, int itemId, int userId) { Panier panier = DB.Paniers.Where(p => p.ItemId.Equals(itemId) && p.UserId.Equals(userId)).FirstOrDefault(); BeginTransaction(DB); DB.Paniers.Remove(panier); DB.SaveChanges(); Commit(); return(true); }
public static bool UpdatePanier(this DBEntities DB, int itemId, int NouvelleQuant, int userId) { Panier panier = DB.Paniers.Where(p => p.ItemId.Equals(itemId) && p.UserId.Equals(userId)).FirstOrDefault(); BeginTransaction(DB); panier.QuantiteAchat = NouvelleQuant; DB.Entry(panier).State = EntityState.Modified; DB.SaveChanges(); Commit(); return(true); }