public IEnumerable <ENodebView> GetByTownNames(string city, string district, string town) { var townItem = _townRepository.QueryTown(city, district, town); return(townItem == null ? null : _eNodebRepository.GetAll().Where(x => x.TownId == townItem.Id).ToList().MapTo <IEnumerable <ENodebView> >()); }
public int SaveENodebs(IEnumerable <CollegeENodebExcel> eNodebExcels, IENodebRepository eNodebRepository) { int count = 0; foreach (CollegeENodebExcel excel in eNodebExcels) { ENodeb eNodeb = eNodebRepository.GetAll().FirstOrDefault(x => x.ENodebId == excel.ENodebId); if (eNodeb == null) { continue; } InfrastructureInfo infrastructure = _repository.InfrastructureInfos.FirstOrDefault(x => x.HotspotName == excel.CollegeName && x.HotspotType == HotspotType.College && x.InfrastructureType == InfrastructureType.ENodeb && x.InfrastructureId == eNodeb.Id); if (infrastructure == null) { infrastructure = new InfrastructureInfo { HotspotName = excel.CollegeName, HotspotType = HotspotType.College, InfrastructureType = InfrastructureType.ENodeb, InfrastructureId = eNodeb.Id }; _repository.AddOneInfrastructure(infrastructure); _repository.SaveChanges(); } count++; } return(count); }
public void Save(IEnumerable <ENodebExcel> eNodebInfoList, bool update) { IEnumerable <ENodebExcel> validInfos = eNodebInfoList.Where(x => infoFilter(x)) .Distinct(new ENodebExcelComparer()) .Distinct(new ENodebExcelNameComparer()); foreach (ENodebExcel info in validInfos) { int townId = _townList.QueryId(info); ENodebBase existedENodebWithSameName = _baseRepository.QueryENodeb(townId, info.Name); ENodebBase existedENodebWithSameId = _baseRepository.QueryENodeb(info.ENodebId); if (existedENodebWithSameName == null && existedENodebWithSameId == null) { ENodeb eNodeb = new ENodeb(); eNodeb.Import(info, townId); _repository.Insert(eNodeb); _infrastructure.ENodebInserted++; } if (!update) { continue; } if (existedENodebWithSameId != null) { ENodeb byIdENodeb = _repository.GetAll().FirstOrDefault(x => x.ENodebId == info.ENodebId); if (byIdENodeb != null) { byIdENodeb.Import(info, townId, false); _repository.Update(byIdENodeb); _infrastructure.ENodebsUpdated++; } } else if (existedENodebWithSameName != null) { ENodeb byNameENodeb = _repository.GetAll().FirstOrDefault(x => x.TownId == townId && x.Name == info.Name); if (byNameENodeb != null) { byNameENodeb.Import(info, townId); _repository.Update(byNameENodeb); _infrastructure.ENodebsUpdated++; } } } }
public IEnumerable <SectorTriangle> Get(int id) { ENodeb eNodeb = eNodebRepository.GetAll().FirstOrDefault(x => x.ENodebId == id); IQueryOutdoorCellsService <EvaluationOutdoorCell> service = new ByENodebQueryOutdoorCellService <EvaluationOutdoorCell>( cellRepository, eNodeb, (c, e) => new EvaluationOutdoorCell(c, e)); List <EvaluationOutdoorCell> outdoorCells = service.Query(); return(outdoorCells.GetSectors()); }
public static IEnumerable <ENodeb> QueryCollegeENodebs(this IInfrastructureRepository repository, IENodebRepository eNodebRepository, CollegeInfo info) { IEnumerable <int> ids = repository.InfrastructureInfos.Where(x => x.HotspotName == info.Name && x.InfrastructureType == InfrastructureType.ENodeb ).Select(x => x.InfrastructureId).ToList(); return(ids.Select(i => eNodebRepository.GetAll().FirstOrDefault(x => x.Id == i) ).Where(eNodeb => eNodeb != null).ToList()); }
public void ImportCellList(IENodebRepository eNodebRepository, ICellRepository cellRepository, IGeoPoint <double> southWest, IGeoPoint <double> northEast) { IEnumerable <ENodeb> eNodebs = eNodebRepository.GetAll().FilterGeoPointList( southWest.Longtitute - GeoMath.BaiduLongtituteOffset, southWest.Lattitute - GeoMath.BaiduLattituteOffset, northEast.Longtitute - GeoMath.BaiduLongtituteOffset, northEast.Lattitute - GeoMath.BaiduLattituteOffset).ToList(); ImportCellList(cellRepository.Query(eNodebs)); }
public bool DeleteOneTown(IENodebRepository eNodebRepository, IBtsRepository btsRepository) { Town town = _repository.GetAllList().Query(_city.Trim(), _district.Trim(), _town.Trim()); if (town == null) return false; ENodeb eNodeb = (eNodebRepository != null && eNodebRepository.GetAll() != null) ? eNodebRepository.GetAll().FirstOrDefault(x => x.TownId == town.Id) : null; CdmaBts bts = (btsRepository != null && btsRepository.GetAll() != null) ? btsRepository.GetAll().FirstOrDefault(x => x.TownId == town.Id) : null; if (eNodeb == null && bts == null) { _repository.Delete(town); return true; } return false; }
public DeleteOneENodebService(IENodebRepository repository, ITownRepository townRepository, string cityName, string districtName, string townName, string eNodebName) : this(repository) { if (townRepository == null) { _eNodeb = null; } else { int townId = townRepository.GetAll().QueryId(cityName, districtName, townName); _eNodeb = repository.GetAll().FirstOrDefault(x => x.TownId == townId && x.Name == eNodebName); } }
public DeleteOneENodebService(IENodebRepository repository, ITownRepository townRepository, string cityName, string districtName, string townName, string eNodebName) : this(repository) { if (townRepository == null) { _eNodeb = null; } else { int townId = townRepository.GetAll().QueryId(cityName, districtName, townName); _eNodeb = repository.GetAll().FirstOrDefault(x => x.TownId == townId && x.Name == eNodebName); } }
public IEnumerable <SectorTriangle> Get() { if (ParametersContainer.QueryCells == null) { return(new List <SectorTriangle>()); } IEnumerable <EvaluationOutdoorCell> outdoorCells = from cell in ParametersContainer.QueryCells let eNodeb = eNodebRepository.GetAll().FirstOrDefault(x => x.ENodebId == cell.ENodebId) where eNodeb != null select new EvaluationOutdoorCell(eNodeb, cell); return(outdoorCells.GetSectors()); }
public bool DeleteOneTown(IENodebRepository eNodebRepository, IBtsRepository btsRepository) { Town town = _repository.GetAllList().Query(_city.Trim(), _district.Trim(), _town.Trim()); if (town == null) { return(false); } ENodeb eNodeb = (eNodebRepository != null && eNodebRepository.GetAll() != null) ? eNodebRepository.GetAll().FirstOrDefault(x => x.TownId == town.Id) : null; CdmaBts bts = (btsRepository != null && btsRepository.GetAll() != null) ? btsRepository.GetAll().FirstOrDefault(x => x.TownId == town.Id) : null; if (eNodeb == null && bts == null) { _repository.Delete(town); return(true); } return(false); }
public ENodebListViewModel(IENodebRepository eNodebRepository, ITownRepository townRepository, int townId, int page, int pageSize = 10) { if (townId != _townId) { ParametersContainer.QueryENodebs = eNodebRepository.GetAll().Where(x => x.TownId == townId).OrderBy(p => p.Id).ToList(); _townId = townId; Town town = townRepository.Get(TownId); _infoTitle = (town == null) ? "" : town.CityName + town.DistrictName + town.TownName + "基站列表"; } this.SetItems(page, pageSize); }
public ActionResult UpdateENodebInfo(ENodeb item) { ENodeb eNodeb = _eNodebRepository.GetAll().FirstOrDefault(x => x.ENodebId == item.ENodebId); if (eNodeb == null) { return(View("ENodebEdit", new ENodebDetailsViewModel())); } eNodeb.Address = item.Address; eNodeb.Name = item.Name; eNodeb.Factory = item.Factory; ENodebDetailsViewModel viewModel = new ENodebDetailsViewModel(); viewModel.Import(eNodeb.ENodebId, _eNodebRepository, _cellRepository, _btsRepository, _cdmaCellRepository, _photoRepository); return(View("ENodebEdit", viewModel)); }
public override void Save(IEnumerable <CellExcel> cellInfoList, ParametersDumpInfrastructure infrastructure) { IEnumerable <CellExcel> distinctInfos = cellInfoList.Distinct(p => new { p.ENodebId, p.SectorId, p.Frequency }); IEnumerable <CellExcel> _validInfos = from d in distinctInfos join e in _eNodebRepository.GetAll() on d.ENodebId equals e.ENodebId select d; var updateCells = (from v in _validInfos join c in _repository.GetAll() on new { v.ENodebId, v.SectorId, v.Frequency } equals new { c.ENodebId, c.SectorId, c.Frequency } select new { Info = v, Data = c }).ToList(); infrastructure.CellsUpdated = 0; infrastructure.NeighborPciUpdated = 0; if (_updateExisted) { foreach (var cell in updateCells.Where(x => x.Data.Pci != x.Info.Pci)) { cell.Info.CloneProperties(cell.Data); _repository.Update(cell.Data); infrastructure.CellsUpdated++; } if (_updatePci) { infrastructure.NeighborPciUpdated = SaveLteCellRelationService.UpdateNeighborPci(_validInfos); } } IEnumerable <Cell> insertInfos = _validInfos.Except(updateCells.Select(x => x.Info)).Select(x => { Cell cell = new Cell(); cell.Import(x); return(cell); }).ToList(); _repository.AddCells(insertInfos); infrastructure.CellsInserted = insertInfos.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 IEnumerable<ENodeb> QueryCollegeENodebs(this IInfrastructureRepository repository, IENodebRepository eNodebRepository, CollegeInfo info) { IEnumerable<int> ids = repository.InfrastructureInfos.Where(x => x.HotspotName == info.Name && x.InfrastructureType == InfrastructureType.ENodeb ).Select(x => x.InfrastructureId).ToList(); return ids.Select(i => eNodebRepository.GetAll().FirstOrDefault(x => x.Id == i) ).Where(eNodeb => eNodeb != null).ToList(); }
public DeleteOneENodebService(IENodebRepository repository, int eNodebId) : this(repository) { _eNodeb = repository.GetAll().FirstOrDefault(x => x.ENodebId == eNodebId); }
public ByENodebQuickSaveOneCellService(ICellRepository repository, CellBaseRepository baseRepository, CellExcel cellInfo, IENodebRepository eNodebRepository, bool updateExisted = false) : base(repository, cellInfo, baseRepository, updateExisted) { _eNodeb = eNodebRepository.GetAll().FirstOrDefault(x => x.ENodebId == cellInfo.ENodebId); }
public DeleteOneENodebService(IENodebRepository repository, int townId, string eNodebName) : this(repository) { _eNodeb = repository.GetAll().FirstOrDefault(x => x.TownId == townId && x.Name == eNodebName); }
public DeleteOneENodebService(IENodebRepository repository, int townId, string eNodebName) : this(repository) { _eNodeb = repository.GetAll().FirstOrDefault(x => x.TownId == townId && x.Name == eNodebName); }
public int SaveENodebs(IEnumerable<CollegeENodebExcel> eNodebExcels, IENodebRepository eNodebRepository) { int count = 0; foreach (CollegeENodebExcel excel in eNodebExcels) { ENodeb eNodeb = eNodebRepository.GetAll().FirstOrDefault(x => x.ENodebId == excel.ENodebId); if (eNodeb==null) continue; InfrastructureInfo infrastructure = _repository.FirstOrDefault(x => x.HotspotName == excel.CollegeName && x.HotspotType == HotspotType.College && x.InfrastructureType == InfrastructureType.ENodeb && x.InfrastructureId == eNodeb.Id); if (infrastructure == null) { infrastructure = new InfrastructureInfo { HotspotName = excel.CollegeName, HotspotType = HotspotType.College, InfrastructureType = InfrastructureType.ENodeb, InfrastructureId = eNodeb.Id }; _repository.Insert(infrastructure); } count++; } return count; }
public DeleteOneENodebService(IENodebRepository repository, int eNodebId) : this(repository) { _eNodeb = repository.GetAll().FirstOrDefault(x => x.ENodebId == eNodebId); }
public ENodeb Get(int id) { return(_repository.GetAll().FirstOrDefault(x => x.ENodebId == id)); }
public SimpleSaveOneCellService(ICellRepository repository, CellExcel cellInfo, IENodebRepository eNodebRepository) : base(repository, cellInfo) { _eNodeb = eNodebRepository.GetAll().FirstOrDefault(x => x.ENodebId == cellInfo.ENodebId); }
public ByENodebQuickSaveOneCellService(ICellRepository repository, CellBaseRepository baseRepository, CellExcel cellInfo, IENodebRepository eNodebRepository, bool updateExisted = false) : base(repository, cellInfo, baseRepository, updateExisted) { _eNodeb = eNodebRepository.GetAll().FirstOrDefault(x => x.ENodebId == cellInfo.ENodebId); }
public void ImportCellList(IENodebRepository eNodebRepository, ICellRepository cellRepository, IGeoPoint<double> southWest, IGeoPoint<double> northEast) { IEnumerable<ENodeb> eNodebs = eNodebRepository.GetAll().FilterGeoPointList( southWest.Longtitute - GeoMath.BaiduLongtituteOffset, southWest.Lattitute - GeoMath.BaiduLattituteOffset, northEast.Longtitute - GeoMath.BaiduLongtituteOffset, northEast.Lattitute - GeoMath.BaiduLattituteOffset).ToList(); ImportCellList(cellRepository.Query(eNodebs)); }
public SimpleSaveOneCellService(ICellRepository repository, CellExcel cellInfo, IENodebRepository eNodebRepository) : base(repository, cellInfo) { _eNodeb = eNodebRepository.GetAll().FirstOrDefault(x => x.ENodebId == cellInfo.ENodebId); }