public List <Question> getQuestionsByJobID(int?JobID)
{
using (DB_9E5950_aes01Entities db = new DB_9E5950_aes01Entities())
{
IQueryable <Question> query = from questions in db.QuestionLists
where questions.JobApplications.Any(c => c.Id == JobID)
select new Question()
{
QuestionID = questions.Id,
QuestionTitle = questions.Title,
FullQuestion = questions.Question
};
return(query.ToList());
}
}
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_9E5950_aes01Entities db = new DB_9E5950_aes01Entities();
JobApplication job = db.JobApplications.Find(value);
db.JobApplications.Remove(job);
db.SaveChanges();
}
catch
{
DB_9E5950_aes01Entities 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_9E5950_aes01Entities db = new DB_9E5950_aes01Entities();
AvailableJob job = db.AvailableJobs.Find(value);
db.AvailableJobs.Remove(job);
db.SaveChanges();
}
catch
{
DB_9E5950_aes01Entities db = new DB_9E5950_aes01Entities();
AvailableJob job = db.AvailableJobs.Find(value);
job.IsActive = FALSE;
db.SaveChanges();
}
}
else
{
throw new Exception("Jobs not Removed!!!");
}
}