public bool DumpSingleENodebExcel(ENodebExcel info)
{
var eNodeb = _eNodebRepository.FirstOrDefault(x => x.ENodebId == info.ENodebId);
if (eNodeb == null)
{
eNodeb = info.ConstructENodeb(_townRepository);
var result = _eNodebRepository.Insert(eNodeb);
if (result == null)
{
return(false);
}
var item = BasicImportContainer.ENodebExcels.FirstOrDefault(x => x.ENodebId == info.ENodebId);
if (item != null)
{
BasicImportContainer.ENodebExcels.Remove(item);
}
_eNodebRepository.SaveChanges();
return(true);
}
eNodeb.IsInUse = true;
_eNodebRepository.Update(eNodeb);
_eNodebRepository.SaveChanges();
return(true);
}
public static ENodeb ConstructENodeb(ENodebExcel info, ITownRepository repository)
{
var town = repository.QueryTown(info.CityName, info.DistrictName, info.TownName);
var eNodeb = Mapper.Map <ENodebExcel, ENodeb>(info);
eNodeb.TownId = town?.Id ?? -1;
return(eNodeb);
}
public static ENodeb ConstructENodeb(this ENodebExcel info, ITownRepository repository)
{
var town = repository.GetAllList()
.FirstOrDefault(x => x.CityName == info.CityName && x.DistrictName == info.DistrictName && x.TownName == info.TownName);
var eNodeb = Mapper.Map <ENodebExcel, ENodeb>(info);
eNodeb.TownId = town?.Id ?? -1;
return(eNodeb);
}
public void TestENodebExcelContruction_Gateway()
{
mockReader.Setup(x => x.GetName(4)).Returns("IP");
mockReader.Setup(x => x.GetName(5)).Returns("网关");
mockReader.Setup(x => x.GetValue(4)).Returns("10.17.165.27");
mockReader.Setup(x => x.GetValue(5)).Returns("10.17.165.100");
eNodebExcel = new ENodebExcel(mockReader.Object);
eNodebExcel.Import();
Assert.IsNotNull(eNodebExcel);
Assert.AreEqual(eNodebExcel.Ip.AddressString, "10.17.165.27");
Assert.AreEqual(eNodebExcel.Gateway.AddressString, "10.17.165.100");
}
public void TestENodebExcelContruction_Gateway()
{
mockReader.Setup(x => x.GetName(4)).Returns("IP");
mockReader.Setup(x => x.GetName(5)).Returns("网关");
mockReader.Setup(x => x.GetValue(4)).Returns("10.17.165.27");
mockReader.Setup(x => x.GetValue(5)).Returns("10.17.165.100");
eNodebExcel = new ENodebExcel(mockReader.Object);
eNodebExcel.Import();
Assert.IsNotNull(eNodebExcel);
Assert.AreEqual(eNodebExcel.Ip.AddressString, "10.17.165.27");
Assert.AreEqual(eNodebExcel.Gateway.AddressString, "10.17.165.100");
}
public void TestENodebExcelConstruction_BasicParameters()
{
PropertyInfo[] properties = (typeof(ENodebExcel)).GetProperties();
Assert.AreEqual(properties.Length, 16);
PropertyInfo property = properties.FirstOrDefault(x => x.Name == "Gateway");
Assert.IsNotNull(property);
Assert.AreEqual(property.PropertyType.Name, "IpAddress");
eNodebExcel = new ENodebExcel(mockReader.Object);
eNodebExcel.Import();
Assert.IsNotNull(eNodebExcel);
Assert.AreEqual(eNodebExcel.CityName, "Foshan");
Assert.AreEqual(eNodebExcel.DistrictName, "Chancheng");
Assert.AreEqual(eNodebExcel.TownName, "Zumiao");
Assert.AreEqual(eNodebExcel.Name, "My Bts");
Assert.AreEqual(eNodebExcel.ENodebId, 3344);
Assert.AreEqual(eNodebExcel.Longtitute, 112.123);
Assert.AreEqual(eNodebExcel.Lattitute, 23.456);
}
public void TestENodebExcelConstruction_BasicParameters()
{
PropertyInfo[] properties = (typeof(ENodebExcel)).GetProperties();
Assert.AreEqual(properties.Length, 16);
PropertyInfo property = properties.FirstOrDefault(x => x.Name == "Gateway");
Assert.IsNotNull(property);
Assert.AreEqual(property.PropertyType.Name, "IpAddress");
eNodebExcel = new ENodebExcel(mockReader.Object);
eNodebExcel.Import();
Assert.IsNotNull(eNodebExcel);
Assert.AreEqual(eNodebExcel.CityName, "Foshan");
Assert.AreEqual(eNodebExcel.DistrictName, "Chancheng");
Assert.AreEqual(eNodebExcel.TownName, "Zumiao");
Assert.AreEqual(eNodebExcel.Name, "My Bts");
Assert.AreEqual(eNodebExcel.ENodebId, 3344);
Assert.AreEqual(eNodebExcel.Longtitute, 112.123);
Assert.AreEqual(eNodebExcel.Lattitute, 23.456);
}
public bool DumpSingleENodebExcel(ENodebExcel info)
{
var eNodeb = _eNodebRepository.GetByENodebId(info.ENodebId);
if (eNodeb == null)
{
eNodeb = ENodeb.ConstructENodeb(info, _townRepository);
var result = _eNodebRepository.Insert(eNodeb);
if (result == null) return false;
var item = BasicImportService.ENodebExcels.FirstOrDefault(x => x.ENodebId == info.ENodebId);
if (item != null)
{
BasicImportService.ENodebExcels.Remove(item);
}
_eNodebRepository.SaveChanges();
return true;
}
eNodeb.IsInUse = true;
_eNodebRepository.Update(eNodeb);
_eNodebRepository.SaveChanges();
return true;
}
protected virtual void Initialize()
{
eNodebInfo = new ENodebExcel
{
ENodebId = 2,
Name = "First eNodeb",
Factory = "Huawei",
Gateway = new IpAddress("10.17.165.100"),
Ip = new IpAddress("10.17.165.121"),
CityName = "Foshan",
DistrictName = "Chancheng",
TownName = "Qinren"
};
eNodebInfos = new List<ENodebExcel>
{
new ENodebExcel
{
ENodebId = 4,
Name = "First eNodeb",
Factory = "Huawei",
Gateway = new IpAddress("10.17.165.100"),
Ip = new IpAddress("10.17.165.121"),
CityName = "Foshan",
DistrictName = "Chancheng",
TownName = "Qinren"
},
new ENodebExcel
{
ENodebId = 3,
Name = "Second eNodeb",
Factory = "Zte",
Gateway = new IpAddress("10.17.165.100"),
Ip = new IpAddress("10.17.165.122"),
CityName = "Foshan",
DistrictName = "Chancheng",
TownName = "Zumiao"
}
};
lteRepository.Setup(x => x.GetAll()).Returns(new List<ENodeb>
{
new ENodeb
{
ENodebId = 1,
Name = "FoshanZhaoming",
Address = "FenjiangZhonglu",
TownId = 122,
Gateway = (new IpAddress("10.17.165.100")).AddressValue,
SubIp = 23,
IsFdd = true,
Longtitute = 112.9987,
Lattitute = 23.1233
}
}.AsQueryable());
lteRepository.Setup(x => x.GetAllList()).Returns(lteRepository.Object.GetAll().ToList());
lteRepository.Setup(x => x.Count()).Returns(lteRepository.Object.GetAll().Count());
townRepository.Setup(x => x.GetAll()).Returns(new List<Town>
{
new Town
{
CityName = "Foshan",
DistrictName = "Chancheng",
TownName = "Qinren",
Id = 122
}
}.AsQueryable());
townRepository.Setup(x => x.GetAllList()).Returns(townRepository.Object.GetAll().ToList());
townRepository.Setup(x => x.Count()).Returns(townRepository.Object.GetAll().Count());
lteRepository.MockENodebRepositorySaveENodeb();
lteRepository.MockENodebRepositoryDeleteENodeb();
SaveENodebListService.InfoFilter = x => true;
}
protected virtual void Initialize()
{
eNodebInfo = new ENodebExcel
{
ENodebId = 2,
Name = "First eNodeb",
Factory = "Huawei",
Gateway = new IpAddress("10.17.165.100"),
Ip = new IpAddress("10.17.165.121"),
CityName = "Foshan",
DistrictName = "Chancheng",
TownName = "Qinren"
};
eNodebInfos = new List <ENodebExcel>
{
new ENodebExcel
{
ENodebId = 4,
Name = "First eNodeb",
Factory = "Huawei",
Gateway = new IpAddress("10.17.165.100"),
Ip = new IpAddress("10.17.165.121"),
CityName = "Foshan",
DistrictName = "Chancheng",
TownName = "Qinren"
},
new ENodebExcel
{
ENodebId = 3,
Name = "Second eNodeb",
Factory = "Zte",
Gateway = new IpAddress("10.17.165.100"),
Ip = new IpAddress("10.17.165.122"),
CityName = "Foshan",
DistrictName = "Chancheng",
TownName = "Zumiao"
}
};
lteRepository.Setup(x => x.GetAll()).Returns(new List <ENodeb>
{
new ENodeb
{
ENodebId = 1,
Name = "FoshanZhaoming",
Address = "FenjiangZhonglu",
TownId = 122,
Gateway = (new IpAddress("10.17.165.100")).AddressValue,
SubIp = 23,
IsFdd = true,
Longtitute = 112.9987,
Lattitute = 23.1233
}
}.AsQueryable());
lteRepository.Setup(x => x.GetAllList()).Returns(lteRepository.Object.GetAll().ToList());
lteRepository.Setup(x => x.Count()).Returns(lteRepository.Object.GetAll().Count());
townRepository.Setup(x => x.GetAll()).Returns(new List <Town>
{
new Town
{
CityName = "Foshan",
DistrictName = "Chancheng",
TownName = "Qinren",
Id = 122
}
}.AsQueryable());
townRepository.Setup(x => x.GetAllList()).Returns(townRepository.Object.GetAll().ToList());
townRepository.Setup(x => x.Count()).Returns(townRepository.Object.GetAll().Count());
lteRepository.MockENodebRepositorySaveENodeb();
lteRepository.MockENodebRepositoryDeleteENodeb();
SaveENodebListService.InfoFilter = x => true;
}
public bool Post(ENodebExcel info)
{
return _service.DumpSingleENodebExcel(info);
}
public bool Post(ENodebExcel info)
{
return(_service.DumpSingleENodebExcel(info));
}
