private void GetPinnedUsers(LinqModelHelperDataContext dataContext)
{
var dbusers = from u in dataContext.Users
join ru in dataContext.RecruiterPinnedUsers on u.UserID equals ru.UserID
where ru.JobID == this.Job.JobID
select u;
foreach (var u in dbusers)
{
PinnedUsers.Add(u);
}
}
private void GetAppliedUsers(LinqModelHelperDataContext dataContext)
{
var dbusers = from u in dataContext.Users
join aj in dataContext.UserAppliedJobs on u.UserID equals aj.UserID
where aj.JobID == this.Job.JobID
select u;
foreach (var u in dbusers)
{
AppliedUsers.Add(u);
}
}
private void GetFollowingRecruiters(LinqModelHelperDataContext dataContext)
{
var dbusers = from r in dataContext.FollowRecruiters
join u in dataContext.Users on r.RecruiterID equals u.UserID
where r.UserID == this.User.UserID
select u;
foreach (var u in dbusers)
{
this.FollowingRecruiters.Add(u);
}
}
private void GetPinnedJobs(LinqModelHelperDataContext dataContext)
{
var dbjobs = from pj in dataContext.UserPinnedJobs
join j in dataContext.Jobs on pj.JobID equals j.JobID
where pj.UserID == this.User.UserID
select j;
foreach (var j in dbjobs)
{
JobUserSkillModel jusm = new JobUserSkillModel(this.User, j);
PinnedJobs.Add(jusm);
}
}
private void GetAppliedJobs(LinqModelHelperDataContext dataContext)
{
var dbjobs = from j in dataContext.Jobs
join aj in dataContext.UserAppliedJobs on j.JobID equals aj.JobID
//join u in dataContext.Users on aj.UserID equals u.UserID
where aj.UserID == this.User.UserID
select j;
foreach (var j in dbjobs)
{
JobUserSkillModel jusm = new JobUserSkillModel(this.User, j);
AppliedJobs.Add(jusm);
}
}
