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