public List <TownMrsSinrUl> QueryTownViews(DateTime begin, DateTime end, int townId, FrequencyBandType frequency)
{
var query =
_repository.GetAllList(
x =>
x.StatDate >= begin && x.StatDate < end && x.FrequencyBandType == frequency &&
x.TownId == townId)
.OrderBy(x => x.StatDate)
.ToList();
return(query);
}
public SinrUlRegionDateView QueryLastDateStat(DateTime initialDate, string city)
{
var stats = _statRepository.QueryDate(initialDate, (repository, beginDate, endDate) =>
{
var query =
_statRepository.GetAllList(x =>
x.StatDate >= beginDate & x.StatDate < endDate && x.FrequencyBandType == FrequencyBandType.All);
return(query.FilterTownList(_townRepository.GetAllList().Where(x => x.CityName == city).ToList()));
});
var townViews = stats.ConstructViews <TownMrsSinrUl, TownMrsSinrUlView>(_townRepository);
return(townViews.QueryRegionDateDateView <SinrUlRegionDateView, DistrictMrsSinrUlView, TownMrsSinrUlView>(initialDate,
DistrictMrsSinrUlView.ConstructView));
}
public IEnumerable <SinrHistory> GetSinrHistories(DateTime begin, DateTime end)
{
var results = new List <SinrHistory>();
while (begin < end.AddDays(1))
{
var beginDate = begin.Date;
var endDate = beginDate.AddDays(1);
var townSinrUlItems =
_townMrsSinrUlRepository.GetAllList(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.All);
var collegeSinrUlItems =
_townMrsSinrUlRepository.GetAllList(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.College);
var marketSinrUlItems =
_townMrsSinrUlRepository.GetAllList(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.Market);
var transportationSinrUlItems =
_townMrsSinrUlRepository.GetAllList(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.Transportation);
var townSinrUlItems800 =
_townMrsSinrUlRepository.GetAllList(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.Band800VoLte);
var townSinrUlItems1800 =
_townMrsSinrUlRepository.GetAllList(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.Band1800);
var townSinrUlItems2100 =
_townMrsSinrUlRepository.GetAllList(x =>
x.StatDate >= beginDate && x.StatDate < endDate &&
x.FrequencyBandType == FrequencyBandType.Band2100);
var topSinrUlItems =
_topMrsSinrUlRepository.GetAllList(x => x.StatDate >= beginDate && x.StatDate < endDate);
results.Add(new SinrHistory
{
DateString = begin.ToShortDateString(),
StatDate = begin.Date,
TownSinrUlStats = townSinrUlItems.Count,
CollegeSinrUlStats = collegeSinrUlItems.Count,
MarketSinrUlStats = marketSinrUlItems.Count,
TransportationSinrUlStats = transportationSinrUlItems.Count,
TownSinrUlStats800 = townSinrUlItems800.Count,
TownSinrUlStats1800 = townSinrUlItems1800.Count,
TownSinrUlStats2100 = townSinrUlItems2100.Count,
TopSinrUlStats = topSinrUlItems.Count
});
begin = begin.AddDays(1);
}
return(results);
}