public void ConvertStuSubjectsBDOToStuSubjects(StudentSubjectBDO sbdo, StudentSubject s) { s.StudentSY = sbdo.StudentSY; s.SubjectCode = sbdo.SubjectCode; s.StudentSubjectsID = sbdo.StudentSubjectsID; s.StudentEnrSubCode = sbdo.StudentEnrSubCode; s.Remarks = sbdo.Remarks; s.FirstPeriodicRating = sbdo.FirstPeriodicRating; s.SecondPeriodicRating = sbdo.SecondPeriodicRating; s.ThirdPeriodicRating = sbdo.ThirdPeriodicRating; s.FourthPeriodicRating = sbdo.FourthPeriodicRating; s.SubjectAssignments = sbdo.SubjectAssignments; s.FirstEntered = sbdo.FirstEntered; s.SecondEntered = sbdo.SecondEntered; s.FourthEntered = sbdo.FourthEntered; s.ThirdEntered = sbdo.ThirdEntered; s.LockFirst = sbdo.LockFirst; s.LockSecond = sbdo.LockSecond; s.LockThird = sbdo.LockThird; s.LockFourth = sbdo.LockFourth; s.FirstLocked = sbdo.FirstLocked; s.SecondLocked = sbdo.SecondLocked; s.ThirdLocked = sbdo.ThirdLocked; s.FourthLocked = sbdo.FourthLocked; }
public List<StudentSubjectBDO> GetAllStudentSubjects() { List<StudentSubjectBDO> subjectBDOList = new List<StudentSubjectBDO>(); List<StudentSubject> subjectList = new List<StudentSubject>(); try { using (var DCEnt = new DCFIEntities()) { var allStudentSubjects = (DCEnt.StudentSubjects); subjectList = allStudentSubjects.ToList<StudentSubject>(); foreach (StudentSubject s in subjectList) { StudentSubjectBDO subjectBDO = new StudentSubjectBDO(); ConvertStuSubjectsToStuSubjectsBDO(s, subjectBDO); subjectBDOList.Add(subjectBDO); } } } 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 subjectBDOList; }
public Boolean ControlSubjects(string StudentId, string sy, List<StudentSubject> subjects) { Boolean ret = false; foreach (StudentSubject sub in subjects) { string message = string.Empty; StudentSubjectBDO ssb = new StudentSubjectBDO(); TranslateStuSubjectsToStuSubjectsBDO(sub, ssb); ret = ssl.ControlStudent(ssb,ref message); } return ret; }
public void ConvertStuSubjectsToStuSubjectsBDO(StudentSubject s, StudentSubjectBDO sbdo) { StudentEnrolmentDAO sed = new StudentEnrolmentDAO(); StudentEnrollmentBDO sedb = new StudentEnrollmentBDO(); sed.ConvertEnrolToEnrolBDO(s.StudentEnrollment, sedb); sbdo.StudentEnrollment = sedb; StudentDAO sd = new StudentDAO(); StudentBDO sb = new StudentBDO(); sd.ConvertStudentToStudentBDO(s.StudentEnrollment.Student, sb); sbdo.StudentEnrollment.Student = sb; SubjectDAO subd = new SubjectDAO(); SubjectBDO sbo = new SubjectBDO(); subd.ConvertSubjectToSubjectBDO(s.Subject, sbo); sbdo.Subject = sbo; sbdo.StudentSY = s.StudentSY; sbdo.SubjectCode = s.SubjectCode; sbdo.StudentSubjectsID = s.StudentSubjectsID; sbdo.StudentEnrSubCode = s.StudentEnrSubCode; sbdo.Remarks = s.Remarks; sbdo.FirstPeriodicRating = s.FirstPeriodicRating; sbdo.SecondPeriodicRating = s.SecondPeriodicRating; sbdo.ThirdPeriodicRating = s.ThirdPeriodicRating; sbdo.FourthPeriodicRating = s.FourthPeriodicRating; sbdo.StudentEnrSubCode = s.StudentEnrSubCode; sbdo.SubjectAssignments = s.SubjectAssignments; sbdo.FirstEntered = s.FirstEntered; sbdo.SecondEntered = s.SecondEntered; sbdo.FourthEntered = s.FourthEntered; sbdo.ThirdEntered = s.ThirdEntered; sbdo.LockFirst = s.LockFirst; sbdo.LockSecond = s.LockSecond; sbdo.LockThird = s.LockThird; sbdo.LockFourth = s.LockFourth; sbdo.FirstLocked = s.FirstLocked; sbdo.SecondLocked = s.SecondLocked; sbdo.ThirdLocked = s.ThirdLocked; sbdo.FourthLocked = s.FourthLocked; }
public List<StudentSubjectBDO> GetClassList(string SubjectAssignments, string gender) { List<StudentSubject> studlist = new List<StudentSubject>(); List<StudentSubjectBDO> classList = new List<StudentSubjectBDO>(); try { using (var DCEnt = new DCFIEntities()) { DCEnt.Database.Log = s => System.Diagnostics.Debug.WriteLine(s); var ss = (from sub in DCEnt.StudentSubjects where sub.SubjectAssignments == SubjectAssignments & sub.StudentEnrollment.Student.Gender == gender & sub.StudentEnrollment.Student.Dismissed== false orderby sub.StudentEnrollment.Student.LastName select sub).ToList<StudentSubject>(); studlist = ss; foreach (StudentSubject st in studlist) { StudentSubjectBDO ssbdo = new StudentSubjectBDO(); ConvertStuSubjectsToStuSubjectsBDO(st, ssbdo); classList.Add(ssbdo); } } } 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 classList; }
public List<StudentSubjectBDO> GetClassGradeReport(string SubjectAssignments, string gender) { List<StudentSubjectBDO> classgradeBDO = new List<StudentSubjectBDO>(); List<StudentSubject> classgrade = new List<StudentSubject>(); try { using (var DCEnt = new DCFIEntities()) { var classEval = (from s in DCEnt.StudentSubjects where s.SubjectAssignments == SubjectAssignments && s.StudentEnrollment.Student.Gender == gender orderby s.StudentEnrollment.Student.LastName select s); classgrade = classEval.ToList(); foreach (StudentSubject ss in classgrade) { StudentSubjectBDO ssb = new StudentSubjectBDO(); ssd.ConvertStuSubjectsToStuSubjectsBDO(ss, ssb); classgradeBDO.Add(ssb); } } } 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 classgradeBDO; }
public List<StudentSubjectBDO> GetStudentEvaluation(string StudentId) { List<StudentSubjectBDO> evalBdo = new List<StudentSubjectBDO>(); List<StudentSubject> eval = new List<StudentSubject>(); try { using (var DCEnt = new DCFIEntities()) { var studentEval = (from s in DCEnt.StudentSubjects where s.StudentSY.Contains(StudentId) select s); eval = studentEval.ToList(); foreach (StudentSubject ss in eval) { StudentSubjectBDO ssb = new StudentSubjectBDO(); ssd.ConvertStuSubjectsToStuSubjectsBDO(ss, ssb); evalBdo.Add(ssb); } } } 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 evalBdo; }
public List<StudentSubjectBDO> GetStudentSubjects(string studentsy) { List<StudentSubjectBDO> ssb = new List<StudentSubjectBDO>(); List<StudentSubject> ss = new List<StudentSubject>(); try { using (var DCEnt = new DCFIEntities()) { ss = (from sub in DCEnt.StudentSubjects where sub.StudentSY == studentsy select sub).ToList<StudentSubject>(); foreach (StudentSubject s in ss) { StudentSubjectBDO subBDO = new StudentSubjectBDO(); ConvertStuSubjectsToStuSubjectsBDO(s, subBDO); ssb.Add(subBDO); } } } 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 ssb; }
public List<StudentSubjectBDO> GetFailedSubjects(string IdSy) { List<StudentSubject> fails = new List<StudentSubject>(); List<StudentSubjectBDO> ssbl = new List<StudentSubjectBDO>(); try { using (var DCEnt = new DCFIEntities()) { var allStudentSubjects = (from subs in DCEnt.StudentSubjects where subs.StudentSY.Equals(IdSy) && subs.FourthPeriodicRating < 75.00 select subs); fails = allStudentSubjects.ToList<StudentSubject>(); foreach (StudentSubject ss in fails) { StudentSubjectBDO ssb = new StudentSubjectBDO(); ConvertStuSubjectsToStuSubjectsBDO(ss, ssb); ssbl.Add(ssb); } } } 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 ssbl; }
public Boolean DeleteStudentSubject(StudentSubjectBDO ssb, ref string message) { String studentEnrSub = ssb.StudentEnrSubCode; try { using (var DCEnt = new DCFIEntities()) { var x = (from ss in DCEnt.StudentSubjects where ss.StudentEnrSubCode == studentEnrSub select ss).FirstOrDefault(); if (x != null) { DCEnt.StudentSubjects.Remove(x); 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 true; }
public Boolean DeleteStudentLoad(StudentSubjectBDO ssb, ref string message) { return ssd.DeleteStudentSubject(ssb, ref message); }
public Boolean CreateStudentSubject(StudentSubjectBDO subBDO,ref string message) { message = "Student Subject Successfully Saved"; bool ret = true; StudentSubject sa = new StudentSubject(); ConvertStuSubjectsBDOToStuSubjects(subBDO, sa); try{ using (var DCEnt = new DCFIEntities()) { DCEnt.StudentSubjects.Attach(sa); DCEnt.Entry(sa).State = System.Data.Entity.EntityState.Added; int num = DCEnt.SaveChanges(); if (num != 1) { ret = false; message = "Saving Failed"; } } } 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 bool SaveClassGrades(List<StudentSubject> grades) { GradingLogic gl = new GradingLogic(); List<StudentSubjectBDO> ssbdo = new List<StudentSubjectBDO>(); foreach (StudentSubject stusub in grades) { StudentSubjectBDO stuSubBdo = new StudentSubjectBDO(); TranslateStudentSubjectToStudentSubjectBDO(stusub, stuSubBdo); ssbdo.Add(stuSubBdo); } return gl.SaveClassGrades(ssbdo); }
public void TranslateStudentSubjectToStudentSubjectBDO(StudentSubject ss, StudentSubjectBDO ssbdo) { ssbdo.FirstEntered = ss.FirstEntered; ssbdo.FirstLocked = ss.FirstLocked; ssbdo.FirstPeriodicRating = ss.FirstPeriodicRating; ssbdo.FourthEntered = ss.FourthEntered; ssbdo.FourthLocked = ss.FourthLocked; ssbdo.FourthPeriodicRating = ss.FourthPeriodicRating; ssbdo.LockFirst = ss.LockFirst; ssbdo.LockFourth = ss.LockFourth; ssbdo.LockSecond = ss.LockSecond; ssbdo.LockThird = ss.LockThird; ssbdo.Remarks = ss.Remarks; ssbdo.SecondEntered = ss.SecondEntered; ssbdo.SecondLocked = ss.SecondLocked; ssbdo.SecondPeriodicRating = ss.SecondPeriodicRating; ssbdo.ThirdEntered = ss.ThirdEntered; ssbdo.ThirdLocked = ss.ThirdLocked; ssbdo.ThirdPeriodicRating = ss.ThirdPeriodicRating; ssbdo.StudentEnrSubCode = ss.StudentEnrSubCode; ssbdo.StudentEnrSubCode = ss.StudentEnrSubCode; ssbdo.StudentSubjectsID = ss.StudentSubjectsID; ssbdo.StudentSY = ss.StudentSY; ssbdo.SubjectAssignments = ss.SubjectAssignments; ssbdo.SubjectCode = ss.SubjectCode; }
public void TranslateStudentSubjectBDOToStudentSubject(StudentSubjectBDO ssbdo, StudentSubject ss) { SubjectService s = new SubjectService(); Subject sub = new Subject(); s.TranslateSubjectBDOToSubject(ssbdo.Subject, sub); RegistrationService r = new RegistrationService(); StudentEnrollment se = new StudentEnrollment(); r.TranslatEnrolBDOToEnrol(ssbdo.StudentEnrollment, se); ss.StudentEnr = se; ss.Description = sub.Description; ss.FirstPeriodicRating = ssbdo.FirstPeriodicRating; ss.SecondPeriodicRating = ssbdo.SecondPeriodicRating; ss.ThirdPeriodicRating = ssbdo.ThirdPeriodicRating; ss.FourthPeriodicRating = ssbdo.FourthPeriodicRating; ss.FirstEntered = ssbdo.FirstEntered; ss.SecondEntered = ssbdo.SecondEntered; ss.ThirdEntered = ssbdo.ThirdEntered; ss.FourthEntered = ssbdo.FourthEntered; ss.LockFirst = (bool)ssbdo.LockFirst; ss.LockFourth = (bool)ssbdo.LockFourth; ss.LockSecond = (bool)ssbdo.LockSecond; ss.LockThird = (bool)ssbdo.LockThird; ss.FirstLocked = ssbdo.FirstLocked; ss.SecondLocked = ssbdo.SecondLocked; ss.ThirdLocked = ssbdo.ThirdLocked; ss.FourthLocked = ssbdo.FourthLocked; ss.Remarks = ssbdo.Remarks; ss.StudentEnrSubCode = ssbdo.StudentEnrSubCode; ss.StudentEnrSubCode = ssbdo.StudentEnrSubCode; ss.StudentSubjectsID = ssbdo.StudentSubjectsID; ss.StudentSY = ssbdo.StudentSY; ss.SubjectCode = ssbdo.SubjectCode; ss.StudentId = se.StudentId; ss.StudentName = se.StudentName; }
public Boolean ControlStudent(StudentSubjectBDO ssb, ref string message) { return ssd.CreateStudentSubject(ssb, ref message); }
public void TranslateStuSubjectsBDOToStuSubjects(StudentSubjectBDO sbdo, StudentSubject s) { SubjectService ss = new SubjectService(); Subject sub = new Subject(); ss.TranslateSubjectBDOToSubject(sbdo.Subject, sub); s.SubjectCode = sbdo.SubjectCode; s.Description = sub.Description; RegistrationService rs = new RegistrationService(); StudentEnrollment se = new StudentEnrollment(); rs.TranslatEnrolBDOToEnrol(sbdo.StudentEnrollment, se); s.StudentEnr = se; s.StudentSY = sbdo.StudentSY; s.StudentId = se.StudentId; s.StudentName = se.StudentName; s.StudentSubjectsID = sbdo.StudentSubjectsID; s.StudentEnrSubCode = sbdo.StudentEnrSubCode; s.Remarks = sbdo.Remarks; s.FirstPeriodicRating = sbdo.FirstPeriodicRating; s.SecondPeriodicRating = sbdo.SecondPeriodicRating; s.ThirdPeriodicRating = sbdo.ThirdPeriodicRating; s.FourthPeriodicRating = sbdo.FourthPeriodicRating; s.Description = sub.Description; s.SubjectAssignments = sbdo.SubjectAssignments; s.FirstEntered = sbdo.FirstEntered; s.FirstLocked = sbdo.FirstLocked; s.FourthEntered = sbdo.FourthEntered; s.FourthLocked = sbdo.FourthLocked; s.LockFirst = sbdo.LockFirst; s.LockFourth = sbdo.LockFourth; s.LockSecond = sbdo.LockSecond; s.LockThird = sbdo.LockThird; s.SecondEntered = sbdo.SecondEntered; s.SecondLocked = sbdo.SecondLocked; s.ThirdEntered = sbdo.ThirdEntered; s.ThirdLocked = sbdo.ThirdLocked; s.FinalRating = (double)sbdo.FourthPeriodicRating; if (s.FinalRating > 90) s.Proficiency = "O"; else if (s.FinalRating >= 85) s.Proficiency = "VS"; else if (s.FinalRating >= 80) s.Proficiency = "S"; else if (s.FinalRating >= 75) s.Proficiency = "FS"; else if (s.FinalRating <= 74) s.Proficiency = "D"; }
public List<StudentSubjectBDO> GetStudentGradeReport(string StudentId, string sy) { List<StudentSubjectBDO> studentGradeBDO = new List<StudentSubjectBDO>(); List<StudentSubject> studentgrade = new List<StudentSubject>(); try { using (var DCEnt = new DCFIEntities()) { var sg = (from s in DCEnt.StudentSubjects where s.StudentSY.Equals(StudentId + sy) select s); studentgrade = sg.ToList(); foreach (StudentSubject ss in studentgrade) { StudentSubjectBDO ssb = new StudentSubjectBDO(); ssd.ConvertStuSubjectsToStuSubjectsBDO(ss, ssb); studentGradeBDO.Add(ssb); } } } 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 studentGradeBDO; }
public bool DeleteLoadedSubjects(string StudentId, string sy, List<StudentSubject> subs) { Boolean ret = false; foreach (StudentSubject sub in subs) { string message = string.Empty; StudentSubjectBDO ssb = new StudentSubjectBDO(); TranslateStuSubjectsToStuSubjectsBDO(sub, ssb); ret = ssl.DeleteStudentLoad(ssb, ref message); } return ret; }