public void Update(Order order)
{
using (var db = new OrderDB())
{
db.Order.Attach(order);
db.Entry(order).State = EntityState.Modified;
List <OrderDetails> odl = GetAllOrderDetails();
foreach (OrderDetails details in order.orderDetails)
{
bool exist = false;
foreach (OrderDetails detailed in odl)
{
if (detailed.ID == details.ID)
{
exist = true;
break;
}
}
db.Entry(details).State = EntityState.Modified;
if (!exist)
{
db.OrderDetail.Add(details);
}
}
//order.orderDetails.ForEach(
// item => db.Entry(item).State = EntityState.Modified);
db.SaveChanges();
}
}
public void Add(Order order)
{
using (var db = new OrderDB()) {
db.Order.Add(order);
db.SaveChanges();
}
}
public void DeleteDetail(String Id)
{
using (var db = new OrderDB())
{
var orderdetail = db.OrderDetail.SingleOrDefault(o => o.ID == Id);
db.OrderDetail.Remove(orderdetail);
db.SaveChanges();
}
}
public void Delete(String orderId)
{
using (var db = new OrderDB()) {
var order = db.Order.Include("Items").SingleOrDefault(o => o.Id == orderId);
db.OrderDetail.RemoveRange(order.Details);
db.Order.Remove(order);
db.SaveChanges();
}
}
public void Update(Order order)
{
using (var db = new OrderDB()) {
db.Order.Attach(order);
db.Entry(order).State = EntityState.Modified;
order.Details.ForEach(
item => db.Entry(item).State = EntityState.Modified);
db.SaveChanges();
}
}
