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