public ActionResult Orders_Update([DataSourceRequest]DataSourceRequest request, OrderViewModel order)
{
if (ModelState.IsValid)
{
using (var northwind = new NorthwindEntities())
{
var entity = northwind.Orders.FirstOrDefault(o => o.OrderID == order.OrderID);
if (entity == null)
{
string errorMessage = string.Format("Cannot update record with OrderID:{0} as it's not available.", order.OrderID);
ModelState.AddModelError("", errorMessage);
}
else
{
entity.CustomerID = order.CustomerID;
entity.EmployeeID = order.EmployeeID;
entity.OrderDate = order.OrderDate;
entity.ShipCountry = order.ShipCountry;
entity.ShipVia = order.ShipVia;
entity.ShippedDate = order.ShippedDate;
entity.ShipName = order.ShipName;
entity.ShipAddress = order.ShipAddress;
entity.ShipCity = order.ShipCity;
entity.ShipPostalCode = order.ShipPostalCode;
northwind.Orders.Attach(entity);
northwind.Entry(entity).State = EntityState.Modified;
northwind.SaveChanges();
}
}
}
return Json(new[] { order }.ToDataSourceResult(request, ModelState));
}
public ActionResult Customers_Update([DataSourceRequest]DataSourceRequest request, CustomerViewModel customer)
{
if (ModelState.IsValid)
{
using (var northwind = new NorthwindEntities())
{
var entity = new Customer
{
CustomerID = customer.CustomerID,
CompanyName = customer.CompanyName,
Country = customer.Country,
City = customer.City,
ContactName = customer.ContactName,
Phone = customer.Phone,
};
northwind.Customers.Attach(entity);
northwind.Entry(entity).State = EntityState.Modified;
northwind.SaveChanges();
}
}
return Json(new[] { customer }.ToDataSourceResult(request, ModelState));
}