private static void GetApproachRouteRecords()
{
SqlConnection sqlconn = GetDataBaseConnection();
var slqQuery = "select * from ApproachRoute";
sqlconn.Open();
var command = new SqlCommand(slqQuery, sqlconn);
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
OldRoute route = new OldRoute();
route.RouteId = (int)reader["ApproachRouteId"];
route.RouteName = (string)reader["RouteName"];
OldRouteList.Add(route);
}
sqlconn.Dispose();
}
}
private static List <RouteSignal> CreateRouteSignals(OldRoute oldRoute, Route newRoute, SPM db)
{
List <RouteSignal> signals = new List <RouteSignal>();
IApproachRepository appRepo = ApproachRepositoryFactory.Create(db);
foreach (var detail in oldRoute.Details)
{
var approach = appRepo.GetApproachByApproachID(detail.ApproachId);
RouteSignal signal = new RouteSignal();
signal.Route = newRoute;
signal.Order = detail.Order;
signal.SignalId = approach.SignalID;
signal.PhaseDirections = CreateRoutePhaseDirections(signal, detail, approach, db);
signals.Add(signal);
}
return(signals);
}
