public int CountVacancyByApprover(int Id) { Expression <Func <CandidateInfo, object> >[] Includes = new Expression <Func <CandidateInfo, object> > [1]; Includes[0] = pack => pack.Vacancy; return(_candidate.GetAllQ(Includes) .Where(x => (x.ApproveOneStatus == ApproverStatus.Shortlist && x.Vacancy.ApproverOneId == Id) || (x.ApproveTwoStatus == ApproverStatus.Shortlist && x.Vacancy.ApproverTwoId == Id)) .Count()); }
public IActionResult Recovery(IDataTablesRequest request) { var candidateIds = Service.GetAllQ().Select(x => x.CandidateId).ToList(); var candidate = _candidate.GetAllQ().Where(x => x.AccountId.HasValue && candidateIds.Contains(x.Id)).Select(x => x.AccountId).ToList(); var userManager = _userManager.GetUsersInRoleAsync("Contractor").Result; var data = _userProfile.GetAll().Where(x => userManager.Contains(x.ApplicationUser) && !candidate.Contains(x.Id)).OrderBy(x => x.UserName).AsQueryable(); var response = Service.GetDataTablesResponseByQuery <UserProfileDto>(request, Mapper, data); return(new DataTablesJsonResult(response, true)); }