// GET: Teachers
public async Task <IActionResult> Index(string fname, string degr, string arank)
{
IQueryable <Teacher> teachers = _context.Teacher.AsQueryable();
if (!string.IsNullOrEmpty(fname))
{
teachers = teachers.Where(s => s.FirstName.Contains(fname));
}
if (!string.IsNullOrEmpty(degr))
{
teachers = teachers.Where(s => s.Degree.Contains(degr));
}
if (!string.IsNullOrEmpty(arank))
{
teachers = teachers.Where(s => s.AcademicRank.Contains(arank));
}
var teacherSearchVM = new TeacherSearchViewModel
{
Teachers = await teachers.ToListAsync(),
FName = fname,
degree = degr,
academicRank = arank
};
return(View(teacherSearchVM));
}
// GET: Teachers
public async Task <IActionResult> Index(string searchfirstname, string searchlastname, string searchacademicrank, string searchdegree)
{
IQueryable <Teacher> teachers = _context.Teacher.AsQueryable();
if (!string.IsNullOrEmpty(searchfirstname))
{
teachers = teachers.Where(x => x.FirstName == searchfirstname);
}
if (!string.IsNullOrEmpty(searchlastname))
{
teachers = teachers.Where(x => x.LastName == searchlastname);
}
if (!string.IsNullOrEmpty(searchacademicrank))
{
teachers = teachers.Where(x => x.AcademicRank == searchacademicrank);
}
if (!string.IsNullOrEmpty(searchdegree))
{
teachers = teachers.Where(x => x.Degree == searchdegree);
}
var teacherSearchVM = new TeacherSearchViewModel
{
Teachers = await teachers.ToListAsync(),
SearchFirstName = searchfirstname,
SearchLastName = searchlastname,
SearchAcademicRank = searchacademicrank,
SearchDegree = searchdegree
};
return(View(teacherSearchVM));
//return View(await _context.Teacher.ToListAsync());
}
public ActionResult Search(string Name, string designation)
{
TeacherSearchViewModel mod = new TeacherSearchViewModel(Name, designation);
ViewBag.Member = Name;
ViewBag.designation = designation;
return(View(mod));
}
public ActionResult Search()
{
TempData["AlertTask"] = null;
int pageno = 0;
if (HttpContext.Request.QueryString["pageno"] != null)
{
pageno = Convert.ToInt32(HttpContext.Request.QueryString["pageno"]) - 1;
}
TeacherSearchViewModel mod = new TeacherSearchViewModel("", "");
return(View(mod));
}
// GET: Teachers
public async Task <IActionResult> Index(string TeacherDegree, string TeacherAcademicRank, string SearchList)
{
IQueryable <Teacher> teachers = _context.Teacher.AsQueryable();
IQueryable <string> AcademicRankQuery = _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(SearchList))
{
string[] full = SearchList.Split(' ');
if (full.Length == 2)
{
var ime = full[0];
var prezime = full[1];
teachers = teachers.Where(s => s.FirstName.Contains(ime) && s.LastName.Contains(prezime)); // ako sme vnele ime I prezime za prebaruvanje
}
else
{
teachers = teachers.Where(s => s.FirstName.Contains(SearchList) || s.LastName.Contains(SearchList)); // ako sme vnele ime ILI prezime za prebaruvanje
}
}
if (!string.IsNullOrEmpty(TeacherDegree))
{
teachers = teachers.Where(s => s.Degree == TeacherDegree);
}
if (!string.IsNullOrEmpty(TeacherAcademicRank))
{
teachers = teachers.Where(s => s.AcademicRank == TeacherAcademicRank);
}
teachers = teachers.Include(n => n.FirstCourses).ThenInclude(n => n.FirstTeacher)
.Include(m => m.SecondCourses).ThenInclude(m => m.SecondTeacher);
var TeacherVM = new TeacherSearchViewModel
{
Degrees = new SelectList(await DegreeQuery.ToListAsync()),
AcademicRanks = new SelectList(await AcademicRankQuery.ToListAsync()),
Teachers = await teachers.ToListAsync()
};
return(View(TeacherVM));
}
//
// GET: /TeacherEntry/
public ActionResult Index(string sortOrder, string CurrentSort, int?page)
{
//var set_teacher_info = db.SET_TEACHER_INFO.Include("SET_TEACHER_DESIG");
//return View(set_teacher_info.ToList());
int pageSize = 10;
int pageIndex = 1;
pageIndex = page.HasValue ? Convert.ToInt32(page) : 1;
IPagedList <SET_TEACHER_INFO> teacher_info = null;
TeacherSearchViewModel teacherModel = null;
var teachers = db.SET_TEACHER_INFO.AsQueryable();
if (Request.QueryString.HasKeys() && !page.HasValue)
{
teacherModel = new TeacherSearchViewModel();
if (!string.IsNullOrEmpty(Request.QueryString["Search_Name"]))
{
teacherModel.Search_Name = Request.QueryString["Search_Name"];
teachers = teachers.Where(u => u.TEACHER_NAME.ToLower()
.Contains(teacherModel.Search_Name.ToLower()));
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Mobile"]))
{
teacherModel.Search_Mobile = Request.QueryString["Search_Mobile"];
teachers = teachers.Where(u => u.TEACHER_MOBILE.ToLower()
.Contains(teacherModel.Search_Mobile.ToLower()));
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Designation"]))
{
teacherModel.Search_Designation = decimal.Parse(Request.QueryString["Search_Designation"]);
teachers = teachers.Where(u => u.TEACH_DESIG_NO == teacherModel.Search_Designation);
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Active"]) &&
Request.QueryString["Search_Active"] != "null")
{
teacherModel.Search_Active = bool.Parse(Request.QueryString["Search_Active"]);
decimal active = teacherModel.Search_Active == true ? 1 : 0;
teachers = teachers.Where(u => u.IS_ACTIVE == active);
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Approved"]) &&
Request.QueryString["Search_Approved"] != "null")
{
teacherModel.Search_Approved = bool.Parse(Request.QueryString["Search_Approved"]);
decimal approved = teacherModel.Search_Approved == true ? 1 : 0;
teachers = teachers.Where(u => u.IS_APPROVED == approved);
}
Session["Teacher_Search_Model"] = teacherModel;
}
if (!Request.QueryString.HasKeys() && !page.HasValue)
{
Session["Teacher_Search_Model"] = null;
}
if (Session["Teacher_Search_Model"] != null)
{
teacherModel = (TeacherSearchViewModel)Session["Teacher_Search_Model"];
if (!string.IsNullOrEmpty(teacherModel.Search_Name))
{
teachers = teachers.Where(u => u.TEACHER_NAME.ToLower()
.Contains(teacherModel.Search_Name.ToLower()));
}
if (!string.IsNullOrEmpty(teacherModel.Search_Mobile))
{
teachers = teachers.Where(u => u.TEACHER_MOBILE.ToLower()
.Contains(teacherModel.Search_Mobile.ToLower()));
}
if (teacherModel.Search_Institute.HasValue)
{
teachers = teachers.Where(u => u.INSTITUTE_NO == teacherModel.Search_Institute);
}
if (teacherModel.Search_Designation.HasValue)
{
teachers = teachers.Where(u => u.TEACH_DESIG_NO == teacherModel.Search_Designation);
}
if (teacherModel.Search_Active.HasValue)
{
decimal active = teacherModel.Search_Active == true ? 1 : 0;
teachers = teachers.Where(u => u.IS_ACTIVE == active);
}
if (teacherModel.Search_Approved.HasValue)
{
decimal approved = teacherModel.Search_Approved == true ? 1 : 0;
teachers = teachers.Where(u => u.IS_APPROVED == approved);
}
}
teacher_info = teachers.OrderBy(m => m.TEACHER_NAME)
.ToPagedList(pageIndex, pageSize);
ViewBag.Search_Teacher_Model = (TeacherSearchViewModel)Session["Teacher_Search_Model"];
if (teacherModel != null && teacherModel.Search_Designation.HasValue)
{
ViewBag.Search_Designation = new SelectList(db.SET_TEACHER_DESIG, "TEACH_DESIG_NO", "TEACHER_DESIG_NAME",
teacherModel.Search_Designation);
}
else
{
ViewBag.Search_Designation = new SelectList(db.SET_TEACHER_DESIG, "TEACH_DESIG_NO", "TEACHER_DESIG_NAME");
}
return(View(teacher_info));
}
