public async Task <IActionResult> Edit(int id, [Bind("OrderId,ProductId,Quantity,ProductOrderPrice")] CafeOrderDetails cafeOrderDetails) { if (id != cafeOrderDetails.OrderId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(cafeOrderDetails); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CafeOrderDetailsExists(cafeOrderDetails.OrderId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["OrderId"] = new SelectList(_context.CafeOrders, "OrderId", "OrderId", cafeOrderDetails.OrderId); ViewData["ProductId"] = new SelectList(_context.CafeProducts, "ProductId", "ProductId", cafeOrderDetails.ProductId); return(View(cafeOrderDetails)); }
public async Task <IActionResult> Create([Bind("OrderId,ProductId,Quantity,ProductOrderPrice")] CafeOrderDetails cafeOrderDetails) { if (ModelState.IsValid) { _context.Add(cafeOrderDetails); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["OrderId"] = new SelectList(_context.CafeOrders, "OrderId", "OrderId", cafeOrderDetails.OrderId); ViewData["ProductId"] = new SelectList(_context.CafeProducts, "ProductId", "ProductId", cafeOrderDetails.ProductId); return(View(cafeOrderDetails)); }
public void CreateOrder(CafeOrders order, int customerId) { //Gets last order ID and adds by 1 CafeOrders lastOrder = _DbContext.CafeOrders.LastOrDefault(o => o.OrderId == o.OrderId); if (lastOrder != null) { order.OrderId = lastOrder.OrderId + 1; } else { order.OrderId = 1; } //Gets order Date order.OrderDate = DateTime.Now; //Gets order customer ID order.CustId = customerId; order.OrderTotalPrice = _shoppingCart.GetShoppingCartTotal(); _DbContext.CafeOrders.Add(order); _DbContext.SaveChanges(); //Adds each product to order details table var shoppingCartItems = _shoppingCart.ShoppingCartItems; foreach (var item in shoppingCartItems) { var orderDetail = new CafeOrderDetails() { OrderId = order.OrderId, ProductId = item.Products.ProductId, Quantity = item.Amount, ProductOrderPrice = (item.Products.ProductPrice) * (item.Amount) }; _DbContext.CafeOrderDetails.Add(orderDetail); } _DbContext.SaveChanges(); }