//修改订单，alterType为修改项
//如果要对订单明细进行修改，则还应传入要修改的订单明细号
public void AlterOrder(int orderID, String alterType, object alterData, int orderItemID = 0)
{
using (var management = new OrderManagement())
{
var order = management.Orders.Include("OrderItems").FirstOrDefault(o => o.ID == orderID);
if (order != null)
{
switch (alterType)
{
case "customer": order.CustomerID = IsInt(alterData); break;
case "order time": order.OrderTime = IsDateTime(alterData); break;
case "add item": order.OrderItems.Add(isOrderItem(alterData)); break;
case "delete item": order.OrderItems.Remove(order.OrderItems.FirstOrDefault(
i => i.ID == orderItemID)); break;
case "quantity":
order.OrderItems.FirstOrDefault(
i => i.ID == orderItemID).Quantity = IsInt(alterData); break;
default: throw new ArgumentException("No such operation!");
}
management.SaveChanges();
}
}
}
public OrderService()
{
using (var management = new OrderManagement())
{
//若无商品（数据库初始化），默认添加商品
if (management.GoodsItems.Count(goods => true) == 0)
{
management.GoodsItems.Add(new GoodsItem()
{
Name = "apple", Price = 6.8
});
management.GoodsItems.Add(new GoodsItem()
{
Name = "bear", Price = 4.8
});
management.GoodsItems.Add(new GoodsItem()
{
Name = "orange", Price = 2.8
});
management.GoodsItems.Add(new GoodsItem()
{
Name = "lemon", Price = 7.8
});
management.SaveChanges();
}
}
}
public List <Order> FindOrder(int orderID)
{
using (var management = new OrderManagement())
{
var query = management.Orders.Include(o => o.OrderItems.Select(i => i.GoodsItem))
.Include("Customer").Where(order => orderID == int.MinValue || order.ID == orderID).OrderBy(order => order.ID);
return(query.ToList());
}
}
//添加新订单
public int AddOrder(Order newOrder)
{
if (newOrder == null)
{
throw new ArgumentException("Cannot add an empty order!");
}
using (var management = new OrderManagement())
{
management.Orders.Add(newOrder);
management.SaveChanges();
}
return(newOrder.ID);
}
public void DeleteOrder(int orderID)
{
using (var management = new OrderManagement())
{
var order = management.Orders.Include("OrderItems").FirstOrDefault(o => o.ID == orderID);
if (order != null)
{
management.Orders.Remove(order);
management.SaveChanges();
}
else
{
throw new ArgumentException("Invalid order!");
}
}
}
