static async Task addWaypointRoutes(String connectionParams)
{
NpgsqlConnection connection = new NpgsqlConnection(connectionParams);
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
try
{
// travel waypoints
//DPoint[] travelCoordinates = new DPoint[] { new DPoint(34.8496, 32.0996), new DPoint(34.8506, 32.099), new DPoint(34.8486, 32.099),
// new DPoint(34.8503, 32.0981), new DPoint(34.8487, 32.0983),
// new DPoint(34.8486, 32.099), new DPoint(34.851, 32.0997),
// new DPoint(34.8515, 32.0992), new DPoint(34.8514, 32.0983),
// new DPoint(34.8511, 32.0973), new DPoint(34.8501, 32.0977),
// new DPoint(34.8487, 32.0982), new DPoint(34.8478, 32.0986)};
DPoint[] travelCoordinates = new DPoint[] { new DPoint(34.848627448082, 32.0995901398799), new DPoint(34.8495876789093, 32.0996264945646),
new DPoint(34.8505747318268, 32.0996492162353),
new DPoint(34.850612282753, 32.0982768171897), new DPoint(34.8492550849915, 32.0980950409352),
new DPoint(34.8486435413361, 32.098308627997), new DPoint(34.8514652252197, 32.0996855708965),
new DPoint(34.851508140564, 32.0986403686134), new DPoint(34.8511004447937, 32.0973452100618),
new DPoint(34.8498612642288, 32.0977905648985), new DPoint(34.8485255241394, 32.0982631839831),
new DPoint(34.8479408025742, 32.0971543430385), new DPoint(34.8504567146301, 32.096090933751) };
// read all barrier coordinates
BarriersDB barriersDB = new BarriersDB(connection);
List <Barrier> barriers = barriersDB.readAllBarriers();
RouteGenerator generator = new RouteGenerator(connection);
// generate routes from waypoint to other waypoints
for (int i = 0; i < travelCoordinates.Count(); i++)
{
for (int j = 0; j < travelCoordinates.Count(); j++)
{
if (i == j)
{
continue;
}
Route waypointRoute = await generator.generateRouteByShortestPath("WaypointToWaypoint_" + i + "," + j, travelCoordinates[i], travelCoordinates[j]);
generator.saveRouteToDB(waypointRoute);
}
}
// generate routes from waypoint to barriers
for (int i = 0; i < travelCoordinates.Count(); i++)
{
for (int j = 0; j < barriers.Count(); j++)
{
if (i == j)
{
continue;
}
DPoint barrierCoordinates = new DPoint(barriers[j].x, barriers[j].y);
Route waypointRoute = await generator.generateRouteByShortestPath("WaypointToBarrier_" + i + "," + j, travelCoordinates[i], barrierCoordinates);
generator.saveRouteToDB(waypointRoute);
}
}
transaction.Commit();
}
catch (Exception exception)
{
try
{
transaction.Rollback();
}
catch (Exception rollbackException)
{
Console.WriteLine("Rollback failed :(");
}
}
connection.Close();
}
static async Task addWaypointRoutes(String connectionParams)
{
NpgsqlConnection connection = new NpgsqlConnection(connectionParams);
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
try
{
// travel waypoints
//DPoint[] travelCoordinates = new DPoint[] { new DPoint(34.8496, 32.0996), new DPoint(34.8506, 32.099), new DPoint(34.8486, 32.099),
// new DPoint(34.8503, 32.0981), new DPoint(34.8487, 32.0983),
// new DPoint(34.8486, 32.099), new DPoint(34.851, 32.0997),
// new DPoint(34.8515, 32.0992), new DPoint(34.8514, 32.0983),
// new DPoint(34.8511, 32.0973), new DPoint(34.8501, 32.0977),
// new DPoint(34.8487, 32.0982), new DPoint(34.8478, 32.0986)};
DPoint[] travelCoordinates = new DPoint[] { new DPoint(34.848627448082, 32.0995901398799), new DPoint(34.8495876789093, 32.0996264945646),
new DPoint(34.8505747318268, 32.0996492162353),
new DPoint(34.850612282753, 32.0982768171897), new DPoint(34.8492550849915, 32.0980950409352),
new DPoint(34.8486435413361, 32.098308627997), new DPoint(34.8514652252197, 32.0996855708965),
new DPoint(34.851508140564, 32.0986403686134), new DPoint(34.8511004447937, 32.0973452100618),
new DPoint(34.8498612642288, 32.0977905648985), new DPoint(34.8485255241394, 32.0982631839831),
new DPoint(34.8479408025742, 32.0971543430385), new DPoint(34.8504567146301, 32.096090933751)};
// read all barrier coordinates
BarriersDB barriersDB = new BarriersDB(connection);
List<Barrier> barriers = barriersDB.readAllBarriers();
RouteGenerator generator = new RouteGenerator(connection);
// generate routes from waypoint to other waypoints
for (int i = 0; i < travelCoordinates.Count(); i++)
{
for (int j = 0; j < travelCoordinates.Count(); j++)
{
if (i == j) continue;
Route waypointRoute = await generator.generateRouteByShortestPath("WaypointToWaypoint_" + i + "," + j, travelCoordinates[i], travelCoordinates[j]);
generator.saveRouteToDB(waypointRoute);
}
}
// generate routes from waypoint to barriers
for (int i = 0; i < travelCoordinates.Count(); i++)
{
for (int j = 0; j < barriers.Count(); j++)
{
if (i == j) continue;
DPoint barrierCoordinates = new DPoint(barriers[j].x, barriers[j].y);
Route waypointRoute = await generator.generateRouteByShortestPath("WaypointToBarrier_" + i + "," + j, travelCoordinates[i], barrierCoordinates);
generator.saveRouteToDB(waypointRoute);
}
}
transaction.Commit();
}
catch (Exception exception)
{
try
{
transaction.Rollback();
}
catch (Exception rollbackException)
{
Console.WriteLine("Rollback failed :(");
}
}
connection.Close();
}
