Exemplo n.º 1
0
        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;
        }
Exemplo n.º 2
0
        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;
        }
Exemplo n.º 3
0
 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;
 }
Exemplo n.º 4
0
        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;
        }
Exemplo n.º 5
0
        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;
        }
Exemplo n.º 6
0
        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;
        }
Exemplo n.º 7
0
        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;
        }
Exemplo n.º 8
0
        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;
        }
Exemplo n.º 9
0
        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;
        }
Exemplo n.º 10
0
 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;
 }
Exemplo n.º 11
0
 public Boolean DeleteStudentLoad(StudentSubjectBDO ssb, ref string message)
 {
     return ssd.DeleteStudentSubject(ssb, ref message);
 }
Exemplo n.º 12
0
        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;
            
        }
Exemplo n.º 13
0
 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);
 }
Exemplo n.º 14
0
        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;


        }
Exemplo n.º 15
0
        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;

        }
Exemplo n.º 16
0
 public Boolean ControlStudent(StudentSubjectBDO ssb, ref string message)
 {
     return ssd.CreateStudentSubject(ssb, ref message);
 }
Exemplo n.º 17
0
        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";

        }
Exemplo n.º 18
0
        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;
        }
Exemplo n.º 19
0
 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;
 }