static void Main(string[] args)
{
Console.WriteLine("Console database webGeoInfo");
string cnStr = ConfigurationManager.AppSettings["cnStr"];
//AddContinents(cnStr);
//AddCountries(cnStr);
//AddCity(cnStr);
Citydb db = new Citydb(cnStr);
db.Open();
Console.WriteLine("***Countries:");
db.countries.Print();
Console.WriteLine("--------------------------------");
Console.WriteLine("***Cities:");
db.cities.Print();
db.Close();
Console.WriteLine("END");
Console.ReadLine();
}
public static void AddContinents(string connection)
{
Citydb db = new Citydb(connection);
db.Open();
Continent c1 = new Continent(1, "North America");
if (db.continents.Find(c1.ContinentID) == null)
{
db.continents.Add(c1);
}
else
{
Console.WriteLine("Object [{0}] is exist in database", c1);
}
Continent c2 = new Continent(2, "South America");
if (db.continents.Find(c2.ContinentID) == null)
{
db.continents.Add(c2);
}
else
{
Console.WriteLine("Object [{0}] is exist in database", c2);
}
Continent c3 = new Continent(3, "Africa");
if (db.continents.Find(c3.ContinentID) == null)
{
db.continents.Add(c3);
}
else
{
Console.WriteLine("Object [{0}] is exist in database", c3);
}
Continent c4 = new Continent(4, "Australia");
if (db.continents.Find(c4.ContinentID) == null)
{
db.continents.Add(c4);
}
else
{
Console.WriteLine("Object [{0}] is exist in database", c4);
}
Continent c5 = new Continent(5, "Antarctic");
if (db.continents.Find(c5.ContinentID) == null)
{
db.continents.Add(c5);
}
else
{
Console.WriteLine("Object [{0}] is exist in database", c5);
}
Continent c6 = new Continent(6, "Eurasia");
if (db.continents.Find(c6.ContinentID) == null)
{
db.continents.Add(c6);
}
else
{
Console.WriteLine("Object [{0}] is exist in database", c6);
}
Console.WriteLine("***Continents:");
db.continents.Print();
Console.WriteLine("***Delete from list one continent:");
if (db.continents.Find(c1.ContinentID) != null)
{
db.continents.Delete(c1);
}
db.continents.Print();
Console.WriteLine("***Update list of continents:");
c2.Name = "Tru-la-la";
db.continents.Update(c2);
db.continents.Print();
Continent find = db.continents.Find("Eurasia");
if (find != null)
{
Console.WriteLine("***Find object: [{0}]", find);
}
Console.WriteLine("***Get list of continents:");
IList <Continent> listContinents = db.continents.GetContinentList();
foreach (Continent item in listContinents)
{
Console.WriteLine(item);
}
db.Close();
}
public static void AddCity(string connection)
{
Citydb db = new Citydb(connection);
db.Open();
City c1 = new City(1, 1, "London");
if (db.cities.Find(c1.CityID) == null)
{
db.cities.Add(c1);
}
City c2 = new City(2, 2, "Paris");
if (db.cities.Find(c2.CountryID) == null)
{
db.cities.Add(c2);
}
City c3 = new City(3, 3, "Stockgolm");
if (db.cities.Find(c3.CountryID) == null)
{
db.cities.Add(c3);
}
City c4 = new City(4, 4, "Sydney");
if (db.cities.Find(c4.CountryID) == null)
{
db.cities.Add(c4);
}
City c5 = new City(5, 6, "Berlin");
if (db.cities.Find(c5.CountryID) == null)
{
db.cities.Add(c5);
}
Console.WriteLine("****Cities list:");
db.cities.Print();
Console.WriteLine();
Console.WriteLine("****Delete func:");
db.cities.Delete(c1);
db.cities.Print();
Console.WriteLine();
Console.WriteLine("****Update func:");
Console.WriteLine("****Before update: [{0}]", c2);
c2.Name = "Rome";
db.cities.Update(c2);
Console.WriteLine("****After update: [{0}]", c2);
db.cities.Print();
City find = db.cities.Find("Sydney");
if (find != null)
{
Console.WriteLine("Find city: [{0}]", find);
}
Console.WriteLine("****Get list of cities:");
IList <City> listCities = db.cities.GetCityList();
foreach (City item in listCities)
{
Console.WriteLine(item);
}
db.Close();
}
public static void AddCountries(string connection)
{
Citydb db = new Citydb(connection);
db.Open();
Country c1 = new Country(1, 1, "USA");
if (db.countries.Find(c1.CountryID) == null)
{
db.countries.Add(c1);
}
Country c2 = new Country(2, 2, "Brazilia");
if (db.countries.Find(c2.CountryID) == null)
{
db.countries.Add(c2);
}
Country c3 = new Country(3, 3, "Egypt");
if (db.countries.Find(c3.CountryID) == null)
{
db.countries.Add(c3);
}
Country c4 = new Country(4, 4, "Australia");
if (db.countries.Find(c4.CountryID) == null)
{
db.countries.Add(c4);
}
Country c5 = new Country(5, 6, "Sweden");
if (db.countries.Find(c5.CountryID) == null)
{
db.countries.Add(c5);
}
Console.WriteLine("****Countries list:");
db.countries.Print();
Console.WriteLine();
Console.WriteLine("****Delete func:");
db.countries.Delete(c1);
db.countries.Print();
Console.WriteLine();
Console.WriteLine("****Update func:");
Console.WriteLine("****Before update: [{0}]", c2);
c2.Name = "Argentina";
db.countries.Update(c2);
Console.WriteLine("****After update: [{0}]", c2);
db.countries.Print();
Country find = db.countries.Find("Sweden");
if (find != null)
{
Console.WriteLine("Find country: [{0}]", find);
}
Console.WriteLine("****Get list of countries:");
IList <Country> listCountries = db.countries.GetCountryList();
foreach (Country item in listCountries)
{
Console.WriteLine(item);
}
db.Close();
}
