public ActionResult SchoolYears_Read([DataSourceRequest] DataSourceRequest request) { IQueryable <SchoolYear> items = SchoolYear.GetAll().AsQueryable(); DataSourceResult result = items.ToDataSourceResult(request, _item => new { Id = _item.Id, Name = _item.Name, IsCurrent = _item.IsCurrent, // IsDeleted = _item.IsDeleted, CreatedOn = _item.CreatedOn, CreatedByUserId = _item.CreatedByUserId, CreatedByUserName = _item.CreatedByUserName }); return(Json(result)); }
public JsonResult GetAllSchoolYears_Read() { List <SchoolYear> allitems = SchoolYear.GetAll(); allitems.Insert(0, new SchoolYear() { Name = "All", Id = -1 }); IQueryable <SchoolYear> items = allitems.AsQueryable(); var result = from item in items select new { Id = item.Id, Name = item.Name }; return(Json(result, JsonRequestBehavior.AllowGet)); }