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 bool UpdateTeacher(ref Teacher teacher, ref string message) { TeacherBDO tbdo = new TeacherBDO(); TranslateTeacherDTOToTeacherBDO(teacher, tbdo); return(tLogic.UpdateTeacher(ref tbdo, ref message)); }
public bool DeactivateTeacher(string teacherId, ref string message) { // Teacher teacher = new Teacher(); TeacherBDO tbdo = tLogic.GetTeacher(teacherId); tbdo.Deactivated = true; return(tLogic.UpdateTeacher(ref tbdo, ref message)); }
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 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 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.Academic = teacher.Academic; 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); tb.Academic = teacher.Academic ?? false; tb.Salary = teacher.Salary; tb.Department = teacher.Department; }
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 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 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); }
public TeacherBDO GetTeacher(string lastname, string firstname, string mname) { TeacherBDO t = new TeacherBDO(); t = teacherDAO.GetTeacherBDO(lastname, firstname, mname); 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 Teacher GetTeacher(string teacherId, ref string message) { Teacher teacher = new Teacher(); TeacherBDO tbdo = tLogic.GetTeacher(teacherId); if (tbdo != null) { TranslateTeacherBDOToTeacherDTO(tbdo, teacher); } else { message = "Teacher Does Not Exists"; } return(teacher); }
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 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 Teacher GetTeacher(string lname, string fname, string mname) { string message = String.Empty; Teacher teacher = new Teacher(); TeacherBDO tbdo = tLogic.GetTeacher(lname, fname, mname); if (tbdo != null) { TranslateTeacherBDOToTeacherDTO(tbdo, teacher); } else { message = "Teacher Does Not Exists"; } return(teacher); }
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); }
private 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; }
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 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 Boolean UpdateTeacher(ref TeacherBDO teacher, ref string message) { message = "Teacher updated successfully."; Boolean ret = true; Teacher t = new Teacher(); 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 user is updated."; } } } return(ret); }
private 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; }