public void Create_Job_Posting(NewPosting posting) { using (db) { AvailableJob job = new AvailableJob { LocationID = posting.Location_ID, JobID = posting.Job_ID, CloseDate = posting.Close_Date, IsActive = TRUE }; db.AvailableJobs.Add(job); db.SaveChanges(); } }
public void removeQuestionFromJob(QuestionIDJobID questionIDjobID) { using (DB_9E5950_aes01Entities db = new DB_9E5950_aes01Entities()) { var questionEntity = (from p in db.QuestionLists where p.Id == questionIDjobID.QuestionID select p).FirstOrDefault(); var query = from ja in db.JobApplications where ja.Id == questionIDjobID.Job_ID select ja; foreach (JobApplication japp in query) { if (japp.Id == questionIDjobID.Job_ID) { japp.QuestionLists.Remove(questionEntity); } } db.SaveChanges(); } }
public void Delete_Job_Template(int?value) { if (value != null) { try { db = new DB_9E5950_aes01Entities(); JobApplication job = db.JobApplications.Find(value); db.JobApplications.Remove(job); db.SaveChanges(); } catch { db = new DB_9E5950_aes01Entities(); JobApplication job = db.JobApplications.Find(value); job.IsActive = FALSE; db.SaveChanges(); } } else { throw new Exception("Jobs not Removed!!!"); } }
public void Delete_Job_Posting(int?value) { if (value != null) { try { db = new DB_9E5950_aes01Entities(); AvailableJob job = db.AvailableJobs.Find(value); db.AvailableJobs.Remove(job); db.SaveChanges(); } catch { db = new DB_9E5950_aes01Entities(); AvailableJob job = db.AvailableJobs.Find(value); job.IsActive = FALSE; db.SaveChanges(); } } else { throw new Exception("Jobs not Removed!!!"); } }