public ActionResult Complete(Tbl_Invoice invoice)
{
var total = 0;
List <Item> cart = (List <Item>)Session["cart"];
invoice.Date = DateTime.Now;
ctx.Tbl_Invoice.Add(invoice);
//ctx.SaveChanges();
foreach (var item in cart)
{
var detail = new Tbl_InvoiceDetail();
detail.ProductID = item.Product.ProductID;
detail.Quantity = item.Quantity;
detail.InvoiceID = invoice.InvoiceID;
ctx.Tbl_InvoiceDetail.Add(detail);
ctx.SaveChanges();
var totalitem = item.Quantity * Convert.ToInt32(item.Product.Price);
total = totalitem + total;
}
//var inv = ctx.Tbl_Invoice.Find(invoice.InvoiceID);
invoice.Total = total;
ctx.SaveChanges();
return(View());
}
public void Add(Tbl_Entity entity)
{
_dbSet.Add(entity);
_DBEntity.SaveChanges();
}
public void SaveChanges()
{
DBEnity.SaveChanges();
}