public static void RemoveOrder(string id)
{
try {
using (var db = new OrderContext()) {
var order = db.Orders.Include("Items").Where(o => o.Id == id).FirstOrDefault();
db.Orders.Remove(order);
db.SaveChanges();
}
}
catch (Exception e) {
//TODO 需要更加错误类型返回不同错误信息
throw new ApplicationException($"删除订单错误!");
}
}
public static Order AddOrder(Order order)
{
try {
using (var db = new OrderContext()) {
db.Orders.Add(order);
db.SaveChanges();
}
return(order);
}
catch (Exception e) {
//TODO 需要更加错误类型返回不同错误信息
throw new ApplicationException($"添加错误: {e.Message}");
}
}
//the order list
//private List<Order> orders;
public OrderService()
{
using (var ctx = new OrderContext())
{
if (ctx.Goods.Count() == 0)
{
ctx.Goods.Add(new Goods("apple", 100.0));
ctx.Goods.Add(new Goods("egg", 200.0));
ctx.Goods.Add(new Goods("banana", 150.0));
ctx.Goods.Add(new Goods("mbp", 13200.0));
ctx.Goods.Add(new Goods("brush", 120.0));
ctx.SaveChanges();
}
if (ctx.Customers.Count() == 0)
{
ctx.Customers.Add(new Customer("Xu"));
ctx.Customers.Add(new Customer("li"));
ctx.Customers.Add(new Customer("zhang"));
ctx.SaveChanges();
}
}
}
public void RemoveOrder(string orderId)
{
using (var context = new OrderContext())
{
var order = context.Orders.Include("Details").SingleOrDefault(o => o.OrderId == orderId);
if (order == null)
{
return;
}
context.OrderDetails.RemoveRange(order.Details);
context.Orders.Remove(order);
context.SaveChanges();
}
}
public static void Add(Goods goods)
{
try
{
using (var db = new OrderContext())
{
db.GoodItems.Add(goods);
db.SaveChanges();
}
}
catch (Exception e)
{
//TODO 需要更加错误类型返回不同错误信息
throw new ApplicationException($"添加错误!");
}
}
public static void Add(Customer customer)
{
try
{
using (var context = new OrderContext())
{
context.Customers.Add(customer);
context.SaveChanges();
}
}
catch (Exception e)
{
//TODO 需要更加错误类型返回不同错误信息
throw new ApplicationException($"添加错误!");
}
}
public void Import(string path)
{
XmlSerializer xs = new XmlSerializer(typeof(List <Order>));
using (FileStream fs = new FileStream(path, FileMode.Open)) {
using (var ctx = new OrderContext()) {
List <Order> temp = (List <Order>)xs.Deserialize(fs);
temp.ForEach(order => {
if (ctx.Orders.SingleOrDefault(o => o.OrderId == order.OrderId) == null)
{
FixOrder(order);
ctx.Orders.Add(order);
}
});
ctx.SaveChanges();
}
}
}
