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