private void Initialize(JobOpeningInterviewQuestionDAO JOIQ, int id, int joiqID, int jobOpeningID, int saQuestionID )
{
JOIQ.ID = id;
JOIQ.JobOpeningInterviewQuestionID = joiqID;
JOIQ.JobOpeningID = jobOpeningID;
JOIQ.SAQuestionID = saQuestionID;
}
public void Test_CreateJobOpeningInterviewQuestion()
{
JobOpeningInterviewQuestionDAO JOIQ3 = new JobOpeningInterviewQuestionDAO() { ID = 3, JobOpeningInterviewQuestionID = 3, JobOpeningID = 3, SAQuestionID = 3 };
Assert.IsTrue(jobOpenQuestionService.CreateJobOpeningInterviewQuestion(JOIQ3));
Assert.AreEqual(jobOpenQuestionService.GetJobOpeningInterviewQuestionByID(3).JobOpeningInterviewQuestionID, 3);
}
public void Test_UpdateJobOpeningInterviewQuestion()
{
JobOpeningInterviewQuestionDAO JOIQ3 = new JobOpeningInterviewQuestionDAO() { ID = 3, JobOpeningInterviewQuestionID = 2, JobOpeningID = 3, SAQuestionID = 3 };
Assert.IsTrue(jobOpenQuestionService.UpdateJobOpeningInterviewQuestion(JOIQ3));
Assert.AreEqual(jobOpenQuestionService.GetJobOpeningInterviewQuestions().Count, 3);
//Assert.AreEqual(jobOpenQuestionService.GetJobOpeningInterviewQuestionByID(2).ID, 3);
}
internal void SetUp()
{
JobOpeningInterviewQuestionDAO JOIQ0 = new JobOpeningInterviewQuestionDAO() { ID = 0, JobOpeningInterviewQuestionID = 0, JobOpeningID = 0, SAQuestionID = 0 };
JobOpeningInterviewQuestionDAO JOIQ1 = new JobOpeningInterviewQuestionDAO() { ID = 1, JobOpeningInterviewQuestionID = 1, JobOpeningID = 1, SAQuestionID = 1 };
JobOpeningInterviewQuestionDAO JOIQ2 = new JobOpeningInterviewQuestionDAO() { ID = 2, JobOpeningInterviewQuestionID = 2, JobOpeningID = 2, SAQuestionID = 2 };
JOIQs.Add(JOIQ0);
JOIQs.Add(JOIQ1);
JOIQs.Add(JOIQ2);
}
public bool UpdateJobOpeningInterviewQuestion(JobOpeningInterviewQuestionDAO newJobOpeningQuestionData)
{
foreach(var joiq in JOIQs)
if(joiq.JobOpeningInterviewQuestionID == newJobOpeningQuestionData.JobOpeningInterviewQuestionID)
{
JOIQs.Remove(joiq);
JOIQs.Add(newJobOpeningQuestionData);
return true;
}
return false;
}
public bool CreateJobOpeningInterviewQuestion(JobOpeningInterviewQuestionDAO e)
{
JOIQs.Add(e);
return true;
}
public bool CreateJobOpeningInterviewQuestion(JobOpeningInterviewQuestionDAO s)
{
JobOpeningInterviewQuestion jobOpeningInterviewQuestion = new JobOpeningInterviewQuestion
{
JobOpeningInterviewQuestion_ID = s.JobOpeningInterviewQuestionID,
JobOpening_ID = s.JobOpeningID,
SAQuestion_ID = s.SAQuestionID
};
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
db.JobOpeningInterviewQuestions.InsertOnSubmit(jobOpeningInterviewQuestion);
try
{
db.SubmitChanges();
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
return true;
}
public bool UpdateJobOpeningInterviewQuestion(JobOpeningInterviewQuestionDAO newJobOpeningInterviewQuestion)
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
JobOpeningInterviewQuestion jobOpeningInterviewQuestion = db.JobOpeningInterviewQuestions.Single(s => s.JobOpeningInterviewQuestion_ID == newJobOpeningInterviewQuestion.JobOpeningInterviewQuestionID);
jobOpeningInterviewQuestion.JobOpening_ID = newJobOpeningInterviewQuestion.JobOpeningID;
jobOpeningInterviewQuestion.SAQuestion_ID = newJobOpeningInterviewQuestion.SAQuestionID;
try
{
db.SubmitChanges();
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
return true;
}
public IList<JobOpeningInterviewQuestionDAO> GetJobOpeningInterviewQuestions()
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
IList<JobOpeningInterviewQuestion> jobOpeningInterviewQuestions = db.JobOpeningInterviewQuestions.ToList();
List<JobOpeningInterviewQuestionDAO> result = new List<JobOpeningInterviewQuestionDAO>();
foreach (var jobOpeningInterviewQuestion in jobOpeningInterviewQuestions)
{
JobOpeningInterviewQuestionDAO temp = new JobOpeningInterviewQuestionDAO
{
ID = jobOpeningInterviewQuestion.JobOpeningInterviewQuestion_ID,
JobOpeningInterviewQuestionID = jobOpeningInterviewQuestion.JobOpeningInterviewQuestion_ID,
JobOpeningID = jobOpeningInterviewQuestion.JobOpening_ID,
SAQuestionID = jobOpeningInterviewQuestion.SAQuestion_ID
};
result.Add(temp);
}
return (result != null ? result : null);
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
public JobOpeningInterviewQuestionDAO GetJobOpeningInterviewQuestionByID(int id)
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
JobOpeningInterviewQuestion jobOpeningInterviewQuestion = (from jbopinqu in db.JobOpeningInterviewQuestions where jbopinqu.JobOpeningInterviewQuestion_ID == id select jbopinqu).FirstOrDefault();
JobOpeningInterviewQuestionDAO result = new JobOpeningInterviewQuestionDAO
{
ID = jobOpeningInterviewQuestion.JobOpeningInterviewQuestion_ID,
JobOpeningInterviewQuestionID = jobOpeningInterviewQuestion.JobOpeningInterviewQuestion_ID,
JobOpeningID = jobOpeningInterviewQuestion.JobOpening_ID,
SAQuestionID = jobOpeningInterviewQuestion.SAQuestion_ID
};
return (result != null ? result : null);
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
