public List <Order> GetOrder(string Name) { using (var db = new OrderDB()) { return(db.Order.Where(o => o.Name.Equals(Name)).ToList <Order>()); } }
public List <Order> GetAllOrders() { using (var db = new OrderDB()) { return(db.Order.ToList <Order>()); } }
public void Add(Order order) { using (var db = new OrderDB()) { db.Order.Add(order); db.SaveChanges(); } }
public List <Order> QueryByGoods(String product) { using (var db = new OrderDB()) { var query = db.Order .Where(o => o.Good.Equals(product)); return(query.ToList <Order>()); } }
public void Delete(string orderId) { using (var db = new OrderDB()) { var order = db.Order.SingleOrDefault(o => o.ID == orderId); db.Order.Remove(order); db.SaveChanges(); } }