public LinkPivot(int routeId, DateTime startDate, DateTime endDate, int cycleTime,
string direction, double bias, string biasDirection, List <DayOfWeek> days)
{
var routeRepository = RouteRepositoryFactory.Create();
var route = routeRepository.GetRouteByIDAndDate(routeId, startDate);
// Get a list of dates that matches the parameters passed by the user
Dates = GetDates(startDate, endDate, days);
//Make a list of numbers to use as indices to perform parallelism
var indices = new List <int>();
if (direction == "Upstream")
{
for (var i = route.RouteSignals.Count - 1; i > 0; i--)
{
indices.Add(i);
}
//Parallel.ForEach(indices, i =>
foreach (var i in indices)
{
var signalRepository = SignalsRepositoryFactory.Create();
var signal = signalRepository.GetVersionOfSignalByDate(route.RouteSignals[i].SignalId, startDate);
var primaryPhaseDirection =
route.RouteSignals[i].PhaseDirections.FirstOrDefault(p => p.IsPrimaryApproach);
var downstreamPrimaryPhaseDirection = route.RouteSignals[i - 1].PhaseDirections
.FirstOrDefault(p => p.IsPrimaryApproach == false);
if (downstreamPrimaryPhaseDirection != null)
{
var dowstreamSignal =
signalRepository.GetVersionOfSignalByDate(route.RouteSignals[i - 1].SignalId, startDate);
var approach = signal.Approaches.FirstOrDefault(a =>
a.DirectionTypeID == primaryPhaseDirection.DirectionTypeId &&
a.IsProtectedPhaseOverlap == primaryPhaseDirection.IsOverlap &&
a.ProtectedPhaseNumber == primaryPhaseDirection.Phase);
var downstreamApproach = dowstreamSignal.Approaches.FirstOrDefault(a =>
a.DirectionTypeID == downstreamPrimaryPhaseDirection.DirectionTypeId &&
a.IsProtectedPhaseOverlap == downstreamPrimaryPhaseDirection.IsOverlap &&
a.ProtectedPhaseNumber == downstreamPrimaryPhaseDirection.Phase);
PairedApproaches.Add(new LinkPivotPair(approach, downstreamApproach, startDate, endDate,
cycleTime,
bias, biasDirection, Dates, i + 1));
}
}
//);
}
else
{
for (var i = 0; i < route.RouteSignals.Count - 1; i++)
{
indices.Add(i);
}
//Parallel.ForEach(indices, i =>
foreach (var i in indices)
{
var signalRepository = SignalsRepositoryFactory.Create();
var signal = signalRepository.GetVersionOfSignalByDate(route.RouteSignals[i].SignalId, startDate);
var primaryPhaseDirection =
route.RouteSignals[i].PhaseDirections.FirstOrDefault(p => p.IsPrimaryApproach);
var downstreamPrimaryPhaseDirection = route.RouteSignals[i + 1].PhaseDirections
.FirstOrDefault(p => p.IsPrimaryApproach == false);
if (downstreamPrimaryPhaseDirection != null)
{
var dowstreamSignal =
signalRepository.GetVersionOfSignalByDate(route.RouteSignals[i + 1].SignalId, startDate);
var approach = signal.Approaches.FirstOrDefault(a =>
a.DirectionTypeID == primaryPhaseDirection.DirectionTypeId &&
a.IsProtectedPhaseOverlap == primaryPhaseDirection.IsOverlap &&
a.ProtectedPhaseNumber == primaryPhaseDirection.Phase);
var downstreamApproach = dowstreamSignal.Approaches.FirstOrDefault(a =>
a.DirectionTypeID == downstreamPrimaryPhaseDirection.DirectionTypeId &&
a.IsProtectedPhaseOverlap == downstreamPrimaryPhaseDirection.IsOverlap &&
a.ProtectedPhaseNumber == downstreamPrimaryPhaseDirection.Phase);
PairedApproaches.Add(new LinkPivotPair(approach, downstreamApproach, startDate, endDate,
cycleTime,
bias, biasDirection, Dates, i + 1));
}
}
//);
}
////If the user has selected the end of the list create a reverse sort the LinkPivotPair list
////otherwise build the list as ordered in the database
//if (direction == "Upstream")
//{
// //build a reverse sort LinkPivotPair list
// for (int i = detailTable.Rows.Count - 1; i > 0; i--)
// {
// pairedApproaches.Add(new LinkPivotPair(detailTable[i].SignalId, detailTable[i].Direction,
// detailTable[i].Location, detailTable[i - 1].SignalId, detailTable[i - 1].Direction,
// detailTable[i - 1].Location, startDate, endDate, cycleTime, chartLocation, bias, biasDirection, dates));
// }
//}
//else
//{
// //build a LinkPivotPair list as ordered in the database
// for (int i = 0; i < detailTable.Rows.Count - 1; i++)
// {
// pairedApproaches.Add(new LinkPivotPair(detailTable[i].SignalId, detailTable[i].Direction,
// detailTable[i].Location, detailTable[i + 1].SignalId, detailTable[i + 1].Direction,
// detailTable[i + 1].Location, startDate, endDate, cycleTime, chartLocation, bias, biasDirection, dates));
// }
//}
if (Adjustment != null)
{
//Cycle through the LinkPivotPair list and add the statistics to the LinkPivotadjustmentTable
foreach (var i in indices)
{
//Make sure the list is in the correct order after parrallel processing
var lpp = PairedApproaches.FirstOrDefault(p =>
p.SignalApproach.SignalID == route.RouteSignals[i].SignalId);
if (lpp != null)
{
Adjustment.AddLinkPivotAdjustmentRow(lpp.SignalApproach.SignalID, Convert.ToInt32(lpp.SecondsAdded),
0,
lpp.PaogUpstreamBefore, lpp.PaogDownstreamBefore, lpp.AogUpstreamBefore,
lpp.AogDownstreamBefore,
lpp.PaogUpstreamPredicted, lpp.PaogDownstreamPredicted, lpp.AogUpstreamPredicted,
lpp.AogDownstreamPredicted,
lpp.SignalApproach.Signal.SignalDescription, lpp.DownSignalApproach.Signal.SignalID,
lpp.DownSignalApproach.DirectionType.Description,
lpp.SignalApproach.DirectionType.Description, lpp.ResultChartLocation,
lpp.DownSignalApproach.Signal.SignalDescription,
lpp.AogTotalBefore, lpp.PaogTotalBefore,
lpp.AogTotalPredicted, lpp.PaogTotalPredicted, lpp.LinkNumber, lpp.TotalVolumeDownstream,
lpp.TotalVolumeUpstream);
}
}
//Set the end row to have zero for the ajustments. No adjustment can be made because
//downstream is unknown. The end row is determined by the starting point seleceted by the user
if (direction == "Upstream")
{
Adjustment.AddLinkPivotAdjustmentRow(route.RouteSignals.FirstOrDefault().SignalId, 0, 0, 0, 0, 0, 0,
0,
0, 0, 0,
route.RouteSignals.FirstOrDefault().Signal.SignalDescription,
"", "", "", "", "", 0, 0, 0, 0, 1, 0, 0);
}
else
{
Adjustment.AddLinkPivotAdjustmentRow(
route.RouteSignals.LastOrDefault().SignalId, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, route.RouteSignals.LastOrDefault().Signal.SignalDescription, "", "",
"",
"", "", 0, 0, 0, 0,
route.RouteSignals.Count, 0, 0);
}
var cumulativeChange = 0;
//Determine the adjustment by adding the previous rows adjustment to the current rows delta
for (var i = Adjustment.Count - 1; i >= 0; i--)
{
//if the new adjustment is greater than the cycle time than the adjustment should subtract
// the cycle time from the current adjustment and the result should be the new adjustment
if (cumulativeChange + Adjustment[i].Delta > cycleTime)
{
Adjustment[i].Adjustment = cumulativeChange + Adjustment[i].Delta - cycleTime;
cumulativeChange = cumulativeChange + Adjustment[i].Delta - cycleTime;
}
else
{
Adjustment[i].Adjustment = cumulativeChange + Adjustment[i].Delta;
cumulativeChange = cumulativeChange + Adjustment[i].Delta;
}
}
}
}