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);
}
public Boolean CreateSchedule(ref SubjectAssignmentBDO schedBDO, ref string message)
{
Boolean ret = false;
ret = schedDAO.CreateSchedule(ref schedBDO, ref message);
return(ret);
}
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);
}
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;
}
public Boolean UpdateSchedule(List <SubjectAssignmentBDO> schedBDO, ref string message)
{
Boolean ret = true;
foreach (SubjectAssignmentBDO sa in schedBDO)
{
SubjectAssignmentBDO sab = sa;
schedDAO.UpdateSchedule(ref sab, ref message);
}
return(ret);
}
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);
}
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;
}
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);
}
public List <SubjectAssignmentBDO> GetAllSchedulesbySection(int iGradeSection)
{
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) && sched.GradeSectionCode == iGradeSection
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);
}
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);
}
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);
}
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);
}
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;
}
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;
}
