public IEnumerable <CollegeStat> QueryStats()
{
IEnumerable <CollegeInfo> infos = _repository.GetAllList();
return(!infos.Any()
? new List <CollegeStat>()
: infos.Select(x => new CollegeStat(_repository, x, _infrastructureRepository)));
}
public Dictionary <string, double> GetAverageRates(DateTime begin, DateTime end)
{
var results = _repository.GetAllList(begin, end);
var query = from r in results
join c in _collegeRepository.GetAllList() on r.CollegeId equals c.Id
select new { c.Name, Rate = r.DownloadRate };
return(query.GroupBy(x => x.Name).ToDictionary(s => s.Key, t => t.Average(x => x.Rate)));
}
public IEnumerable <CollegeStat> QueryStats(int year)
{
var infos = _repository.GetAllList();
return(!infos.Any()
? new List <CollegeStat>()
: infos.Select(
x =>
new CollegeStat(_repository, x, _yearRepository.GetByCollegeAndYear(x.Id, year),
_infrastructureRepository, _eNodebRepository, _cellRepository, _btsRepository, _cdmaCellRepository))
.Where(x => x.ExpectedSubscribers > 0));
}
public ActionResult List()
{
IEnumerable <CollegeInfo> infos = _repository.GetAllList();
IEnumerable <Town> towns = _townRepository.GetAllList();
CollegeViewModel viewModel = new CollegeViewModel
{
Colleges = infos.Select(x => new CollegeDto(x, towns))
};
return(View(viewModel));
}
public List <CollegeView> QueryInfos()
{
var views = _repository.GetAllList().MapTo <List <CollegeView> >();
views.ForEach(view =>
{
var region = _repository.GetRegion(view.Id);
view.RectangleRange = region?.RectangleRange;
view.Area = region?.Area ?? 0;
view.RegionType = region?.RegionType ?? 0;
view.Info = region?.Info;
var town = _townRepository.FirstOrDefault(x => x.Id == view.TownId);
if (town == null)
{
return;
}
view.City = town.CityName;
view.District = town.DistrictName;
view.Town = town.TownName;
});
return(views);
}
public Dictionary <string, IEnumerable <Tuple <string, int> > > GetAlarmCounts(DateTime begin, DateTime end)
{
var colleges = _repository.GetAllList().Select(x => x.Name);
var results = new Dictionary <string, IEnumerable <Tuple <string, int> > >();
foreach (var college in colleges)
{
var alarms = _service.QueryCollegeENodebs(college, begin, end).Where(x => x.AlarmTimes > 0).ToArray();
if (alarms.Any())
{
results.Add(college, alarms.Select(x => new Tuple <string, int>(x.Name, x.AlarmTimes)));
}
}
return(results);
}
public Dictionary <string, double> GetAverageKpi(DateTime begin, DateTime end, string kpiName)
{
var property = typeof(CollegeKpi).GetProperty(kpiName);
if (property == null)
{
return(null);
}
var results = _repository.GetAllList(begin, end);
var query = from r in results
join c in _collegeRepository.GetAllList() on r.CollegeId equals c.Id
select new { c.Name, Kpi = (double)property.GetValue(r) };
return(query.GroupBy(x => x.Name).ToDictionary(s => s.Key, t => t.Average(x => x.Kpi)));
}
public IEnumerable <CollegeInfo> Get()
{
return(_repository.GetAllList());
}
