public static void EndManualCommandsTransactions() { return; StringBuilder sbSQL = new StringBuilder(); List <string> listSQL = CurrentCommandsSQL; string currentFileName = GlobalConstants.CurrentFileName; foreach (string sql in listSQL) { sbSQL.Append(sql); } /*****************/ CurrentCommandsSQL.Clear(); GlobalConstants.CurrentFileName = string.Empty; IsManualCommandTransactions = false; /*****************/ DirectoryInfo dir = new DirectoryInfo(GlobalConstants.QUEUE_FILES); if (dir.Exists) { FileInfo[] fInfo = dir.GetFiles(); foreach (FileInfo f in fInfo) { sbSQL.Append(GetContentFile(f.FullName)); f.Delete(); } } string fName = GlobalConstants.TEMP_FILES + "\\" + currentFileName; if (File.Exists(fName)) { sbSQL.Append(GetContentFile(fName)); File.Delete(fName); } //foreach (string sql in listSQL) // sbSQL.Append(sql); //CurrentCommandsSQL.Clear(); //GlobalConstants.CurrentFileName = string.Empty; //IsManualCommandTransactions = false; CatTransactionBL.AddCommandsTransaction(sbSQL.ToString()); IsActivatedManualCommandTransaction = false; }
public static void LogTransaction(string Agent, string Command) { CatTransactionBL.AddCommandsTransaction(Login.Agent, Common.CurrentPNR, Command, DateTime.Now, Common.CurrentArea); }