public static List <TeacherDTO.TeacherAndSubjectDTO> GetTeacherAndSubject() { var q = DAL.TeacherDAL.GetTeachers(); var q2 = GetUsers(); var q3 = DAL.SubjectToTeacherDAL.GetSubjectToTeachers(); List <TeacherDTO.TeacherAndSubjectDTO> teacherAndSubjecList = new List <TeacherDTO.TeacherAndSubjectDTO>() { }; foreach (var u in q2) { foreach (var t in q) { if (u.userId == t.TeacherId) { foreach (var s in q3) { if (s.TeacherId == u.userId) { TeacherDTO.TeacherAndSubjectDTO teacherAndSubjectDTO = new TeacherDTO.TeacherAndSubjectDTO() { userId = u.userId, firstName = u.firstName, lastName = u.lastName, city = u.city, street = u.street, numhouse = u.numhouse, phone = u.phone, password = u.password, email = u.email, GradesRange = s.GradesRange, PriceForLesson = (int)s.PriceForLesson, SubjectName = s.Subject, //DAL.SubjectToTeacherDAL.GetSubjects().Find(i => i.SubjectId == s.SubjectId).SubjectName, Qualifications = t.Qualifications }; //foreach (var i in DAL.SubjectToTeacherDAL.GetSubjects()) //{ // if (i.SubjectId == s.SubjectId) // { // teacherAndSubjectDTO.SubjectName = i.SubjectName; // } //}; teacherAndSubjecList.Add(teacherAndSubjectDTO); } } } } } return(teacherAndSubjecList); }
public IHttpActionResult getTeachersDaysAndHours(TeacherDTO.TeacherAndSubjectDTO TeacherAndSubjectDTO) { try { var q = BL.HoursForTeacherBL.getTeachersDaysAndHours(TeacherAndSubjectDTO); if (q != null) { return(Ok(q)); } else { return(NotFound()); } } catch { return(BadRequest()); } }
public static List <HoursForTeacherDTO.AvailableHours> getTeachersDaysAndHours(TeacherDTO.TeacherAndSubjectDTO teacherAndSubjectDTO) { List <HoursForTeacherDTO.AvailableHours> list = new List <HoursForTeacherDTO.AvailableHours>(); foreach (var teacher in DAL.HoursForTeacherDAL.GetHoursForTeacher()) { if (teacher.TeacherId == teacherAndSubjectDTO.userId) { int day = ConvertDay(teacher.Day); //GetDate(day); for (int i = 0; i < 12; i++) { DateTime newDate = GetDate(day).AddDays(i * 7); if (checkDate(newDate, teacher.TeacherId) == true) { HoursForTeacherDTO.AvailableHours AvailableHours = new HoursForTeacherDTO.AvailableHours() { Date = newDate, TeacherId = teacher.TeacherId, Day = teacher.Day, Starttime = teacher.Starttime.ToString(), timeInNUm = ConvertTime(teacher.Starttime.ToString()) }; list.Add(AvailableHours); } } } } return(list); }