public IEnumerable <College4GTestView> GetResult(DateTime begin, DateTime end, string name)
{
var college = _collegeRepository.GetByName(name);
if (college == null)
{
return(new List <College4GTestView>());
}
var result =
_repository.GetAllList(x => x.TestTime >= begin && x.TestTime < end && x.CollegeId == college.Id);
var views = result.MapTo <IEnumerable <College4GTestView> >().Select(x =>
{
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 = name;
view.CellName = eNodeb?.Name + "-" + x.SectorId;
view.Pci = cell?.Pci ?? -1;
return(view);
});
return(views);
}
public CollegeKpi GetResult(DateTime date, int hour, string name)
{
var college = _collegeRepository.GetByName(name);
if (college == null)
{
return(null);
}
var time = date.AddHours(hour);
var result = _repository.GetByCollegeIdAndTime(college.Id, time);
return(result ?? new CollegeKpi
{
TestTime = date.AddHours(hour),
CollegeId = college.Id,
OnlineUsers = 100,
DownloadFlow = 10,
UploadFlow = 1,
RrcConnection = 99.9,
ErabConnection = 99.9,
ErabDrop = 0.1,
Connection2G = 99.8,
Connection3G = 99.9,
Erlang3G = 32,
Flow3G = 1,
Drop3G = 0.1
});
}
public CollegeYearInfo QueryInfo(string name, int year)
{
var info = _repository.GetByName(name);
return(info == null
? null
: _yearRepository.GetByCollegeAndYear(info.Id, year));
}
public IEnumerable <College3GTestView> GetViews(DateTime begin, DateTime end, string name)
{
var college = _collegeRepository.GetByName(name);
if (college == null)
{
return(new List <College3GTestView>());
}
var results =
_repository.GetAllList(x => x.TestTime >= begin && x.TestTime < end && x.CollegeId == college.Id)
.MapTo <List <College3GTestView> >();
results.ForEach(x => x.CollegeName = name);
return(results);
}
public CollegeYearView QueryInfo(string name, int year)
{
var info = _repository.GetByName(name);
if (info == null)
{
return(null);
}
var yearInfo = _yearRepository.GetByCollegeAndYear(info.Id, year);
if (yearInfo == null)
{
return(null);
}
var view = yearInfo.MapTo <CollegeYearView>();
view.Name = name;
return(view);
}
public College3GTestResults GetResult(DateTime date, int hour, string name)
{
var college = _collegeRepository.GetByName(name);
if (college == null)
{
return(null);
}
var time = date.AddHours(hour);
var result = _repository.GetByCollegeIdAndTime(college.Id, time);
return(result ?? new College3GTestResults
{
TestTime = date.AddHours(hour),
CollegeId = college.Id,
AccessUsers = 10,
DownloadRate = 500,
MinRssi = -110,
MaxRssi = -100,
Vswr = 1.4
});
}
public College4GTestResults GetResult(DateTime date, int hour, string name, string eNodebName, byte sectorId)
{
var college = _collegeRepository.GetByName(name);
if (college == null)
{
return(null);
}
var eNodeb = _eNodebRepository.GetByName(eNodebName);
if (eNodeb == null)
{
return(null);
}
var time = date.AddHours(hour);
var result = _repository.GetByCollegeIdAndTime(college.Id, time);
if (result == null)
{
return new College4GTestResults
{
TestTime = date.AddHours(hour),
CollegeId = college.Id,
ENodebId = eNodeb.ENodebId,
AccessUsers = 20,
DownloadRate = 8000,
UploadRate = 3000,
SectorId = sectorId,
Rsrp = -90,
Sinr = 14
}
}
;
result.ENodebId = eNodeb.ENodebId;
result.SectorId = sectorId;
return(result);
}
