public void UpdateSaleProduct(Sale_Product sale_product) { var dbSale = GetFirst<Sale_Product>(sa => sa.SaleId == sale_product.SaleId); dbSale.quantite = sale_product.quantite ?? dbSale.quantite; }
public async Task<ActionResult> ViewReceipt(int Sale_ID) { BillInfoViewModel vm = new BillInfoViewModel(); var sale=_context.Sale.Where(m => m.Sale_Id == Sale_ID).FirstOrDefault(); var customer= _context.Customers.Where(m => m.Customer_Id == sale.Customer_Id).FirstOrDefault(); var Sale_FoodItem = await _context.Sale_FoodItems.Where(m => m.Sale_Id == Sale_ID).ToListAsync(); vm.Sale_Products = new List<Sale_Product>(); vm.Customer = customer; vm.Created_Date = sale.Created_Date; vm.Is_Paid = sale.Is_Paid == true ? "Yes" : "No"; vm.Amount = sale.Amount; vm.Amount_Pay = sale.Amount_Pay; vm.Grand_Total = sale.Grand_Total; vm.Left_Amount = sale.Left_Amount; vm.Remaining_Amount = sale.Remaining_Amount; foreach (var item in Sale_FoodItem) { var item1 = new Sale_Product(); item1.Rate = item.Rate; item1.Quantity = item.Quantity; item1.Amount = item.Amount; item1.Created_Date = item.Created_Date; item1.Name = _context.FoodItems.Where(m => m.FoodItem_Id == item.Food_Item_Id.Value).FirstOrDefault().Name; item1.Category = item.Food_Item.FoodCategory.ToString(); vm.Sale_Products.Add(item1); } return View(vm); }
public void RemoveSaleProduct(Sale_Product sale_product) { var dbSaleProduct = GetFirst<Sale_Product>(sa => sa.SaleId == sale_product.SaleId); Remove(dbSaleProduct); }
public void AddSaleProduct(Sale_Product sale_product) { Add(sale_product); SaveChanges(); }