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))); }