public JobPosting getOneJobPosting(long jobPostingID) { using (Entities db = new Entities()) { JobPosting eJP = (from d in db.JobPostings where d.JobPostingID == jobPostingID select new JobPosting { PartnerID = d.PartnerID, Active_YN = d.Active_YN, ContactID = d.ContactID, CreatedDT = d.CreatedDT, BusinessCategory = d.BusinessCategory, Description_JobPosting = d.Description_JobPosting, JobPostingID = d.JobPostingID, JobTitle = d.JobTitle, LocationID = d.LocationID, PositionID = d.PositionID, EstHoursPerWeek = d.EstHoursPerWeek, PartnerJobLevel = d.PartnerJobLevel, PartnerRequisitionNumber = d.PartnerRequisitionNumber, PostingEndDate = d.PostingEndDate, PostingStartDate = d.PostingStartDate, Requirements = d.Requirements, WorkSchedule = d.WorkSchedule }).SingleOrDefault(); return eJP; } }
public JobDisplayModel getJobDisplayByID(long jobPostingID) { using (Entities db = new Entities()) { JobDisplayModel jdm = (from d in db.JobPostings where d.JobPostingID == jobPostingID select new JobDisplayModel { Active_YN = d.Active_YN, CreatedDT = d.CreatedDT, BusinessCategory = d.BusinessCategory, Description_JobPosting = d.Description_JobPosting, JobPostingID = d.JobPostingID, JobTitle = d.JobTitle, EstHoursPerWeek = d.EstHoursPerWeek, PostingEndDate = d.PostingEndDate, PostingStartDate = d.PostingStartDate, Requirements = d.Requirements, WorkSchedule = d.WorkSchedule }).SingleOrDefault(); return jdm; } }
public Repository() { db = new Entities(); }