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