private string AddOrUpdateFoodInOrder(string orderID, List <Food> orderItems) { Table <DAL.FoodCalled> foodOrderTable = GetFoodCalledTable(); DeleteFoodInOrder(orderID); FoodManager fdManager = new FoodManager(); IngredientManager igrManager = new IngredientManager(); StockManager stkManager = new StockManager(); foreach (Food fd in orderItems) { DAL.FoodCalled data = new DAL.FoodCalled(); try { data.orderID = orderID; data.foodID = fdManager.GetFoodIDByName(fd.Name); data.quantity = fd.Quantity; // Update quantity in stock foreach (Ingredient igr in igrManager.GetFoodIngredientList(fd.Name)) { string err = stkManager.DecreaseIngredientQuantityInStock(igrManager.GetIngredientDetailsID(igr.Name), data.quantity * int.Parse(igr.Quantity.ToString())); if (err != "") { return(err); } } foodOrderTable.InsertOnSubmit(data); foodOrderTable.Context.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } } return(""); }