public ActionResult Index(QueryModel qModel) { int departmentSelection = int.Parse(qModel.DepartmentsDropDownSelection); int locationSelection = int.Parse(qModel.LocationsDropDownSelection); int positionTypeSelection = int.Parse(qModel.PositionTypeDropDownSelection); if (departmentSelection > 0) { _selectedId = departmentSelection; _searchType = 1; } else if (locationSelection > 0) { _selectedId = locationSelection; _searchType = 2; } else if (positionTypeSelection > 0) { _selectedId = positionTypeSelection; _searchType = 3; } else return RedirectToAction("NullEmployeeList"); return RedirectToAction("FilteredEmployeeList", new { _selectedId = _selectedId, _searchType = _searchType }); }
public ActionResult Index() { using(var db = new HR_QueryEntities()) { var model = new QueryModel(); model.OptionsDropDown.Add(new SelectListItem { Text = "Select an option...", Value = "0" }); model.OptionsDropDown.Add(new SelectListItem { Text = "Query by department", Value = "1" }); model.OptionsDropDown.Add(new SelectListItem { Text = "Query by location", Value = "2" }); model.OptionsDropDown.Add(new SelectListItem { Text = "Query by position type", Value = "3" }); model.DepartmentsDropDown.Add(new SelectListItem { Text = "Select an option...", Value = "0" }); model.LocationsDropDown.Add(new SelectListItem { Text = "Select an option...", Value = "0" }); model.PositionTypeDropDown.Add(new SelectListItem { Text = "Select an option...", Value = "0" }); var list = db.Departments.ToList(); var items = from g in list select new SelectListItem { Value = g.Dept_ID.ToString(), Text = g.Dept_Name }; foreach (var item in items) { model.DepartmentsDropDown.Add(item); } var list2 = db.Locations.ToList(); var items2 = from g in list2 select new SelectListItem { Value = g.Location_ID.ToString(), Text = g.Location_Name }; foreach (var item in items2) { model.LocationsDropDown.Add(item); } var list3 = db.Position_Types.ToList(); var items3 = from g in list3 select new SelectListItem { Value = g.Position_Type_ID.ToString(), Text = g.Position_Type_Name }; foreach (var item in items3) { model.PositionTypeDropDown.Add(item); } return View(model); } }