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