public bool SubmitUserOrder(PizzaOrder newOrder) { try{ // submit order object into db _dbConnection.OrderTable.Add(new OrderTable { UserId = newOrder.UserID, LocationId = newOrder.OrderShopLocationID, OrderTotalCost = newOrder.GetTotalOrderCost(), PizzaCount = newOrder.GetTotalPizzaCount() }); _dbConnection.SaveChanges(); }catch (System.Exception ex) { return(false); } try{ int currentOrderID = _dbConnection.OrderTable.ToList() [_dbConnection.OrderTable.ToList().Count - 1].OrderId; // submit pizzas to db and link to order foreach (var pizza in newOrder.OrderItems) { int CurrentPizzaID = PizzaRecipesDataRetriever.GetInstance().AddPizzaToDB(pizza); _dbConnection.PizzasInOrder.Add(new PizzasInOrder { OrderId = currentOrderID, PizzaId = CurrentPizzaID }); _dbConnection.SaveChanges(); } }catch (System.Exception ex) { return(false); } return(true); }