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