public void DeleteOrder(ClassLibrary.Models.Order order)
{
using var context = new Project0DBContext(_contextOptions);
var dbOrder = context.Orders.Where(i => i.OrderId == order.OrderId).First();
context.Remove(dbOrder);
context.SaveChanges();
}
public ActionResult Create(ClassLibrary.Models.Order order)
{
using var context = new Project0DBContext(_contextOptions);
if (ModelState.IsValid)
{
var createOrder = _orderRepo.CreateAndReturnOrder(order);
return(RedirectToAction(nameof(Detail), new { id = createOrder.OrderId }));
}
return(View("Index"));
}
public Order CreateAndReturnOrder(ClassLibrary.Models.Order order)
{
using var context = new Project0DBContext(_contextOptions);
var dbOrder = new Order()
{
CustomerId = order.CustomerId,
LocationId = order.LocationId,
OrderDate = order.OrderDate,
Total = order.Total
};
context.Orders.Add(dbOrder);
context.SaveChanges();
return(GetOrderById(dbOrder.OrderId));
}
public List <ClassLibrary.Models.OrderSale> GetOrderProducts(ClassLibrary.Models.Order order)
{
using var context = new Project0DBContext(_contextOptions);
var dbOrderSales = context.OrderSales.Where(o => o.OrderId == order.OrderId).Include(o => o.Product).ToList();
var appOrderSales = new List <ClassLibrary.Models.OrderSale>();
foreach (var item in dbOrderSales)
{
var orderSale = new Product()
{
ProductId = item.Product.ProductId,
Name = item.Product.Name,
Price = item.Product.Price,
};
var newOrderSale = new ClassLibrary.Models.OrderSale(item.OrderId, item.ProductName, item.SalePrice, item.Quantity);
newOrderSale.ProductId = orderSale.ProductId;
appOrderSales.Add(newOrderSale);
}
return(appOrderSales);
}
public void InsertOrder(ClassLibrary.Models.Order order)
{
using var context = new Project0DBContext(_contextOptions);
var dbOrder = new Order()
{
CustomerId = order.CustomerId,
LocationId = order.LocationId,
OrderDate = order.OrderDate,
Total = order.Total,
};
context.Orders.Add(dbOrder);
context.SaveChanges();
foreach (var orderSale in dbOrder.OrderSales)
{
orderSale.OrderId = dbOrder.OrderId;
}
context.SaveChanges();
}
