public ViewResult GetJobApplicants(int id)
{
JobApplicantsViewModel javm;
List <JobApplicantsViewModel> javmList = new List <JobApplicantsViewModel>();
var applicants = (from j in db.Jobs
join uj in db.SeekersToJobs on j.job_id equals uj.job_id
join u in db.Users on uj.UserId equals u.Id
where j.job_id == id
select new
{
job_id = j.job_id,
user_id = u.Id,
user_name = u.UserName
}).ToList();
foreach (var item in applicants)
{
javm = new JobApplicantsViewModel();
javm.Job_Id = item.job_id;
javm.User_Id = item.user_id;
javm.User_Name = item.user_name;
javmList.Add(javm);
}
return(View(javmList));
}
public async Task <IActionResult> ApplicantsByJob(int id)
{
var user = await _userManager.GetUserAsync(HttpContext.User);
var job = _context.Jobs
.Include(x => x.Applicants)
.ThenInclude(x => x.User)
.SingleOrDefault(x => x.Id == id);
// _logger.LogInformation(job.Title);
var model = new JobApplicantsViewModel
{
Job = job,
Applicants = job.Applicants
};
return(View(model));
}
