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