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