static void Main(string[] args) { // This code reads the connection string from appsettings.json IConfigurationBuilder builder = new ConfigurationBuilder(); builder.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); IConfigurationRoot configuration = builder.Build(); string connectionString = configuration.GetConnectionString("World"); // TODO 00: Create a Model for Country to go with the City model we already have // TODO 01: Create a CountrySqlDAO class (GetCountries, GetCountries(continent), GetCountry(code)) // TODO 01a: Create an ICountryDAO interface ICountryDAO countryDAO = new CountrySqlDAO(connectionString); // TODO 07: Create a CitySqlDAO class (GetCitiesByCountryCode) // TODO 07a: Create an ICityDAO interface // TODO 02b: Create a WorldDBMenu, passing in the country dao, and Run it WorldDBMenu menu = new WorldDBMenu(countryDAO); menu.Run(); // Say goodbye to the user... Console.ForegroundColor = ConsoleColor.DarkRed; Console.Write("Goodbye..."); Thread.Sleep(1500); }
static void Main(string[] args) { // This code reads the connection string from appsettings.json // Add the connection string to appsettings.json and un-comment the following lines to read the configuration IConfigurationBuilder builder = new ConfigurationBuilder(); builder.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); IConfigurationRoot configuration = builder.Build(); string connectionString = configuration.GetConnectionString("World"); // TEMPORARY: DB EXAMPLE (vanilla, no DAO) //ReadCities(); //return; ICountryDAO countryDAO = new CountrySqlDAO(connectionString); ICityDAO cityDAO = new CitySqlDAO(connectionString); // TODO 14a: Create a Model for CountryLanguage // TODO 14b: Create a CountryLanguageSqlDAO class (GetLanguages(string countryCode)) // TODO 14c: Create an ICountryLanguageDAO interface ICountryLanguageDAO countryLanguageDAO = new CountryLanguageSqlDAO(connectionString); // Create a WorldDBMenu, passing in the country dao, and Run it WorldDBMenu menu = new WorldDBMenu(countryDAO, cityDAO, countryLanguageDAO); menu.Show(); // Say goodbye to the user... Console.ForegroundColor = ConsoleColor.DarkRed; Console.Write("Goodbye..."); Thread.Sleep(1500); }
static void Main(string[] args) { // This code reads the connection string from appsettings.json IConfigurationBuilder builder = new ConfigurationBuilder(); builder.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); IConfigurationRoot configuration = builder.Build(); // Get the connection string for the World database string connectionString = configuration.GetConnectionString("World"); CitySqlDAO cityDAO = new CitySqlDAO(connectionString); List <City> cities = cityDAO.GetAllCities(); foreach (City city in cities) { Console.WriteLine($"{city.Id,5} {city.Name,-40} {city.Population,12:N0} "); } Console.ReadLine(); cities = cityDAO.GetCitiesForCountryCode("GBR"); foreach (City city in cities) { Console.WriteLine($"{city.Id,5} {city.Name,-40} {city.Population,12:N0} "); } // GetAllCities(connectionString) // GetCitiesForCountry(connectionString, "USA"); Console.ReadLine(); return; // TODO: Create a City Model class // TODO: Create a City SQL DAO Class (GetCities, GetCitiesByCountryCode) // TODO: List the cities of the world // TODO: List the cities in a Country (code) // TODO: Add a City to the US // TODO: Create instances of DAOs to pass into the menus // TODO: Create a WorldDBMenu and Run it WorldDBMenu menu = new WorldDBMenu(); menu.Run(); // Say goodbye to the user... Console.ForegroundColor = ConsoleColor.DarkRed; Console.Write("Goodbye..."); Thread.Sleep(1500); }
static void Main(string[] args) { // This code reads the connection string from appsettings.json // TODO 03: Add the connection string to appsettings.json and un-comment the following lines to read the configuration IConfigurationBuilder builder = new ConfigurationBuilder(); builder.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); IConfigurationRoot configuration = builder.Build(); string connectionString = configuration.GetConnectionString("World"); // TEMPORARY: DB EXAMPLE (vanilla, no DAO) //ReadCities(); //return; /* CREATED JUST TO TEST MENU * CountrySqlDAO dao = new CountrySqlDAO(connectionString); * List<Country> list = dao.GetCountries("Asia"); * * Country country = dao.GetCountry("ZZZ"); * * country = dao.GetCountry("USA"); */ // TODO 04a: Create a Model for Country to go with the City model we already have // TODO 04b: Create a CountrySqlDAO class (GetCountries, GetCountries(continent), GetCountry(code)) // TODO 04c: Create an ICountryDAO interface // TODO 10: Create a CitySqlDAO class (GetCitiesByCountryCode) // TODO 10a: Create an ICityDAO interface // TODO 14a: Create a Model for CountryLanguage // TODO 14b: Create a CountryLanguageSqlDAO class (GetLanguages(string countryCode)) // TODO 14c: Create an ICountryLanguageDAO interface ICountryDAO countryDAO = new CountrySqlDAO(connectionString); ICityDAO cityDAO = new CitySqlDAO(connectionString); // TODO 05b: Create a WorldDBMenu, passing in the country dao, and Run it WorldDBMenu menu = new WorldDBMenu(countryDAO, cityDAO); menu.Show(); // Say goodbye to the user... Console.ForegroundColor = ConsoleColor.DarkRed; Console.Write("Goodbye..."); Thread.Sleep(1500); }
static void Main(string[] args) { IConfigurationBuilder builder = new ConfigurationBuilder(); builder.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); IConfigurationRoot configuration = builder.Build(); string connectionString = configuration.GetConnectionString("World"); ICityDAO cityDAO = new CitySqlDAO(connectionString); ICountryDAO countryDAO = new CountrySqlDAO(connectionString); ILanguageDAO languageDAO = new LanguageSqlDAO(connectionString); WorldDBMenu menu = new WorldDBMenu(cityDAO, countryDAO, languageDAO); menu.Run(); Console.ForegroundColor = ConsoleColor.DarkRed; Console.Write("Goodbye..."); Thread.Sleep(1500); }
static void Main(string[] args) { // TODO: This is how we load a configuration file and get the connection string IConfigurationBuilder builder = new ConfigurationBuilder(); builder.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); IConfigurationRoot configuration = builder.Build(); string connectionString = configuration.GetConnectionString("World"); // TODO: This gets a custom value from the Config file bool useFileDAO = configuration.GetSection("DAO").GetValue <bool>("UseFileDAO", false); // TODO: Here, the Main method creates instances of DAOs which will be "injected" into the menu (CLI). ICityDAO cityDAO; ICountryDAO countryDAO; ILanguageDAO languageDAO; if (useFileDAO) { // TODO: This is a COMPLETELY different set of DAOs which implement the SAME interfaces cityDAO = new CityFileDAO(@"..\..\..\City_Data.txt"); countryDAO = new CountryFileDAO(@"..\..\..\Country_Data.txt"); languageDAO = new LanguageFileDAO(@"..\..\..\Language_Data.txt"); } else { cityDAO = new CitySqlDAO(connectionString); countryDAO = new CountrySqlDAO(connectionString); languageDAO = new LanguageSqlDAO(connectionString); } // TODO: Here, we create the menu, and "inject" the DAOs we want to use WorldDBMenu menu = new WorldDBMenu(cityDAO, countryDAO, languageDAO); menu.Run(); Console.ForegroundColor = ConsoleColor.DarkRed; Console.Write("Goodbye..."); Thread.Sleep(1500); }