public OrdersBasicToppings SaveOrdersBasicToppings(OrdersBasicToppings topping)
{
SqlServerConnection conn = new SqlServerConnection();
topping.Id = conn.SqlServerUpdate("DECLARE @idnt INT=" + topping.Id + ", @dtls INT='" + topping.Details.Id + "', @topp INT=" + topping.Topping.Id + ", @amts FLOAT=" + topping.Price + "; IF NOT EXISTS (SELECT odtb_idnt FROM orders_details_toppings_basic WHERE odtb_idnt=@idnt) BEGIN INSERT INTO orders_details_toppings_basic (odtb_order_detail, odtb_topping, odtb_price) output INSERTED.odtb_idnt VALUES (@dtls, @topp, @amts) END ELSE BEGIN UPDATE orders_details_toppings_basic SET odtb_order_detail=@dtls, odtb_topping=@topp, odtb_price=@amts output INSERTED.odtb_idnt WHERE odtb_idnt=@idnt END");
return(topping);
}
public IActionResult SaveOrder()
{
OrderObject obj = JsonConvert.DeserializeObject <OrderObject>(Order.Json);
Orders order = new Orders {
SubTotal = obj.amount,
GST = obj.amount * 0.05
};
order.Total = order.GST + order.SubTotal;
order.Save();
foreach (var item in obj.items)
{
OrdersDetails details = new OrdersDetails {
Order = order,
Pizza = new PizzaService().GetPizza(item.pizza),
Price = item.amount
};
details.Save();
foreach (var topping in item.basic)
{
OrdersBasicToppings basic = new OrdersBasicToppings {
Details = details,
Topping = new BasicToppings(topping.id),
Price = topping.amount
};
basic.Save();
}
foreach (var topping in item.deluxe)
{
OrdersDeluxeToppings deluxe = new OrdersDeluxeToppings {
Details = details,
Topping = new DeluxeToppings(topping.id),
Price = topping.amount
};
deluxe.Save();
}
}
return(LocalRedirect("/"));
}
