public IEnumerable <College4GTestView> GetViews(DateTime date, int hour) { var statTime = date.AddHours(hour); var results = _repository.GetAllList().Where(x => x.TestTime == statTime).ToList(); if (!results.Any()) { return(new List <College4GTestView>()); } return(results.Select(x => { var college = _collegeRepository.Get(x.CollegeId); var eNodeb = _eNodebRepository.GetByENodebId(x.ENodebId); var cell = eNodeb == null ? null : _cellRepository.GetBySectorId(x.ENodebId, x.SectorId); var view = x.MapTo <College4GTestView>(); view.CollegeName = college?.Name; view.CellName = eNodeb?.Name + "-" + x.SectorId; view.Pci = cell?.Pci ?? -1; return view; })); }
public IEnumerable <College4GTestView> GetViews(DateTime begin, DateTime end) { var results = _repository.GetAllList(x => x.TestTime >= begin && x.TestTime < end); if (!results.Any()) { return(new List <College4GTestView>()); } return(results.Select(x => { var college = _collegeRepository.Get(x.CollegeId); var eNodeb = _eNodebRepository.FirstOrDefault(e => e.ENodebId == x.ENodebId); var cell = eNodeb == null ? null : _cellRepository.GetBySectorId(x.ENodebId, x.SectorId); var view = x.MapTo <College4GTestView>(); view.CollegeName = college?.Name; view.CellName = eNodeb?.Name + "-" + x.SectorId; view.Pci = cell?.Pci ?? -1; return view; })); }