// GET: Movies public async Task <IActionResult> Index(string testcategory, int?testID) { IQueryable <string> categoryQuery = from m in _context.Test_Titles orderby m.Test_ID select m.Title; var category = from m in _context.Test_Titles select m; if (testID == null) { category = category.Where(s => s.Test_ID.Equals(testID)); } if (!string.IsNullOrEmpty(testcategory)) { category = category.Where(x => x.Title == testcategory); } var testCategoriesVM = new testCategoriesModel { categories = new SelectList(await categoryQuery.Distinct().ToListAsync()), Tests = await category.ToListAsync() }; return(View(testCategoriesVM)); }
public async Task <IActionResult> Userinput(testCategoriesModel model) { Test_Titles test = await _context.Test_Titles.FirstOrDefaultAsync( category => (category.Title == model.test)); if (test == null) { return(NotFound()); } return(Redirect("/testCategories/index")); }