public ActionResult shortListedCandidates(int?page, int?job_id, string searchkey = "")
{
int pageIndex;
int emp_id = Convert.ToInt32(Session["emp_id"].ToString());
pageIndex = page.HasValue ? Convert.ToInt16(page) : 1;
int pageSize = 10;
int userid = Convert.ToInt32(Session["emp_id"].ToString());
List <ShortListViewModel> show = new List <ShortListViewModel>();
if (job_id.HasValue)
{
int job_id_ = Convert.ToInt16(job_id);
var model = (from data in db.applications
join js in db.jobseeker_info on data.jobseeker_id equals js.js_id
join jobs in db.jobs on data.job_id equals jobs.job_id
where jobs.employer == emp_id
where jobs.status == 1
where jobs.job_id == job_id_
where data.accept_status == 1
where data.status == 1
where js.full_name.Contains(searchkey) || jobs.title.Contains(searchkey)
select new
{
app_id = data.app_id,
job = jobs.title,
jobseeker = js.full_name,
created_at = data.created_at,
status = data.status,
job_id = jobs.job_id,
jobseeker_id = js.js_id,
profile = js.profile,
age = js.dateofbirth,
location = js.current_address
}
);
foreach (var item in model)
{
ShortListViewModel app = new ShortListViewModel();
app.app_id = item.app_id;
app.job = item.job;
app.jobseeker = item.jobseeker;
app.jobseeker_id = item.jobseeker_id;
app.status = item.status;
app.job_id = item.job_id;
app.created_at = item.created_at;
app.profile = item.profile;
var temp = item.age;
if (temp != null)
{
DateTime now = DateTime.Now;
TimeSpan t = (now - Convert.ToDateTime(temp));
int years = Convert.ToInt16(t.TotalDays) / 365;
app.age = years;
}
show.Add(app);
}
}
else
{
var model_job_id = (from data in db.applications
join js in db.jobseeker_info on data.jobseeker_id equals js.js_id
join jobs in db.jobs on data.job_id equals jobs.job_id
where jobs.employer == emp_id
where jobs.status == 1
where data.accept_status == 1
where data.status == 1
where js.full_name.Contains(searchkey) || jobs.title.Contains(searchkey)
select new
{
app_id = data.app_id,
job = jobs.title,
jobseeker = js.full_name,
created_at = data.created_at,
status = data.status,
job_id = jobs.job_id,
jobseeker_id = js.js_id,
profile = js.profile,
age = js.dateofbirth,
location = js.current_address
}
);
foreach (var item in model_job_id)
{
ShortListViewModel app = new ShortListViewModel();
app.app_id = item.app_id;
app.job = item.job;
app.jobseeker = item.jobseeker;
app.jobseeker_id = item.jobseeker_id;
app.status = item.status;
app.job_id = item.job_id;
app.created_at = item.created_at;
app.profile = item.profile;
var temp = item.age;
if (temp != null)
{
DateTime now = DateTime.Now;
TimeSpan t = (now - Convert.ToDateTime(temp));
int years = Convert.ToInt16(t.TotalDays) / 365;
app.age = years;
}
show.Add(app);
}
}
return(View(show.ToPagedList(pageIndex, pageSize)));
}
public AccountsViewModel(ShortListViewModel shortListViewModel, DetailListViewModel detailListViewModel, TransfersViewModel transfersViewModel)
{
ShortListVm = shortListViewModel;
DetailListVm = detailListViewModel;
TransfersVm = transfersViewModel;
}
