public async Task <JsonResult> GetAllAddress()
{
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 listOfAddress = new List <Address>();
listOfAddress = await _lookUpService.GetAllAddress();
// Getting all Customer data z
var allInstitution = listOfAddress;
//Search
if (!string.IsNullOrEmpty(searchValue))
{
allInstitution = allInstitution.Where(m =>
m.City.CityName == searchValue ||
m.Province.ProvinceName == searchValue)
as List <Address>;
}
//total number of rows count
recordsTotal = allInstitution.Count();
//Paging
var dataList = allInstitution.Skip(skip).Take(pageSize).ToList();
//Returning Json Data
return(Json(new
{ draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = allInstitution }));
}
catch (Exception)
{
throw;
}
}
