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