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(); }