public IList <OrderDetail> GetOrderLinesbyOrder(int id) { using (StoreDbEntities db = new StoreDbEntities()) { } throw new NotImplementedException(); }
public IList <Produit> GetProduitByCriterias(string nom) { using (StoreDbEntities db = new StoreDbEntities()) { } throw new NotImplementedException(); }
public int?ShoppingRemoveFromCart(int id, string ShoppingCartId) { using (StoreDbEntities db = new StoreDbEntities()) { // Get the cart var cartItem = db.Cart.Single( cart => cart.CartId == ShoppingCartId && cart.RecordId == id); int?itemCount = 0; if (cartItem != null) { db.Cart.Remove(cartItem); //if (cartItem.Count > 1) //{ // cartItem.Count--; // itemCount = cartItem.Count; //} //else //{ // db.Cart.Remove(cartItem); //} //// Save changes db.SaveChanges(); } return(itemCount); } }
public void ShoppingAddMoreProductToCart(Produit produit, string ShoppingCartId, int number) { using (StoreDbEntities db = new StoreDbEntities()) { // Get the matching cart and produit instances var cartItem = db.Cart.SingleOrDefault( c => c.CartId == ShoppingCartId && c.ProduitId == produit.ProduitId); if (cartItem == null) { // Create a new cart item if no cart item exists cartItem = new Cart { ProduitId = produit.ProduitId, CartId = ShoppingCartId, Count = 1, DateCreated = DateTime.Now }; db.Cart.Add(cartItem); } else { // If the item does exist in the cart, // then add one to the quantity cartItem.Count = number; } // Save changes db.SaveChanges(); } }
public IList <Genre> GetGenres() { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Genre.ToList(); return(result); } }
public IList <Order> GetOrders() { using (StoreDbEntities db = new StoreDbEntities()) { var order = db.Order.ToList(); return(order); } }
public IList <Order> GetOrderByCustumer(string email) { using (StoreDbEntities db = new StoreDbEntities()) { var result = (from s in db.Order where s.Email == email & s.OrderDate == s.OrderDate select s).ToList(); return(result); } }
public bool ShoppingIsValid(int id, string name) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Order.Any(o => o.OrderId == id && o.UserName == name); return(result); } }
public List <Cart> ShoppingGetCartItems(string ShoppingCartId) { using (StoreDbEntities db = new StoreDbEntities()) { return(db.Cart.Include("Produit").Where( cart => cart.CartId == ShoppingCartId).ToList()); } }
public Marque GetMarqueByid(int id) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Marque.Find(id); return(result); } }
public IList <Marque> GetMarques() { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Marque.ToList(); return(result); } }
public IList <Produit> GetProduitByCategoryId(int id) { using (StoreDbEntities db = new StoreDbEntities()) { return(db.Produit.Where(p => p.GenreId == id).ToList()); } throw new NotImplementedException(); }
public OrderDetail GetOrderDetailByid(int id) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.OrderDetail.Find(id); return(result); } }
public Genre GetGenreByid(int id) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Genre.Find(id); return(result); } }
public Cart GetCartByid(int id) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Cart.Include("Produit").Where(c => c.RecordId == id).FirstOrDefault(); return(result); } }
public IList <Cart> GetCarts() { using (StoreDbEntities db = new StoreDbEntities()) { var result = (from s in db.Cart.Include("Produit") select s).OrderBy(p => p.DateCreated).ToList(); return(result); //var cart = db.Cart.ToList(); //return cart; } }
public IList <OrderDetail> GetOrderDetailsCustumer(int OrderID) { using (StoreDbEntities db = new StoreDbEntities()) { var result = (from s in db.OrderDetail.Include("Order").Include("Produit") where s.OrderId == OrderID select s).ToList(); return(result); //var orderDatail = db.OrderDetail.ToList(); //return orderDatail; } }
public void ShoppingUpdateStock(OrderDetail order) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Produit.Find(order.ProduitId); result.Quantite -= order.Quantity; db.Entry(result).State = EntityState.Modified; db.SaveChanges(); } }
public Produit GetProduitByid(int id) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Produit.Include(p => p.Marque) .Include(p => p.Genre) .FirstOrDefault(p => p.ProduitId == id); return(result); } }
public IList <Produit> GetProduitByMarque(string marque) { using (StoreDbEntities db = new StoreDbEntities()) { var products = (from s in db.Produit.Include("Marque").Include("Genre") where s.Marque.Name.Equals(marque) select s).ToList(); return(products); } }
public string Add(Image image) { if (image == null) { return(null); } StoreDbEntities.Images.Add(image); StoreDbEntities.SaveChanges(); return(image.ImagePath); }
public IList <Produit> GetProduitSearchByCriteria(string search) { using (StoreDbEntities db = new StoreDbEntities()) { var products = (from s in db.Produit.Include("Marque").Include("Genre") where s.Title.Contains(search) || s.Genre.Name.Contains(search) || s.Marque.Name.Contains(search) select s).ToList(); return(products); } }
public IList <Produit> GetProduits() { using (StoreDbEntities db = new StoreDbEntities()) {/*var quizz = (from s in dbContext.Quizzs.Include("Course") select s).ToList(); * return quizz; * //dbContext.Quizzs.Include(q => q.Course).ToList(); * }*/ var products = (from s in db.Produit.Include("Marque").Include("Genre") select s).ToList(); return(products); } }
public Produit AddProduit(Produit produit) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Produit.Add(produit); if (db.SaveChanges() > 0) { return(result); } return(null); } }
public Genre AddGenre(Genre genre) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Genre.Add(genre); if (db.SaveChanges() > 0) { return(result); } return(null); } }
public Marque AddMarque(Marque marque) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Marque.Add(marque); if (db.SaveChanges() > 0) { return(result); } return(null); } }
public int ShoppingGetCount(string ShoppingCartId) { using (StoreDbEntities db = new StoreDbEntities()) { // Get the count of each item in the cart and sum them up int?count = (from cartItems in db.Cart where cartItems.CartId == ShoppingCartId select(int?) cartItems.Count).Sum(); // Return 0 if all entries are null return(count ?? 0); } }
public Cart AddCart(Cart cart) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Cart.Add(cart); if (db.SaveChanges() > 0) { return(result); } return(null); } }
public Order AddOrder(Order order) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.Order.Add(order); if (db.SaveChanges() > 0) { return(result); } return(null); } }
public OrderDetail AddOrderDetail(OrderDetail orderDetail) { using (StoreDbEntities db = new StoreDbEntities()) { var result = db.OrderDetail.Add(orderDetail); if (db.SaveChanges() > 0) { return(result); } return(null); } }