public ActionResult ForeignKeyColumn_Update([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <ClientOrderViewModel> orders)
{
if (orders != null && ModelState.IsValid)
{
foreach (var order in orders)
{
var target = SessionClientOrderRepository.One(o => o.OrderID == order.OrderID);
if (target != null)
{
target.OrderDate = order.OrderDate;
target.ShipAddress = order.ShipAddress;
target.ShipCountry = order.ShipCountry;
target.ShipName = order.ShipName;
target.ContactName = order.ContactName;
target.Employee = new NorthwindDataContext()
.Employees
.Where(e => e.EmployeeID == order.EmployeeID)
.ToList()
.Select(e => new ClientEmployeeViewModel
{
EmployeeName = e.FirstName + " " + e.LastName,
EmployeeID = e.EmployeeID
}).FirstOrDefault();
target.EmployeeID = order.EmployeeID;
SessionClientOrderRepository.Update(target);
}
}
}
return(Json(ModelState.ToDataSourceResult()));
}
public ActionResult _ForeignKeyColumnUpdateOrder(int id, int employeeId)
{
var order = new ClientEditableOrder
{
OrderID = id,
Employee = new NorthwindDataContext().Employees
.Where(e => e.EmployeeID == employeeId)
.Select(e => e.FirstName + " " + e.LastName).SingleOrDefault()
};
// Exclude "Employee" from the list of updated properties
if (TryUpdateModel(order, null, null, new[] { "Employee" }))
{
SessionClientOrderRepository.Update(order);
}
return(View(new GridModel(SessionClientOrderRepository.All())));
}
public ActionResult EditingCustom_Update([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <ClientOrderViewModel> orders)
{
if (orders != null && ModelState.IsValid)
{
foreach (var order in orders)
{
var target = SessionClientOrderRepository.One(o => o.OrderID == order.OrderID);
if (target != null)
{
target.OrderDate = order.OrderDate;
target.ShipAddress = order.ShipAddress;
target.ShipCountry = order.ShipCountry;
target.ShipName = order.ShipName;
target.ContactName = order.ContactName;
target.Employee = order.Employee;
target.EmployeeID = order.Employee.EmployeeID;
SessionClientOrderRepository.Update(target);
}
}
}
return(Json(ModelState.ToDataSourceResult()));
}
public ActionResult _ForeignKeyColumn()
{
return(View(new GridModel(SessionClientOrderRepository.All())));
}
public ActionResult EditingCustom_Read([DataSourceRequest] DataSourceRequest request)
{
return(Json(SessionClientOrderRepository.All().ToDataSourceResult(request)));
}
public ActionResult _ClientEditTemplate()
{
PopulateEmployees();
return(View(new GridModel(SessionClientOrderRepository.All())));
}
public ActionResult ForeignKeyColumn_Read([DataSourceRequest] DataSourceRequest request)
{
return(Json(SessionClientOrderRepository.All().ToDataSourceResult(request)));
}
