public async Task <IActionResult> Index(string teacherAcademicRank, string teacherDegree, string searchString) { //IQueryable<Teacher> teachers = _context.Teacher.AsQueryable(); IEnumerable <Teacher> teachers = _context.Teacher; IQueryable <string> rankQuery = _context.Teacher.Where(m => m.AcademicRank != null).OrderBy(m => m.AcademicRank).Select(m => m.AcademicRank).Distinct(); IQueryable <string> degreeQuery = _context.Teacher.Where(m => m.Degree != null).OrderBy(m => m.Degree).Select(m => m.Degree).Distinct(); if (!string.IsNullOrEmpty(teacherAcademicRank)) { teachers = teachers.Where(x => x.AcademicRank == teacherAcademicRank); } if (!string.IsNullOrEmpty(teacherDegree)) { teachers = teachers.Where(x => x.Degree == teacherDegree); } if (!string.IsNullOrEmpty(searchString)) { teachers = teachers.ToList().Where(s => s.FullName.ToLower().Contains(searchString.ToLower())); //teachers = teachers.Where(s => s.FullName.Contains(searchString)); //ne raboti } var teacherViewModel = new TeacherFilterViewModel { Ranges = new SelectList(await rankQuery.ToListAsync()), Degrees = new SelectList(await degreeQuery.ToListAsync()), Teachers = teachers.ToList() }; return(View(teacherViewModel)); }
// GET: Teachers public async Task <IActionResult> Index(string SearchFirstName, string SearchLastName, string SearchDegree, string SearchAcademicRank) { IQueryable <Teacher> teachers = _context.Teacher.AsQueryable(); if (!string.IsNullOrEmpty(SearchFirstName)) { teachers = teachers.Where(s => s.FirstName.Contains(SearchFirstName)); } if (!string.IsNullOrEmpty(SearchLastName)) { teachers = teachers.Where(s => s.LastName.Contains(SearchLastName)); } if (!string.IsNullOrEmpty(SearchDegree)) { teachers = teachers.Where(s => s.Degree.Contains(SearchDegree)); } if (!string.IsNullOrEmpty(SearchAcademicRank)) { teachers = teachers.Where(s => s.AcademicRank.Contains(SearchAcademicRank)); } var teacherVM = new TeacherFilterViewModel { Teachers = await teachers.ToListAsync() }; return(View(teacherVM)); }
public async Task <IActionResult> List() { var studentListViewModel = new TeacherListViewModel { Teachers = new List <TeacherMvcDto>() }; var teacherFilterViewModel = new TeacherFilterViewModel { Genders = await _optionManager.GetGenders() }; ViewBag.TeacherFilterViewModel = teacherFilterViewModel; return(View(studentListViewModel)); }
public async Task <IActionResult> List([FromForm] TeacherFilterViewModel teacherFilterViewModel) { var teacherListViewModel = new TeacherListViewModel(); var teacherListResult = await _teacherManager.GetList(_mapper.Map <TeacherFilterModel>(teacherFilterViewModel)); if (teacherListResult.IsOk) { var teachers = _mapper.Map(teacherListResult.Data.Teachers, new List <TeacherMvcDto>()); teacherListViewModel.Teachers = teachers; } var timeTextResult = await _teacherManager.GetCachedData(); teacherFilterViewModel.Genders = await _optionManager.GetGenders(); teacherListViewModel.TimeText = timeTextResult.Data; teacherListViewModel.ReturnMessage = Resource.OperationCompletedSuccessfully; ViewBag.TeacherFilterViewModel = teacherFilterViewModel; return(View(teacherListViewModel)); }
// GET: Teachers public async Task <IActionResult> Index(string teacherName, string teacherDegree, string teacherAcRank) { IQueryable <Teacher> professors = _context.Teacher.AsQueryable(); IQueryable <String> teacherDegreeQuery = _context.Teacher .OrderBy(m => m.Degree).Select(m => m.Degree).Distinct(); IQueryable <String> teacherAcRankQuery = _context.Teacher .OrderBy(m => m.AcademicRank).Select(m => m.AcademicRank).Distinct(); if (!String.IsNullOrEmpty(teacherName)) { professors = professors.Where(s => s.FirstName.Contains(teacherName) || s.LastName.Contains(teacherName)); } if (!String.IsNullOrEmpty(teacherDegree)) { professors = professors.Where(x => x.Degree == teacherDegree); } if (!String.IsNullOrEmpty(teacherAcRank)) { professors = professors.Where(x => x.AcademicRank == teacherAcRank); } professors = professors.Include(m => m.FirstTeacherCourses) .Include(m => m.SecondTeacherCourses); var teacherFilterViewModel = new TeacherFilterViewModel { Professors = await professors.ToListAsync(), Degrees = new SelectList(await teacherDegreeQuery.ToListAsync()), AcademicRanks = new SelectList(await teacherAcRankQuery.ToListAsync()) }; return(View(teacherFilterViewModel)); }
// GET: Teachers public async Task <IActionResult> Index(string teacherAcademicRank, string teacherDegree, string searchFullName) { var teachers = from m in _context.Teacher select m; var t = from m in _context.Teacher select m; IQueryable <string> rankQuery = _context.Teacher.OrderBy(m => m.AcademicRank).Select(m => m.AcademicRank).Distinct(); IQueryable <string> degreeQuery = _context.Teacher.OrderBy(m => m.Degree).Select(m => m.Degree).Distinct(); if (!string.IsNullOrEmpty(teacherAcademicRank)) { teachers = teachers.Where(x => x.AcademicRank == teacherAcademicRank); } if (!string.IsNullOrEmpty(teacherDegree)) { teachers = teachers.Where(x => x.Degree == teacherDegree); } IEnumerable <Teacher> datalist = teachers as IEnumerable <Teacher>; if (!string.IsNullOrEmpty(searchFullName)) { datalist = datalist.Where(s => s.FullName.ToLower().Contains(searchFullName.ToLower())); } var teacherViewModel = new TeacherFilterViewModel { AcademicRanges = new SelectList(await rankQuery.ToListAsync()), Degrees = new SelectList(await degreeQuery.ToListAsync()), Teachers = datalist.ToList() }; return(View(teacherViewModel)); }