public void UpdateOrder(Order newOrder)
{
//Order oldOrder = GetOrder(newOrder.OrderID);
using (var db = new OScontext())
{
var oldOrder = db.Orders
.Include(o => o.Customer)
.Include(o => o.OrderItems)
.Include(o => o.OrderItems.Select(item => item.GoodsItem))
.FirstOrDefault(o => o.OrderID == newOrder.OrderID);
if (oldOrder == null)
{
throw new ApplicationException($"修改错误：订单 {newOrder.OrderID} 不存在!");
}
for (int i = 0; i < oldOrder.OrderItems.Count; i++)
{
db.Goods.Remove(oldOrder.OrderItems[i].GoodsItem);
db.OrderItems.Remove(oldOrder.OrderItems[i]);
}
db.Customers.Remove(oldOrder.Customer);
db.Orders.Remove(oldOrder);
db.Orders.Add(newOrder);
db.SaveChanges();
}
//orders.Remove(oldOrder);
//orders.Add(newOrder);
}
public void Sort(Func <Order, Order, int> func)
{
using (var db = new OScontext())
{
db.Orders.ToList().Sort((o1, o2) => func(o1, o2));
db.SaveChanges();
}
//Orders.Sort((o1,o2)=>func(o1,o2));
}
public void Sort()
{
using (var db = new OScontext())
{
db.Orders.OrderBy(o => o.OrderID);
db.SaveChanges();
}
// orders.Sort();
}
public object QueryByTotalAmount(float amout)
{
using (var db = new OScontext())
{
return(db.Orders
.Where(order => order.TotalPrice >= amout)
.OrderByDescending(o => o.TotalPrice)
.ToList());
}
}
public List <Order> QueryOrdersByGoodsName(string goodsName)
{
using (var db = new OScontext())
{
var query = db.Orders
.Where(order => order.OrderItems.Exists(item => item.GoodsName == goodsName))
.OrderBy(o => o.TotalPrice);
return(query.ToList());
}
}
public void Export(String fileName)
{
XmlSerializer xs = new XmlSerializer(typeof(List <Order>));
using (FileStream fs = new FileStream(fileName, FileMode.Create))
{
using (var db = new OScontext())
{
xs.Serialize(fs, db.Orders.ToList());
}
//xs.Serialize(fs, Orders);
}
}
public Order GetOrder(int id)
{
using (var db = new OScontext())
{
var order = db.Orders
.Include(o => o.Customer)
.Include(o => o.OrderItems)
.Include(o => o.OrderItems.Select(item => item.GoodsItem))
.Where(o => o.OrderID == id)
.FirstOrDefault();
return(order);
}
//return orders.Where(o => o.OrderID == id).FirstOrDefault();
}
public List <Order> QueryOrdersByCustomerName(string customerName)
{
using (var db = new OScontext())
{
var query = db.Orders
.Where(order => order.CustomerName == customerName)
.OrderBy(o => o.TotalPrice);
return(query.ToList());
//return orders
// .Where(order => order.CustomerName == customerName)
// .OrderBy(o => o.TotalPrice)
// .ToList();
}
}
public void AddOrder(Order order)
{
//if (orders.Contains(order))
// throw new ApplicationException($"添加错误: 订单{order.OrderID} 已经存在了!");
using (var db = new OScontext())
{
if (db.Orders.Select(o => o.OrderID).Contains(order.OrderID))
{
throw new ApplicationException($"添加错误: 订单{order.OrderID} 已经存在了!");
}
db.Orders.Add(order);
db.SaveChanges();
//orders = db.Orders
// .Include(o => o.Customer)
// .Include(o => o.OrderItems)
// .Include(o => o.OrderItems.Select(item => item.GoodsItem))
// .ToList();
}
//orders.Add(order);
}
public void Import(string path)
{
XmlSerializer xs = new XmlSerializer(typeof(List <Order>));
using (FileStream fs = new FileStream(path, FileMode.Open))
{
List <Order> temp = (List <Order>)xs.Deserialize(fs);
using (var db = new OScontext())
{
temp.ForEach(order =>
{
if (!db.Orders.Select(o => o.OrderID).Contains(order.OrderID))
{
db.Orders.Add(order);
}
});
db.SaveChanges();
}
}
}
public void RemoveOrder(int orderId)
{
//orders.Remove(order);
using (var db = new OScontext())
{
var order = db.Orders
.Include(o => o.Customer)
.Include(o => o.OrderItems)
.Include(o => o.OrderItems.Select(item => item.GoodsItem))
.FirstOrDefault(o => o.OrderID == orderId);
if (order != null)
{
for (int i = 0; i < order.OrderItems.Count; i++)
{
db.Goods.Remove(order.OrderItems[i].GoodsItem);
db.OrderItems.Remove(order.OrderItems[i]);
}
db.Customers.Remove(order.Customer);
db.Orders.Remove(order);
db.SaveChanges();
}
}
}
