public List <Order> GetByCustormer(String custormer)
{
using (var db = new OrderDB())
{
return(db.Order.Include("items").Where(order => order.Customer.Equals(custormer)).ToList <Order>());
}
}
public List <Order> GetAll()
{
using (var db = new OrderDB())
{
return(db.Order.Include("items").ToList <Order>());
}
}
public List <Order> GetByGoods(String good)
{
using (var db = new OrderDB())
{
return(db.Order.Include("items").Where(order => order.Items.Where(item => item.Product.Equals(good)).Count() > 0).ToList <Order>());
}
}
public Order GetOrder(String id)
{
using (var db = new OrderDB())
{
return(db.Order.Include("items").SingleOrDefault(order => order.Id == id));
}
}
}///更新订单
/// <summary>
/// query by orderId
/// </summary>
/// <param name="orderId">id of the order to find</param>
/// <returns>List<Order></returns>
public Order GetById(int orderId)
{
using (var db = new OrderDB())
{
return(db.Order.Include("Details").SingleOrDefault(o => o.Id == orderId));//找到order
}
}
}//删除货物
/// <summary>
/// query all orders
/// </summary>
/// <returns>List<Order>:all the orders</returns>
public List <Order> QueryAll()
{
using (var db = new OrderDB())
{
return(db.Order.Include("Details").ToList <Order>());
}
}
public List <Order> GetAllOrders()
{
using (var db = new OrderDB())
{
List <OrderDetail> orderDetails = db.OrderDetail.Include("Goods").ToList <OrderDetail>();
List <Order> orders = db.Order.Include("Details").Include("Customer").ToList <Order>();
foreach (Order O in orders)
{
foreach (OrderDetail ODetail in O.Details)
{
foreach (OrderDetail orderDetail in orderDetails)
{
if (ODetail.Id.Equals(orderDetail.Id))
{
ODetail.Goods = orderDetail.Goods;
}
}
}
}
SaveOrders = orders;
return(SaveOrders);
}
}
/// <summary>
/// update the order
/// </summary>
/// <param name="order">the order to be updated</param>
/*public void Update(Order order) {
* RemoveOrder(order.Id);
* orderList.Add(order);
* }
*/
public void updata(Order order, List <OrderDetail> removed, List <OrderDetail> newDetails)
{
using (var db = new OrderDB())
{
order.Details.AddRange(newDetails);
foreach (OrderDetail Detail in order.Details)
{
if (removed.Contains(Detail))
{
db.Entry(Detail).State = EntityState.Deleted;
}
else if (newDetails.Contains(Detail))
{
db.Entry(Detail).State = EntityState.Added;
}
else
{
db.Entry(Detail).State = EntityState.Modified;
}
}
db.SaveChanges();
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// query by customerName
/// </summary>
/// <param name="customerName">customer name</param>
/// <returns></returns>
/*public List<Order> QueryByCustomerName(string customerName) {
* var query = orderList
* .Where(o => o.Customer.Name == customerName);
* return query.ToList();
* }*/
public List <Order> QueryByCustomerName(string customerName)
{
using (var db = new OrderDB())
{
return(db.Order.Include("Details").Where(o => o.Customer.Equals(customerName)).ToList <Order>());
}
}
public Order GetOrder(String Id)
{
using (var db = new OrderDB())
{
return(db.Order.Include("Details").
SingleOrDefault(o => o.Id == Id));
}
}
public void Add(Order order)
{
using (var db = new OrderDB())
{
db.Order.Add(order);
db.SaveChanges();
}
}
public Order GetById(string orderId)
{
using (var db = new OrderDB())
{
return(db.Order.Include("details").
SingleOrDefault(o => o.Id == orderId));
}
}
public Order GetOrder(int Id)
{
using (var db = new OrderDB())
{
return(db.Order.Include("Items").
SingleOrDefault(o => o.Id == Id));
}
}
//private List<Order> orderList;
/// <summary>
/// constructor
/// </summary>
/// <summary>
/// add new order
/// </summary>
/// <param name="order">the order to be added</param>
public void AddOrder(Order order)
{
using (var db = new OrderDB())
{
db.Entry(order).State = EntityState.Added;
db.SaveChanges();
}
}
/// <summary>
/// query all orders
/// </summary>
/// <returns>List<Order>:all the orders</returns>
public List <Order> QueryAllOrders()
{
//return orderDict.Values.ToList();
using (var db = new OrderDB())
{
return(db.Order.Include("details").ToList <Order>());
}
}
/// <summary>
/// query by goodsName
/// </summary>
/// <param name="goodsName">the name of goods in order's orderDetail</param>
/// <returns></returns>
public List <Order> QueryByGoodsName(string goodsName)
{
using (var db = new OrderDB())
{
var query = db.Order.Include("Details")
.Where(o => o.Details.Where(detail => detail.Goods.Name.Equals(goodsName)).Count() > 0);
return(query.ToList <Order>());
}
}
/// <summary>
/// update the order
/// </summary>
/// <param name="order">the order to be updated</param>
public void Update(Order order)
{
RemoveOrder(order.Id);
using (var db = new OrderDB())
{
db.Entry(order).State = EntityState.Added;
db.SaveChanges();
}
}///更新订单
/// <summary>
/// query orders whose totalAmount >= totalAmount
/// </summary>
/// <param name="totalAmount">the minimum totalAmount</param>
/// <returns></returns>
/* public List<Order> QueryByTotalAmount(float totalAmount) {
* var query = orderList.Where(o=>o.TotalAmount>=totalAmount);
* return query.ToList();
* }*/
public List <Order> QueryByTotalAmount(float totalAmount)
{
using (var db = new OrderDB())
{
var query = db.Order.Include("Details")
.Where(o => o.Details.Where(detail => detail.Goods.Equals(totalAmount)).Count() > 0);
return(query.ToList <Order>());
}
}
public void Delete(String orderId)
{
using (var db = new OrderDB())
{
var order = db.Order.Include("Details").SingleOrDefault(o => o.Id == orderId);
db.OrderDetail.RemoveRange(order.Details);
db.Order.Remove(order);
db.SaveChanges();
}
}
public void RemoveOrder(string orderId)
{
using (var db = new OrderDB())
{
var order = db.Order.Include("details").SingleOrDefault(o => o.Id == orderId);
db.OrderItem.RemoveRange(order.details);
db.Order.Remove(order);
db.SaveChanges();
}
}
public List <Order> QueryByGoods(String product)
{
using (var db = new OrderDB())
{
var query = db.Order.Include("Details")
.Where(o => o.Details.Where(
item => item.Goods.Name.Equals(product)).Count() > 0);
return(query.ToList <Order>());
}
}
public void Update(Order order)
{
using (var db = new OrderDB())
{
db.Order.Attach(order);
db.Entry(order).State = EntityState.Modified;
order.Details.ForEach(detail => db.Entry(detail).State = EntityState.Modified);
db.SaveChanges();
}
}
/// <summary>
/// remove order
/// </summary>
/// <param name="orderId">id of the order which will be removed</param>
public void RemoveOrder(int orderId)
{
Order order = GetById(orderId);
using (var db = new OrderDB())
{
db.Entry(order).State = EntityState.Deleted;
db.SaveChanges();
}
}//数据库删除订单
public void Delete(int orderId)
{
using (var db = new OrderDB())
{
var order = db.Order.Include("Items").SingleOrDefault(o => o.Id == orderId);
db.OrderItem.RemoveRange(order.Items);
db.Order.Remove(order);
db.SaveChanges();
}
}
/// <summary>
/// query by customerName
/// </summary>
/// <param name="customerName">customer name</param>
/// <returns></returns>
public List <Order> QueryByCustomerName(string customerName)
{
//var query=orderDict.Values
// .Where(order => order.Customer.Name == customerName);
//return query.ToList();
using (var db = new OrderDB())
{
return(db.Order.Include("details")
.Where(order => order.Customer.Name == customerName)
.ToList <Order>());
}
}
public List <Order> QueryByPrice(double price)
{
using (var db = new OrderDB())
{
return(db.Order.Include("details")
.Where(order => order.Amount > price)
.ToList <Order>());
}
//var query = orderDict.Values
// .Where(order => order.Amount> price);
//return query.ToList();
}
/// <summary>
/// query by goodsName
/// </summary>
/// <param name="goodsName">the name of goods in order's orderDetail</param>
/// <returns></returns>
public List <Order> QueryByGoodsName(string goodsName)
{
//var query = orderDict.Values.Where(order =>
// order.Details.Where(d => d.Goods.Name == goodsName)
// .Count() > 0
// );
//return query.ToList();
using (var db = new OrderDB())
{
return(db.Order.Include("details")
.Where(order => order.Details.Where(d => d.Goods.Name == goodsName).Count() > 0)
.ToList <Order>());
}
}
/// <summary>
/// add new order
/// </summary>
/// <param name="order">the order will be added</param>
public void AddOrder(Order order)
{
//if (orderDict.ContainsKey(order.Id))
// throw new Exception($"order-{order.Id} is already existed!");
//orderDict[order.Id] = order;
if (orderDict.ContainsKey(order.Id))
{
throw new Exception($"order-{order.Id} is already existed!");
}
else
{
using (var db = new OrderDB())
{
db.Order.Add(order);
db.SaveChanges();
}
}
}
public void Delete(string orderId)
{
using (var db = new OrderDB())
{
var order = db.Order.Include("Details").Include("Customer").SingleOrDefault(o => o.Id == orderId);
foreach (OrderDetail orderDetail in order.Details)
{
var ods = db.OrderDetail.Include("Goods").SingleOrDefault(d => d.Id == orderDetail.Id);
db.Goods.Remove(ods.Goods);
}
db.OrderDetail.RemoveRange(order.Details);
db.Customer.Remove(order.Customer);
db.Order.Remove(order);
SaveOrders.Remove(order);
db.SaveChanges();
}
}
