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