public Order CreateOrder(Order order)
{
var dc = new DataClassesDataContext(_connectionString);
if (order.Shipper != null)
{
dc.Shippers.Attach(order.Shipper, false);
}
if (order.Customer != null)
{
dc.Customers.Attach(order.Customer, false);
}
if (order.Employee != null)
{
dc.Employees.Attach(order.Employee, false);
}
dc.Orders.InsertOnSubmit(order);
dc.SubmitChanges();
return order;
}
partial void DeleteOrder(Order instance);
partial void UpdateOrder(Order instance);
partial void InsertOrder(Order instance);
public Order UpdateOrder(Order order)
{
var dc = new DataClassesDataContext(_connectionString);
dc.Orders.Attach(order, ReadOrder(order.OrderID));
dc.SubmitChanges();
return order;
}
public void DeleteOrder(Order order)
{
var dc = new DataClassesDataContext(_connectionString);
IQueryable<Order> s = from e in dc.Orders
where e.OrderID == order.OrderID
select e;
dc.Orders.DeleteOnSubmit(s.First());
dc.SubmitChanges();
}
