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