public JsonResult GetAllFinancialyear()
{
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 listOfFinancialyear = new List <Financialyear>();
listOfFinancialyear = _lookUpService.GetAllFinancialyear().Result;
// Getting all Customer data z
var allfinancialyear = listOfFinancialyear;
//Search
if (!string.IsNullOrEmpty(searchValue))
{
allfinancialyear = allfinancialyear.Where(m =>
m.FinancialyearDesc == searchValue ||
m.ActiveForWsp == searchValue)
as List <Financialyear>;
}
//total number of rows count
recordsTotal = allfinancialyear.Count();
//Paging
var dataList = allfinancialyear.Skip(skip).Take(pageSize).ToList();
//Returning Json Data
return(Json(new
{ draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = allfinancialyear }));
}
catch (Exception)
{
throw;
}
}
