public void TranslateSubjectToSubjectBDO(Subject sub, SubjectBDO sbdo)
{
LearningAreaService las = new LearningAreaService();
LearningAreaBDO lb = new LearningAreaBDO();
sbdo.SubjectID = sub.SubjectID;
sbdo.Description = sub.Description;
sbdo.GradeLevel = sub.GradeLevel;
sbdo.LearningAreaCode = sub.LearningAreaCode;
sbdo.SubjectCode = sub.SubjectCode;
sbdo.MPW = sub.MPW;
sbdo.Academic = sub.Academic;
las.TranslateLearningAreaToLearningAreaBDO(sub.LArea, lb);
sbdo.LearningArea = lb;
}
public void TranslateCurrSub(Subject s, CurriculumSubject cs)
{
LearningAreaService las = new LearningAreaService();
LearningArea la = new LearningArea();
SubjectService ss = new SubjectService();
Subject subj = new Subject();
subj = ss.GetSubject(s.SubjectCode);
cs.Subj = s;
cs.SubjectCode = s.SubjectCode;
la = las.GetLearningArea(s.LearningAreaCode);
cs.Academic = la.Academic;
cs.RatePerUnit = la.RatePerUnit;
cs.Units = la.Units;
cs.SubjectDescription = subj.Description;
cs.GradeLevel = subj.GradeLevel;
cs.LearningAreaCode = subj.LearningAreaCode;
}
public List<Subject> ToSubjectList(List<SubjectBDO> sList)
{
List<Subject> slist = new List<Subject>();
foreach (SubjectBDO s in sList)
{
Subject sbdo = new Subject();
sbdo.SubjectID = s.SubjectID;
sbdo.LearningAreaCode = s.LearningAreaCode;
sbdo.Description = s.Description;
sbdo.GradeLevel = s.GradeLevel;
sbdo.SubjectCode = s.SubjectCode;
sbdo.Academic = s.Academic;// s.LearningArea.Academic ?? false;
sbdo.MPW = s.MPW;
slist.Add(sbdo);
}
return slist;
}
private void TranslateCurriculumSubjectBDOToCurriculumSubject(CurriculumSubjectBDO cs, CurriculumSubject csbdo)
{
Subject sbdo = new Subject();
SubjectService ss = new SubjectService();
LearningAreaService las = new LearningAreaService();
LearningArea la = new LearningArea();
csbdo.CurriculumSubjectsID = cs.CurriculumSubjectsID;
csbdo.CurriculumCode = cs.CurriculumCode;
csbdo.CurrSubCode = cs.CurrSubCode;
csbdo.Deactivated = cs.Deactivated;
ss.TranslateSubjectBDOToSubject(cs.Sub, sbdo);
csbdo.Subj = sbdo;
csbdo.SubjectCode = cs.SubjectCode;
la = las.GetLearningArea(sbdo.LearningAreaCode);
csbdo.Academic = la.Academic;
csbdo.RatePerUnit = la.RatePerUnit;
csbdo.Units = la.Units;
csbdo.SubjectDescription = sbdo.Description;
csbdo.GradeLevel = sbdo.GradeLevel;
csbdo.LearningAreaCode = sbdo.LearningAreaCode;
}
public Subject GetSubject(string subjectCode)
{
Subject s = new Subject();
TranslateSubjectBDOToSubject(slogic.GetSubject(subjectCode), s);
return s;
}
private void gvSubjects_UserAddedRow(object sender, Telerik.WinControls.UI.GridViewRowEventArgs e)
{
int index = this.gvSubjects.RowCount - 1;
if (oldSubjects.Exists(x => x.GradeLevel == gLevelSelected.GradeLev) == true)
{
Subject returnedSub = new Subject();
returnedSub = oldSubjects.Find(x => x.GradeLevel == gLevelSelected.GradeLev);
subjects[index].SubjectID = returnedSub.SubjectID;
subjects[index].SubjectCode = returnedSub.SubjectCode;
subjects[index].MPW = returnedSub.MPW;
oldSubjects.RemoveAll(x => x.SubjectCode == returnedSub.SubjectCode);
}
else
{
subjects[index].SubjectID = 0;
subjects[index].SubjectCode = this.txtLearningAreaCode.Text + gLevelSelected.GradeLev;
}
subjects[index].LearningAreaCode = this.txtLearningAreaCode.Text;
subjects[index].GradeLevel = gLevelSelected.GradeLev;
gvSubjects.DataSource = subjects1;
gvSubjects.DataSource = subjects;
gLevelSelected = null;
}
private void gvSubjects_ValueChanging(object sender, ValueChangingEventArgs e)
{
if (gvSubjects.CurrentRow.Index >= 0)
{
oldsub = new Subject()
{
Description = subjects[gvSubjects.CurrentRow.Index].Description,
GradeLevel = subjects[gvSubjects.CurrentRow.Index].GradeLevel,
LArea = subjects[gvSubjects.CurrentRow.Index].LArea,
LearningAreaCode = subjects[gvSubjects.CurrentRow.Index].LearningAreaCode,
SubjectCode = subjects[gvSubjects.CurrentRow.Index].SubjectCode,
SubjectID = subjects[gvSubjects.CurrentRow.Index].SubjectID,
MPW=subjects[gvSubjects.CurrentRow.Index].MPW
};
oldSubjects.Add(oldsub);
if (e.NewValue != e.OldValue)
{
if (gvSubjects.CurrentColumn.Index == 3)
{
if (subjects.FindAll(x => x.GradeLevel == e.NewValue.ToString()).Count <= 0)
{
if (oldSubjects.Exists(x => x.GradeLevel == e.NewValue.ToString()) == true)
{
Subject returnedSub = new Subject();
returnedSub = oldSubjects.Find(x => x.GradeLevel == e.NewValue.ToString());
subjects[gvSubjects.CurrentRow.Index].SubjectID = returnedSub.SubjectID;
subjects[gvSubjects.CurrentRow.Index].SubjectCode = returnedSub.SubjectCode;
subjects[gvSubjects.CurrentRow.Index].MPW = returnedSub.MPW;
oldSubjects.RemoveAll(x => x.SubjectCode == returnedSub.SubjectCode);
}
else
{
subjects[gvSubjects.CurrentRow.Index].SubjectID = 0;
subjects[gvSubjects.CurrentRow.Index].SubjectCode = this.txtLearningAreaCode.Text + e.NewValue.ToString();
}
subjects[gvSubjects.CurrentRow.Index].LearningAreaCode = this.txtLearningAreaCode.Text;
gvSubjects.Rows[gvSubjects.CurrentRow.Index].Cells[0].Value = this.txtLearningAreaCode.Text + e.NewValue.ToString();
subjects[gvSubjects.CurrentRow.Index].GradeLevel = e.NewValue.ToString();
}
else
{
MessageBox.Show("Subject for this Grade Level already exist");
e.Cancel = true;
}
}
}
}
}
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;
}
private void cmbSubject_SelectedValueChanged(object sender, EventArgs e)
{
if (cmbSubject.SelectedIndex >= 0)
{
Subject sb = new Subject();
sb = subjects.Find(x => x.SubjectCode == cmbSubject.SelectedValue.ToString());
academicSubject = sb.Academic;
//if (sb.Academic ==true)
//{
// academicTeachers = new List<Teacher>(teachers.FindAll(x => x.Academic == true));
// cmbTeacher.DataSource = academicTeachers;
//}
//else
//{
// cmbTeacher.DataSource = teachers;
//}
}
}
private void btnAddSchedule_Click(object sender, EventArgs e)
{
if (cmbGradeLevel.Text != string.Empty && cmbSection.Text != string.Empty && cmbTimeslot.Text != string.Empty &&
cmbSubject.Text != string.Empty && cmbTeacher.Text != string.Empty && cmbRoom.Text != string.Empty)
{
Timeslot t = new Timeslot();
t = timeslots.Find(x => x.TimeSlotCode == cmbTimeslot.SelectedValue.ToString());
GradeSection gs = new GradeSection();
gs = sections.Find(x => x.GradeSectionCode == sectioncode);
Subject su = new Subject();
su = subjects.Find(x => x.SubjectCode == cmbSubject.SelectedValue.ToString());
Room rm = new Room();
rm = rooms.Find(x => x.RoomId == Int32.Parse(cmbRoom.SelectedValue.ToString()));
Teacher tc = new Teacher();
tc = teachers.Find(x => x.TeacherId == cmbTeacher.SelectedValue.ToString());
SubjectAssignment sa = new SubjectAssignment();
sa.GradeLevel = cmbGradeLevel.SelectedValue.ToString() ;
sa.TeacherName = cmbTeacher.Text;
sa.SY = currentSY;
sa.Subject = su;
sa.SubjectCode = su.SubjectCode;
sa.SubjectDescription = su.Description;
sa.TimeslotInfo = t.TimeSlotInfo;
sa.TimeSlotCode = t.TimeSlotCode;
sa.Room = rm;
sa.RoomId = rm.RoomId;
sa.RoomCode = rm.RoomCode;
sa.Teacher = tc;
sa.TeacherId = tc.TeacherId;
sa.Section = section;
sa.GradeSection = gs;
sa.GradeSectionCode = gs.GradeSectionCode;
sa.Timeslot = t;
sa.Timestart = t.TimeStart;
sa.TimeEnd = t.TimeEnd;
sa.Days = t.Days;
sa.Deactivated = false;
createdSchedule.Add(sa);
schedules.Add(sa);
cmbTimeslot.DataSource = null;
availTimeSlot.RemoveAll(x => x.TimeSlotCode == t.TimeSlotCode);
if (availTimeSlot.Count > 0)
{
cmbTimeslot.DataSource = availTimeSlot;
cmbTimeslot.SelectedIndex = 0;
cmbTimeslot.Refresh();
}
else
cmbTimeslot.Enabled = false;
gvSchedule.DataSource = null;
gvSchedule.DataSource = schedules.FindAll(x => x.GradeSectionCode == sectioncode);
gvSchedule.Refresh();
// LoadSchedules();
}
}
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 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";
}
