public JsonResult GetAllJobSector() { try { var draw = HttpContext.Request.Query["draw"].FirstOrDefault(); // Skiping number of Rows count var start = Request.Query["start"].FirstOrDefault(); // Paging Length 10,20 var length = Request.Query["length"].FirstOrDefault(); // Sort Column Name var sortColumn = Request .Query["columns[" + Request.Query["order[0][column]"].FirstOrDefault() + "][name]"] .FirstOrDefault(); // Sort Column Direction ( asc ,desc) var sortColumnDirection = Request.Query["order[0][dir]"].FirstOrDefault(); // Search Value from (Search box) var searchValue = Request.Query["search[value]"].FirstOrDefault(); //Paging Size (10,20,50,100) var pageSize = length != null?Convert.ToInt32(length) : 0; var skip = start != null?Convert.ToInt32(start) : 0; var recordsTotal = 0; var listOfJobSector = new List <JobSector>(); listOfJobSector = _lookUpService.GetAllJobSector().Result; // Getting all Customer data z var alljobSector = listOfJobSector; //Search if (!string.IsNullOrEmpty(searchValue)) { alljobSector = alljobSector.Where(m => m.JobSectorDesc == searchValue || m.JobSectorCode == searchValue) as List <JobSector>; } //total number of rows count recordsTotal = alljobSector.Count(); //Paging var dataList = alljobSector.Skip(skip).Take(pageSize).ToList(); //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = alljobSector })); } catch (Exception) { throw; } }