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