public List<CoverageInterferenceDistribution> GenerateCoverageInterferenceDistribution()
 {
     var stats = _dailyStatRepository.Stats.Select(x =>
         new
         {
             Stat = x,
             DropEcio = x.DropEcioHourInfo,
             MainRssi = x.MainRssiHourInfo,
             SubRssi = x.SubRssiHourInfo
         });
     var stat = stats.FirstOrDefault(x =>
         x.Stat.StatTime == _statDate && x.Stat.CellId == _cellId && x.Stat.SectorId == _sectorId
                    && x.Stat.Frequency == _frequency);
     List<CoverageInterferenceDistribution> result = new List<CoverageInterferenceDistribution>();
     if (stat != null)
         result.Import(stat.DropEcio, stat.MainRssi, stat.SubRssi);
     return result;
 }
 public List<DropsHourDistribution> GenerateDropsHourDistribution()
 {
     var stats = _dailyStatRepository.Stats.Select(x =>
         new
         {
             Stat = x,
             CdrCalls = x.CdrCallsHourInfo,
             CdrDrops = x.CdrDropsHourInfo,
             ErasureDrops = x.ErasureDropsHourInfo,
             KpiCalls = x.KpiCallsHourInfo,
             KpiDrops = x.KpiDropsHourInfo
         });
     var stat = stats.FirstOrDefault(x =>
         x.Stat.StatTime == _statDate && x.Stat.CellId == _cellId && x.Stat.SectorId == _sectorId
                    && x.Stat.Frequency == _frequency);
     List<DropsHourDistribution> result = new List<DropsHourDistribution>();
     if (stat != null)
         result.Import(stat.CdrCalls, stat.CdrDrops,
             stat.ErasureDrops, stat.KpiCalls, stat.KpiDrops);
     return result;
 }
 public List<DistanceDistribution> GenerateDistanceDistribution()
 {
     var stats = _dailyStatRepository.Stats.Select(x =>
         new
         {
             Stat = x,
             CdrCalls = x.CdrCallsDistanceInfo,
             CdrDrops = x.CdrDropsDistanceInfo,
             DropEcio = x.DropEcioDistanceInfo,
             GoodEcio = x.GoodEcioDistanceInfo
         });
     var stat = stats.FirstOrDefault(x =>
         x.Stat.StatTime == _statDate && x.Stat.CellId == _cellId && x.Stat.SectorId == _sectorId
                    && x.Stat.Frequency == _frequency);
     List<DistanceDistribution> result = new List<DistanceDistribution>();
     if (stat != null)
         result.Import(stat.CdrCalls, stat.CdrDrops, stat.DropEcio, stat.GoodEcio);
     return result;
 }