public bool DeleteOrder(int orderNum)
{
using (var context = new OrderContext())
{
var order = context.Orders
.SingleOrDefault(o => o.OrderID == orderNum);
if (order != null)
{
context.Orders.Remove(order);
context.SaveChanges();
return(true);
}
}
return(false);
}
public static Order AddOrder(Order order)
{
try
{
using (var db = new OrderContext())
{
db.Orders.Add(order);
db.SaveChanges();
}
return(order);
}
catch (Exception e)
{
throw new ApplicationException($"添加错误: {e.Message}");
}
}
public static void RemoveOrder(Order order1)
{
try
{
using (var db = new OrderContext())
{
var order = db.Orders.Include("OrderItems").Where(o => o.Id == order1.Id).FirstOrDefault();
db.Orders.Remove(order);
db.SaveChanges();
}
}
catch (Exception e)
{
throw new ApplicationException($"删除订单错误!");
}
}
public void UpdateOrder(Order m)
{
using (var context = new OrderContext())
{
var order = context.Orders
.SingleOrDefault(o => o.OrderID == m.OrderID);
if (order == null)
{
AddOrder(m);
}
else
{
order = m.DeepClone();
context.SaveChanges();
}
}
}
public bool AddOrder(Order m)
{
using (var context = new OrderContext())
{
var order = context.Orders
.SingleOrDefault(o => o.OrderID == m.OrderID);
if (order != null)
{
return(false);
}
}
using (var context = new OrderContext())
{
var order = m.DeepClone();
context.Orders.Add(order);
context.SaveChanges();
}
return(true);
}
