/// <summary> /// Represents the index listing of cities. /// </summary> /// <returns></returns> public IActionResult List() { // Get all of the cities var cities = cityDao.GetCities(); // Return the Index view return(View(cities)); }
public IActionResult GetCities(string countryCode, string district) { if (countryCode == null && district == null) { return(new JsonResult(cityDAO.GetCities())); } else { return(new JsonResult(cityDAO.GetCities(countryCode, district))); } }
/// <summary> /// Gets all the cities which is operational for flights /// </summary> /// <exception cref="CityManagerException">Thrown when unable get cities</exception> /// <returns>Returns List of cities</returns> public City[] GetCities() { try { City[] cities = cityDAO.GetCities(); return(cities); } catch (CityDAOException ex) { throw new CityManagerException("Unable to get cities", ex); } }
/// <summary> /// Gets all the cities which is operational for flights /// </summary> /// <exception cref="CityManagerException">Thrown when unable get cities</exception> /// <returns>Returns collection of cities</returns> public List <City> GetCities() { try { DataSet citiesDS = cityDAO.GetCities(); var cities = from city in citiesDS.Tables[0].AsEnumerable().Distinct() orderby city["CityName"] select new City { CityId = Convert.ToInt64(city["CityId"]), Name = city["CityName"].ToString(), StateInfo = new State { StateId = Convert.ToInt64(city["StateId"]), Name = city["StateName"].ToString() } }; return(cities.ToList <City>()); } catch (CityDAOException ex) { throw new CityManagerException("Unable to get cities", ex); } }
/// <summary> /// Gets all the cities which is operational for flights /// </summary> /// <exception cref="CityManagerException">Thrown when unable get cities</exception> /// <returns>Returns collection of cities</returns> public List <City> GetCities() { List <City> cities = null; try { DataSet citiesDS = cityDAO.GetCities(); cities = new List <City>(); foreach (DataRow rw in citiesDS.Tables[0].Rows) { City city = new City(); city.CityId = Convert.ToInt64(rw["CityId"]); city.Name = rw["CityName"].ToString(); State state = new State(); state.StateId = Convert.ToInt64(rw["StateId"]); state.Name = rw["CityName"].ToString(); city.StateInfo = state; cities.Add(city); } } catch (CityDAOException ex) { throw new CityManagerException("Unable to get cities", ex); } return(cities); }
// 8. Create an action CitiesByCountry so that the user can // navigate to world/citiesbycountry public IActionResult CitiesByCountry(string code) { //10. Call the DAL //var cityDAL = new CitySqlDAL(@"Data Source=.\sqlexpress;Initial Catalog=world;Integrated Security=true;"); var cities = cityDAL.GetCities(code); //11. Pass the model into the view return(View(cities)); }
//4. Allow the user to navigate to day1/searchresult // by creating a search result action. //9. Have the model passed in to the result action public IActionResult SearchResult(CitySearch citySearch) { //11. Call the DAL to get matching cities var cities = dao.GetCities(citySearch.CountryCode, citySearch.District); //12. Pass the cities into the view citySearch.Results = cities; return(View("Index", citySearch)); }
/// <summary> /// Represents a search result. /// </summary> /// <param name="searchModel"></param> /// <returns></returns> public IActionResult Results(CitySearchModel searchModel) { var cities = cityDAL.GetCities(searchModel.CountryCode, searchModel.District); // Update the search model with the cities returned searchModel.Results = cities; // Display search results return(View(searchModel)); }
public IActionResult Search(CitySearchVM vm) { if (vm.CountryCode != null) { // Use the dao to get the cities that match the search vm.Cities = cityDAO.GetCities(vm.CountryCode, vm.District); } // Pass the results into the SearchResults view for display return(View(vm)); }
public IActionResult SearchResults(CitySearchModel search) { //get the list of cities var cities = cityDao.GetCities(search.CountryCode, search.District); //add the cities to my model search.Results = cities; //send it to the view return(View(search)); }
/// <summary> /// Represents a search result. /// </summary> /// <param name="searchModel"></param> /// <returns></returns> public IActionResult Results(CitySearchModel searchModel) { // Use the search model to get our data // Connection Strings are outside of the scope of this content var cities = cityDao.GetCities(searchModel.CountryCode, searchModel.District); // Update the search model with the cities returned searchModel.Results = cities; // Display search results return(View(searchModel)); }
public IActionResult Search(CitySearchVM vm) { if (vm.CountryCode != null) { // Use the dao to get the cities that match the search vm.Cities = cityDAO.GetCities(vm.CountryCode, vm.District); } // Call the GetCountries private method, which Populates the country list on the view model vm.CountryList = GetCountries(); // Pass the results into the SearchResults view for display return(View(vm)); }
public IActionResult Detail(CityListViewModel vm) { CityDetailViewModel detailViewModel = new CityDetailViewModel(); detailViewModel.Cities = _dao.GetCities(vm.CountryCode, vm.District); detailViewModel.CityListVM = vm; var codes = _dao.GetCountryCodes(); foreach (var code in codes) { SelectListItem item = new SelectListItem(); item.Text = code; detailViewModel.CityListVM.CountryCodes.Add(item); } return(View(detailViewModel)); }
public IActionResult Index() { IList <City> cities = cityDAO.GetCities(); return(View(cities)); }
public ActionResult <List <City> > GetAll() { return(cityDao.GetCities().ToList()); }
public IActionResult CitiesByCountry(string code) { var cities = _cityDao.GetCities(code); return(View(cities)); }