public IEnumerable <CellExcel> GetNewCellExcels()
{
if (!CellExcels.Any())
{
return(new List <CellExcel>());
}
return(from info in CellExcels
join cell in _cellRepository.GetAllInUseList()
on new { info.ENodebId, info.SectorId, info.Pci } equals
new { cell.ENodebId, cell.SectorId, cell.Pci } into cellQuery
from cq in cellQuery.DefaultIfEmpty()
where cq == null
select info);
}
public IEnumerable <CellIdPair> GetVanishedCellIds()
{
if (!CellExcels.Any())
{
return(new List <CellIdPair>());
}
return(from cell in _cellRepository.GetAllInUseList()
join info in CellExcels
on new { cell.ENodebId, cell.SectorId } equals new { info.ENodebId, info.SectorId }
into cellQuery
from cq in cellQuery.DefaultIfEmpty()
where cq == null
select new CellIdPair {
CellId = cell.ENodebId, SectorId = cell.SectorId
});
}
