or
public
JsonResult LoadAllUsers([DataSourceRequest]DataSourceRequest request)
{
var repo =
new
AdminRepository();
var users = repo.LoadAllUsers();
var resp = users.Select(u =>
new
{
u.UserId,
u.UserName,
u.FirstName,
u.LastName,
u.EmailAddress,
u.LastActivityDate,
});
var data = resp.ToList().ToDataSourceResult(request);
// var data = resp.Skip(20).Take(20).ToList();
return
Json(data, JsonRequestBehavior.AllowGet);
}
$(
'#grid'
).kendoGrid({dataSource: {transport: {read:
'/AdminJson/LoadAllUsers'
},schema: {model: {fields: {UserId: { type:
'number'
},UserName: { type:
'string'
},FirstName: { type:
'string'
},LastName: { type:
'string'
},EmailAddress: { type:
'string'
},LastActivityDate: { type:
'date'
}}}},pageSize: 20,serverPaging:
true
,serverFiltering:
false
,serverSorting:
true
,scrollable:
true
},height: 430,pageable:
true
,filterable:
false
,sortable:
true
,columns: [{ field:
'UserId'
, title:
'User ID'
, sortable:
false
, filterable:
false
, groupable:
false
},{ field:
'UserName'
, title:
'User Name'
, sortable:
true
, filterable:
false
, groupable:
false
},{ field:
'FirstName'
, title:
'First Name'
, sortable:
true
, filterable:
false
, groupable:
false
},{ field:
'LastName'
, title:
'Last Name'
, sortable:
true
, filterable:
false
, groupable:
false
},{ field:
'EmailAddress'
, title:
'Email Address'
, sortable:
true
, filterable:
false
, groupable:
false
},{ field:
'LastActivityDate'
, title:
'Last Activity Date'
, sortable:
true
, filterable:
false
, groupable:
false
, format:
'{0: yyyy-MM-dd HH:mm:ss}'
}]});
dataSource:
new
kendo.data.DataSource({
serverFiltering:
true
,
transport: {
read: {
url:
function
(e) {
var
value = $(
"#activityTypeBox"
).data(
"kendoDropDownList"
).value();
if
(value !=
""
) {
return
"http://site/api/activities/getByType/id/"
+ value +
"/format/jsonp"
}
},
dataType:
"jsonp"
,
jsonpCallback:
'myCallback'
},
parameterMap:
function
(data, type) {
}
},
schema: {
errors:
"error"
// ex: twitter's response is { "error": "Invalid query" }
},
error:
function
(e) {
alert(
"Problem populating the curriculum db activities based on that type"
);
}
})