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