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)); }