public void ConvertGradeSectionToGradeSectionBDO(GradeSection gs, GradeSectionBDO gsBDO)
{
RoomDAO r = new RoomDAO();
RoomBDO room = new RoomBDO();
TeacherDAO t = new TeacherDAO();
TeacherBDO teach = new TeacherBDO();
SchoolYearDAO s = new SchoolYearDAO();
SchoolYearBDO sy = new SchoolYearBDO();
s.ConvertSYToSYBDO(gs.SchoolYear, sy);
t.ConvertTeacherToTeacherBDO(gs.Teacher, teach);
r.ConvertRoomToRoomBDO(gs.Room, room);
gsBDO.Deactivated = gs.Deactivated;
gsBDO.GradeLevel = gs.GradeLevel;
gsBDO.GradeSectionCode = gs.GradeSectionCode;
gsBDO.HomeRoomNumber = (int)gs.HomeRoomNumber;
gsBDO.HomeRoomTeacherId = gs.HomeRoomTeacherId;
gsBDO.Section = gs.Section;
gsBDO.SY = gs.SY;
gsBDO.Class = gs.Class;
gsBDO.HomeRoom = room;
gsBDO.HomeRoomTeacher = teach;
gsBDO.SchoolYear = sy;
}
public void ConvertSubjectAssignmentToSubjectAssignmentBDO(SubjectAssignment sa, SubjectAssignmentBDO sabdo)
{
sabdo.Deactivated = (bool)sa.Deactivated;
GradeSectionDAO gd = new GradeSectionDAO();
GradeSectionBDO g = new GradeSectionBDO();
g = gd.GetGradeSectionBDO((int)sa.GradeSectionCode);
sabdo.GradeSection = g;
sabdo.GradeSectionCode = g.GradeSectionCode;
RoomBDO r = new RoomBDO();
RoomDAO rd = new RoomDAO();
rd.ConvertRoomToRoomBDO(sa.Room, r);
sabdo.Room = r;
sabdo.RoomId = r.RoomId;
SubjectDAO sd = new SubjectDAO();
SubjectBDO sb = new SubjectBDO();
sd.ConvertSubjectToSubjectBDO(sa.Subject, sb);
sabdo.Subject = sb;
sabdo.SubjectAssignmentsID = sa.SubjectAssignmentsID;
sabdo.SubjectCode = sa.SubjectCode;
sabdo.SY = sa.SY;
TeacherDAO td = new TeacherDAO();
TeacherBDO tb = new TeacherBDO();
td.ConvertTeacherToTeacherBDO(sa.Teacher, tb);
sabdo.Teacher = tb;
sabdo.TeacherId = tb.TeacherId;
TimeslotDAO tid = new TimeslotDAO();
TimeslotBDO tib = new TimeslotBDO();
tid.ConvertTimeslotToTimeslotBDO(sa.Timeslot, tib);
sabdo.Timeslot = tib;
sabdo.TimeSlotCode = tib.TimeSlotCode;
sabdo.GradeLevel = g.GradeLevel;
}
public TeacherBDO GetTeacherBDO(string lastname, string firstname)
{
TeacherBDO teacherBDO = null;
try {
using (var DCEnt = new DCFIEntities())
{
Teacher teacher = (from t in DCEnt.Teachers
where (t.LastName == lastname) && (t.FirstName == firstname)
select t).FirstOrDefault();
if (teacher != null)
{
teacherBDO = new TeacherBDO();
ConvertTeacherToTeacherBDO(teacher, teacherBDO);
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return teacherBDO;
}
public bool CreateTeacher(ref Teacher teacher, ref string message)
{
Boolean ret = false; ;
TeacherBDO tbdo = new TeacherBDO();
TranslateTeacherDTOToTeacherBDO(teacher, tbdo);
ret= tLogic.CreateTeacher(ref tbdo, ref message);
return ret;
}
public TeacherBDO GetTeacher(string teacherId) {
TeacherBDO t = new TeacherBDO();
t= teacherDAO.GetTeacherBDO(teacherId);
t.TeacherChildrens = teacherDAO.GetAllChildren(t.TeacherId);
t.TeacherEligibilities = teacherDAO.GetAllEligibility(t.TeacherId);
t.TeacherEducationalBackgrounds = teacherDAO.GetAllEducationalBackground(t.TeacherId);
t.TrainingSeminars = teacherDAO.GetAllTrainingSeminars(t.TeacherId);
t.WorkExperiences = teacherDAO.GetAllWorkExperience(t.TeacherId);
return t;
}
public TeacherBDO GetTeacher(string lastname, string firstname)
{
TeacherBDO t = new TeacherBDO();
t= teacherDAO.GetTeacherBDO(lastname,firstname);
if (t != null)
{
t.TeacherChildrens = teacherDAO.GetAllChildren(t.TeacherId);
t.TeacherEligibilities = teacherDAO.GetAllEligibility(t.TeacherId);
t.TeacherEducationalBackgrounds = teacherDAO.GetAllEducationalBackground(t.TeacherId);
t.TrainingSeminars = teacherDAO.GetAllTrainingSeminars(t.TeacherId);
t.WorkExperiences = teacherDAO.GetAllWorkExperience(t.TeacherId);
}
return t;
}
public void TranslateTeacherDTOToTeacherBDO(Teacher teacher, TeacherBDO tb)
{
tb.BloodType = teacher.BloodType;
tb.CivilStatus = teacher.CivilStatus;
tb.DateOfAppointment = teacher.DateOfAppointment;
tb.Deactivated = teacher.Deactivated;
tb.DialectSpoken = teacher.DialectSpoken;
tb.DOB = teacher.DOB;
tb.EmailAddress = teacher.EmailAddress;
tb.EmploymentStatus = teacher.EmploymentStatus;
tb.FirstName = teacher.FirstName;
tb.Gender = teacher.Gender;
tb.HeightCm = teacher.HeightCm;
tb.LastName = teacher.LastName;
tb.MiddleName = teacher.MiddleName;
tb.MobileNo = teacher.MobileNo;
tb.PagIBIGNo = teacher.PagIBIGNo;
tb.PAMunicipality = teacher.PAMunicipality;
tb.PAProvince = teacher.PAProvince;
tb.PARegion = teacher.PARegion;
tb.PAStreetName = teacher.PAStreetName;
tb.PhilHealthNo = teacher.PhilHealthNo;
tb.POBMunicipality = teacher.POBMunicipality;
tb.POBProvince = teacher.POBProvince;
tb.PreviousSchool = teacher.PreviousSchool;
tb.RAMunicipality = teacher.RAMunicipality;
tb.RAProvince = teacher.RAProvince;
tb.RARegion = teacher.RARegion;
tb.RAStreetName = teacher.RAStreetName;
tb.ResTelephoneNo = teacher.ResTelephoneNo;
tb.SpouseBusinessAdd = teacher.SpouseBusinessAdd;
tb.SpouseEmployerName = teacher.SpouseEmployerName;
tb.SpouseFirstName = teacher.SpouseFirstName;
tb.SpouseLastName = teacher.SpouseLastName;
tb.SpouseMiddleName = teacher.SpouseMiddleName;
tb.SpouseOccupation = teacher.SpouseOccupation;
tb.SpouseTelephoneNo = teacher.SpouseTelephoneNo;
tb.SSSNum = teacher.SSSNum;
tb.TeacherId = teacher.TeacherId;
tb.TIN = teacher.TIN;
tb.WeightKg = teacher.WeightKg;
tb.Image = teacher.Image;
tb.PERAA = teacher.PERAA;
tb.TeacherChildrens = ToChildrenBDO(teacher.TeacherChildrens);
tb.TeacherEligibilities = ToEligibilityBDO(teacher.TeacherEligibilities);
tb.TeacherEducationalBackgrounds = ToEducBacBDO(teacher.TeacherEducationalBackgrounds);
tb.TrainingSeminars = ToTrainSemBDO(teacher.TrainingSeminars);
tb.WorkExperiences = ToWorkExpBDO(teacher.WorkExperiences);
}
public Boolean CreateTeacher(ref TeacherBDO teacherBDO, ref string message)
{
Boolean ret = false;
TeacherBDO tBDO = GetTeacher(teacherBDO.LastName, teacherBDO.FirstName);
if (tBDO == null)
{
// teacherBDO.TeacherId = GenerateTeacherId();
ret = teacherDAO.CreateTeacher(ref teacherBDO, ref message);
}
else
message = teacherBDO.LastName + ", " + teacherBDO.FirstName + " already exists. Please check your entry";
return ret;
}
public TeacherBDO GetTeacherBDO(string teacherId)
{
TeacherBDO teacherBDO = null;
using (var DCEnt = new DCFIEntities())
{
Teacher teacher = (from t in DCEnt.Teachers
where t.TeacherId == teacherId
select t).FirstOrDefault();
if (teacher != null)
{
teacherBDO = new TeacherBDO();
ConvertTeacherToTeacherBDO(teacher, teacherBDO);
}
}
return teacherBDO;
}
public TeacherBDO GetTeacherBDO(string lastname, string firstname)
{
TeacherBDO teacherBDO = null;
using (var DCEnt = new DCFIEntities())
{
Teacher teacher = (from t in DCEnt.Teachers
where (t.LastName == lastname) && (t.FirstName == firstname)
select t).FirstOrDefault();
if (teacher != null)
{
teacherBDO = new TeacherBDO();
ConvertTeacherToTeacherBDO(teacher, teacherBDO);
}
}
return teacherBDO;
}
public Teacher ActivateTeacher(string fname, string mname, string lname)
{
String message = " ";
Teacher teacher = new Teacher();
TeacherBDO tbdo = new TeacherBDO();
tbdo = tLogic.GetTeacher(lname, fname, mname);
if (tbdo == null)
{
return null;
}
else {
tbdo.Deactivated = false;
tLogic.UpdateTeacher(ref tbdo, ref message);
TranslateTeacherBDOToTeacherDTO(tbdo, teacher);
return teacher;
}
}
public List<TeacherBDO> GetAllTeachers()
{
List<Teacher> teacherList = new List<Teacher>();
using (var DCEnt = new DCFIEntities())
{
teacherList = (from t in DCEnt.Teachers
where t.Deactivated == false
select t).ToList<Teacher>();
}
List<TeacherBDO> teacherBDOList = new List<TeacherBDO>();
foreach (Teacher t in teacherList)
{
TeacherBDO teacherBDO = new TeacherBDO();
ConvertTeacherToTeacherBDO(t, teacherBDO);
teacherBDOList.Add(teacherBDO);
}
return teacherBDOList;
}
public Boolean UpdateTeacher(ref TeacherBDO teacher, ref string message)
{
message = "Teacher updated successfully.";
Boolean ret = true;
Teacher t = new Teacher();
try {
ConvertTeacherBDOToTeacher(teacher, t);
Teacher teacherInDB = new Teacher();
using (var DCEnt = new DCFIEntities())
{
var teacherID = teacher.TeacherId;
teacherInDB = (from tea in DCEnt.Teachers
where tea.TeacherId.Equals(teacherID)
select tea).FirstOrDefault();
if (teacherInDB == null)
{
throw new Exception("No teacher with ID " + teacher.TeacherId);
}
//1st Part
if (teacherInDB.TeacherChildrens.Count == 0)
{
foreach (TeacherChildren tc in t.TeacherChildrens)
{
teacherInDB.TeacherChildrens.Add(tc);
}
}
else if (teacherInDB.TeacherChildrens.Count < t.TeacherChildrens.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<TeacherChildren> tcToAdd = t.TeacherChildrens.Except(teacherInDB.TeacherChildrens);
if (tcToAdd != null)
{
foreach (TeacherChildren child in tcToAdd)
{
teacherInDB.TeacherChildrens.Add(child);
}
}
IEnumerable<TeacherChildren> tcToRemove = teacherInDB.TeacherChildrens.Except(t.TeacherChildrens);
if (tcToRemove != null)
{
foreach (TeacherChildren child in tcToRemove)
{
teacherInDB.TeacherChildrens.Add(child);
}
}
}
else if (teacherInDB.TeacherChildrens.Count > t.TeacherChildrens.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<TeacherChildren> tcToAdd = t.TeacherChildrens.Except(teacherInDB.TeacherChildrens);
if (tcToAdd != null)
{
foreach (TeacherChildren child in tcToAdd)
{
teacherInDB.TeacherChildrens.Add(child);
}
}
IEnumerable<TeacherChildren> tcToRemove = teacherInDB.TeacherChildrens.Except(t.TeacherChildrens);
if (tcToRemove != null)
{
foreach (TeacherChildren child in tcToRemove)
{
teacherInDB.TeacherChildrens.Add(child);
}
}
}
else if (teacherInDB.TeacherChildrens.Count == t.TeacherChildrens.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<TeacherChildren> tcToAdd = t.TeacherChildrens.Except(teacherInDB.TeacherChildrens);
if (tcToAdd != null)
{
foreach (TeacherChildren child in tcToAdd)
{
teacherInDB.TeacherChildrens.Add(child);
}
}
IEnumerable<TeacherChildren> tcToRemove = teacherInDB.TeacherChildrens.Except(t.TeacherChildrens);
if (tcToRemove != null)
{
foreach (TeacherChildren child in tcToRemove)
{
teacherInDB.TeacherChildrens.Add(child);
}
}
}
//2nd Part
if (teacherInDB.TeacherEligibilities.Count == 0)
{
foreach (TeacherEligibility te in t.TeacherEligibilities)
{
teacherInDB.TeacherEligibilities.Add(te);
}
}
else if (teacherInDB.TeacherEligibilities.Count < t.TeacherEligibilities.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<TeacherEligibility> tcToAdd = t.TeacherEligibilities.Except(teacherInDB.TeacherEligibilities);
if (tcToAdd != null)
{
foreach (TeacherEligibility child in tcToAdd)
{
teacherInDB.TeacherEligibilities.Add(child);
}
}
IEnumerable<TeacherEligibility> tcToRemove = teacherInDB.TeacherEligibilities.Except(t.TeacherEligibilities);
if (tcToRemove != null)
{
foreach (TeacherEligibility child in tcToRemove)
{
teacherInDB.TeacherEligibilities.Add(child);
}
}
}
else if (teacherInDB.TeacherEligibilities.Count > t.TeacherEligibilities.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<TeacherEligibility> tcToAdd = t.TeacherEligibilities.Except(teacherInDB.TeacherEligibilities);
if (tcToAdd != null)
{
foreach (TeacherEligibility child in tcToAdd)
{
teacherInDB.TeacherEligibilities.Add(child);
}
}
IEnumerable<TeacherEligibility> tcToRemove = teacherInDB.TeacherEligibilities.Except(t.TeacherEligibilities);
if (tcToRemove != null)
{
foreach (TeacherEligibility child in tcToRemove)
{
teacherInDB.TeacherEligibilities.Add(child);
}
}
}
else if (teacherInDB.TeacherEligibilities.Count == t.TeacherEligibilities.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<TeacherEligibility> tcToAdd = t.TeacherEligibilities.Except(teacherInDB.TeacherEligibilities);
if (tcToAdd != null)
{
foreach (TeacherEligibility child in tcToAdd)
{
teacherInDB.TeacherEligibilities.Add(child);
}
}
IEnumerable<TeacherEligibility> tcToRemove = teacherInDB.TeacherEligibilities.Except(t.TeacherEligibilities);
if (tcToRemove != null)
{
foreach (TeacherEligibility child in tcToRemove)
{
teacherInDB.TeacherEligibilities.Add(child);
}
}
}
//3rd Part
if (teacherInDB.TeacherEducationalBackgrounds.Count == 0)
{
foreach (TeacherEducationalBackground eb in t.TeacherEducationalBackgrounds)
{
teacherInDB.TeacherEducationalBackgrounds.Add(eb);
}
}
else if (teacherInDB.TeacherEducationalBackgrounds.Count < t.TeacherEducationalBackgrounds.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<TeacherEducationalBackground> tcToAdd = t.TeacherEducationalBackgrounds.Except(teacherInDB.TeacherEducationalBackgrounds);
if (tcToAdd != null)
{
foreach (TeacherEducationalBackground child in tcToAdd)
{
teacherInDB.TeacherEducationalBackgrounds.Add(child);
}
}
IEnumerable<TeacherEducationalBackground> tcToRemove = teacherInDB.TeacherEducationalBackgrounds.Except(t.TeacherEducationalBackgrounds);
if (tcToRemove != null)
{
foreach (TeacherEducationalBackground child in tcToRemove)
{
teacherInDB.TeacherEducationalBackgrounds.Add(child);
}
}
}
else if (teacherInDB.TeacherEducationalBackgrounds.Count > t.TeacherEducationalBackgrounds.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<TeacherEducationalBackground> tcToAdd = t.TeacherEducationalBackgrounds.Except(teacherInDB.TeacherEducationalBackgrounds);
if (tcToAdd != null)
{
foreach (TeacherEducationalBackground child in tcToAdd)
{
teacherInDB.TeacherEducationalBackgrounds.Add(child);
}
}
IEnumerable<TeacherEducationalBackground> tcToRemove = teacherInDB.TeacherEducationalBackgrounds.Except(t.TeacherEducationalBackgrounds);
if (tcToRemove != null)
{
foreach (TeacherEducationalBackground child in tcToRemove)
{
teacherInDB.TeacherEducationalBackgrounds.Add(child);
}
}
}
else if (teacherInDB.TeacherEducationalBackgrounds.Count == t.TeacherEducationalBackgrounds.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<TeacherEducationalBackground> tcToAdd = t.TeacherEducationalBackgrounds.Except(teacherInDB.TeacherEducationalBackgrounds);
if (tcToAdd != null)
{
foreach (TeacherEducationalBackground child in tcToAdd)
{
teacherInDB.TeacherEducationalBackgrounds.Add(child);
}
}
IEnumerable<TeacherEducationalBackground> tcToRemove = teacherInDB.TeacherEducationalBackgrounds.Except(t.TeacherEducationalBackgrounds);
if (tcToRemove != null)
{
foreach (TeacherEducationalBackground child in tcToRemove)
{
teacherInDB.TeacherEducationalBackgrounds.Add(child);
}
}
}
//4th Part
if (teacherInDB.TrainingSeminars.Count == 0)
{
foreach (TrainingSeminar ts in t.TrainingSeminars)
{
teacherInDB.TrainingSeminars.Add(ts);
}
}
else if (teacherInDB.TrainingSeminars.Count < t.TrainingSeminars.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<TrainingSeminar> tcToAdd = t.TrainingSeminars.Except(teacherInDB.TrainingSeminars);
if (tcToAdd != null)
{
foreach (TrainingSeminar child in tcToAdd)
{
teacherInDB.TrainingSeminars.Add(child);
}
}
IEnumerable<TrainingSeminar> tcToRemove = teacherInDB.TrainingSeminars.Except(t.TrainingSeminars);
if (tcToRemove != null)
{
foreach (TrainingSeminar child in tcToRemove)
{
teacherInDB.TrainingSeminars.Add(child);
}
}
}
else if (teacherInDB.TrainingSeminars.Count > t.TrainingSeminars.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<TrainingSeminar> tcToAdd = t.TrainingSeminars.Except(teacherInDB.TrainingSeminars);
if (tcToAdd != null)
{
foreach (TrainingSeminar child in tcToAdd)
{
teacherInDB.TrainingSeminars.Add(child);
}
}
IEnumerable<TrainingSeminar> tcToRemove = teacherInDB.TrainingSeminars.Except(t.TrainingSeminars);
if (tcToRemove != null)
{
foreach (TrainingSeminar child in tcToRemove)
{
teacherInDB.TrainingSeminars.Add(child);
}
}
}
else if (teacherInDB.TrainingSeminars.Count == t.TrainingSeminars.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<TrainingSeminar> tcToAdd = t.TrainingSeminars.Except(teacherInDB.TrainingSeminars);
if (tcToAdd != null)
{
foreach (TrainingSeminar child in tcToAdd)
{
teacherInDB.TrainingSeminars.Add(child);
}
}
IEnumerable<TrainingSeminar> tcToRemove = teacherInDB.TrainingSeminars.Except(t.TrainingSeminars);
if (tcToRemove != null)
{
foreach (TrainingSeminar child in tcToRemove)
{
teacherInDB.TrainingSeminars.Add(child);
}
}
}
//5th Part
if (teacherInDB.WorkExperiences.Count == 0)
{
foreach (WorkExperience we in t.WorkExperiences)
{
teacherInDB.WorkExperiences.Add(we);
}
}
else if (teacherInDB.WorkExperiences.Count < t.WorkExperiences.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<WorkExperience> tcToAdd = t.WorkExperiences.Except(teacherInDB.WorkExperiences);
if (tcToAdd != null)
{
foreach (WorkExperience child in tcToAdd)
{
teacherInDB.WorkExperiences.Add(child);
}
}
IEnumerable<WorkExperience> tcToRemove = teacherInDB.WorkExperiences.Except(t.WorkExperiences);
if (tcToRemove != null)
{
foreach (WorkExperience child in tcToRemove)
{
teacherInDB.WorkExperiences.Add(child);
}
}
}
else if (teacherInDB.WorkExperiences.Count > t.WorkExperiences.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<WorkExperience> tcToAdd = t.WorkExperiences.Except(teacherInDB.WorkExperiences);
if (tcToAdd != null)
{
foreach (WorkExperience child in tcToAdd)
{
teacherInDB.WorkExperiences.Add(child);
}
}
IEnumerable<WorkExperience> tcToRemove = teacherInDB.WorkExperiences.Except(t.WorkExperiences);
if (tcToRemove != null)
{
foreach (WorkExperience child in tcToRemove)
{
teacherInDB.WorkExperiences.Add(child);
}
}
}
else if (teacherInDB.WorkExperiences.Count == t.WorkExperiences.Count)
{
//compare 2 lists check the non existing to the other
IEnumerable<WorkExperience> tcToAdd = t.WorkExperiences.Except(teacherInDB.WorkExperiences);
if (tcToAdd != null)
{
foreach (WorkExperience child in tcToAdd)
{
teacherInDB.WorkExperiences.Add(child);
}
}
IEnumerable<WorkExperience> tcToRemove = teacherInDB.WorkExperiences.Except(t.WorkExperiences);
if (tcToRemove != null)
{
foreach (WorkExperience child in tcToRemove)
{
teacherInDB.WorkExperiences.Add(child);
}
}
}
using (var DC = new DCFIEntities())
{
// DC.Teachers.Remove(teacherInDB);
teacherInDB = t;
foreach (TeacherChildren tc in teacherInDB.TeacherChildrens)
DC.Entry(tc).State = tc.ChildId == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified;
foreach (TeacherEducationalBackground tc in teacherInDB.TeacherEducationalBackgrounds)
DC.Entry(tc).State = tc.TEBId == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified;
foreach (TeacherEligibility tc in teacherInDB.TeacherEligibilities)
DC.Entry(tc).State = tc.EligibilityId == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified;
foreach (TrainingSeminar tc in teacherInDB.TrainingSeminars)
DC.Entry(tc).State = tc.TSID == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified;
foreach (WorkExperience tc in teacherInDB.WorkExperiences)
DC.Entry(tc).State = tc.WEId == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified;
DC.Entry(teacherInDB).State = System.Data.Entity.EntityState.Modified;
int num = DC.SaveChanges();
if (num > 0)
{
// ret = false;
message = "No teacher is updated.";
}
}
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return ret;
}
public List<TeacherBDO> GetFilteredTeachers(string searchType, string search)
{
List<Teacher> teacherList = new List<Teacher>();
List<TeacherBDO> teacherBDOList = new List<TeacherBDO>();
try {
using (var DCEnt = new DCFIEntities())
{
if (searchType == "Teacher ID")
{
teacherList = (from t in DCEnt.Teachers
where t.Deactivated == false
&& t.TeacherId.Contains(search)
select t).ToList<Teacher>();
}
if (searchType == "First Name")
{
teacherList = (from t in DCEnt.Teachers
where t.Deactivated == false
&& t.FirstName.Contains(search)
select t).ToList<Teacher>();
}
if (searchType == "Middle Name")
{
teacherList = (from t in DCEnt.Teachers
where t.Deactivated == false
&& t.MiddleName.Contains(search)
select t).ToList<Teacher>();
}
if (searchType == "Last Name")
{
teacherList = (from t in DCEnt.Teachers
where t.Deactivated == false
&& t.LastName.Contains(search)
select t).ToList<Teacher>();
}
}
foreach (Teacher t in teacherList)
{
TeacherBDO teacherBDO = new TeacherBDO();
ConvertTeacherToTeacherBDO(t, teacherBDO);
teacherBDOList.Add(teacherBDO);
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return teacherBDOList;
}
public List<TeacherBDO> GetAllTeachers()
{
List<Teacher> teacherList = new List<Teacher>();
List<TeacherBDO> teacherBDOList = new List<TeacherBDO>();
try {
using (var DCEnt = new DCFIEntities())
{
teacherList = (from t in DCEnt.Teachers
where t.Deactivated == false
orderby t.LastName
select t).ToList<Teacher>();
}
foreach (Teacher t in teacherList)
{
TeacherBDO teacherBDO = new TeacherBDO();
ConvertTeacherToTeacherBDO(t, teacherBDO);
teacherBDOList.Add(teacherBDO);
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return teacherBDOList;
}
public Boolean CreateTeacher(ref TeacherBDO teacher, ref string message)
{
message = "Teacher Added Successfully";
bool ret = true;
Teacher t = new Teacher();
try {
ConvertTeacherBDOToTeacher(teacher, t);
using (var DCEnt = new DCFIEntities())
{
DCEnt.Teachers.Add(t);
DCEnt.SaveChanges();
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return ret;
}
public void ConvertTeacherBDOToTeacher(TeacherBDO teacher, Teacher tb)
{
ICollection<TeacherChildren> tc = new List<TeacherChildren>();
tc = ToChildrenList(teacher.TeacherChildrens);
ICollection<TeacherEligibility> te = new List<TeacherEligibility>();
te = ToEligibilityList(teacher.TeacherEligibilities);
ICollection<TeacherEducationalBackground> eb = new List<TeacherEducationalBackground>();
eb = ToEducationalBackList(teacher.TeacherEducationalBackgrounds);
ICollection<TrainingSeminar> ts = new List<TrainingSeminar>();
ts = ToTrainingSeminarList(teacher.TrainingSeminars);
ICollection<WorkExperience> we = new List<WorkExperience>();
we = ToWorkExperienceList(teacher.WorkExperiences);
tb.TeacherId = teacher.TeacherId;
tb.LastName = teacher.LastName;
tb.FirstName = teacher.FirstName;
tb.MiddleName = teacher.MiddleName;
tb.Deactivated = teacher.Deactivated;
tb.Gender = teacher.Gender;
tb.DOB = teacher.DOB;
tb.TIN = teacher.TIN;
tb.DateOfAppointment = teacher.DateOfAppointment;
tb.EmploymentStatus = teacher.EmploymentStatus;
tb.POBProvince = teacher.POBProvince;
tb.POBMunicipality = teacher.POBMunicipality;
tb.CivilStatus = teacher.CivilStatus;
tb.HeightCm = teacher.HeightCm;
tb.WeightKg = teacher.WeightKg;
tb.BloodType = teacher.BloodType;
tb.SSSNum = teacher.SSSNum;
tb.PagIBIGNo = teacher.PagIBIGNo;
tb.PhilHealthNo = teacher.PhilHealthNo;
tb.RAStreetName = teacher.RAStreetName;
tb.RARegion = teacher.RARegion;
tb.RAProvince = teacher.RAProvince;
tb.RAMunicipality = teacher.RAMunicipality;
tb.ResTelephoneNo = teacher.ResTelephoneNo;
tb.PAStreetName = teacher.PAStreetName;
tb.PARegion = teacher.PARegion;
tb.PAProvince = teacher.PAProvince;
tb.PAMunicipality = teacher.PAMunicipality;
tb.EmailAddress = teacher.EmailAddress;
tb.MobileNo = teacher.MobileNo;
tb.PreviousSchool = teacher.PreviousSchool;
tb.DialectSpoken = teacher.DialectSpoken;
tb.SpouseLastName = teacher.SpouseLastName;
tb.SpouseFirstName = teacher.SpouseFirstName;
tb.SpouseMiddleName = teacher.SpouseMiddleName;
tb.SpouseOccupation = teacher.SpouseOccupation;
tb.SpouseBusinessAdd = teacher.SpouseBusinessAdd;
tb.SpouseEmployerName = teacher.SpouseEmployerName;
tb.SpouseTelephoneNo = teacher.SpouseTelephoneNo;
tb.PERAA = teacher.PERAA;
tb.Image = teacher.Image;
tb.TeacherChildrens = tc;
tb.TeacherEligibilities = te;
tb.TeacherEducationalBackgrounds = eb;
tb.TrainingSeminars = ts;
tb.WorkExperiences = we;
tb.Academic = teacher.Academic;
}
public void ConvertTeacherToTeacherBDO(Teacher teacher, TeacherBDO tb)
{
tb.TeacherId = teacher.TeacherId;
tb.LastName = teacher.LastName;
tb.FirstName = teacher.FirstName;
tb.MiddleName = teacher.MiddleName;
tb.Deactivated = teacher.Deactivated;
tb.Gender = teacher.Gender;
tb.DOB = teacher.DOB;
tb.TIN = teacher.TIN;
tb.DateOfAppointment = teacher.DateOfAppointment;
tb.EmploymentStatus = teacher.EmploymentStatus;
tb.POBProvince = teacher.POBProvince;
tb.POBMunicipality = teacher.POBMunicipality;
tb.CivilStatus = teacher.CivilStatus;
tb.HeightCm = teacher.HeightCm;
tb.WeightKg = teacher.WeightKg;
tb.BloodType = teacher.BloodType;
tb.SSSNum = teacher.SSSNum;
tb.PagIBIGNo = teacher.PagIBIGNo;
tb.PhilHealthNo = teacher.PhilHealthNo;
tb.RAStreetName = teacher.RAStreetName;
tb.RARegion = teacher.RARegion;
tb.RAProvince = teacher.RAProvince;
tb.RAMunicipality = teacher.RAMunicipality;
tb.ResTelephoneNo = teacher.ResTelephoneNo;
tb.PAStreetName = teacher.PAStreetName;
tb.PARegion = teacher.PARegion;
tb.PAProvince = teacher.PAProvince;
tb.PAMunicipality = teacher.PAMunicipality;
tb.EmailAddress = teacher.EmailAddress;
tb.MobileNo = teacher.MobileNo;
tb.PreviousSchool = teacher.PreviousSchool;
tb.DialectSpoken = teacher.DialectSpoken;
tb.SpouseLastName = teacher.SpouseLastName;
tb.SpouseFirstName = teacher.SpouseFirstName;
tb.SpouseMiddleName = teacher.SpouseMiddleName;
tb.SpouseOccupation = teacher.SpouseOccupation;
tb.SpouseBusinessAdd = teacher.SpouseBusinessAdd;
tb.SpouseEmployerName = teacher.SpouseEmployerName;
tb.SpouseTelephoneNo = teacher.SpouseTelephoneNo;
tb.PERAA = teacher.PERAA;
tb.Image = teacher.Image;
if (teacher.Academic == null)
tb.Academic = true;
else
tb.Academic = (bool)teacher.Academic;
}
public List<TeacherBDO> GetFilteredTeachers(string searchType, string search)
{
List<Teacher> teacherList = new List<Teacher>();
using (var DCEnt = new DCFIEntities())
{
if (searchType == "Teacher ID")
{
teacherList = (from t in DCEnt.Teachers
where t.Deactivated == false
&& t.TeacherId.Contains(search)
select t).ToList<Teacher>();
}
if (searchType == "First Name")
{
teacherList = (from t in DCEnt.Teachers
where t.Deactivated == false
&& t.FirstName.Contains(search)
select t).ToList<Teacher>();
}
if (searchType == "Middle Name")
{
teacherList = (from t in DCEnt.Teachers
where t.Deactivated == false
&& t.MiddleName.Contains(search)
select t).ToList<Teacher>();
}
if (searchType == "Last Name")
{
teacherList = (from t in DCEnt.Teachers
where t.Deactivated == false
&& t.LastName.Contains(search)
select t).ToList<Teacher>();
}
}
List<TeacherBDO> teacherBDOList = new List<TeacherBDO>();
foreach (Teacher t in teacherList)
{
TeacherBDO teacherBDO = new TeacherBDO();
ConvertTeacherToTeacherBDO(t, teacherBDO);
teacherBDOList.Add(teacherBDO);
}
return teacherBDOList;
}
public void TranslateTeacherBDOToTeacherDTO(TeacherBDO teacher, Teacher tb)
{
if (teacher.MiddleName.Length > 0)
tb.TeacherName = teacher.LastName + ", " + teacher.FirstName + " " + teacher.MiddleName.Substring(0, 1) + ".";
else
tb.TeacherName = teacher.LastName + ", " + teacher.FirstName;
tb.BloodType = teacher.BloodType;
tb.CivilStatus = teacher.CivilStatus;
tb.DateOfAppointment = (DateTime)teacher.DateOfAppointment;
tb.Deactivated = teacher.Deactivated;
tb.DialectSpoken = teacher.DialectSpoken;
tb.DOB = (DateTime)teacher.DOB;
tb.EmailAddress = teacher.EmailAddress;
tb.EmploymentStatus = teacher.EmploymentStatus;
tb.FirstName = teacher.FirstName;
tb.Gender = teacher.Gender;
tb.HeightCm = (int)teacher.HeightCm;
tb.LastName = teacher.LastName;
tb.MiddleName = teacher.MiddleName;
tb.MobileNo = teacher.MobileNo;
tb.PagIBIGNo = teacher.PagIBIGNo;
tb.PAMunicipality = teacher.PAMunicipality;
tb.PAProvince = teacher.PAProvince;
tb.PARegion = teacher.PARegion;
tb.PAStreetName = teacher.PAStreetName;
tb.PhilHealthNo = teacher.PhilHealthNo;
tb.POBMunicipality = teacher.POBMunicipality;
tb.POBProvince = teacher.POBProvince;
tb.PreviousSchool = teacher.PreviousSchool;
tb.RAMunicipality = teacher.RAMunicipality;
tb.RAProvince = teacher.RAProvince;
tb.RARegion = teacher.RARegion;
tb.RAStreetName = teacher.RAStreetName;
tb.ResTelephoneNo = teacher.ResTelephoneNo;
tb.SpouseBusinessAdd = teacher.SpouseBusinessAdd;
tb.SpouseEmployerName = teacher.SpouseEmployerName;
tb.SpouseFirstName = teacher.SpouseFirstName;
tb.SpouseLastName = teacher.SpouseLastName;
tb.SpouseMiddleName = teacher.SpouseMiddleName;
tb.SpouseOccupation = teacher.SpouseOccupation;
tb.SpouseTelephoneNo = teacher.SpouseTelephoneNo;
tb.SSSNum = teacher.SSSNum;
tb.TeacherId = teacher.TeacherId;
tb.TIN = teacher.TIN;
tb.WeightKg = (double)teacher.WeightKg;
tb.Image = teacher.Image;
tb.PERAA = teacher.PERAA;
tb.Academic = teacher.Academic;
tb.TeacherChildrens = ToChildrenDTO(teacher.TeacherChildrens);
tb.TeacherEligibilities = ToEligibilityDTO(teacher.TeacherEligibilities);
tb.TeacherEducationalBackgrounds = ToEducBacDTO(teacher.TeacherEducationalBackgrounds);
tb.TrainingSeminars = ToTrainSemDTO(teacher.TrainingSeminars);
tb.WorkExperiences = ToWorkExpDTO(teacher.WorkExperiences);
tb.Academic = teacher.Academic;
tb.Salary = teacher.Salary;
tb.Department = teacher.Department;
}
public Boolean UpdateTeacher(ref TeacherBDO teacherBDO, ref string message)
{
if (GetTeacher(teacherBDO.TeacherId)!=null)
return teacherDAO.UpdateTeacher(ref teacherBDO, ref message);
else
{
message = "Cannot get teacher for this ID";
return false;
}
}
public bool UpdateTeacher(ref Teacher teacher, ref string message)
{
TeacherBDO tbdo = new TeacherBDO();
TranslateTeacherDTOToTeacherBDO(teacher, tbdo);
return tLogic.UpdateTeacher(ref tbdo, ref message);
}
public Boolean CreateTeacher(ref TeacherBDO teacher, ref string message)
{
message = "Teacher Added Successfully";
bool ret = true;
Teacher t = new Teacher();
ConvertTeacherBDOToTeacher(teacher, t);
using (var DCEnt = new DCFIEntities())
{
DCEnt.Teachers.Add(t);
DCEnt.SaveChanges();
}
return ret;
}
