static void removeWaypointRoutes(String connectionParams)
{
NpgsqlConnection connection = new NpgsqlConnection(connectionParams);
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
try
{
RoutesReader reader = new RoutesReader(connection);
RouteGenerator generator = new RouteGenerator(connection);
// read all waypoint routes
List <Route> waypointRoutes = reader.readRoutesStartingWith("Waypoint");
// delete them
generator.deleteRoutes(waypointRoutes);
transaction.Commit();
}
catch (Exception exception)
{
try
{
transaction.Rollback();
}
catch (Exception rollbackException)
{
Console.WriteLine("Rollback failed :(");
}
}
connection.Close();
}
private static void addAtoms(String connectionParams)
{
NpgsqlConnection connection = new NpgsqlConnection(connectionParams);
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
try
{
RoutesReader routesReader = new RoutesReader(connection);
AtomGenerator generator = new AtomGenerator(connection);
RouteGenerator routeGenerator = new RouteGenerator(connection);
generator.deleteAllAtomsAndActivities();
//Route source1 = routesReader.readRouteByName("Escape3");
//Route source2 = routesReader.readRouteByName("Escape3_reversed");
//Route source3 = routesReader.readRouteByName("Source3");
//Route cornerRoute = routesReader.readRouteByName("Corner");
//addAtomsToRoute(source1, generator, 100);
//addAtomsToRoute(source2, generator, 100);
//addAtomsToRoute(source3, generator, 100);
//addAtomsToRoute(cornerRoute, generator);
//AtomObject ambulance = new AtomObject("Ambulance1", -1, 34.8514473088014, 32.1008536878526);
//generator.createAtom(ambulance);
//generator.addAtomToTreeObject(ambulance);
//routeGenerator.generateReversedRoute("Escape3");
transaction.Commit();
}
catch (Exception exception)
{
try
{
transaction.Rollback();
}
catch (Exception rollbackException)
{
Console.WriteLine("Rollback failed :(");
}
}
connection.Close();
}
private static void addAtoms(String connectionParams)
{
NpgsqlConnection connection = new NpgsqlConnection(connectionParams);
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
try
{
RoutesReader routesReader = new RoutesReader(connection);
AtomGenerator generator = new AtomGenerator(connection);
RouteGenerator routeGenerator = new RouteGenerator(connection);
generator.deleteAllAtomsAndActivities();
Route source1 = routesReader.readRouteByName("Escape3");
Route source2 = routesReader.readRouteByName("Escape3_reversed");
//Route source3 = routesReader.readRouteByName("Source3");
//Route cornerRoute = routesReader.readRouteByName("Corner");
//addAtomsToRoute(source1, generator, 100);
//addAtomsToRoute(source2, generator, 100);
//addAtomsToRoute(source3, generator, 100);
//addAtomsToRoute(cornerRoute, generator);
//AtomObject ambulance = new AtomObject("Ambulance1", -1, 34.8514473088014, 32.1008536878526);
//generator.createAtom(ambulance);
//generator.addAtomToTreeObject(ambulance);
//routeGenerator.generateReversedRoute("Escape3");
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();
}
static void removeWaypointRoutes(String connectionParams)
{
NpgsqlConnection connection = new NpgsqlConnection(connectionParams);
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
try
{
RoutesReader reader = new RoutesReader(connection);
RouteGenerator generator = new RouteGenerator(connection);
// read all waypoint routes
List<Route> waypointRoutes = reader.readRoutesStartingWith("Waypoint");
// delete them
generator.deleteRoutes(waypointRoutes);
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();
}
