public void DeleteOrder(int orderId) { using (MySqlOrdersDb Db = new MySqlOrdersDb(ConnectionString)) { Order order = Db.Orders.Where(o => o.OrderID == orderId).FirstOrDefault(); if (order == null) return; Db.ProductOrders.RemoveRange(order.OrderedProducts); Db.SaveChanges(); Db.Orders.Remove(order); Db.SaveChanges(); } }
public void SetOrderStatus(int orderId, eOrderStatus status) { using (MySqlOrdersDb Db = new MySqlOrdersDb(ConnectionString)) { var ord = GetOrderById(orderId); if (ord != null) { Db.Orders.Attach(ord); ord.Status = status; if (status == eOrderStatus.DELIVERED) { ord.DeliveredAt = DateTime.Now; Db.Entry(ord).Property("DeliveredAt").IsModified = true; } Db.Entry(ord).Property("Status").IsModified = true; Db.SaveChanges(); } } }
public int StoreOrder(Order order) { using (MySqlOrdersDb Db = new MySqlOrdersDb(ConnectionString)) { Db.Orders.Add(order); Db.SaveChanges(); } return order.OrderID; }