public IActionResult Add(salessummaryviewmodel sum) { Salesummary summary = new Salesummary(); summary.cus_id = sum.cus_id; summary.total_amount = sum.total_amount; summary.discount = sum.discount; summary.vat = sum.vat; summary.net_total = sum.net_total; _context.Add(summary); _context.SaveChanges(); foreach (var details in sum.details) { Sales_details saledetails = new Sales_details(); saledetails.sales_id = summary.sales_id; saledetails.product_id = details.product_id; saledetails.qty = details.qty; saledetails.price = details.price; saledetails.total = details.total; _context.Add(saledetails); _context.SaveChanges(); Product pr = _context.products.Find(saledetails.product_id); pr.qty = pr.qty - saledetails.qty; _context.products.Update(pr); _context.SaveChanges(); } return(Json(new { id = summary.sales_id })); }
public IActionResult Bill(int id) { Salesummary sum = _context.salesummaries.Where(a => a.sales_id == id).SingleOrDefault(); return(View(sum)); }