public Boolean UpdateTimeslot(ref Timeslot timeslot, ref string message) { message = String.Empty; TimeslotBDO tBDO = new TimeslotBDO(); TranslateTimeslotDTOToTimeslotBDo(timeslot, tBDO); return timeslotLogic.UpdateTimeslot(ref tBDO, ref message); }
public Boolean CreateTimeslot(ref Timeslot timeslot, ref string message) { message = String.Empty; TimeslotBDO tbdo = new TimeslotBDO(); TranslateTimeslotDTOToTimeslotBDo(timeslot, tbdo); return timeslotLogic.CreateTimeslot(ref tbdo, ref message); }
public void TranslateTimeslotDTOToTimeslotBDo(Timeslot timeslot, TimeslotBDO tBDO) { tBDO.TimeSlotCode = timeslot.TimeSlotCode; tBDO.TimeStart = timeslot.TimeStart; tBDO.TimeEnd = timeslot.TimeEnd; tBDO.Days = timeslot.Days; tBDO.TotalMins = timeslot.TotalMins; }
public void TranslateTimeslotBDOToTimeslotDTo(TimeslotBDO tBDO, Timeslot timeslot) { timeslot.TimeSlotCode = tBDO.TimeSlotCode; timeslot.TimeStart = tBDO.TimeStart; timeslot.TimeEnd = tBDO.TimeEnd; timeslot.Days = tBDO.Days; timeslot.TotalMins = tBDO.TotalMins; timeslot.TimeSlotInfo = tBDO.Days + " " + tBDO.TimeStart + "-" + tBDO.TimeEnd; }
public Timeslot GetTimeslot(string timeslotCode) { TimeslotBDO tbdo = new TimeslotBDO(); tbdo = timeslotLogic.GetTimeslot(timeslotCode); Timeslot t = new Timeslot(); TranslateTimeslotBDOToTimeslotDTo(tbdo, t); return t; }
public List<Timeslot> GetAllTimeslots() { List<TimeslotBDO> tBDOList = timeslotLogic.GetAllTimeslots(); List<Timeslot> allTimeslot = new List<Timeslot>(); foreach (TimeslotBDO tBDO in tBDOList) { Timeslot t = new Timeslot(); TranslateTimeslotBDOToTimeslotDTo(tBDO, t); allTimeslot.Add(t); } return allTimeslot; }
private void gvTimeSlot_SelectionChanged(object sender, EventArgs e) { int selectedIndex = gvTimeSlot.CurrentRow.Index; if (selectedIndex >= 0) { string tCode = gvTimeSlot.Rows[selectedIndex].Cells["TimeslotCode"].Value.ToString(); List<Timeslot> item = new List<Timeslot>(); item = timeslotList.FindAll(x => x.TimeSlotCode.ToString() == tCode); timeslotSelected = new Timeslot(); timeslotSelected = (Timeslot)item[0]; } }
private void SetTimeSlotCombo() { //Get timeslot that are already assigned List<Timeslot> usedtslot = new List<Timeslot>(); foreach (SubjectAssignment sch in schedules) { if (sch.GradeLevel == gradelevel && sch.GradeSectionCode == int.Parse(cmbSection.SelectedValue.ToString())) { Timeslot ts = new Timeslot(); ts.TimeSlotCode = sch.TimeSlotCode; ts.TimeSlotInfo = sch.TimeslotInfo; ts.TimeStart = sch.Timestart; ts.TimeEnd = sch.TimeEnd; ts.Days = sch.Days; usedtslot.Add(ts); } } //get the list of all timeslots availTimeSlot = new List<Timeslot>(timeslots); //timeslots; //Remove timeslots that are already been used if (usedtslot.Count > 0) { foreach (Timeslot t in usedtslot) { string times = t.TimeSlotCode; availTimeSlot.RemoveAll(a => a.TimeSlotCode == times); } } //Remove timeslots that are conflicting to other schedules #region ConflictTimeslotsFilter List<Timeslot> compareTimeSlot = new List<Timeslot>(); List<String> tCodelist; foreach (Timeslot t in usedtslot) { string[] dayArray = t.Days.Split(','); int t_TimeStart = timeStringToInt(t.TimeStart); int t_TimeEnd = timeStringToInt(t.TimeEnd); compareTimeSlot = availTimeSlot; tCodelist = new List<String>(); foreach (Timeslot ct in compareTimeSlot) { foreach (string sDay in dayArray) { if (ct.Days.Contains(sDay)) { int ct_TimeStart = timeStringToInt(ct.TimeStart); int ct_TimeEnd = timeStringToInt(ct.TimeEnd); if ((ct_TimeStart <= t_TimeStart && ct_TimeEnd <= t_TimeEnd && ct_TimeEnd > t_TimeStart) || (ct_TimeStart >= t_TimeStart && ct_TimeEnd <= t_TimeEnd) || (ct_TimeStart >= t_TimeStart && ct_TimeStart < t_TimeEnd && ct_TimeEnd > t_TimeEnd)) { tCodelist.Add(ct.TimeSlotCode); } } } } //Remove conflicted schedules against the used schedules foreach (string code in tCodelist) { availTimeSlot.RemoveAll(x => x.TimeSlotCode == code); compareTimeSlot = null; } } #endregion //assign new list of Timeslot on the dropdown box if (availTimeSlot.Count > 0) { cmbTimeslot.Enabled = true; cmbTimeslot.ValueMember = "TimeslotCode"; cmbTimeslot.DisplayMember = "TimeslotInfo"; cmbTimeslot.DataSource = availTimeSlot; cmbTimeslot.SelectedIndex = 0; } }
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(); } }
private void loadAvailableTeachers() { List<SubjectAssignment> roomSchedule = new List<SubjectAssignment>(schedules.FindAll(s => s.SY == GlobalClass.currentsy)); Timeslot selectedTimeslot = new Timeslot(); string szVal = string.Empty; szVal = cmbTimeslot.SelectedValue.ToString(); selectedTimeslot = timeslots.Find(x => x.TimeSlotCode == szVal); string[] dayArray = selectedTimeslot.Days.Split(','); int selected_TimeStart = timeStringToInt(selectedTimeslot.TimeStart); int selected_TimeEnd = timeStringToInt(selectedTimeslot.TimeEnd); availTeach = new List<Teacher>(teachers); foreach (Teacher tc in teachers) { foreach (SubjectAssignment rS in roomSchedule) { if (rS.TeacherId == tc.TeacherId) { foreach (string sDay in dayArray) { if (rS.Days.Contains(sDay)) { int compared_TimeStart = timeStringToInt(rS.Timestart); int compared_TimeEnd = timeStringToInt(rS.TimeEnd); if ((compared_TimeStart <= selected_TimeStart && compared_TimeEnd <= selected_TimeEnd && compared_TimeEnd > selected_TimeStart) || (compared_TimeStart >= selected_TimeStart && compared_TimeEnd <= selected_TimeEnd) || (compared_TimeStart >= selected_TimeStart && compared_TimeStart < selected_TimeEnd && compared_TimeEnd > selected_TimeEnd)) { availTeach.RemoveAll(x => x.TeacherId == rS.TeacherId); } } } } } } if (availTeach.Count > 0) { cmbTeacher.Enabled = true; cmbTeacher.ValueMember = "TeacherId"; cmbTeacher.DisplayMember = "TeacherName"; if (academicSubject == true) { academicTeachers = new List<Teacher>(teachers.FindAll(x => x.Academic == true)); cmbTeacher.DataSource = availTeach; } else { cmbTeacher.DataSource = availTeach; } //cmbTeacher.DataSource = availTeach; } }
private void loadAvailableRooms() { List<SubjectAssignment> roomSchedule = new List<SubjectAssignment>(schedules.FindAll(s => s.SY == GlobalClass.currentsy)); Timeslot selectedTimeslot = new Timeslot(); string szVal = string.Empty; cmbTimeslot.ValueMember = "TimeSlotCode"; cmbTimeslot.DisplayMember = "TimeSlotInfo"; szVal = cmbTimeslot.SelectedValue.ToString(); selectedTimeslot = timeslots.Find(x => x.TimeSlotCode == szVal); string[] dayArray = selectedTimeslot.Days.Split(','); int selected_TimeStart = timeStringToInt(selectedTimeslot.TimeStart); int selected_TimeEnd = timeStringToInt(selectedTimeslot.TimeEnd); availRooms = new List<Room>(rooms); foreach (Room rm in rooms) { foreach (SubjectAssignment rS in roomSchedule) { if (rS.RoomId == rm.RoomId) { foreach (string sDay in dayArray) { if (rS.Days.Contains(sDay)) { int compared_TimeStart = timeStringToInt(rS.Timestart); int compared_TimeEnd = timeStringToInt(rS.TimeEnd); if ((compared_TimeStart <= selected_TimeStart && compared_TimeEnd <= selected_TimeEnd && compared_TimeEnd > selected_TimeStart) || (compared_TimeStart >= selected_TimeStart && compared_TimeEnd <= selected_TimeEnd) || (compared_TimeStart >= selected_TimeStart && compared_TimeStart < selected_TimeEnd && compared_TimeEnd > selected_TimeEnd)) { availRooms.RemoveAll(x => x.RoomId == rS.RoomId); } } } } } } if (availRooms.Count > 0) { cmbRoom.Enabled = true; cmbRoom.ValueMember = "RoomId"; cmbRoom.DisplayMember = "RoomCode"; cmbRoom.DataSource = availRooms; } }
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; }
private void SaveUser() { try { Boolean ret = false; string message = String.Empty; List<String> list = new List<String>(); if (chkSunday.Checked == true) list.Add("Sun"); if (chkMonday.Checked == true) list.Add("Mon"); if (chkTuesday.Checked == true) list.Add("Tue"); if (chkWednesday.Checked == true) list.Add("Wed"); if (chkThursday.Checked == true) list.Add("Thu"); if (chkFriday.Checked == true) list.Add("Fri"); if (chkSaturday.Checked == true) list.Add("Sat"); string szDays = string.Empty; szDays = string.Join(",", list.ToArray()); DateTime? dtTimeStart = DateTime.Now; DateTime? dtTimeEnd = DateTime.Now; dtTimeStart = tPStart.Value; dtTimeEnd = tpEnd.Value; ITimeslotService tService = new TimeslotService(); Timeslot timeslot = new Timeslot() { TimeSlotCode = txtTimeslotCode.Text, TimeStart = dtTimeStart.Value.ToString("hh:mm tt"), TimeEnd = dtTimeEnd.Value.ToString("hh:mm tt"), Days = szDays }; if (Op.Equals("edit")) { timeslot.TimeSlotCode = SelectedTimeslot.TimeSlotCode; ret = tService.UpdateTimeslot(ref timeslot, ref message); Log("U", "Timeslots", timeslot); } else { ret = tService.CreateTimeslot(ref timeslot, ref message); Log("C", "Timeslots", timeslot); } MessageBox.Show("Saved Successfully!"); Close(); } catch (Exception ex) { MessageBox.Show("Error: " + ex.ToString()); } }