private static void GetApproachRouteDetails()
{
SqlConnection sqlconn = GetDataBaseConnection();
var slqQuery = "select * from ApproachRouteDetail";
sqlconn.Open();
var command = new SqlCommand(slqQuery, sqlconn);
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
OldRouteDetail routeDetail = new OldRouteDetail();
routeDetail.RouteId = (int)reader["ApproachRouteId"];
routeDetail.Order = (int)reader["ApproachOrder"];
routeDetail.DetailId = (int)reader["RouteDetailID"];
routeDetail.ApproachId = (int)reader["ApproachID"];
var route = OldRouteList.Find(r => r.RouteId == routeDetail.RouteId);
if (route != null)
{
route.Details.Add(routeDetail);
}
}
}
sqlconn.Dispose();
}
private static List <RoutePhaseDirection> CreateRoutePhaseDirections(RouteSignal signal, OldRouteDetail detail,
Approach approach, SPM db)
{
List <RoutePhaseDirection> phaseDirecitons = new List <RoutePhaseDirection>();
RoutePhaseDirection phaseDireciton = new RoutePhaseDirection();
phaseDireciton.RouteSignal = signal;
phaseDireciton.DirectionTypeId = approach.DirectionTypeID;
phaseDireciton.Phase = approach.ProtectedPhaseNumber;
phaseDireciton.IsOverlap = approach.IsProtectedPhaseOverlap;
phaseDireciton.IsPrimaryApproach = true;
phaseDirecitons.Add(phaseDireciton);
return(phaseDirecitons);
}
