public async Task <IActionResult> ControlPanel(SelectQueryDetailsViewModel model) { var countries = new List <string>(); countries = Context_.Countries.Select(x => x.Value).ToList(); model.Countries = GetSelectListItems(countries); if (!string.IsNullOrEmpty(model.Country)) { var parameters = new List <string>(); model.Parameters = GetSelectListItems(parameters); var cities = new List <string>(); var code = Context_.GetCodeByCountryName(model.Country); cities = await GetCitiesByCountry(code); model.Cities = GetSelectListItems(cities); if (!string.IsNullOrEmpty(model.City)) { model.Parameters = GetSelectListItems(parameters); } } var details = Context_.PrepareQuery(model.Country, model.City, model.Parameter); model.QueryResults = await ShowResults(details); return(View(model)); //return Redirect("/Home/ControlPanel"); }
public async Task <IActionResult> ControlPanel() { var model = new SelectQueryDetailsViewModel(); model.Title = Context_.GetTitle(); var countries = new List <string>(); var cities = new List <string>(); //Load all countries var result = await Context_.GetAllCountriesAsync(); countries = Context_.Countries.Select(x => x.Value).ToList(); model.Countries = GetSelectListItems(countries); ViewData["Countries"] = model.Countries; //Get cities, intially will be empty as no country selected. model.Cities = GetSelectListItems(cities); ViewData["Cities"] = model.Cities; //Select Parameters var parameters = await SelectParameters(); model.Parameters = GetSelectListItems(parameters); //Initialize query results from view model var queryresult = new List <QueryResult>(); model.QueryResults = queryresult.ToList(); return(View(model)); }