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 TestLinkTransportMode()
{
var mumbai = new City("Mumbai", "India", 12383146, 18.96, 72.82);
var buenosAires = new City("Buenos Aires", "Argentina", 12116379, -34.61, -58.37);
var link = new Link(mumbai, buenosAires, 10);
// verify default transport
Assert.AreEqual(TransportModes.Car, link.TransportMode);
link = new Link(mumbai, buenosAires, 10, TransportModes.Ship);
Assert.AreEqual(TransportModes.Ship, link.TransportMode);
}
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);
}
private Link FindLink(City u, City n, TransportModes mode)
{
var linkToFind = new Link(u, n, u.Location.Distance(n.Location), mode);
var linkToFindRevert = new Link(n, u, n.Location.Distance(u.Location), mode);
Predicate<Link> predicate = delegate(Link link)
{
return link.Equals(linkToFind) || link.Equals(linkToFindRevert);
};
return routes.Find(predicate);
}
