public void TestExcelExport()
{
string excelFileName = Directory.GetCurrentDirectory() + @"\ExportTest.xlsx";
City bern = new City("Bern", "Switzerland", 5000, 46.95, 7.44);
City zuerich = new City("Zürich", "Switzerland", 100000, 32.876174, 13.187507);
City aarau = new City("Aarau", "Switzerland", 10000, 35.876174, 12.187507);
Link link1 = new Link(bern, aarau, 15, TransportModes.Ship);
Link link2 = new Link(aarau, zuerich, 20, TransportModes.Ship);
List<Link> links = new List<Link>();
links.Add(link1);
links.Add(link2);
// TODO: Fix starting Excel on sever (not robust)
ExcelExchange excel = new ExcelExchange();
Console.WriteLine("Export Path is: {0}", excelFileName);
excel.WriteToFile(excelFileName, bern, zuerich, links);
// first verify that file exists
Assert.IsTrue(File.Exists(excelFileName));
// now verify the content of the file
// TODO: Fix reading file on sever
VerifyExcelContent(excelFileName);
}
static void Main(string[] args)
{
var assembly = Assembly.GetExecutingAssembly().FullName;
var version = assembly.Split(',')[1].Split('=')[1];
Console.Out.WriteLine("Welcome to RoutePlanner (Version {0})", arg0: version);
var wayPoint = new WayPoint("Windisch", 47.479319847061966, 8.212966918945312);
Console.WriteLine("{0}: {1}/{2}", wayPoint.Name, wayPoint.Latitude, wayPoint.Longitude);
Console.Out.WriteLine("--------------");
Console.Out.WriteLine(wayPoint);
RoutesFactory.Create(new Cities());
string excelFileName = Directory.GetCurrentDirectory() + @"\ExportTest.xlsx";
ExcelExchange excel = new ExcelExchange();
Console.WriteLine("Export Path is: {0}", excelFileName);
City bern = new City("Bern", "Switzerland", 5000, 46.95, 7.44);
City zuerich = new City("Zürich", "Switzerland", 100000, 32.876174, 13.187507);
City aarau = new City("Aarau", "Switzerland", 10000, 35.876174, 12.187507);
Link link1 = new Link(bern, aarau, 15, TransportModes.Ship);
Link link2 = new Link(aarau, zuerich, 20, TransportModes.Ship);
List<Link> links = new List<Link>();
links.Add(link1);
links.Add(link2);
excel.WriteToFile(excelFileName, bern, zuerich, links);
/* Test Logging */
var cities = new Cities();
Routes routes = new RoutesFloydWarshall(cities);
//cities.ReadCities("adsf");
//routes.ReadRoutes("adsf");
}
public void TestExcelExport()
{
var excelFileName = Directory.GetCurrentDirectory() + @"\ExportTest.xlsx";
var bern = new City("Bern", "Switzerland", 5000, 46.95, 7.44);
var zuerich = new City("Zürich", "Switzerland", 100000, 32.876174, 13.187507);
var aarau = new City("Aarau", "Switzerland", 10000, 35.876174, 12.187507);
var link1 = new Link(bern, aarau, 15, TransportModes.Ship);
var link2 = new Link(aarau, zuerich, 20, TransportModes.Ship);
var links = new List<Link>();
links.Add(link1);
links.Add(link2);
var excel = new ExcelExchange();
excel.WriteToFile(excelFileName, bern, zuerich, links);
Assert.IsTrue(File.Exists(excelFileName), excelFileName);
}
public void TestExcelExport()
{
var excelFileName = Directory.GetCurrentDirectory() + @"\ExportTest.xlsx";
var bern = new City("Bern", "Switzerland", 5000, 46.95, 7.44);
var zuerich = new City("Zürich", "Switzerland", 100000, 32.876174, 13.187507);
var aarau = new City("Aarau", "Switzerland", 10000, 35.876174, 12.187507);
var links = new Link[]
{
new Link(bern, aarau, 15, TransportMode.Ship),
new Link(aarau, zuerich, 20, TransportMode.Ship)
};
var excel = new ExcelExchange();
excel.WriteToFile(excelFileName, links);
Assert.IsTrue(File.Exists(excelFileName), excelFileName);
//should not show dialog boxes or fail, should silently overwrite the file
excel.WriteToFile(excelFileName, links);
Assert.IsTrue(File.Exists(excelFileName), excelFileName);
}
static void Main(string[] args)
{
Version version = Assembly.GetEntryAssembly().GetName().Version;
Console.WriteLine("Welcome to RoutePlanner ({0})", version);
WayPoint wayPoint = new WayPoint("Windisch", 47.479319847061966, 8.212966918945312);
Console.WriteLine(wayPoint.ToString());
WayPoint wpBern = new WayPoint("Bern", 46.9472221, 7.451202500000022);
WayPoint wpTripolis = new WayPoint("Tripolis", 59.86062519999999, 17.650885199999948);
Console.WriteLine("Distanz Bern-Tripolis: {0}km", wpBern.Distance(wpTripolis));
City cBern = new City("Bern", "Schweiz", 75000, 47.479319847061966, 8.212966918945312);
City c0 = new City("Mumbai", "India", 12383146, 18.96, 72.82);
string serializedCity = string.Empty;
using (StringWriter outstream = new StringWriter())
{
SimpleObjectWriter writer = new SimpleObjectWriter(outstream);
writer.Next(cBern);
serializedCity = outstream.ToString();
}
Console.WriteLine(serializedCity);
using(StringReader inStream = new StringReader(serializedCity)) {
SimpleObjectReader reader = new SimpleObjectReader(inStream);
object o = reader.Next();
}
WayPoint wp = c0.Location;
Cities c = new Cities();
c.ReadCities("citiesTestDataLab2.txt");
c.FindNeighbours(wp,2000);
c.ReadCities("citiesTestDataLab2.txt");
var routes = new RoutesDijkstra(c);
var reqWatch = new RouteRequestWatcher();
routes.RouteRequestEvent += reqWatch.LogRouteRequests;
routes.FindShortestRouteBetween("Mumbai", "India", TransportModes.Rail);
routes.FindShortestRouteBetween("Mumbai", "India", TransportModes.Rail);
routes.FindShortestRouteBetween("India", "Mumbai", TransportModes.Rail);
Console.WriteLine("City found: {0}", c.FindCity("Mumbai").Name);
c.ReadCities("citiesTestDataLab4.txt");
Routes r = new RoutesDijkstra(c);
r.RouteRequestEvent += reqWatch.LogRouteRequests;
r.ReadRoutes("linksTestDataLab4.txt");
List<Link> l = r.FindShortestRouteBetween("Zürich", "Winterthur", TransportModes.Rail);
foreach (Link link in l)
{
Console.WriteLine("from {0} to {1} in {2}", link.FromCity.Name, link.ToCity.Name, link.Distance);
}
Console.ReadKey();
City zurich = c.FindCity("Zürich");
City winterthur = c.FindCity("Winterthur");
ExcelExchange export = new ExcelExchange();
export.WriteToFile("Test.xls", zurich, winterthur,l);
}