public ActionResult ProcessOrder(FormCollection frc) { List <Cart> lstCart = (List <Cart>)Session[strCart]; Order order = new Order() { FirstName = frc["cusName"], LastName = frc["cusLast"], PhoneNumber = frc["cusPhone"], Email = frc["cusEmail"], OrderDate = DateTime.Now }; db.Orders.Add(order); db.SaveChanges(); foreach (Cart cart in lstCart) { OrderDetail orderDetail = new OrderDetail() { OrderId = order.OrderId, PizzaId = cart.Pizza.PizzaId, Quantity = cart.Quantity, Price = cart.Pizza.Price }; db.OrderDetails.Add(orderDetail); db.SaveChanges(); } Session.Remove(strCart); return(View("OrderSuccess")); }
public ActionResult Create([Bind(Include = "PizzaId,Name,Price,Description,ImageUrl")] Pizza pizza) { if (ModelState.IsValid) { db.Pizzas.Add(pizza); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(pizza)); }
public ActionResult Create([Bind(Include = "OrderId,FirstName,LastName,PhoneNumber,Email,OrderTotal")] Order order) { if (ModelState.IsValid) { db.Orders.Add(order); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(order)); }
public void CreateCustomer(Customer1 customer) { if (PC.Customer.Any(c => c.Email == customer.Email) || customer.Email == null) { Console.WriteLine($"This customer with email {customer.Email} already exists and cannot be added"); return; } else { PC.Customer.Add(Mappings.Mapper.Map(customer)); // this will generate insertMapper.Map(customer) } PC.SaveChanges(); // this will execute the above generate insert query }
public void CreateOrder(Order1 order) { //if (PC.CxOrder.Any(c => c.OrderId == order.) || order.Phone == null) //{ // Console.WriteLine($"This order with username {order.Username} already exists and cannot be added"); // return; //} //else PC.CxOrder.Add(MapOrder.Map(order)); // this will generate insertMapper.Map(order) PC.SaveChanges(); // this will execute the above generate insert query }
public void AddOrderToDB(domain.Order order) { int newOrderNumber = db.PizzaOrder.Max(p => p.OrderId) + 1; List <domain.Order> ordersToAdd = new List <domain.Order>(); foreach (domain.Pizza pizza in order.pizzas) { int store_ID = order.store.id; int user_ID = order.user; PizzaOrder dbOrder = new PizzaOrder { OrderId = newOrderNumber, StoreId = store_ID, PizzaId = pizza.id, UserId = user_ID, WhenOrdered = (DateTime)order.created, TotalCost = (float)order.totalCost, Size = pizza.size.ToString() }; AddOrder(dbOrder); db.PizzaOrder.Add(dbOrder); } db.SaveChanges(); }
public void CreatePizza(Pizza1 pizza) { PC.Pizza.Add(MapPizza.Map(pizza)); // this will generate insertMapper.Map(order) PC.SaveChanges(); // this will execute the above generate insert query }