public IActionResult PlaceOrder(int id) { List <Cart_Item> CartItems = _context.cart_items.Where(c => c.customer_id == id).ToList(); if (CartItems.Count() == 0) { return(RedirectToAction("CustomerDetail", "Customers", new { id = id })); } Order currentorder = new Order(); currentorder.customer_id = id; _context.orders.Add(currentorder); _context.SaveChanges(); foreach (Cart_Item cartitem in CartItems) { Order_Item orderitem = new Order_Item(); orderitem.order_id = currentorder.id; orderitem.product_id = cartitem.product_id; orderitem.product_quantity = cartitem.product_quantity; _context.order_items.Add(orderitem); _context.Remove(cartitem); _context.SaveChanges(); } return(RedirectToAction("CustomerDetail", "Customers", new { id = id })); }