public JsonResult PilotGridData(JqSettings settings) { var skip = settings.rows*(settings.page - 1); var dbData = _pilotRepository.GetAllPilots(); var filteredDbData = dbData.Skip(skip).Take(settings.rows); var count = dbData.Count(); var gridData = from record in filteredDbData select new { cell = new object[] { record.Name, record.Age, record.Team, record.DebutDate } }; var jsonData = new { total = (int) Math.Ceiling((double) count/settings.rows), //totalPages settings.page, records = count, rows = gridData }; return Json(jsonData, JsonRequestBehavior.AllowGet); }
public JsonResult CarGridData(JqSettings settings) { var skip = settings.rows * (settings.page - 1); var dbData = _carRepository.GetAllCars(); var filteredDbData = dbData.Skip(skip).Take(settings.rows); var count = dbData.Count(); var gridData = from record in filteredDbData select new { cell = new object[] { record.Version, record.Name, record.FuelTank, record.AdditionalInfo } }; var jsonData = new { total = (int)Math.Ceiling((double)count / settings.rows), //totalPages settings.page, records = count, rows = gridData }; return Json(jsonData, JsonRequestBehavior.AllowGet); }