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);
}
