public ActionResult GetList(JQueryDataTableParamModel param)
{
GenderService GenderService = new GenderService();
IEnumerable<GenderDto> allGenders = GenderService.GetAllExposeDto();
IEnumerable<GenderDto> filteredGenders;
if (!string.IsNullOrEmpty(param.sSearch))
{
//Used if particulare columns are filtered
var nameFilter = Convert.ToString(Request["sSearch_1"]);
//Optionally check whether the columns are searchable at all
var isNameSearchable = Convert.ToBoolean(Request["bSearchable_1"]);
filteredGenders = allGenders
.Where(c => isNameSearchable && c.Name != null && c.Name.ToString().ToLower().Contains(param.sSearch.ToLower()));
}
else
{
filteredGenders = allGenders;
}
var isNameSortable = Convert.ToBoolean(Request["bSortable_1"]);
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func<GenderDto, string> orderingFunction = (c => sortColumnIndex == 1 && isNameSortable ? c.Name.ToString() :
"");
var sortDirection = Request["sSortDir_0"]; // asc or desc
if (sortDirection == "asc")
filteredGenders = filteredGenders.OrderBy(orderingFunction);
else
filteredGenders = filteredGenders.OrderByDescending(orderingFunction);
IEnumerable<GenderDto> displayedGenders;
if (param.iDisplayLength != -1)
displayedGenders = filteredGenders.Skip(param.iDisplayStart).Take(param.iDisplayLength);
else
displayedGenders = filteredGenders;
var result = from c in displayedGenders
select new[]
{
c.Id.ToString(),
c.Name
};
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = allGenders.Count(),
iTotalDisplayRecords = filteredGenders.Count(),
aaData = result
},
JsonRequestBehavior.AllowGet);
}
public ActionResult Index()
{
PersonModel model = new PersonModel();
GenderService genderService = new GenderService();
DepartmentService departmentService = new DepartmentService();
ChucDanhService chucDanhService = new ChucDanhService();
PersonService personService = new PersonService();
model.Departments = departmentService.GetAll().ToList();
model.Departments.Insert(0, new Department() { Id = -1, Name = "Tất cả"});
model.ChucDanhs = chucDanhService.GetAll().ToList();
model.ReportDate = System.DateTime.Now.ToShortDateString();
model.ListOfFilterNames = new List<FilterName>();
model.ListOfFilterNames.Add(new FilterName() { Id = 1, Name = "Đang công tác" });
model.ListOfFilterNames.Add(new FilterName() { Id = 2, Name = "Thôi việc" });
model.ListOfFilterNames.Add(new FilterName() { Id = 3, Name = "Tất cả" });
model.Genders = genderService.GetAll().ToList();
return View(model);
}