public static void RemoveOrder(string id) { try { using (var db = new OrderContext()) { var order = db.Orders.Include("Items").Where(o => o.Id == id).FirstOrDefault(); db.Orders.Remove(order); db.SaveChanges(); } } catch (Exception e) { //TODO 需要更加错误类型返回不同错误信息 throw new ApplicationException($"删除订单错误!"); } }
public static Order AddOrder(Order order) { try { using (var db = new OrderContext()) { db.Orders.Add(order); db.SaveChanges(); } return(order); } catch (Exception e) { //TODO 需要更加错误类型返回不同错误信息 throw new ApplicationException($"添加错误: {e.Message}"); } }
//the order list //private List<Order> orders; public OrderService() { using (var ctx = new OrderContext()) { if (ctx.Goods.Count() == 0) { ctx.Goods.Add(new Goods("apple", 100.0)); ctx.Goods.Add(new Goods("egg", 200.0)); ctx.Goods.Add(new Goods("banana", 150.0)); ctx.Goods.Add(new Goods("mbp", 13200.0)); ctx.Goods.Add(new Goods("brush", 120.0)); ctx.SaveChanges(); } if (ctx.Customers.Count() == 0) { ctx.Customers.Add(new Customer("Xu")); ctx.Customers.Add(new Customer("li")); ctx.Customers.Add(new Customer("zhang")); ctx.SaveChanges(); } } }
public void RemoveOrder(string orderId) { using (var context = new OrderContext()) { var order = context.Orders.Include("Details").SingleOrDefault(o => o.OrderId == orderId); if (order == null) { return; } context.OrderDetails.RemoveRange(order.Details); context.Orders.Remove(order); context.SaveChanges(); } }
public static void Add(Goods goods) { try { using (var db = new OrderContext()) { db.GoodItems.Add(goods); db.SaveChanges(); } } catch (Exception e) { //TODO 需要更加错误类型返回不同错误信息 throw new ApplicationException($"添加错误!"); } }
public static void Add(Customer customer) { try { using (var context = new OrderContext()) { context.Customers.Add(customer); context.SaveChanges(); } } catch (Exception e) { //TODO 需要更加错误类型返回不同错误信息 throw new ApplicationException($"添加错误!"); } }
public void Import(string path) { XmlSerializer xs = new XmlSerializer(typeof(List <Order>)); using (FileStream fs = new FileStream(path, FileMode.Open)) { using (var ctx = new OrderContext()) { List <Order> temp = (List <Order>)xs.Deserialize(fs); temp.ForEach(order => { if (ctx.Orders.SingleOrDefault(o => o.OrderId == order.OrderId) == null) { FixOrder(order); ctx.Orders.Add(order); } }); ctx.SaveChanges(); } } }