public async Task <PartialViewResult> TimetableSearchResult(string id) { List <Schedule> schedules; ScheduleViewModel timetable = new ScheduleViewModel(); timetable.classId = id; using (var appContext = new TimetableEntities()) { if (appContext.Class.FirstOrDefault(a => a.id.Replace(" ", "") == id) != null) { schedules = appContext.Schedule.ToList(); List <Schedule> searchedTimetable = schedules.Where(a => a.class_id.Replace(" ", "") == timetable.classId).ToList(); foreach (var tmp in searchedTimetable) { if (tmp.day_of_week.Replace(" ", "") == "пн") { LessonViewModel lessonViewModel = new LessonViewModel(); lessonViewModel.schedule = tmp; lessonViewModel.subject = appContext.Subject.FirstOrDefault(a => a.id == tmp.subject_id); lessonViewModel.teacher = await UserManager.FindByIdAsync(tmp.teacher_id); timetable.mondayLessons.Add(lessonViewModel); } if (tmp.day_of_week.Replace(" ", "") == "вт") { LessonViewModel lessonViewModel = new LessonViewModel(); lessonViewModel.schedule = tmp; lessonViewModel.subject = appContext.Subject.FirstOrDefault(a => a.id == tmp.subject_id); lessonViewModel.teacher = await UserManager.FindByIdAsync(tmp.teacher_id); timetable.tuesdayLessons.Add(lessonViewModel); } if (tmp.day_of_week.Replace(" ", "") == "ср") { LessonViewModel lessonViewModel = new LessonViewModel(); lessonViewModel.schedule = tmp; lessonViewModel.subject = appContext.Subject.FirstOrDefault(a => a.id == tmp.subject_id); lessonViewModel.teacher = await UserManager.FindByIdAsync(tmp.teacher_id); timetable.wednesdayLessons.Add(lessonViewModel); } if (tmp.day_of_week.Replace(" ", "") == "чт") { LessonViewModel lessonViewModel = new LessonViewModel(); lessonViewModel.schedule = tmp; lessonViewModel.subject = appContext.Subject.FirstOrDefault(a => a.id == tmp.subject_id); lessonViewModel.teacher = await UserManager.FindByIdAsync(tmp.teacher_id); timetable.thursdayLessons.Add(lessonViewModel); } if (tmp.day_of_week.Replace(" ", "") == "пт") { LessonViewModel lessonViewModel = new LessonViewModel(); lessonViewModel.schedule = tmp; lessonViewModel.subject = appContext.Subject.FirstOrDefault(a => a.id == tmp.subject_id); lessonViewModel.teacher = await UserManager.FindByIdAsync(tmp.teacher_id); timetable.fridayLessons.Add(lessonViewModel); } } timetable.countDifficulty(); return(PartialView(timetable)); } else { return(PartialView("TimetableNotFound")); } } }