public List <JobPost> GetJobPosts() { using (var dbContext = new InternshipDbContext()) { return(dbContext.JobPosts.ToList()); } }
public List <PostedBy> GetJobPostByPersons() { using (var dbContext = new InternshipDbContext()) { return(dbContext.PersonPostedJobs.ToList()); } }
public List <Company> GetCompanies() { using (var dbContext = new InternshipDbContext()) { return(dbContext.Companies.ToList()); } }
public List <JobLocation> GetJobLocations() { using (var dbContext = new InternshipDbContext()) { return(dbContext.JobLocations.ToList()); } }
public void UploadResume(CareerResume careerResume) { //TODO using (var dbContext = new InternshipDbContext()) { dbContext.CareerResumes.Add(careerResume); dbContext.SaveChanges(); } }
public void SaveJobPost(JobPost jobPost) { using (var dbContext = new InternshipDbContext()) { if (jobPost.JobPostID == 0) { dbContext.JobPosts.Add(jobPost); } else { JobPost dbEntry = dbContext.JobPosts.Find(jobPost.JobPostID); if (dbEntry != null) { JobType jbType = new JobType(); jbType.JobTypeID = jobPost.JobType.JobTypeID; dbEntry.JobType = jbType; Company comp = new Company(); comp.CompanyID = jobPost.Company.CompanyID; dbEntry.Company = comp; JobLocation jbLocation = new JobLocation(); jbLocation.JobLocationID = jobPost.JobLocation.JobLocationID; dbEntry.JobLocation = jbLocation; JobPostSkillSet jbPostSkillset = new JobPostSkillSet(); jbPostSkillset.JobPostSkillSetID = jobPost.JobPostSkillSet.JobPostSkillSetID; dbEntry.JobPostSkillSet = jbPostSkillset; dbEntry.JobDescription = jobPost.JobDescription; dbEntry.IsActive = jobPost.IsActive; dbEntry.IsCompanyNameHidden = jobPost.IsCompanyNameHidden; dbEntry.PostedByID = 1; dbEntry.CreatedDate = DateTime.Now; } } dbContext.SaveChanges(); } }