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