public ActionResult LoadEmployeeData()
{
try
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDirection = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault();
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
using (var _emplpoyeeEntity = new EmployeeTrackerEntities())
{
_emplpoyeeEntity.Database.Log = logLinqResult;
var employeeData = (from e in _emplpoyeeEntity.employees
select new
{
employee_id = e.employee_id,
first_name = e.first_name,
last_name = e.last_name,
sex = e.sex,
salary = Math.Round(e.salary, 2),
start_date = e.start_date,
age = e.age
});
if (!string.IsNullOrEmpty(sortColumn) && !string.IsNullOrEmpty(sortColumnDirection))
{
employeeData = employeeData.OrderBy(sortColumn + " " + sortColumnDirection);
}
if (!string.IsNullOrEmpty(searchValue))
{
employeeData = employeeData.Where(e => e.first_name.Contains(searchValue) || e.last_name.Contains(searchValue));
}
recordsTotal = employeeData.Count();
var finalData = employeeData.Skip(skip).Take(pageSize).ToList();
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = finalData }));
}
}
catch (Exception ex)
{
throw;
}
}
public ActionResult WithPagedList(int?page)
{
int pageNumber = page ?? 1;
int pageSize = 10;
using (var _emplpoyeeEntity = new EmployeeTrackerEntities())
{
_emplpoyeeEntity.Database.Log = logLinqResult;
List <employee> employeeData = (from e in _emplpoyeeEntity.employees
select e).OrderBy("employee_id").ToList();
//.Skip((pageNumber - 1) * pageSize).Take(pageSize)
return(View(employeeData.ToPagedList(pageNumber, pageSize)));
}
}
