public IEnumerable <CoverageHistory> GetCoverageHistories(DateTime begin, DateTime end)
{
var results = new List <CoverageHistory>();
while (begin < end.AddDays(1))
{
var beginDate = begin.Date;
var endDate = begin.Date.AddDays(1);
results.Add(new CoverageHistory
{
DateString = beginDate.ToShortDateString(),
CoverageStats = _coverageStatRepository.Count(x => x.StatDate >= beginDate && x.StatDate < endDate),
TownCoverageStats =
_townCoverageRepository.Count(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.All),
TownCoverage800 =
_townCoverageRepository.Count(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.Band800VoLte),
TownCoverage1800 =
_townCoverageRepository.Count(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.Band1800),
TownCoverage2100 =
_townCoverageRepository.Count(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.Band2100),
CollegeCoverageStats =
_townCoverageRepository.Count(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.College),
MarketCoverageStats =
_townCoverageRepository.Count(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.Market),
TransportationCoverageStats =
_townCoverageRepository.Count(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.Transportation)
});
begin = begin.AddDays(1);
}
return(results);
}
public IEnumerable <AlarmHistory> GetAlarmHistories(DateTime begin, DateTime end)
{
var results = new List <AlarmHistory>();
while (begin < end.AddDays(1))
{
var beginDate = begin.Date;
var endDate = begin.Date.AddDays(1);
results.Add(new AlarmHistory
{
DateString = beginDate.ToShortDateString(),
Alarms = _repository.Count(x => x.HappenTime >= beginDate && x.HappenTime < endDate),
CoverageStats = _coverageStatRepository.Count(x => x.StatDate >= beginDate && x.StatDate < endDate),
TownCoverageStats = _townCoverageRepository.Count(x => x.StatDate >= beginDate && x.StatDate < endDate)
});
begin = begin.AddDays(1);
}
return(results);
}
