private bool AlreadyFrequencyHasInGCELLFREQ(FrequencyChangeData frequencyChangeData)
{
if (GCELLFREQ.Exists(i => i["BSCName"] == frequencyChangeData.BSCName &&
i["CELLID"] == frequencyChangeData.CELLID &&
i["TRXID"].Trim().Length == 0 &&
i["FREQ"] == frequencyChangeData.NewFrequency))
{
return(true);
}
return(false);
}
private bool HasFrequencyInProvidedCell(FrequencyChangeData frequencyChangeData)
{
var currentData =
GTRX.Where(
i =>
i["FREQ"] == frequencyChangeData.OldFrequency && i["BSCName"] == frequencyChangeData.BSCName &&
i["CELLID"] == frequencyChangeData.CELLID);
foreach (Dictionary <string, string> dictionary in currentData)
{
return(true);
}
return(false);
}
private bool Has900RFHopping(FrequencyChangeData frequencyChangeData)
{
if (frequencyChangeData.NewFrequency.Trim().Length == 3)
{
return(false);
}
if (GCELLMAGRP.Exists(i => i["BSCName"] == frequencyChangeData.BSCName &&
i["CELLID"] == frequencyChangeData.CELLID &&
i["HOPMODE"] == "RF_FH" &&
i["FREQ1"].Trim().Length == 2))
{
return(true);
}
return(false);
}
private void ReadWOInput(string inputFile)
{
DataSet aSet = IOFileOperation.ReadExcelFile(inputFile, "Input");
int count = aSet.Tables[0].Rows.Count;
foreach (DataRow dataRow in aSet.Tables[0].Rows)
{
if (dataRow["NEW BCCH"].ToString().Trim().Length != 0)
{
FrequencyChangeData aData = new FrequencyChangeData();
aData.LAC = dataRow["LAC"].ToString().Trim();
aData.CI = dataRow["CI"].ToString().Trim();
aData.OldFrequency = dataRow["BCCH"].ToString().Trim();
aData.NewFrequency = dataRow["NEW BCCH"].ToString().Trim();
woInputFrequency.Add(aData);
}
if (dataRow["NEW TCH1"].ToString().Trim().Length != 0)
{
FrequencyChangeData aData1 = new FrequencyChangeData();
aData1.LAC = dataRow["LAC"].ToString().Trim();
aData1.CI = dataRow["CI"].ToString().Trim();
aData1.OldFrequency = dataRow["TCH1"].ToString().Trim();
aData1.NewFrequency = dataRow["NEW TCH1"].ToString().Trim();
woInputFrequency.Add(aData1);
}
if (dataRow["NEW TCH2"].ToString().Trim().Length != 0)
{
FrequencyChangeData aData2 = new FrequencyChangeData();
aData2.LAC = dataRow["LAC"].ToString().Trim();
aData2.CI = dataRow["CI"].ToString().Trim();
aData2.OldFrequency = dataRow["TCH2"].ToString().Trim();
aData2.NewFrequency = dataRow["NEW TCH2"].ToString().Trim();
woInputFrequency.Add(aData2);
}
if (dataRow["NEW TCH3"].ToString().Trim().Length != 0)
{
FrequencyChangeData aData3 = new FrequencyChangeData();
aData3.LAC = dataRow["LAC"].ToString().Trim();
aData3.CI = dataRow["CI"].ToString().Trim();
aData3.OldFrequency = dataRow["TCH3"].ToString().Trim();
aData3.NewFrequency = dataRow["NEW TCH3"].ToString().Trim();
woInputFrequency.Add(aData3);
}
if (dataRow["NEW TCH4"].ToString().Trim().Length != 0)
{
FrequencyChangeData aData4 = new FrequencyChangeData();
aData4.LAC = dataRow["LAC"].ToString().Trim();
aData4.CI = dataRow["CI"].ToString().Trim();
aData4.OldFrequency = dataRow["TCH4"].ToString().Trim();
aData4.NewFrequency = dataRow["NEW TCH4"].ToString().Trim();
woInputFrequency.Add(aData4);
}
if (dataRow["NEW TCH5"].ToString().Length != 0)
{
FrequencyChangeData aData5 = new FrequencyChangeData();
aData5.LAC = dataRow["LAC"].ToString().Trim();
aData5.CI = dataRow["CI"].ToString().Trim();
aData5.OldFrequency = dataRow["TCH5"].ToString().Trim();
aData5.NewFrequency = dataRow["NEW TCH5"].ToString().Trim();
woInputFrequency.Add(aData5);
}
if (dataRow["NEW TCH6"].ToString().Length != 0)
{
FrequencyChangeData aData6 = new FrequencyChangeData();
aData6.LAC = dataRow["LAC"].ToString().Trim();
aData6.CI = dataRow["CI"].ToString().Trim();
aData6.OldFrequency = dataRow["TCH6"].ToString().Trim();
aData6.NewFrequency = dataRow["NEW TCH6"].ToString().Trim();
woInputFrequency.Add(aData6);
}
if (dataRow["NEW TCH7"].ToString().Length != 0)
{
FrequencyChangeData aData7 = new FrequencyChangeData();
aData7.LAC = dataRow["LAC"].ToString().Trim();
aData7.CI = dataRow["CI"].ToString().Trim();
aData7.OldFrequency = dataRow["TCH7"].ToString().Trim();
aData7.NewFrequency = dataRow["NEW TCH7"].ToString().Trim();
woInputFrequency.Add(aData7);
}
if (dataRow["NEW TCH8"].ToString().Trim().Length != 0)
{
FrequencyChangeData aData8 = new FrequencyChangeData();
aData8.LAC = dataRow["LAC"].ToString().Trim();
aData8.CI = dataRow["CI"].ToString();
aData8.OldFrequency = dataRow["TCH8"].ToString().Trim();
aData8.NewFrequency = dataRow["NEW TCH8"].ToString().Trim();
woInputFrequency.Add(aData8);
}
if (dataRow["NEW TCH9"].ToString().Length != 0)
{
FrequencyChangeData aData9 = new FrequencyChangeData();
aData9.LAC = dataRow["LAC"].ToString().Trim();
aData9.CI = dataRow["CI"].ToString().Trim();
aData9.OldFrequency = dataRow["TCH9"].ToString().Trim();
aData9.NewFrequency = dataRow["NEW TCH9"].ToString().Trim();
woInputFrequency.Add(aData9);
}
if (dataRow["NEW TCH10"].ToString().Length != 0)
{
FrequencyChangeData aData10 = new FrequencyChangeData();
aData10.LAC = dataRow["LAC"].ToString().Trim();
aData10.CI = dataRow["CI"].ToString().Trim();
aData10.OldFrequency = dataRow["TCH10"].ToString().Trim();
aData10.NewFrequency = dataRow["NEW TCH10"].ToString().Trim();
woInputFrequency.Add(aData10);
}
if (dataRow["NEW TCH11"].ToString().Length != 0)
{
FrequencyChangeData aData11 = new FrequencyChangeData();
aData11.LAC = dataRow["LAC"].ToString().Trim();
aData11.CI = dataRow["CI"].ToString().Trim();
aData11.OldFrequency = dataRow["TCH11"].ToString().Trim();
aData11.NewFrequency = dataRow["NEW TCH11"].ToString().Trim();
woInputFrequency.Add(aData11);
}
string bsic = dataRow["NEW BSIC"].ToString().Trim();
if (dataRow["NEW BSIC"].ToString().Trim().Length != 0)
{
BSICChangeData aData12 = new BSICChangeData();
aData12.LAC = dataRow["LAC"].ToString().Trim();
aData12.CI = dataRow["CI"].ToString().Trim();
aData12.OldBSIC = dataRow["BSIC"].ToString().Trim();
aData12.NewBSIC = dataRow["NEW BSIC"].ToString().Trim();
woInputBSIC.Add(aData12);
}
}
}
