public void Test_Import_UpdateSecondFrequency(
int btsId, byte sectorId, int cellId, short frequency, string cellType, double antennaGain,
short overallFrequency)
{
var cell = new CdmaCell
{
BtsId = 1,
SectorId = 2,
CellId = 3,
Frequency = 1,
CellType = "DO",
AntennaGain = 12.8,
Frequency1 = 37
};
var cellExcelInfo = new CdmaCellExcel
{
BtsId = btsId,
SectorId = sectorId,
CellId = cellId,
Frequency = frequency,
CellType = cellType,
AntennaGain = antennaGain
};
cell.Import(cellExcelInfo);
Assert.AreEqual(cell.BtsId, 1, "btsId");
Assert.AreEqual(cell.SectorId, 2);
Assert.AreEqual(cell.CellId, 3);
Assert.AreEqual(cell.CellType, "DO");
Assert.AreEqual(cell.Frequency, overallFrequency, "frequency");
Assert.AreEqual(cell.Frequency1, 37);
Assert.AreEqual(cell.Frequency2, frequency == 37 || !frequency.IsCdmaFrequency() ? -1 : frequency);
Assert.AreEqual(cell.AntennaGain, !frequency.IsCdmaFrequency() || frequency == 37 ? 12.8 : antennaGain);
}
public void Test_Import_UpdateFirstFrequency(
int btsId, byte sectorId, int cellId, short frequency, string cellType, double antennaGain,
short overallFrequency)
{
var cell = new CdmaCell
{
BtsId = 1,
SectorId = 2,
CellId = 3,
Frequency = 0,
CellType = "DO",
AntennaGain = 12.8,
Frequency1 = -1
};
var cellExcelInfo = new CdmaCellExcel
{
BtsId = btsId,
SectorId = sectorId,
CellId = cellId,
Frequency = frequency,
CellType = cellType,
AntennaGain = antennaGain
};
cell.Import(cellExcelInfo);
Assert.AreEqual(cell.BtsId, 1, "btsId");
Assert.AreEqual(cell.SectorId, 2);
Assert.AreEqual(cell.CellId, 3);
Assert.AreEqual(cell.CellType, "DO");
Assert.AreEqual(cell.Frequency, overallFrequency, "frequency");
Assert.AreEqual(cell.Frequency1, overallFrequency == 0 ? -1 : frequency, "frequency1");
Assert.AreEqual(cell.AntennaGain, overallFrequency != 0 ? antennaGain :12.8);
Assert.AreEqual(cell.HasFrequency(frequency), overallFrequency != 0);
}
protected override bool SaveWhenBtsNotExisted()
{
bool result = true;
CdmaCellBase cellBase = _baseRepository.QueryCell(_cellInfo.BtsId, _cellInfo.SectorId, _cellInfo.CellType);
if (cellBase == null)
{
CdmaCell cell = new CdmaCell();
cell.Import(_cellInfo, true);
_repository.Insert(cell);
}
else if (cellBase.Frequency < 0 || !cellBase.HasFrequency(_cellInfo.Frequency))
{
CdmaCell cell = _repository.Query(_cellInfo.BtsId, _cellInfo.SectorId, _cellInfo.CellType);
if (cell != null)
{
cell.Import(_cellInfo, true);
}
}
else
{
result = false;
}
return(result);
}
public void TestCdmaCellConstruction_SameSecondFrequency()
{
CdmaCellExcel cellExcelInfo = new CdmaCellExcel
{
BtsId = 22,
SectorId = 2,
CellId = 255,
Frequency = 78,
CellType = "DO"
};
using (CdmaCell cell = new CdmaCell
{
BtsId = 1,
SectorId = 2,
CellId = 255,
Frequency1 = 37,
Frequency2 = 78,
Frequency = 3
})
{
cell.Import(cellExcelInfo, true);
Assert.IsNotNull(cell);
Assert.AreEqual(cell.BtsId, 1);
Assert.AreEqual(cell.SectorId, 2);
Assert.AreEqual(cell.CellId, 255);
Assert.AreEqual(cell.CellType, null);
Assert.AreEqual(cell.Frequency1, 37, "f1");
Assert.AreEqual(cell.Frequency2, 78, "f1");
Assert.AreEqual(cell.Frequency3, -1);
Assert.AreEqual(cell.Frequency, 3);
Assert.IsTrue(cell.HasFrequency(37));
Assert.IsTrue(cell.HasFrequency(78));
}
using (CdmaCell cell = new CdmaCell
{
BtsId = 1,
SectorId = 2,
CellId = 255,
Frequency1 = 37,
Frequency2 = 78,
Frequency = 3
})
{
CdmaCell.UpdateFirstFrequency = true;
cell.Import(cellExcelInfo, true);
Assert.IsNotNull(cell);
Assert.AreEqual(cell.BtsId, 1);
Assert.AreEqual(cell.SectorId, 2);
Assert.AreEqual(cell.CellId, 255);
Assert.AreEqual(cell.CellType, null);
Assert.AreEqual(cell.Frequency1, 37);
Assert.AreEqual(cell.Frequency2, 78);
Assert.AreEqual(cell.Frequency3, -1);
Assert.AreEqual(cell.Frequency, 3);
Assert.IsTrue(cell.HasFrequency(37));
Assert.IsTrue(cell.HasFrequency(78));
}
}
public void TestCdmaCellConstruction_NewCell()
{
CdmaCell cell = new CdmaCell {
BtsId = 1, SectorId = 2, CellId = 255, Frequency1 = -1
};
CdmaCellExcel cellExcelInfo = new CdmaCellExcel
{
BtsId = 22,
SectorId = 2,
CellId = 255,
Frequency = 37,
CellType = "DO"
};
cell.Import(cellExcelInfo, false);
Assert.IsNotNull(cell);
Assert.AreEqual(cell.BtsId, 1);
Assert.AreEqual(cell.SectorId, 2);
Assert.AreEqual(cell.CellId, 255);
Assert.AreEqual(cell.CellType, null);
Assert.AreEqual(cell.Frequency1, 37);
Assert.IsTrue(cell.HasFrequency(37));
Assert.IsFalse(cell.HasFrequency(78));
Assert.AreEqual(cell.Frequency, 1);
Assert.AreEqual(cell.Frequency2, -1);
cell = new CdmaCell {
BtsId = 1, SectorId = 2, CellId = 255, Frequency1 = -1
};
cell.Import(cellExcelInfo, true);
Assert.IsNotNull(cell);
Assert.AreEqual(cell.BtsId, 22);
Assert.AreEqual(cell.SectorId, 2);
Assert.AreEqual(cell.CellId, 255);
Assert.AreEqual(cell.CellType, "DO");
Assert.AreEqual(cell.Frequency1, 37);
Assert.IsTrue(cell.HasFrequency(37));
Assert.IsFalse(cell.HasFrequency(78));
Assert.AreEqual(cell.Frequency, 1);
Assert.AreEqual(cell.Frequency2, -1);
}
public void TestCdmaCellConstruction_SameFirstFrequency()
{
CdmaCellExcel cellExcelInfo = new CdmaCellExcel
{
BtsId = 22,
SectorId = 2,
CellId = 255,
Frequency = 37,
CellType = "DO"
};
using (CdmaCell cell = new CdmaCell { BtsId = 1, SectorId = 2, CellId = 255, Frequency1 = 37, Frequency = 1 })
{
cell.Import(cellExcelInfo, true);
Assert.IsNotNull(cell);
Assert.AreEqual(cell.BtsId, 1);
Assert.AreEqual(cell.SectorId, 2);
Assert.AreEqual(cell.CellId, 255);
Assert.AreEqual(cell.CellType, null);
Assert.AreEqual(cell.Frequency1, 37, "f1");
Assert.AreEqual(cell.Frequency, 1);
Assert.AreEqual(cell.Frequency2, -1, "f1");
Assert.IsTrue(cell.HasFrequency(37));
Assert.IsFalse(cell.HasFrequency(78));
}
using (CdmaCell cell = new CdmaCell { BtsId = 1, SectorId = 2, CellId = 255, Frequency1 = 37, Frequency = 1 })
{
CdmaCell.UpdateFirstFrequency = true;
cell.Import(cellExcelInfo, true);
Assert.IsNotNull(cell);
Assert.AreEqual(cell.BtsId, 1);
Assert.AreEqual(cell.SectorId, 2);
Assert.AreEqual(cell.CellId, 255);
Assert.AreEqual(cell.CellType, null);
Assert.AreEqual(cell.Frequency1, 37);
Assert.AreEqual(cell.Frequency, 1);
Assert.AreEqual(cell.Frequency2, -1);
Assert.IsTrue(cell.HasFrequency(37));
Assert.IsFalse(cell.HasFrequency(78));
}
}
public void TestCdmaCellConstruction_NewCell()
{
CdmaCell cell = new CdmaCell { BtsId = 1, SectorId = 2, CellId = 255, Frequency1 = -1 };
CdmaCellExcel cellExcelInfo = new CdmaCellExcel
{
BtsId = 22,
SectorId = 2,
CellId = 255,
Frequency = 37,
CellType = "DO"
};
cell.Import(cellExcelInfo, false);
Assert.IsNotNull(cell);
Assert.AreEqual(cell.BtsId, 1);
Assert.AreEqual(cell.SectorId, 2);
Assert.AreEqual(cell.CellId, 255);
Assert.AreEqual(cell.CellType, null);
Assert.AreEqual(cell.Frequency1, 37);
Assert.IsTrue(cell.HasFrequency(37));
Assert.IsFalse(cell.HasFrequency(78));
Assert.AreEqual(cell.Frequency, 1);
Assert.AreEqual(cell.Frequency2, -1);
cell = new CdmaCell { BtsId = 1, SectorId = 2, CellId = 255, Frequency1 = -1 };
cell.Import(cellExcelInfo, true);
Assert.IsNotNull(cell);
Assert.AreEqual(cell.BtsId, 22);
Assert.AreEqual(cell.SectorId, 2);
Assert.AreEqual(cell.CellId, 255);
Assert.AreEqual(cell.CellType, "DO");
Assert.AreEqual(cell.Frequency1, 37);
Assert.IsTrue(cell.HasFrequency(37));
Assert.IsFalse(cell.HasFrequency(78));
Assert.AreEqual(cell.Frequency, 1);
Assert.AreEqual(cell.Frequency2, -1);
}
protected override bool SaveWhenBtsNotExisted()
{
bool result = true;
CdmaCellBase cellBase = _baseRepository.QueryCell(_cellInfo.BtsId, _cellInfo.SectorId, _cellInfo.CellType);
if (cellBase == null)
{
CdmaCell cell = new CdmaCell();
cell.Import(_cellInfo, true);
_repository.Insert(cell);
}
else if (cellBase.Frequency < 0 || !cellBase.HasFrequency(_cellInfo.Frequency))
{
CdmaCell cell = _repository.Query(_cellInfo.BtsId, _cellInfo.SectorId, _cellInfo.CellType);
if (cell != null) { cell.Import(_cellInfo, true); }
}
else { result = false; }
return result;
}
public void TestCdmaCellConstruction_UpdateFourthFrequency()
{
;
CdmaCellExcel cellExcelInfo = new CdmaCellExcel
{
BtsId = 22,
SectorId = 2,
CellId = 255,
Frequency = 160,
CellType = "DO"
};
using (CdmaCell cell = new CdmaCell
{
BtsId = 1,
SectorId = 2,
CellId = 255,
Frequency1 = 37,
Frequency2 = 78,
Frequency3 = 119,
Frequency = 7
})
{
cell.Import(cellExcelInfo, true);
Assert.IsNotNull(cell);
Assert.AreEqual(cell.BtsId, 1);
Assert.AreEqual(cell.SectorId, 2);
Assert.AreEqual(cell.CellId, 255);
Assert.AreEqual(cell.CellType, null);
Assert.AreEqual(cell.Frequency1, 37, "f1");
Assert.AreEqual(cell.Frequency2, 78, "f1");
Assert.AreEqual(cell.Frequency3, 119);
Assert.AreEqual(cell.Frequency4, 160);
Assert.AreEqual(cell.Frequency5, -1);
Assert.AreEqual(cell.Frequency, 15);
Assert.IsTrue(cell.HasFrequency(37));
Assert.IsTrue(cell.HasFrequency(78));
Assert.IsTrue(cell.HasFrequency(119));
Assert.IsTrue(cell.HasFrequency(160));
}
using (CdmaCell cell = new CdmaCell
{
BtsId = 1,
SectorId = 2,
CellId = 255,
Frequency1 = 37,
Frequency2 = 78,
Frequency3 = 119,
Frequency = 7
})
{
CdmaCell.UpdateFirstFrequency = true;
cell.Import(cellExcelInfo, true);
Assert.IsNotNull(cell);
Assert.AreEqual(cell.BtsId, 1);
Assert.AreEqual(cell.SectorId, 2);
Assert.AreEqual(cell.CellId, 255);
Assert.AreEqual(cell.CellType, null);
Assert.AreEqual(cell.Frequency1, 37);
Assert.AreEqual(cell.Frequency2, 78);
Assert.AreEqual(cell.Frequency3, 119);
Assert.AreEqual(cell.Frequency4, 160);
Assert.AreEqual(cell.Frequency5, -1);
Assert.AreEqual(cell.Frequency, 15);
Assert.IsTrue(cell.HasFrequency(37));
Assert.IsTrue(cell.HasFrequency(78));
Assert.IsTrue(cell.HasFrequency(119));
Assert.IsTrue(cell.HasFrequency(160));
}
}