public ActionResult SubmitOrder(OrderViewModel orderViewModel)
{
try
{
ViewBag.Sent = false;
if (Session["EmailAddress"] != null)
{
var emailAddress = Session["EmailAddress"].ToString();
var userId = db.Customers.Where(a => a.EmailAddress == emailAddress).Select(t => t.CustomerId).FirstOrDefault();
var pizzaId = db.Pizzas.Where(a => a.PizzaName == orderViewModel.pizzaName).Select(t => t.PizzaId).FirstOrDefault();
var baseId = db.Bases.Where(a => a.SizeOfPizza == orderViewModel.size).Select(t => t.BaseId).FirstOrDefault();
var drinkId = db.CoolDrinks.Where(a => a.Flavour == orderViewModel.drink).Select(t => t.DrinkId).FirstOrDefault();
var toppingId = db.Toppings.Where(a => a.Description == orderViewModel.topping).Select(t => t.TopId).FirstOrDefault();
//saving to Delivery Method
var deliveryMethodId = db.SaveDeliveryDetails(orderViewModel.delivery, orderViewModel.address, orderViewModel.number).FirstOrDefault();
//Saving to order
var orderId = db.SaveOrder(userId, deliveryMethodId, baseId, drinkId, 1, pizzaId, DateTime.Now);
ViewBag.Sent = true;
return(RedirectToAction("CustOrderHistory"));
}
else
{
ViewBag.Successful = "Unsuccessufully: Please login before you place an order";
}
//Save To Pizza
// }
return(RedirectToAction("Menu"));
}
catch (Exception e)
{
throw;
}
}