public ActionResult Search([Bind(Include = "keywordFilter,yearsFilter")] EmployVM emVM) { EmployVM model = new EmployVM(); if ((emVM.keywordFilter != null && emVM.keywordFilter != "") && emVM.yearsFilter != 0) { //Both values filled model.Users = (db.Users.Where(u => u.YearsXP >= emVM.yearsFilter)).Where(u => u.CV.Contains(emVM.keywordFilter)).ToList(); } else if (emVM.yearsFilter == 0 && (emVM.keywordFilter != null && emVM.keywordFilter != "")) { //keyword filled model.Users = db.Users.Where(u => u.CV.Contains(emVM.keywordFilter)).ToList(); } else if ((emVM.keywordFilter == null || emVM.keywordFilter == "") && emVM.yearsFilter != 0) { //years filled model.Users = db.Users.Where(u => u.YearsXP >= emVM.yearsFilter).ToList(); } else { //both blank model.Users = db.Users.ToList(); } return(View("Employ", model)); }
// GET: Users public async Task <ActionResult> Employ() { var model = new EmployVM(); //Pass a list of users to the view via the model. model.Users = await db.Users.Include(u => u.UserType).ToListAsync(); return(View(model)); }