public void create(Warehouse warehouse) { sellingComponentsDBContext.Add(warehouse); var pd = sellingComponentsDBContext.Products.Find(warehouse.IdProduct); pd.Amount += warehouse.Amount; sellingComponentsDBContext.SaveChanges(); }
public IActionResult SanPham_GioHang(int id, int iduser) { Console.WriteLine("id là" + id + "iduser là " + iduser); //var productInCart = context.Carts.Where(t => t.IdProduct == id); var queryProductInCart = (from c in context.Carts where c.IdProduct == id && c.IdUser == iduser select c); Cart cart = queryProductInCart.Count() != 0 ? queryProductInCart.First() : null; Cart carts = new Cart(); if (cart != null) { var ud = context.Carts.Find(cart.Id); ud.IdUser = cart.IdUser; ud.IdCombo = cart.IdCombo; ud.IdProduct = cart.IdProduct; ud.Amount = 1 + int.Parse(cart.Amount + ""); context.SaveChanges(); } else { carts.IdUser = iduser; carts.IdProduct = id; carts.Amount = 1; context.Carts.Add(carts); context.SaveChanges(); } return(new JsonResult("Thêm thành công.")); }
public IActionResult DatHang(int IdUser, Decimal TotalCost, String DeliveryAddress, DateTime DeliveryDate) { Order order = new Order(); order.IdUser = IdUser; order.TotalCost = TotalCost; order.DeliveryAddress = DeliveryAddress; order.DeliveryDate = DeliveryDate; context.Add(order); context.SaveChanges(); var carts = context.Carts.Include(t => t.IdComboNavigation).Include(t => t.IdProductNavigation).Where(t => t.IdUser == IdUser); Console.WriteLine(order.Id); foreach (var item in carts) { if (item.IdCombo == null) { OrdersDetail ordersDetail = new OrdersDetail() { IdOrders = order.Id , IdCombo = item.IdCombo, IdProduct = item.IdProduct, Amount = item.Amount, Price = item.IdProductNavigation.Price }; var ud = context.Products.Find(ordersDetail.IdProduct); ud.Amount = ud.Amount - ordersDetail.Amount; contextWrite.Add(ordersDetail); contextWrite.SaveChanges(); contextWrite.Update(ud); contextWrite.SaveChanges(); contextWrite.Remove(item); contextWrite.SaveChanges(); } else { OrdersDetail ordersDetail = new OrdersDetail() { IdOrders = order.Id , IdCombo = item.IdCombo, IdProduct = item.IdProduct, Amount = item.Amount, Price = item.IdComboNavigation.Price }; contextWrite.Add(ordersDetail); contextWrite.SaveChanges(); contextWrite.Remove(item); contextWrite.SaveChanges(); } } return(new JsonResult("Đặt hàng thành công")); }
public void create(Classify classify) { sellingComponentsDBContext.Add(classify); sellingComponentsDBContext.SaveChanges(); }
public void create(Combo combo) { sellingComponentsDBContext.Add(combo); sellingComponentsDBContext.SaveChanges(); }
public void create(Product product) { sellingComponentsDBContext.Add(product); sellingComponentsDBContext.SaveChanges(); }
public void create(Catalog catalog) { sellingComponentsDBContext.Add(catalog); sellingComponentsDBContext.SaveChanges(); }