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