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));
}
