private static void ListAllLocations()
{
Console.WriteLine();
Console.WriteLine("--- START List of all locations ---");
Console.WriteLine();
using (var db = new addressEntities())
{
db.Database.Log = message => Trace.WriteLine(message);
foreach (var country in db.Locations.OfType<Country>())
{
Console.WriteLine("Country: {0}", country.Name);
foreach (var state in country.States.OrderBy(s => s.Name))
{
Console.WriteLine(" State: {0}", state.Name);
foreach (var province in state.Provinces.OrderBy(p => p.Name))
{
Console.WriteLine(" Province: {0}", province.Name);
foreach (var region in province.Regions.OrderBy(r => r.Name))
{
Console.WriteLine(" Region: {0}", region.Name);
foreach (var city in region.Cities.OrderBy(c => c.Name))
{
Console.WriteLine(" City: {0}", city.Name);
}
}
}
}
}
}
Console.WriteLine();
Console.WriteLine("--- END List of all locations ---");
Console.WriteLine();
}
private static void InsertAddress(string line1, string cityName)
{
using (var db = new addressEntities())
{
db.Database.Log = message => Trace.WriteLine(message);
var city = db.Locations
.Include("Region.Province.State.Country")
.OfType<City>()
.Where(c => c.Name == cityName)
.FirstOrDefault();
if (city == null)
return;
var address = new Address
{
AddressLine1 = line1,
City = city,
Region = city.Region,
Province = city.Region.Province,
State = city.Region.Province.State,
Country = city.Region.Province.State.Country
};
db.Addresses.Add(address);
db.SaveChanges();
}
}
private static void ListAddresses()
{
Console.WriteLine();
Console.WriteLine("--- START List of all addresses ---");
Console.WriteLine();
using (var db = new addressEntities())
{
db.Database.Log = message => Trace.WriteLine(message);
var addresses = db.Addresses
.Include("Region")
.Include("Province")
.Include("State")
.Include("Country");
if (addresses == null)
return;
foreach (var a in addresses)
{
Console.WriteLine(a.AddressLine1);
Console.WriteLine(" City: {0}", a.City.Name);
Console.WriteLine(" Region: {0}", a.Region.Name);
Console.WriteLine(" Province: {0}", a.Region.Province.Name);
Console.WriteLine(" State: {0}", a.Region.Province.State.Name);
Console.WriteLine(" Country: {0}", a.Region.Province.State.Country.Name);
Console.WriteLine();
}
}
Console.WriteLine();
Console.WriteLine("--- END List of all addresses ---");
Console.WriteLine();
}
private static void ListCities()
{
Console.WriteLine();
Console.WriteLine("--- START List of all cities ---");
Console.WriteLine();
using (var db = new addressEntities())
{
db.Database.Log = message => Trace.WriteLine(message);
var cities = db.Locations
.Include("Region.Province.State.Country")
.OfType<City>();
if (cities == null)
return;
foreach (var c in cities)
{
Console.Write("City: {0}", c.Name);
Console.Write(" / Region: {0}", c.Region.Name);
Console.Write(" / Province: {0}", c.Region.Province.Name);
Console.Write(" / State: {0}", c.Region.Province.State.Name);
Console.Write(" / Country: {0}", c.Region.Province.State.Country.Name);
Console.WriteLine();
}
}
Console.WriteLine();
Console.WriteLine("--- END List of all cities ---");
Console.WriteLine();
}
