private void PopulateTraceFileListView(bool firstRun)
{
if (CheckTraceFileDir(firstRun, traceFileDirComboBox.Text))
{
traceFileListView.Items.Clear();
DirectoryInfo dir = new DirectoryInfo(_traceFileDir);
FileInfo[] files = dir.GetFiles("*.*");
Array.Sort(files, delegate(FileInfo a, FileInfo b)
{
return(b.CreationTime.CompareTo(a.CreationTime));
});
for (int i = 0; i < files.Length; i++)
{
if (files[i].Extension == ".trc" || (files[i].Extension == ".xel" && GenericHelper.SqlServerVersion >= 11))
{
string[] items = { "", (i + 1).ToString(), files[i].Name, GenericHelper.FormatWithThousandSeparator(Convert.ToInt32(files[i].Length / 1024)), GenericHelper.FormatDate(files[i].CreationTime) };
ListViewItem traceFileListViewItem = new ListViewItem(items, GetIcon(files[i].Extension));
traceFileListView.Items.Add(traceFileListViewItem);
}
}
}
if (ConfigHandler.UseTranslation)
{
traceFileCountLabel.Text = string.Format("{1} {0}", traceFileListView.Items.Count, Translator.GetText("traceFileCountLabel"));
}
else
{
traceFileCountLabel.Text = string.Format("Number of Trace Files: {0}", traceFileListView.Items.Count);
}
}
private void PopulateSessionListView()
{
sessionListView.Items.Clear();
DataTable existingSessions = _databaseOperation.GetSessionInfo(this);
string existingSessionId = GenericHelper.GetSessionIdFromTableName();
for (int i = 0; i < existingSessions.Rows.Count; i++)
{
if (existingSessions.Rows[i]["TableName"].ToString() != existingSessionId)
{
int size = Convert.ToInt32(existingSessions.Rows[i]["TableSizeInKB"]) + Convert.ToInt32(existingSessions.Rows[i]["IndexSizeInKB"]);
string[] items = { "", (i + 1).ToString(), existingSessions.Rows[i]["TableName"].ToString(), GenericHelper.FormatWithThousandSeparator(Convert.ToInt32(size)), GenericHelper.FormatDate(Convert.ToDateTime(existingSessions.Rows[i]["CreateDate"])) };
ListViewItem sessionListViewItem = new ListViewItem(items, "database.png");
SetCheckedListViewItems(existingSessions.Rows[i]["TableName"].ToString(), sessionListViewItem);
sessionListView.Items.Add(sessionListViewItem);
}
}
if (ConfigHandler.UseTranslation)
{
sessionCountLabel.Text = string.Format("{1} {0}", sessionListView.Items.Count, Translator.GetText("sessionCountLabel"));
}
else
{
sessionCountLabel.Text = string.Format("Number of Sessions: {0}", sessionListView.Items.Count);
}
FillExistingSessionsComboBox(existingSessions);
}
