Пример #1
0
        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;
        }
Пример #2
0
 public bool CreateSchedules(SubjectAssignment subjectAssignment, string message)
 {
     Boolean ret = false; ;
     SubjectAssignmentBDO sabdo = new SubjectAssignmentBDO();
     TranslateScheduleToScheduleBDO(subjectAssignment, sabdo);
     ret = schedLogic.CreateSchedule(ref sabdo, ref message);
     return ret;
 }
Пример #3
0
        public Boolean CreateSchedule(ref SubjectAssignmentBDO schedBDO, ref string message)
        {
            Boolean ret = false;

            ret = schedDAO.CreateSchedule(ref schedBDO, ref message);

            return ret;
        }
Пример #4
0
 private List<SubjectAssignmentBDO> ToScheduleBDOList(List<SubjectAssignment> sched)
 {
     List<SubjectAssignmentBDO> slist = new List<SubjectAssignmentBDO>();
     foreach (SubjectAssignment s in sched)
     {
         SubjectAssignmentBDO sb = new SubjectAssignmentBDO();
         TranslateScheduleToScheduleBDO(s, sb);
         slist.Add(sb);
     }
     return slist;
 }
Пример #5
0
 public void ConvertSubjectAssignmentBDOToSubjectAssignment(SubjectAssignmentBDO sa, SubjectAssignment sabdo)
 {
     sabdo.Deactivated = (bool)sa.Deactivated;
     sabdo.GradeSectionCode = sa.GradeSectionCode;
     sabdo.RoomId = sa.RoomId;
     sabdo.SubjectAssignmentsID = sa.SubjectAssignmentsID;
     sabdo.SubjectCode = sa.SubjectCode;
     sabdo.SY = sa.SY;
     sabdo.TeacherId = sa.TeacherId;
     sabdo.TimeSlotCode = sa.TimeSlotCode;
 }
Пример #6
0
        public List<SubjectAssignmentBDO> GetAllSchedules()
        {
            SchoolYearDAO syd = new SchoolYearDAO();
            currentSY = syd.CurrentSY();
            List<SubjectAssignment> saList = new List<SubjectAssignment>();
            List<SubjectAssignmentBDO> sabdoList = new List<SubjectAssignmentBDO>();
            try { 
            using (var DCEnt = new DCFIEntities())
            {
                var allSchedule = (from sched in DCEnt.SubjectAssignments
                                   where sched.Deactivated == false && sched.SY.Equals(currentSY)
                                   select sched).ToList<SubjectAssignment>();
                saList = allSchedule;



                foreach (SubjectAssignment sa in saList)
                {
                    SubjectAssignmentBDO saBDO = new SubjectAssignmentBDO();
                    ConvertSubjectAssignmentToSubjectAssignmentBDO(sa, saBDO);
                    sabdoList.Add(saBDO);
                }
            }
            }
            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 sabdoList;
        }
Пример #7
0
        public Boolean CreateSchedule(ref SubjectAssignmentBDO sched, ref string message)
        {
            message = "Schedule Added Successfully";
            bool ret = true;

            SubjectAssignment sa = new SubjectAssignment();
            try {
            ConvertSubjectAssignmentBDOToSubjectAssignment(sched, sa);
            using (var DCEnt = new DCFIEntities())
            {
                DCEnt.SubjectAssignments.Add(sa);
                DCEnt.Entry(sa).State = System.Data.Entity.EntityState.Added;
                int num = DCEnt.SaveChanges();
                sched.SubjectAssignmentsID = sa.SubjectAssignmentsID;

                if (num == 0)
                {
                    ret = false;
                    message = "Adding of Schedule 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;
        }
Пример #8
0
        public List<SubjectAssignmentBDO> GetScheduleOfSection(int GradeSectionCode)
        {
            List<SubjectAssignment> saList = new List<SubjectAssignment>();
            List<SubjectAssignmentBDO> sabdoList = new List<SubjectAssignmentBDO>();
            try {
              using (var DCEnt = new DCFIEntities())
            {
                var allSchedule = (from sched in DCEnt.SubjectAssignments
                                   where sched.GradeSectionCode == GradeSectionCode
                                   select sched).ToList<SubjectAssignment>();
                saList = allSchedule;


                foreach (SubjectAssignment sa in saList)
                {
                    SubjectAssignmentBDO saBDO = new SubjectAssignmentBDO();
                    ConvertSubjectAssignmentToSubjectAssignmentBDO(sa, saBDO);
                    sabdoList.Add(saBDO);
                }
            }
        }
            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 sabdoList;
        }
Пример #9
0
        public List<SubjectAssignmentBDO> GetTeacherLoad(string TeacherId, string schoolYear)
        {
            List<SubjectAssignment> saList = new List<SubjectAssignment>();
            List<SubjectAssignmentBDO> sabdoList = new List<SubjectAssignmentBDO>();
            try{ 
            using (var DCEnt = new DCFIEntities())
            {
                var allSchedule = (from sched in DCEnt.SubjectAssignments
                                   where sched.SY == schoolYear && sched.TeacherId.Equals(TeacherId)
                                   select sched).ToList<SubjectAssignment>();
                saList = allSchedule;



                foreach (SubjectAssignment sa in saList)
                {
                    SubjectAssignmentBDO saBDO = new SubjectAssignmentBDO();
                    ConvertSubjectAssignmentToSubjectAssignmentBDO(sa, saBDO);
                    sabdoList.Add(saBDO);
                }
            }
            }
            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 sabdoList;
        }
Пример #10
0
        public Boolean UpdateSchedule(ref SubjectAssignmentBDO schedBDO, ref string message)
        {
            message = "Schedule updated successfully.";
            Boolean ret = true;
            try { 
            using (var DCEnt = new DCFIEntities())
            {
                var schedID = schedBDO.SubjectAssignmentsID;
                SubjectAssignment schedInDB = (from s in DCEnt.SubjectAssignments
                                               where s.SubjectAssignmentsID == schedID
                                               select s).FirstOrDefault();
                if (schedInDB == null)
                {
                    throw new Exception("No schedule with ID " + schedBDO.SubjectAssignmentsID);
                }
                DCEnt.SubjectAssignments.Remove(schedInDB);
                ConvertSubjectAssignmentBDOToSubjectAssignment(schedBDO, schedInDB);

                DCEnt.SubjectAssignments.Attach(schedInDB);
                DCEnt.Entry(schedInDB).State = System.Data.Entity.EntityState.Modified;
                int num = DCEnt.SaveChanges();

                if (num == 0)
                {
                    ret = false;
                    message = "No schedules 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;
        }
Пример #11
0
 public SubjectAssignmentBDO GetScheduleInfo(int sAi)
 {
     SchoolYearDAO syd = new SchoolYearDAO();
     currentSY = syd.CurrentSY();
     SubjectAssignment schedInfo = new SubjectAssignment();
     SubjectAssignmentBDO saBDO = new SubjectAssignmentBDO();
     try { 
     using (var DCEnt = new DCFIEntities())
     {
         schedInfo = (from sched in DCEnt.SubjectAssignments
                      where sched.Deactivated == false && sched.SY.Equals(currentSY) && sched.SubjectAssignmentsID == sAi
                      select sched).FirstOrDefault<SubjectAssignment>();
             
         ConvertSubjectAssignmentToSubjectAssignmentBDO(schedInfo, saBDO);
     }
     }
     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 saBDO;
 }
Пример #12
0
        public void TranslateScheduleToScheduleBDO(SubjectAssignment schedule, SubjectAssignmentBDO sabdo)
        {
            sabdo.Deactivated = false;

            sabdo.GradeSectionCode = schedule.GradeSectionCode;
            sabdo.RoomId = schedule.RoomId;
            sabdo.SubjectAssignmentsID = schedule.SubjectAssignmentsID;
            sabdo.SubjectCode = schedule.SubjectCode;
            sabdo.SY = schedule.SY;
            sabdo.TeacherId = schedule.TeacherId;
            sabdo.TimeSlotCode = schedule.TimeSlotCode;
        }
Пример #13
0
        public void TranslateScheduleBDOToSchedule(SubjectAssignmentBDO sabdo, SubjectAssignment sched)
        {
            GradeSectionService gs = new GradeSectionService();
            GradeSection g = new GradeSection();
            gs.TranslateGradeSectionBDOToGradeSection(sabdo.GradeSection, g);
            sched.GradeSection = g;
            sched.Section = g.Section;
            sched.GradeLevel = g.GradeLevel;
            sched.Class = (int)g.Class;

            RoomService rs = new RoomService();
            Room r = new Room();
            rs.TranslateRoomBDOtoRoomDTO(sabdo.Room, r);
            sched.Room = r;
            sched.RoomCode = r.RoomCode;

            SubjectService ss = new SubjectService();
            Subject s = new Subject();
            ss.TranslateSubjectBDOToSubject(sabdo.Subject, s);
            sched.Subject = s;

            TeacherService ts = new TeacherService();
            Teacher t = new Teacher();
            ts.TranslateTeacherBDOToTeacherDTO(sabdo.Teacher, t);
            sched.Teacher = t;
            if (t.MiddleName == String.Empty)
                sched.TeacherName = t.LastName + ", " + t.FirstName;
            else
                sched.TeacherName = t.LastName + ", " + t.FirstName + " " + t.MiddleName.Substring(0, 1) + ".";

            TimeslotService times = new TimeslotService();
            Timeslot time = new Timeslot();
            times.TranslateTimeslotBDOToTimeslotDTo(sabdo.Timeslot, time);
            sched.Timeslot = time;
            sched.Timestart = time.TimeStart;
            sched.TimeEnd = time.TimeEnd;
            sched.Days = time.Days;

            sched.Deactivated = sabdo.Deactivated;
            sched.GradeSectionCode = sabdo.GradeSectionCode;
            sched.RoomId = sabdo.RoomId;
            sched.SubjectAssignmentsID = sabdo.SubjectAssignmentsID;
            sched.SubjectCode = sabdo.SubjectCode;

            sched.SY = sabdo.SY;
            sched.TeacherId = sabdo.TeacherId;
            sched.TimeSlotCode = sabdo.TimeSlotCode;

            sched.TimeslotInfo = time.Days + " " + time.TimeStart + "-" + time.TimeEnd;
            sched.SubjectInfo = sabdo.SubjectCode + " " + sched.Section + " " + sched.TimeslotInfo;

            sched.SubjectDescription = s.Description;
        }