public async Task <ActionResult> SendOrder(int id) { var order = db.Orders.Single(ord => ord.OrderID == id); foreach (var prodOrd in db.ProdOrder.Where(PrOd => PrOd.OrderID == order.OrderID)) { db.Products.Single(prod => prod.ProductID == prodOrd.ProductID).NrInStore -= 1; //await db.SaveChangesAsync(); } db.Orders.Single(ord => ord.OrderID == id).OrderSent = true; await db.SaveChangesAsync(); return(View("index", await GetOrders())); }