private void UpdateTRXIdInGCELLFREQ_FREQ()
{
ExecuteNonQueryOnExcel aExecuteNonQueryOnExcel = new ExecuteNonQueryOnExcel(dbFileName);
foreach (Dictionary <string, string> dictionary in GCELLFREQ)
{
var cellData =
GTRX.Where(i => i["BSCName"] == dictionary["BSCName"] && i["CELLID"] == dictionary["CELLID"] &&
i["FREQ"] == dictionary["FREQ"]);
foreach (Dictionary <string, string> aCellData in cellData)
{
dictionary["TRXID"] = aCellData["TRXID"];
}
if (!dictionary.ContainsKey("TRXID"))
{
dictionary.Add("TRXID", "");
}
}
foreach (Dictionary <string, string> dictionary in GCELLFREQ)
{
if (dictionary["TRXID"].Length != 0)
{
string nonQuery = "update [GCELLFREQ_FREQ$] set TRXID = '" + dictionary["TRXID"] +
"' where BSCName='" + dictionary["BSCName"] + "' and CELLID='" +
dictionary["CELLID"] + "' and FREQ='" + dictionary["FREQ"] + "';";
aExecuteNonQueryOnExcel.ExecuteCommandOnExcelFile(nonQuery);
Console.WriteLine(nonQuery);
}
}
aExecuteNonQueryOnExcel.CloseConnection();
}
private void RemoveColumnTRXIDInGCELLFREQ_FREQ()
{
string nonQuery = "UPDATE [GCELLFREQ_FREQ$] SET TRXID='';";
ExecuteNonQueryOnExcel aExcel = new ExecuteNonQueryOnExcel(dbFileName);
aExcel.ExecuteCommandOnExcelFile(nonQuery);
aExcel.CloseConnection();
ExecuteNonQueryOnExcel.RemoveTRXIDFromGCELLFREQ_FREQColumn(dbFileName, "GCELLFREQ_FREQ");
}
private void AddNewColumnTRXIDInGCELLFREQ_FREQ()
{
ExecuteNonQueryOnExcel aExecuteNonQueryOnExcel = new ExecuteNonQueryOnExcel(dbFileName);
string nQuery =
"CREATE TABLE [GCELLFREQ_FREQ$] (BSCName TEXT(100),CELLNAME TEXT(100),FREQ TEXT(100),CELLID TEXT(100),TRXID TEXT(100),REQUIRE TEXT(100));";
aExecuteNonQueryOnExcel.ExecuteCommandOnExcelFile(nQuery);
aExecuteNonQueryOnExcel.CloseConnection();
UpdateTRXIdInGCELLFREQ_FREQ();
}
private void RunNonQueryCommandsInDBFile(string dbFileName)
{
int index = 0;
if (logDictionary.Keys.Count != 0)
{
index = Convert.ToInt16(logDictionary.Keys.Last()) + 1;
}
int totalCommand = nonQueryCommandList.Where(i => i != "").Count();
string log = string.Empty;
string errorLog = string.Empty;
ExecuteNonQueryOnExcel aNonQueryOnExcel = new ExecuteNonQueryOnExcel(dbFileName);
foreach (string nonQuery in nonQueryCommandList)
{
if (nonQuery.Trim().Length != 0)
{
log = "Running Command(Freq Change): " + nonQuery + "\r\n";
Console.WriteLine("Running Command(" + ++index + "/" + totalCommand + "): " + nonQuery);
int affectedRows = aNonQueryOnExcel.ExecuteCommandOnExcelFile(nonQuery);
Console.WriteLine("Affected Rows(Freq Change): " + affectedRows);
log += "Affected Rows: " + affectedRows + "\n";
logDictionary.Add(index.ToString(), log);
if (affectedRows != 1)
{
errorLog = "Error: " + nonQuery + "\r\n Affected Rows: " + affectedRows;
errorLogDictionary.Add(index.ToString(), errorLog);
}
}
}
aNonQueryOnExcel.CloseConnection();
}
