public JsonResult IndexData(JqSettings settings)
{
var company = CompanyRepository.GetAllCompaniesAllInfo();
var model = new CompanyModel();
var result = model.ConvertToCompanyModel(company);
int skip = settings.rows * (settings.page - 1);
int compCount = result.Count;
IEnumerable<CompanyModel> companies = result.Skip(skip).Take(settings.rows);
var data = from a in companies
select new
{
cell = new object[]
{
a.Id,
a.CompanyName,
a.Activity.ToString(),
a.City,
a.Street,
}
};
var jsonData = new
{
total = (int)Math.Ceiling((double)compCount / settings.rows), //totalPages
page = settings.page, //page number
records = compCount, //total record found
rows = data
};
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
public JsonResult IndexData(JqSettings settings)
{
var company = CompanyRepository.GetAllCompaniesAllInfo();
var model = new CompanyModel();
var result = model.ConvertToCompanyModel(company);
int skip = settings.rows * (settings.page - 1);
int compCount = result.Count;
IEnumerable <CompanyModel> companies = result.Skip(skip).Take(settings.rows);
var data = from a in companies
select new
{
cell = new object[]
{
a.Id,
a.CompanyName,
a.Activity.ToString(),
a.City,
a.Street,
}
};
var jsonData = new
{
total = (int)Math.Ceiling((double)compCount / settings.rows), //totalPages
page = settings.page, //page number
records = compCount, //total record found
rows = data
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
