public static void EditOrder(Order order)
{
if (order == null)
{
throw new ArgumentException("参数不能为null");
}
using (var _context = new OrdingDBContext())
{
var currentOrder = _context.Orders.Include(o => o.Details).Where(o => o.OrderId == order.OrderId).FirstOrDefault();
if (currentOrder == null)
{
throw new InvalidOperationException("要编辑的订单不存在！");
}
if (!string.IsNullOrEmpty(order.CustomerName))
{
currentOrder.CustomerName = order.CustomerName;
}
if (order.Details != null && order.Details.Count > 0)
{
currentOrder.Details = order.Details;
}
if (order.OrderAmount > 0)
{
currentOrder.OrderAmount = order.OrderAmount;
}
_context.Entry(currentOrder).State = EntityState.Modified;
_context.SaveChanges();
}
}
/// <summary>
/// 全删了
/// </summary>
public static void RemoveAll()
{
using (var _context = new OrdingDBContext())
{
_context.Orders.RemoveRange(_context.Orders.Include(o => o.Details).ToList());
_context.SaveChanges();
}
}
private static IEnumerable <Order> QueryAll()
{
using (var _context = new OrdingDBContext())
{
return(from o in _context.Orders.Include(o => o.Details)
orderby o.OrderAmount
select o);
}
}
public static void Export(string fileName)
{
using (var _context = new OrdingDBContext())
{
using (var output = File.OpenWrite(fileName))
{
_serializer.Serialize(output, _context.Orders.Include(o => o.Details).ToArray());
}
_context.SaveChanges();
}
}
public static void DeleteOrder(int orderId)
{
using (var _context = new OrdingDBContext())
{
var currentOrder = _context.Orders.Include(o => o.Details).Where(o => o.OrderId == orderId).FirstOrDefault();
if (currentOrder == null)
{
throw new InvalidOperationException("要删除的订单不存在！");
}
_context.Orders.Remove(currentOrder);
_context.SaveChanges();
}
}
public static bool AddOrder(Order order)
{
using (var _context = new OrdingDBContext())
{
if (order == null || order.Details == null)
{
throw new ArgumentException("参数不能为null");
}
//检查是否已经存在
if (_context.Orders.Where(o => o.OrderId == order.OrderId).Any())
{
return(false);
}
_context.Orders.Add(order);
_context.Entry(order).State = EntityState.Added;
_context.SaveChanges();
return(true);
}
}
public OrderController(ILogger <OrderController> logger, OrdingDBContext ctx)
{
_logger = logger;
_ctx = ctx;
}