public ActionResult Orders_Create([DataSourceRequest]DataSourceRequest request, OrderViewModel order)
{
if (ModelState.IsValid)
{
using (var northwind = new NorthwindEntities())
{
var entity = new Order
{
CustomerID = order.CustomerID,
EmployeeID = order.EmployeeID,
OrderDate = order.OrderDate,
ShipCountry = order.ShipCountry,
ShipVia = order.ShipVia,
ShippedDate = order.ShippedDate,
ShipName = order.ShipName,
ShipAddress = order.ShipAddress,
ShipCity = order.ShipCity,
ShipPostalCode = order.ShipPostalCode
};
northwind.Orders.Add(entity);
northwind.SaveChanges();
order.OrderID = entity.OrderID;
}
}
return Json(new[] { order }.ToDataSourceResult(request, ModelState));
}
public ActionResult Orders_Destroy([DataSourceRequest]DataSourceRequest request, OrderViewModel order)
{
if (ModelState.IsValid)
{
using (var northwind = new NorthwindEntities())
{
List<Order_Detail> details = northwind.Order_Details.Where(od => od.OrderID == order.OrderID).ToList();
foreach (var orderDetail in details)
{
northwind.Order_Details.Remove(orderDetail);
}
var entity = new Order
{
CustomerID = order.CustomerID,
OrderID = order.OrderID,
EmployeeID = order.EmployeeID,
OrderDate = order.OrderDate,
ShipCountry = order.ShipCountry,
ShipVia = order.ShipVia,
ShippedDate = order.ShippedDate,
ShipName = order.ShipName,
ShipAddress = order.ShipAddress,
ShipCity = order.ShipCity,
ShipPostalCode = order.ShipPostalCode
};
northwind.Orders.Attach(entity);
northwind.Orders.Remove(entity);
northwind.SaveChanges();
}
}
return Json(new[] { order }.ToDataSourceResult(request, ModelState));
}
