public void Test_CreateInterview()
{
InterviewDAO interview3 = new InterviewDAO() { ID = 3, InterviewID = 3, ApplicantID = 3, SAQuestionID = 3, SAResponseID = 3 };
Assert.IsTrue(interviewService.CreateInterview(interview3));
Assert.AreEqual(interviewService.GetInterviews().Count, 4);
}
private void Initialize( InterviewDAO interview, int id, int interviewID, int applicantID, int saQuestionID, int saResponseID )
{
interview.ID = id;
interview.InterviewID = interviewID;
interview.ApplicantID = applicantID;
interview.SAQuestionID = saQuestionID;
interview.SAResponseID = saResponseID;
}
public void Test_UpdateInterview()
{
InterviewDAO interview3 = new InterviewDAO() { ID = 3, InterviewID = 0, ApplicantID = 3, SAQuestionID = 3, SAResponseID = 3 };
Assert.IsTrue(interviewService.UpdateInterview(interview3));
Assert.AreEqual(interviewService.GetInterviewByID(0).ApplicantID, 3);
Assert.AreEqual(interviewService.GetInterviewByID(0).InterviewID, 0);
Assert.AreEqual(interviewService.GetInterviews().Count, 3);
}
internal void SetUp()
{
InterviewDAO interview0 = new InterviewDAO() { ID = 0, InterviewID = 0, ApplicantID = 0, SAQuestionID = 0, SAResponseID = 0 };
InterviewDAO interview1 = new InterviewDAO() { ID = 1, InterviewID = 1, ApplicantID = 1, SAQuestionID = 1, SAResponseID = 1 };
InterviewDAO interview2 = new InterviewDAO() { ID = 2, InterviewID = 2, ApplicantID = 2, SAQuestionID = 2, SAResponseID = 2 };
Interviews.Add(interview0);
Interviews.Add(interview1);
Interviews.Add(interview2);
}
public bool UpdateInterview(InterviewDAO newInterview)
{
foreach(var interview in Interviews)
if(interview.InterviewID == newInterview.InterviewID)
{
Interviews.Remove(interview);
Interviews.Add(newInterview);
return true;
}
return false;
}
public bool CreateInterview(InterviewDAO e)
{
Interviews.Add(e);
return true;
}
public bool UpdateInterview(InterviewDAO newInterview)
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
Interview interview = db.Interviews.Single(s => s.Interview_ID == newInterview.InterviewID);
interview.Interview_ID = newInterview.InterviewID;
interview.Applicant_ID = newInterview.ApplicantID;
interview.SAQuestion_ID = newInterview.SAQuestionID;
interview.SAResponse_ID = newInterview.SAResponseID;
//interview.UserID = newInterview.UserID;
try
{
db.SubmitChanges();
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
return true;
}
public bool CreateInterview(InterviewDAO s)
{
Interview interview = new Interview
{
Interview_ID = s.InterviewID,
Applicant_ID = s.ApplicantID,
SAQuestion_ID = s.SAQuestionID,
SAResponse_ID = s.SAResponseID
//UserID = s.UserID
};
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
db.Interviews.InsertOnSubmit(interview);
try
{
db.SubmitChanges();
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
return true;
}
public IList<InterviewDAO> GetInterviews()
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
IList<Interview> interviews = db.Interviews.ToList();
List<InterviewDAO> result = new List<InterviewDAO>();
foreach (var interview in interviews)
{
InterviewDAO temp = new InterviewDAO
{
ID = interview.Interview_ID,
InterviewID = interview.Interview_ID,
ApplicantID = interview.Applicant_ID,
SAQuestionID = interview.SAQuestion_ID,
SAResponseID = interview.SAResponse_ID
//UserID = interview.UserID
};
result.Add(temp);
}
return (result != null ? result : null);
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
public InterviewDAO GetInterviewByID(int id)
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
Interview interview = (from intvw in db.Interviews where intvw.Interview_ID == id select intvw).FirstOrDefault();
InterviewDAO result = new InterviewDAO
{
ID = interview.Interview_ID,
InterviewID = interview.Interview_ID,
ApplicantID = interview.Applicant_ID,
SAQuestionID = interview.SAQuestion_ID,
SAResponseID = interview.SAResponse_ID
//UserID = interview.UserID
};
return (result != null ? result : null);
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
