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); }