public PageListResultBO <RecruitmentSkillDTO> GetDataByPage(RecruitmentSkillSearchDTO searchParams, int pageIndex = 1, int pageSize = 20)
{
var queryResult = (from skill in recruitmentSkillRepository.GetAllAsQueryable()
select new RecruitmentSkillDTO()
{
Id = skill.Id,
Title = skill.Title,
Skills = skill.Skills
});
if (searchParams != null)
{
if (!string.IsNullOrEmpty(searchParams.QueryTitle))
{
searchParams.QueryTitle = searchParams.QueryTitle.Trim().ToLower();
queryResult = queryResult.Where(x => x.Title.Trim().ToLower().Contains(searchParams.QueryTitle));
}
if (!string.IsNullOrEmpty(searchParams.sortQuery))
{
queryResult = queryResult.OrderBy(searchParams.sortQuery);
}
else
{
queryResult = queryResult.OrderByDescending(x => x.Id);
}
}
var result = new PageListResultBO <RecruitmentSkillDTO>();
if (pageSize == -1)
{
var pagedList = queryResult.ToList();
result.Count = pagedList.Count;
result.TotalPage = 1;
result.ListItem = pagedList;
}
else
{
var dataPageList = queryResult.ToPagedList(pageIndex, pageSize);
result.Count = dataPageList.TotalItemCount;
result.TotalPage = dataPageList.PageCount;
result.ListItem = dataPageList.ToList();
}
if (result.ListItem.Any())
{
var groupSkillsDetail = recruitmentSkillDetailRepository.GetAll();
result.ListItem.ForEach(x =>
{
x.NumberOfSkills = x.Skills.Split(',').Count();
var skillIds = x.Skills.ToListNumber <long>();
x.GroupSkillDetails = groupSkillsDetail.Where(y => skillIds.Contains(y.Id))
.Select(y => mapper.Map <RecruitmentSkillDetail, RecruitmentSkillDetailDTO>(y)).ToList();
});
}
return(result);
}
// GET: RecruitmentSkillArea/RecruitmentSkill
public ActionResult Index()
{
var searchModel = new RecruitmentSkillSearchDTO();
SessionManager.SetValue("RecruitmentSkillSearch", new RecruitmentSkillSearchDTO());
RecruitmentSkillIndexViewModel viewModel = new RecruitmentSkillIndexViewModel()
{
GroupData = recruitmentSkillService.GetDataByPage(searchModel),
};
return(View(viewModel));
}
public JsonResult SearchData(FormCollection form)
{
var searchModel = SessionManager.GetValue("RecruitmentSkillSearch") as RecruitmentSkillSearchDTO;
if (searchModel == null)
{
searchModel = new RecruitmentSkillSearchDTO();
searchModel.pageSize = 20;
}
searchModel.QueryTitle = form["QUERY_TITLE"];
SessionManager.SetValue("RecruitmentSkillSearch", searchModel);
var data = recruitmentSkillService.GetDataByPage(searchModel, 1);
return(Json(data));
}
public JsonResult GetData(int indexPage, string sortQuery, int pageSize)
{
var searchModel = SessionManager.GetValue("RecruitmentSkillSearch") as RecruitmentSkillSearchDTO;
if (searchModel == null)
{
searchModel = new RecruitmentSkillSearchDTO();
}
if (!string.IsNullOrEmpty(sortQuery))
{
searchModel.sortQuery = sortQuery;
}
if (pageSize > 0)
{
searchModel.pageSize = pageSize;
}
SessionManager.SetValue("RecruitmentSkillSearch", searchModel);
var data = recruitmentSkillService.GetDataByPage(searchModel, indexPage, pageSize);
return(Json(data));
}
