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 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();
}
