I have implemented master/detail grid folowing your example but now I have another problem. When I try to filter the detail grid(second one) I get the error. Any idea how to pass productId while filtering?
The parameters dictionary contains a null entry for parameter 'productId' of non-nullable type 'System.Int32' for method 'System.Web.Mvc.ActionResult Users_Read(Kendo.Mvc.UI.DataSourceRequest, Int32)' in 'PC.Controllers.AdminController'. An optional parameter must be a reference type, a nullable type, or be declared as an optional parameter.
Parameter name: parameters
The source code
@(Html.Kendo().Grid<AdminProductViewModel>()
.Name("Products")
.Columns(columns =>
{
columns.Bound(c => c.Id).Width(130);
columns.Bound(c => c.Name).Width(250);
columns.Bound(c => c.UsersCount).Width(50);
/*columns.Command(c => c.Custom("New User").SendDataKeys(true).Action("InsertUser", "Admin"));*/
})
.DataSource(dataSource => dataSource
.Ajax()/*.ServerOperation(true)*/
.Read(read => read.Action("Products_Read", "Admin"))
.Model(x => x.Id(model => model.Id))
)
.Pageable().Sortable().Selectable()
.ToolBar(toolBar => toolBar.Custom().Text("Queue Info").Action("QueueInfo", "Admin"))
.ToolBar(toolBar => toolBar.Custom().Text("Queue Manager").Action("QueueManager", "Admin"))
.ToolBar(toolBar => toolBar.Custom().Text("Thread Info").Action("ThreadInfo", "Admin"))
.ToolBar(toolBar => toolBar.Custom().Name("NewUser").Text("New User").Action("InsertUser", "Admin"))
.Events(events => events.Change("change"))
.Events(events => events.DataBound("dataBound"))
)
@(Html.Kendo().Grid<AdminUserViewModel>()
.Name("Users")
.AutoBind(false)
.Columns(columns =>
{
columns.Command(commands =>
{
commands.Edit();
commands.Destroy();
}).Width(150);
columns.Bound(c => c.Id).Width(20)/*.ReadOnly()*/;
columns.Bound(c => c.DateStamp).Width(20).Format("{0:MMM d, yyyy}")/*.ReadOnly()*/;
columns.Bound(c => c.Active).Width(20);
columns.Bound(c => c.FirstName).Width(200);
columns.Bound(c => c.LastName).Width(200);
columns.Bound(c => c.Email).Width(200);
columns.Bound(c => c.InitialEmail).Hidden();
})
.DataSource(dataSource => dataSource
.Ajax()
.Read(x => x.Action("Users_Read", "Admin"))
.Update("User_Update", "Admin")
.Destroy("User_Delete", "Admin")
.Model(x => x.Id(model => model.Id))
)
.Pageable().Sortable().Filterable().Selectable()
.ToolBar(toolBar => toolBar.Custom().Name("Login").Text("Login").Action("LoginUser", "Admin"))
)
<script>
function change(e) {
var selectedData = this.dataItem(this.select());
var productId = selectedData.Id;
$("#Users").data("kendoGrid").dataSource.read({ productId: productId });
}
</script>
public ActionResult Users_Read([DataSourceRequest]DataSourceRequest request, int productId)
{
var users = GerUsers(productId).Select(p => new AdminUserViewModel
{
Id = p.Id,
Active = p.Active,
Email = p.Email,
InitialEmail = p.Email,
FirstName = p.FirstName,
LastName = p.LastName,
DateStamp = p.DateStamp
});
return Json(users.ToDataSourceResult(request));
}