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; }