public double GetTmcVolume(DateTime startDate, DateTime endDate, string signalId, int phase)
{
var repository =
SignalsRepositoryFactory.Create();
var signal = repository.GetVersionOfSignalByDate(signalId, startDate);
var graphDetectors = signal.GetDetectorsForSignalByPhaseNumber(phase);
var tmcChannels = new List <int>();
foreach (var gd in graphDetectors)
{
foreach (var dt in gd.DetectionTypes)
{
if (dt.DetectionTypeID == 4)
{
tmcChannels.Add(gd.DetChannel);
}
}
}
double count = (from cel in _db.Controller_Event_Log
where cel.Timestamp >= startDate &&
cel.Timestamp < endDate &&
cel.SignalID == signalId &&
tmcChannels.Contains(cel.EventParam) &&
cel.EventCode == 82
select cel).Count();
return(count);
}
public RouteSignal GetByRouteSignalId(int id)
{
var routeSignal = db.RouteSignals.Include("PhaseDirections").FirstOrDefault(r => r.Id == id);
var signalRepository = SignalsRepositoryFactory.Create();
routeSignal.Signal = signalRepository.GetLatestVersionOfSignalBySignalID(routeSignal.SignalId);
return(routeSignal);
}
public List <DatabaseArchiveExcludedSignal> GetAllExcludedSignals()
{
var excludedSignals = _db.DatabaseArchiveExcludedSignals
.ToList();
var orderedSignals = excludedSignals.OrderBy(signal => signal.SignalId).ToList();
var signalRepository = SignalsRepositoryFactory.Create();
foreach (var databaseArchiveExcludedSignal in orderedSignals)
{
databaseArchiveExcludedSignal.SignalDescription =
signalRepository.GetSignalDescription(databaseArchiveExcludedSignal.SignalId);
}
return(orderedSignals);
}
