public List <byte> GetSectorIds(string btsName) { var bts = _btsRepository.GetByName(btsName); return(bts == null ? null : _repository.GetAll().Where(x => x.BtsId == bts.BtsId).Select(x => x.SectorId).Distinct().ToList()); }
public int SaveCdmaCells(IEnumerable<CollegeCdmaCellExcel> cellExcels, ICdmaCellRepository cellRepository) { int count = 0; foreach (CollegeCdmaCellExcel excel in cellExcels) { CdmaCell cell = cellRepository.GetAll().FirstOrDefault( x => x.BtsId == excel.BtsId && x.SectorId == excel.SectorId); if (cell == null) continue; InfrastructureInfo infrastructure = _repository.FirstOrDefault(x => x.HotspotName == excel.CollegeName && x.HotspotType == HotspotType.College && x.InfrastructureType == InfrastructureType.CdmaCell && x.InfrastructureId == cell.Id); if (infrastructure == null) { infrastructure = new InfrastructureInfo { HotspotName = excel.CollegeName, HotspotType = HotspotType.College, InfrastructureType = InfrastructureType.CdmaCell, InfrastructureId = cell.Id }; _repository.Insert(infrastructure); } count++; } return count; }
public int SaveCdmaCells(IEnumerable <CollegeCdmaCellExcel> cellExcels, ICdmaCellRepository cellRepository) { int count = 0; foreach (CollegeCdmaCellExcel excel in cellExcels) { CdmaCell cell = cellRepository.GetAll().FirstOrDefault( x => x.BtsId == excel.BtsId && x.SectorId == excel.SectorId); if (cell == null) { continue; } InfrastructureInfo infrastructure = _repository.InfrastructureInfos.FirstOrDefault(x => x.HotspotName == excel.CollegeName && x.HotspotType == HotspotType.College && x.InfrastructureType == InfrastructureType.CdmaCell && x.InfrastructureId == cell.Id); if (infrastructure == null) { infrastructure = new InfrastructureInfo { HotspotName = excel.CollegeName, HotspotType = HotspotType.College, InfrastructureType = InfrastructureType.CdmaCell, InfrastructureId = cell.Id }; _repository.AddOneInfrastructure(infrastructure); _repository.SaveChanges(); } count++; } return(count); }
public void Import(int eNodebId, IENodebRepository eNodebRepository, ICellRepository cellRepository, IBtsRepository btsRepository, ICdmaCellRepository cdmaCellRepository, IENodebPhotoRepository photoRepository) { ENodeb eNodeb = eNodebRepository.GetAll().FirstOrDefault(x => x.ENodebId == eNodebId); if (eNodeb != null) { ENodeb = eNodeb; Cells = cellRepository.GetAll().Where(x => x.ENodebId == eNodebId).ToList(); } CdmaBts bts = btsRepository.GetAll().FirstOrDefault(x => x.ENodebId == eNodebId); if (bts != null) { int btsId = bts.BtsId; Bts = bts; CdmaCells = cdmaCellRepository.GetAll().Where(x => x.BtsId == btsId).ToList(); } Photos = photoRepository.Photos.Where(x => x.ENodebId == eNodebId).ToList(); }
public static CdmaCell Query(this ICdmaCellRepository repository, int btsId, byte sectorId, string cellType) { return(repository.GetAll().FirstOrDefault( x => x.BtsId == btsId && x.SectorId == sectorId && x.CellType == cellType)); }
public IEnumerable <CdmaCell> GetCells(double west, double east, double south, double north) { return(_repository.GetAll().Where(x => x.Longtitute >= west && x.Longtitute <= east && x.Lattitute >= south && x.Lattitute <= north)); }