public static string CheckDaySlotAvialability(string levels) { //var theValue = $('#Subject').val() + ";" + $('#Class').val() + ";" + $('#StratTimeHour').val() + ";" + $('#StratTimeMinute').val() + ";" + $('#Teacher').val() + ";" + $('#Day').val(); string[] theLEvel = levels.Split(';'); string subject = theLEvel[0]; string level = theLEvel[1]; string StartHourclinet = theLEvel[2]; string StartMinuteclinet = theLEvel[3]; string day1 = theLEvel[5]; // string day1 = theLEvel[5]; Day day = DayHelper.GetDay(day1); sdContext db = new sdContext(); List<TeachingDay> theTeachingDay = db.TeachingDay.Include("TeachingSubject").Where(a => a.TeachingClass.ClassName == level && a.theDay == day).ToList(); foreach (TeachingDay td in theTeachingDay) { string theClass = td.TeachingClass.ClassName; foreach (TeachingSubject ts in td.TeachingSubject) { String Day = ts.TeachingDay.theDay.ToString(); string theSubject = ts.SubjectName; string EndHour = ts.TeachingDay.EndTimeHour; string EndMinutes = ts.TeachingDay.EndTimeMinute; string StartHour = ts.TeachingDay.StratTimeHour; string StartMinutes = ts.TeachingDay.StratTimeMinute; StringBuilder EndHourEndMinutes = new StringBuilder(); EndHourEndMinutes.Append(EndHour); EndHourEndMinutes.Append(EndMinutes); int time = Convert.ToInt16(EndHourEndMinutes.ToString()); //= Convert.ToInt16(EndHour) + Convert.ToInt16(EndMinutes); StringBuilder StartHourStartMinuteclinets = new StringBuilder(); StartHourStartMinuteclinets.Append(StartHourclinet).Append(StartMinuteclinet); int timeClient = Convert.ToInt16(StartHourStartMinuteclinets.ToString());//Convert.ToInt16(StartHourclinet) + Convert.ToInt16(StartMinuteclinet); if (timeClient < time) { string theAlert = theSubject + " has been fixed for " + theClass + " which starts " + StartHour + ":" + StartMinutes + " ends at " + EndHour + ":" + EndMinutes; return theAlert; } } } return ""; }
public static string CheckStaffSlotAvialability(string levels) { string[] theLEvel = levels.Split(';'); string subject = theLEvel[0]; string level = theLEvel[1]; string StartHourclinet = theLEvel[2]; string StartMinuteclinet = theLEvel[3]; string teacher = theLEvel[4]; string day1 = theLEvel[5]; Day day = DayHelper.GetDay(day1); sdContext db = new sdContext(); List<Teacher> Teacher = db.Teacher.Include("TheTeachingClass").Where(a => a.TeacherName == teacher).ToList(); foreach (Teacher t in Teacher) { // List<TeachingSubject> theTeachingSubject = work.TeachingSubjectRepository.Get().ToList(); // List<TeachingClass> theTeachingClass = db.TeachingClass.Include("TheTeachingDay").Where(a => a.ClassName == level && a.Teacher.TeacherID == t.TeacherID).ToList(); //work.TeachingClassRepository.Get(a => a.ClassName == level).ToList(); List<TeachingClass> theTeachingClass = db.TeachingClass.Include("TheTeachingDay").Where(a => a.Teacher.TeacherID == t.TeacherID).ToList(); //work.TeachingClassRepository.Get(a => a.ClassName == level).ToList(); foreach (TeachingClass c in theTeachingClass) { string ClassName = c.ClassName; // foreach (TeachingDay td in c.TheTeachingDay) // { List<TeachingDay> theTeachingDay = db.TeachingDay.Include("TeachingSubject").Where(a => a.TeachingClass.TeachingClassID == c.TeachingClassID && a.theDay == day).ToList(); foreach (TeachingDay td in theTeachingDay) { foreach (TeachingSubject ts in td.TeachingSubject) { String Day = ts.TeachingDay.theDay.ToString(); string theSubject = ts.SubjectName; string EndHour = ts.TeachingDay.EndTimeHour; string EndMinutes = ts.TeachingDay.EndTimeMinute; string StartHour = ts.TeachingDay.StratTimeHour; string StartMinutes = ts.TeachingDay.StratTimeMinute; StringBuilder EndHourEndMinutes = new StringBuilder(); EndHourEndMinutes.Append(EndHour); EndHourEndMinutes.Append(EndMinutes); int time = Convert.ToInt16(EndHourEndMinutes.ToString()); //= Convert.ToInt16(EndHour) + Convert.ToInt16(EndMinutes); StringBuilder StartHourStartMinuteclinets = new StringBuilder(); StartHourStartMinuteclinets.Append(StartHourclinet).Append(StartMinuteclinet); int timeClient = Convert.ToInt16(StartHourStartMinuteclinets.ToString());//Conve if (theSubject == subject && timeClient < time) { string theAlert = theSubject + " " + "has been fixed for " + teacher + " on " + Day + " for class " + ClassName + " which starts at " + StartHour + ":" + StartMinutes + " and which ends at " + EndHour + ":" + EndMinutes; return theAlert; } if (theSubject != subject && timeClient < time) { string theAlert = theSubject + " " + "has been fixed for " + teacher + " on " + Day + " for class " + ClassName + " which starts at " + StartHour + ":" + StartMinutes + " and which ends at " + EndHour + ":" + EndMinutes; // string theAlert = teacher + " " + "has been fixed for this day and ends " + EndHour + ":" + EndMinutes; return theAlert; } } } } } return ""; }
public static List<List<TimeTable>> DisplayTimeTableCustomisedForStaff(int personID) { List<TimeTable> timeTable = new List<TimeTable>(); List<List<TimeTable>> timeTableOverAll = new List<List<TimeTable>>(); int thePersonID = Convert.ToInt16(personID); sdContext db = new sdContext(); // List<Teacher> Teacher = db.Teacher.Include("TheTeachingClass").ToList(); // foreach (Teacher t in Teacher) // { // List<TeachingClass> theTeachingClass = db.TeachingClass.Include("TheTeachingDay").Where(a =>a.ClassName == level).ToList(); //work.TeachingClassRepository.Get(a => a.ClassName == level).ToList(); //List<TeachingClass> theTeachingClass = db.TeachingClass.Include("TheTeachingDay").Where(a=> a.ClassName == level).ToList(); //work.TeachingClassRepository.Get(a => a.ClassName == level).ToList(); //foreach (TeachingClass c in theTeachingClass) //{ // string theTeacherName = c.Teacher.TeacherName; // string ClassName = c.ClassName; Day theDay = Day.SUNDAY; int counter = 0; for (int k = 0; k < 7; k++) { if (counter == 0) { theDay = Day.SUNDAY; } if (counter == 1) { theDay = Day.MONDAY; } if (counter == 2) { theDay = Day.TUESDAY; } if (counter == 3) { theDay = Day.WEDNESDAY; } if (counter == 4) { theDay = Day.THURSDAY; } if (counter == 5) { theDay = Day.FRIDAY; } if (counter == 6) { theDay = Day.SATURDAY; } // List<TeachingDay> theTeachingDay = db.TeachingDay.Include("TeachingSubject").Where(a => a.TeachingClass.TeachingClassID == c.TeachingClassID && a.theDay == theDay).OrderBy(a => a.StratTimeHour).ToList(); List<TeachingDay> theTeachingDay = db.TeachingDay.Include("TeachingSubject").Where(a => a.TeachingClass.Teacher.ThePersonID == thePersonID && a.theDay == theDay).OrderBy(a => a.StratTimeHour).ToList(); foreach (TeachingDay td in theTeachingDay) { foreach (TeachingSubject ts in td.TeachingSubject) { TimeTable tt = new TimeTable(); tt.Day = theDay.ToString(); tt.Class = ts.TeachingDay.TeachingClass.ClassName; string[] theSplitedName = ts.TeachingDay.TeachingClass.Teacher.TeacherName.Split(' ');// theTeacherName; tt.Subject = Truncate(ts.SubjectName, 21); if (theSplitedName.Count() >= 2) { tt.Teacher = theSplitedName[0] + " " + theSplitedName[2]; tt.Teacher = Truncate(tt.Teacher, 16); // tt.Teacher = tt.Teacher.Truncate(); } if (theSplitedName.Count() < 2) { tt.Teacher = theSplitedName[0] + " " + theSplitedName[2]; tt.Teacher = Truncate(tt.Teacher, 16); } //ts.TeachingDay.TeachingClass.Teacher.TeacherName;// theTeacherName; tt.StratTimeHour = ts.TeachingDay.StratTimeHour + ":" + ts.TeachingDay.StratTimeMinute; tt.EndTimeHour = ts.TeachingDay.EndTimeHour + ":" + ts.TeachingDay.EndTimeMinute; timeTable.Add(tt); } } if (timeTable.Count() != 0) { timeTableOverAll.Add(timeTable); timeTable = new List<TimeTable>(); } counter = counter + 1; } // break; // } //// } return timeTableOverAll; }