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