private void Initialize( AssessmentDAO assessment, int id, int assessmentID, int applicantID, int questionBankID )
{
assessment.ID = id;
assessment.AssessmentID = assessmentID;
assessment.ApplicantID = applicantID;
assessment.QuestionBankID = questionBankID;
}
public void Test_UpdateAssessment()
{
AssessmentDAO assessment4 = new AssessmentDAO() { ID = 5, AssessmentID = 3, ApplicantID = 5, QuestionBankID = 5 };
assessmentService.UpdateAssessment(assessment4);
Assert.AreEqual(assessmentService.GetAssessmentByID(3).ApplicantID, 5);
}
public void Test_CreateAssessment()
{
AssessmentDAO assessment4 = new AssessmentDAO() { ID = 4, AssessmentID = 4, ApplicantID = 4, QuestionBankID = 4 };
Assert.AreEqual(assessmentService.CreateAssessment(assessment4), true);
Assert.AreEqual(assessment4.AssessmentID, 4);
Assert.IsNotNull(assessmentService.GetAssessmentByID(4));
}
internal void SetUp()
{
AssessmentDAO assessment1 = new AssessmentDAO() { ID = 1, AssessmentID = 1, ApplicantID = 1, QuestionBankID = 1 };
AssessmentDAO assessment2 = new AssessmentDAO() { ID = 2, AssessmentID = 2, ApplicantID = 2, QuestionBankID = 2 };
AssessmentDAO assessment3 = new AssessmentDAO() { ID = 3, AssessmentID = 3, ApplicantID = 3, QuestionBankID = 3 };
Assessments.Add(assessment1);
Assessments.Add(assessment2);
Assessments.Add(assessment3);
}
public bool UpdateAssessment(AssessmentDAO newAssessment)
{
foreach(var assess in Assessments)
if(assess.AssessmentID == newAssessment.AssessmentID)
{
Assessments.Remove(assess);
Assessments.Add(newAssessment);
return true;
}
return false;
}
public bool CreateAssessment(AssessmentDAO e)
{
Assessments.Add(e);
return true;
}
public bool UpdateAssessment(AssessmentDAO newAssessment)
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
Assessment assessment = db.Assessments.Single(s => s.Assessment_ID == newAssessment.AssessmentID);
assessment.Assessment_ID = newAssessment.AssessmentID;
assessment.Applicant_ID = newAssessment.ApplicantID;
assessment.QuestionBank_ID = newAssessment.QuestionBankID;
try
{
db.SubmitChanges();
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
return true;
}
public IList<AssessmentDAO> GetAssessments()
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
IList<Assessment> assessments = db.Assessments.ToList();
List<AssessmentDAO> result = new List<AssessmentDAO>();
foreach (var assessment in assessments)
{
AssessmentDAO temp = new AssessmentDAO
{
ID = assessment.Assessment_ID,
AssessmentID = assessment.Assessment_ID,
ApplicantID = assessment.Applicant_ID,
QuestionBankID = assessment.QuestionBank_ID
};
result.Add(temp);
}
return (result != null ? result : null);
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
public AssessmentDAO GetAssessmentByID(int id)
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
Assessment assessment = (from asmt in db.Assessments where asmt.Assessment_ID == id select asmt).FirstOrDefault();
AssessmentDAO result = new AssessmentDAO
{
ID = assessment.Assessment_ID,
AssessmentID = assessment.Assessment_ID,
ApplicantID = assessment.Applicant_ID,
QuestionBankID = assessment.QuestionBank_ID
};
return (result != null ? result : null);
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
public bool CreateAssessment(AssessmentDAO s)
{
Assessment assessment = new Assessment
{
Assessment_ID = s.AssessmentID,
Applicant_ID = s.ApplicantID,
QuestionBank_ID = s.QuestionBankID
};
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
db.Assessments.InsertOnSubmit(assessment);
try
{
db.SubmitChanges();
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
return true;
}
