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