public List <byte> GetSectorIds(string eNodebName)
{
var eNodeb = _eNodebRepository.GetByName(eNodebName);
return(eNodeb == null
? null
: _repository.GetAll().Where(x => x.ENodebId == eNodeb.ENodebId).Select(x => x.SectorId).ToList());
}
public async Task <int> UpdateHotSpotCells(CollegeCellNamesContainer container)
{
foreach (var cell in from cellName in container.CellNames
select cellName.GetSplittedFields('-')
into fields
where fields.Length > 1
let eNodeb = _eNodebRepository.GetByName(fields[0])
where eNodeb != null
select _cellRepository.GetBySectorId(eNodeb.ENodebId, fields[1].ConvertToByte(0))
into cell
where cell != null
select cell)
{
await _repository.InsertAsync(new HotSpotCellId
{
ENodebId = cell.ENodebId,
SectorId = cell.SectorId,
HotspotType = HotspotType.College,
HotspotName = container.CollegeName
});
}
return(_repository.SaveChanges());
}
public async Task <int> Post(College4GTestView view)
{
var college = _collegeRepository.GetByName(view.CollegeName);
if (college == null)
{
return(0);
}
view.TestTime = DateTime.Today.AddHours(DateTime.Now.Hour);
var result =
_repository.FirstOrDefault(
x => x.TestTime == view.TestTime && x.CollegeId == college.Id && x.Place == view.Place);
if (result != null)
{
Mapper.Map(view, result);
}
else
{
result = view.MapTo <College4GTestResults>();
}
result.CollegeId = college.Id;
var fields = view.CellName.GetSplittedFields('-');
if (fields.Length > 1)
{
var eNodeb = _eNodebRepository.GetByName(fields[0]);
if (eNodeb != null)
{
result.ENodebId = eNodeb.ENodebId;
result.SectorId = fields[1].ConvertToByte(0);
}
}
await _repository.InsertOrUpdateAsync(result);
return(_repository.SaveChanges());
}
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);
}
public LteRru QueryRru(string cellName)
{
var fields = cellName.GetSplittedFields('-');
if (fields.Length < 2)
{
return(null);
}
var eNodebName = fields[0];
var sectorId = fields[1].ConvertToByte(0);
var eNodeb = _eNodebRepository.GetByName(eNodebName);
if (eNodeb == null)
{
return(null);
}
var cell = _repository.GetBySectorId(eNodeb.ENodebId, sectorId);
if (cell == null)
{
return(null);
}
return(_rruRepository.Get(eNodeb.ENodebId, cell.LocalSectorId));
}