public ActionResult ConfirmOrder(int cartID, int shipID, int billID, int cardID) { Customer customer = db.Customers.Where(x => x.Username == User.Identity.Name).First(); var books = db.Cart_Book.Where(x => x.CartID == cartID); List <Cart_Book> list = new List <Cart_Book>(); foreach (var item in books) { list.Add(item); } db.usp_AddInvoice(cartID, shipID, billID, cardID, customer.CustomerID); db.usp_CreateCart(customer.CustomerID); Invoice invoice = db.Invoices.Where(x => x.CartID == cartID).First(); foreach (var item in list) { db.usp_AddBookToInvoice(item.BookID, invoice.InvoiceID, item.Amount, item.Price); } return(RedirectToAction("Index", "Invoice", null)); }