public void Test_UpdateEducation()
{
EducationDAO education4 = new EducationDAO() { ID = 7, ApplicantID = 7, EducationID = 4, SchoolID = 7, DegreeAndMajor = "TEST" };
educationService.UpdateEducation(education4);
Assert.AreEqual(educationService.GetEducationByID(4).ID, 7);
Assert.AreEqual(educationService.GetEducationByID(4).DegreeAndMajor, "TEST");
}
private void initializeEducation(EducationDAO education, int id, int educationID, int applicantID, int schoolID, string degreeAndmajor)
{
education.ID = id;
education.EducationID = educationID;
education.ApplicantID = applicantID;
education.SchoolID = schoolID;
education.DegreeAndMajor = degreeAndmajor;
education.YearsAttendedFrom = null;
education.Graduated = null;
education.YearsAttendedTo = null;
}
public bool UpdateEducation(EducationDAO newEmp)
{
foreach (var e in Educations)
if (e.EducationID == newEmp.EducationID)
{
Educations.Remove(e);
Educations.Add(newEmp);
return true;
}
return false;
}
internal void SetUp()
{
EducationDAO education1 = new EducationDAO() { ID = 1, ApplicantID = 1, EducationID = 1, SchoolID = 1, DegreeAndMajor = "Math" };
EducationDAO education2 = new EducationDAO() { ID = 2, ApplicantID = 2, EducationID = 2, SchoolID = 1, DegreeAndMajor = "Math" };
EducationDAO education3 = new EducationDAO() { ID = 3, ApplicantID = 3, EducationID = 3, SchoolID = 1, DegreeAndMajor = "Math" };
EducationDAO education4 = new EducationDAO() { ID = 4, ApplicantID = 4, EducationID = 4, SchoolID = 1, DegreeAndMajor = "Math" };
Educations.Add(education1);
Educations.Add(education2);
Educations.Add(education3);
Educations.Add(education4);
}
public bool UpdateEducation(EducationDAO newEdu)
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
Education education = db.Educations.Single(edu => edu.Education_ID == newEdu.EducationID);
education.Applicant_ID = newEdu.ApplicantID;
education.School_ID = newEdu.SchoolID;
education.YearsAttendedFrom = newEdu.YearsAttendedFrom;
education.YearsAttendedTo = newEdu.YearsAttendedTo;
education.Graduated = newEdu.Graduated;
education.DegreeAndMajor = newEdu.DegreeAndMajor;
try
{
db.SubmitChanges();
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
return true;
}
public IList<EducationDAO> GetEducationsByName(string first, string last, string ssn)
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
Applicant applicant = (from a in db.Applicants where a.SSN == ssn && a.FirstName == first && a.LastName == last select a).FirstOrDefault();
IList<Education> educations = (from e in db.Educations where e.Applicant_ID == applicant.Applicant_ID select e).ToList();
List<EducationDAO> result = new List<EducationDAO>();
foreach (var e in educations)
{
EducationDAO edu = new EducationDAO
{
ID = e.Education_ID,
EducationID = e.Education_ID,
ApplicantID = e.Applicant_ID,
SchoolID = e.School_ID,
YearsAttendedFrom = e.YearsAttendedFrom,
YearsAttendedTo = e.YearsAttendedTo,
Graduated = e.Graduated,
DegreeAndMajor = e.DegreeAndMajor
};
result.Add(edu);
}
return result;
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
public IList<EducationDAO> GetEducations()
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
IList<Education> educations = db.Educations.ToList();
List<EducationDAO> result = new List<EducationDAO>();
foreach (var education in educations)
{
EducationDAO temp = new EducationDAO
{
EducationID = education.Education_ID,
ApplicantID = education.Applicant_ID,
SchoolID = education.School_ID,
YearsAttendedFrom = education.YearsAttendedFrom,
YearsAttendedTo = education.YearsAttendedTo,
Graduated = education.Graduated,
DegreeAndMajor = education.DegreeAndMajor
};
result.Add(temp);
}
return (result != null ? result : null);
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
public EducationDAO GetEducationByID(int id)
{
try
{
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
Education education = (from edu in db.Educations where edu.Education_ID == id select edu).FirstOrDefault();
EducationDAO result = new EducationDAO
{
EducationID = education.Education_ID,
ApplicantID = education.Applicant_ID,
SchoolID = education.School_ID,
YearsAttendedFrom = education.YearsAttendedFrom,
YearsAttendedTo = education.YearsAttendedTo,
Graduated = education.Graduated,
DegreeAndMajor = education.DegreeAndMajor
};
return (result != null ? result : null);
}
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
public bool CreateEducation(EducationDAO edu)
{
Education education = new Education
{
Applicant_ID = edu.ApplicantID,
School_ID = edu.SchoolID,
YearsAttendedFrom = edu.YearsAttendedFrom,
YearsAttendedTo = edu.YearsAttendedTo,
Graduated = edu.Graduated,
DegreeAndMajor = edu.DegreeAndMajor
};
using (AESDatabaseDataContext db = new AESDatabaseDataContext())
{
db.Educations.InsertOnSubmit(education);
try
{
db.SubmitChanges();
}
catch (Exception e)
{
throw new FaultException<KaskServiceException>(new KaskServiceException(), new FaultReason(e.Message));
}
}
return true;
}
public bool CreateEducation(EducationDAO e)
{
Educations.Add(e);
return true;
}
public void Test_CreateEducation()
{
EducationDAO education5 = new EducationDAO() { ID = 5, ApplicantID = 5, EducationID = 1, SchoolID = 1, DegreeAndMajor = "BIO" };
educationService.CreateEducation(education5);
Assert.AreEqual(educationService.GetEducations().Count, 5);
}
