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);
}