public void DeleteSelectedTraceFiles()
{
for (int i = 0; i < traceFileListView.SelectedItems.Count; i++)
{
string fileName = string.Format(@"{0}\{1}", _traceFileDir, traceFileListView.SelectedItems[i].SubItems[2].Text);
try
{
GenericHelper.DeleteFile(fileName);
}
catch (Exception ex)
{
string text = "Error deleting Trace File.\r\n\r\n{0}";
if (ConfigHandler.UseTranslation)
{
text = Translator.GetText("errorDeletingTrace");
}
OutputHandler.Show(string.Format(text, ex.Message), GenericHelper.ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
RefreshTraceFileListView();
}
private static bool SendLogtoWebService(int returnCode)
{
bool success = false;
string machineName = Environment.MachineName;
string userName = Environment.UserName;
string domainName = Environment.UserDomainName;
try
{
ServiceHandler service = new ServiceHandler(new Uri(_sendLogToWebService));
if (ConfigHandler.StatisticsArchive == null)
{
object[] args = { "SQL Event Analyzer", GenericHelper.Version, machineName, userName, domainName, returnCode, OutputHandler.GetLog() };
success = service.InvokeMethod <bool>("LogService", "RegisterLogEvent", args);
}
else
{
byte[] attachment = GetDocument(ConfigHandler.StatisticsArchive);
object[] args = { "SQL Event Analyzer", GenericHelper.Version, machineName, userName, domainName, returnCode, OutputHandler.GetLog(), attachment };
success = service.InvokeMethod <bool>("LogService", "RegisterLogEventWithAttachment", args);
GenericHelper.DeleteFile(ConfigHandler.StatisticsArchive);
}
}
catch
{
}
return(success);
}
public bool DeleteCheckedTraceFiles()
{
bool success = true;
OutputHandler.WriteToLog(string.Format("Deleting Trace Files after import. Number of Trace Files to delete: {0}", traceFileListView.CheckedItems.Count));
for (int i = 0; i < traceFileListView.CheckedItems.Count; i++)
{
string fileName = string.Format(@"{0}\{1}", _traceFileDir, traceFileListView.CheckedItems[i].SubItems[2].Text);
try
{
GenericHelper.DeleteFile(fileName);
}
catch (Exception ex)
{
success = false;
string text = "Error deleting Trace File.\r\n\r\n{0}";
if (ConfigHandler.UseTranslation)
{
text = Translator.GetText("errorDeletingTrace");
}
OutputHandler.Show(string.Format(text, ex.Message), GenericHelper.ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
return(success);
}
public static bool WriteXmlToFile(string xml, string fileName)
{
try
{
if (File.Exists(fileName))
{
GenericHelper.DeleteFile(fileName);
}
XmlDocument xmlDocument = FormatXml(xml);
xmlDocument.LoadXml(xml);
XmlTextWriter xmlTextWriter = new XmlTextWriter(fileName, Encoding.UTF8);
xmlTextWriter.IndentChar = '\t';
xmlTextWriter.Indentation = 1;
xmlTextWriter.Formatting = Formatting.Indented;
xmlDocument.WriteContentTo(xmlTextWriter);
xmlTextWriter.Flush();
xmlTextWriter.Close();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(string.Format("Error writing Xml to file.\r\n\r\n{0}", ex.Message), GenericHelper.ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
public bool CompressCheckedTraceFiles(int filesToKeep, string sevenZipFileName)
{
bool success = true;
OutputHandler.WriteToLog(string.Format("Compressing Trace Files after import. Number of Trace Files to compress: {0}", traceFileListView.CheckedItems.Count));
try
{
GenericHelper.WriteFile(sevenZipFileName, SQLEventAnalyzer.Properties.Resources._7za);
}
catch (Exception ex)
{
OutputHandler.WriteToLog(string.Format("Error writing 7za.exe in CompressCheckedTraceFiles: \"{0}\"", ex.Message));
success = false;
}
if (success)
{
for (int i = 0; i < traceFileListView.CheckedItems.Count; i++)
{
string fileName = string.Format(@"{0}\{1}", _traceFileDir, traceFileListView.CheckedItems[i].SubItems[2].Text);
try
{
CompressionHandler.CompressFile(fileName, string.Format(@"{0}\{1}.7z", _traceFileDir, Path.GetFileNameWithoutExtension(fileName)), sevenZipFileName);
}
catch (Exception ex)
{
success = false;
string text = "Error compressing Trace File.\r\n\r\n{0}";
if (ConfigHandler.UseTranslation)
{
text = Translator.GetText("errorCompressingTrace");
}
OutputHandler.Show(string.Format(text, ex.Message), GenericHelper.ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
if (filesToKeep > 0)
{
DeleteOldCompressedFiles(filesToKeep, _traceFileDir);
}
try
{
GenericHelper.DeleteFile(sevenZipFileName);
}
catch
{
}
}
return(success);
}
public static bool DeleteTraceFile(bool showError, DatabaseOperation databaseOperation)
{
databaseOperation.DropEventSession();
if (Directory.Exists(ConfigHandler.RecordTraceFileDir))
{
foreach (string file in Directory.GetFiles(ConfigHandler.RecordTraceFileDir, string.Format("{0}*.*", ConfigHandler.TraceFileName)))
{
try
{
GenericHelper.DeleteFile(file);
}
catch (Exception ex)
{
if (showError)
{
string text = "Error deleting Trace File.\r\n\r\n{0}";
if (ConfigHandler.UseTranslation)
{
text = Translator.GetText("errorDeletingTrace");
}
OutputHandler.Show(string.Format(text, ex.Message), GenericHelper.ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
return(false);
}
}
}
else
{
if (showError)
{
string text = "The Trace File Directory \"{0}\" does not exist.\r\n\r\nPlease create the directory manually.";
if (ConfigHandler.UseTranslation)
{
text = Translator.GetText("createTraceDirManually");
}
OutputHandler.Show(string.Format(text, ConfigHandler.RecordTraceFileDir), GenericHelper.ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(false);
}
return(true);
}
private static void DeleteOldCompressedFiles(int filesToKeep, string traceFileDir)
{
DirectoryInfo di = new DirectoryInfo(traceFileDir);
FileInfo[] zipFiles = di.GetFiles(@"*.7z");
GenericHelper.DateCompareFileInfo dayCompareFileInfo = new GenericHelper.DateCompareFileInfo();
Array.Sort(zipFiles, dayCompareFileInfo);
for (int i = filesToKeep; i < zipFiles.Length; i++)
{
try
{
GenericHelper.DeleteFile(zipFiles[i].FullName);
}
catch
{
}
}
}
private static bool CompressStatisticsDirectory(string tempPath, string archiveName, string sevenZipFileName)
{
bool success = true;
try
{
GenericHelper.WriteFile(sevenZipFileName, SQLEventAnalyzer.Properties.Resources._7za);
}
catch (Exception ex)
{
OutputHandler.WriteToLog(string.Format("Error writing 7za.exe in CompressStatisticsDirectory: \"{0}\"", ex.Message));
success = false;
}
if (success)
{
try
{
CompressionHandler.CompressDirectory(tempPath, archiveName, sevenZipFileName);
}
catch (Exception ex)
{
OutputHandler.WriteToLog(string.Format("Error creating statistics archive: \"{0}\"", ex.Message));
success = false;
}
}
if (success)
{
try
{
GenericHelper.DeleteFile(sevenZipFileName);
}
catch
{
}
}
return(success);
}
private static string ApplyCustomColumnsUpdate(string fileName)
{
string updatedXml = null;
string tempFilenameAndPath = string.Format(@"{0}\{1}", GenericHelper.TempPath, Path.GetFileName(fileName));
try
{
string oldXml = File.ReadAllText(fileName, Encoding.UTF8);
ColumnCollection oldColumns = ColumnHelper.XmlToColumnCollection(oldXml);
string newXml = File.ReadAllText(tempFilenameAndPath, Encoding.UTF8);
ColumnCollection newColumns = ColumnHelper.XmlToColumnCollection(newXml);
foreach (Parameter oldParameter in oldColumns.Parameters)
{
foreach (Parameter newParameter in newColumns.Parameters)
{
if (oldParameter.Name == newParameter.Name)
{
newParameter.Value = oldParameter.Value;
break;
}
}
}
updatedXml = ColumnHelper.ColumnCollectionToXml(newColumns);
WriteXmlToFile(ColumnHelper.ColumnCollectionToXml(newColumns), fileName);
GenericHelper.DeleteFile(tempFilenameAndPath);
}
catch (Exception ex)
{
OutputHandler.Show(string.Format("Error applying Custom Column update.\r\n\r\n{0}", ex.Message), GenericHelper.ApplicationName, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
return(updatedXml);
}
public static void InitializeLog()
{
DirectoryInfo di = new DirectoryInfo(GenericHelper.ExecPath);
FileInfo[] logFiles = di.GetFiles(string.Format(@"{0}*.log", GenericHelper.ApplicationName));
GenericHelper.DateCompareFileInfo dateCompareFileInfo = new GenericHelper.DateCompareFileInfo();
Array.Sort(logFiles, dateCompareFileInfo);
for (int i = ConfigHandler.NumberOfServiceContextLogFiles - 1; i < logFiles.Length; i++)
{
try
{
GenericHelper.DeleteFile(logFiles[i].FullName);
}
catch
{
}
}
_fileNameDate = GenericHelper.FormatFileNameDate(DateTime.Now);
_log = new StringBuilder();
}
private static bool CompressStatistics(string saveToPath, string tempPath, string tempPathSendToWebService, List <string> sendToWebServiceNames, string sevenZipFileName)
{
string archiveName = string.Format(@"{0}\Statistics.zip", GenericHelper.TempPath);
bool success = CompressStatisticsDirectory(tempPath, archiveName, sevenZipFileName);
if (saveToPath != null)
{
if (Directory.Exists(saveToPath))
{
try
{
File.Copy(archiveName, string.Format(@"{0}\Statistics.zip", saveToPath), true);
}
catch (Exception ex)
{
OutputHandler.WriteToLog(string.Format("Error copying Statistics.zip to \"{0}\". Error: {1}", saveToPath, ex.Message));
success = false;
}
}
else
{
OutputHandler.WriteToLog(string.Format("Error: Directory \"{0}\" does not exist", saveToPath));
success = false;
}
}
if (success)
{
try
{
foreach (string file in Directory.GetFiles(tempPath))
{
GenericHelper.DeleteFile(file);
}
Directory.Delete(tempPath);
}
catch
{
}
}
if (success)
{
try
{
GenericHelper.DeleteFile(archiveName);
}
catch
{
}
}
if (sendToWebServiceNames.Count > 0)
{
if (success)
{
success = CompressStatisticsDirectory(tempPathSendToWebService, archiveName, sevenZipFileName);
}
if (success)
{
try
{
foreach (string file in Directory.GetFiles(tempPathSendToWebService))
{
GenericHelper.DeleteFile(file);
}
Directory.Delete(tempPathSendToWebService);
}
catch
{
}
}
if (success)
{
ConfigHandler.StatisticsArchive = archiveName;
}
}
return(success);
}