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