public Order GetOrder(String Id)
{
using (var db = new OrderDB()) {
return(db.Order.Include("Items").
SingleOrDefault(o => o.Id == Id));
}
}
public List <Order> QueryByCustormer(String custormer)
{
using (var db = new OrderDB()) {
return(db.Order.Include("items")
.Where(o => o.Customer.Equals(custormer)).ToList <Order>());
}
}
public void Add(Order order)
{
using (var db = new OrderDB()) {
db.Entry(order).State = EntityState.Added;
db.SaveChanges();
}
}
public List <Order> GetAllOrders()
{
using (var db = new OrderDB())
{
return(db.Order.Include("Items").ToList <Order>());
}
}
public List <Order> Import(string path)
{
if (Path.GetExtension(path) != ".xml")
{
throw new ArgumentException("It isn't a xml file!");
}
XmlSerializer xs = new XmlSerializer(typeof(List <Order>));
List <Order> result = new List <Order>();
using (FileStream fs = new FileStream(path, FileMode.Open))
{
using (var db = new OrderDB())
{
List <Order> temp = (List <Order>)xs.Deserialize(fs);
temp.ForEach(order =>
{
if (!db.Order.ToList().Contains(order))
{
result.Add(order);
}
});
}
}
return(result);
}
public List <Order> QueryByGoods(String product)
{
using (var db = new OrderDB()) {
var query = db.Order.Include("items")
.Where(o => o.Items.Where(
item => item.Product.Equals(product)).Count() > 0);
return(query.ToList <Order>());
}
}
public void Delete(String 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();
}
}
public void Update(Order order)
{
using (var db = new OrderDB()) {
Console.WriteLine(db.Entry(order).State);
db.Entry(order).State = EntityState.Modified;
order.Items.ForEach(
item => db.Entry(item).State = EntityState.Modified);
db.SaveChanges();
}
}
public void Update(Order order)
{
using (var db = new OrderDB()) {
db.Order.Attach(order);
db.Entry(order).State = EntityState.Modified;
order.Items.ForEach(
item => db.Entry(item).State = EntityState.Modified);
db.SaveChanges();
}
}
public List <Order> QueryByPrice(double price)
{
using (var db = new OrderDB())
{
var query = db.Order.Include("items").Where(
o => o.Items.Where(
item => item.UnitPrice * item.Quantity < price).Count() > 0);
return(query.ToList <Order>());
}
}
public void Export(String fileName)
{
XmlSerializer xs = new XmlSerializer(typeof(List <Order>));
using (FileStream fs = new FileStream(fileName, FileMode.Create))
{
using (var db = new OrderDB())
{
xs.Serialize(fs, db.Order.Include("items").ToList <Order>());
}
}
}
public void Add(Order order)
{
using (var db = new OrderDB())
{
if (db.Order.Where(o => o.Id == order.Id).Count() == 0)
{
db.Order.Add(order);
//db.Order.Attach(order);
//db.Entry(order).State = EntityState.Added;
db.SaveChanges();
}
}
}
public void Update(Order newOrder)
{
using (var db = new OrderDB()) {
Order oldOrder = db.Order.Include("Details").SingleOrDefault(o => o.Id == newOrder.Id);
db.OrderItem.RemoveRange(oldOrder.Details);
db.SaveChanges();
}
using (var db = new OrderDB()) {
foreach (OrderDetail detail in newOrder.Details)
{
db.Entry(detail).State = EntityState.Added;
}
//db.SaveChanges();//先保存items部分的修改
db.Entry(newOrder).State = EntityState.Modified;
db.SaveChanges();//保存Order的属性修改
}
}
public void Update(Order order, List <OrderItem> removed, List <OrderItem> newItems)
{
using (var db = new OrderDB()) {
order.Items.AddRange(newItems);
foreach (OrderItem item in order.Items)
{
if (removed.Contains(item))
{
db.Entry(item).State = EntityState.Deleted;
}
else if (newItems.Contains(item))
{
db.Entry(item).State = EntityState.Added;
}
else
{
db.Entry(item).State = EntityState.Modified;
}
}
db.SaveChanges(); //先保存items部分的修改
db.Entry(order).State = EntityState.Modified;
db.SaveChanges(); //保存Order的属性修改
}
}
