private void SQLView_Clicked(object sender, EventArgs e)
{
var menu = sender as ToolStripMenuItem;
var currentStatus = menu.Checked;
/* reset all menu's */
allToolStripMenuItem.Checked = false;
byWhereClauseToolStripMenuItem.Checked = false;
byFromClauseToolStripMenuItem.Checked = false;
errorsToolStripMenuItem.Checked = false;
menu.Checked = currentStatus;
if (sender == allToolStripMenuItem)
{
mainTabStrip.SelectedTab = sqlStatementsTab;
UIBuilder.BuildAllSQLList(sqlListView, traceData.SQLStatements);
sortAscending = true;
sqlListView.ListViewItemSorter = new ListViewItemComparer(0, sortAscending);
previousSortColumn = 0;
currentSQLDisplay = SQLDisplayType.ALL;
} else if (sender == byWhereClauseToolStripMenuItem)
{
mainTabStrip.SelectedTab = sqlStatementsTab;
UIBuilder.BuildWhereSQLList(sqlListView, traceData.SQLByWhere);
sortAscending = true;
sqlListView.ListViewItemSorter = new ListViewItemComparer(2, sortAscending);
previousSortColumn = 0;
currentSQLDisplay = SQLDisplayType.WHERE;
} else if (sender == byFromClauseToolStripMenuItem)
{
mainTabStrip.SelectedTab = sqlStatementsTab;
UIBuilder.BuildFromSQLList(sqlListView, traceData.SQLByFrom);
sortAscending = true;
sqlListView.ListViewItemSorter = new ListViewItemComparer(2, sortAscending);
previousSortColumn = 0;
currentSQLDisplay = SQLDisplayType.WHERE;
} else if (sender == errorsToolStripMenuItem)
{
mainTabStrip.SelectedTab = sqlStatementsTab;
UIBuilder.BuildAllSQLList(sqlListView, traceData.SQLStatements.Where<SQLStatement>(s => s.IsError == true).ToList());
previousSortColumn = 0;
currentSQLDisplay = SQLDisplayType.ALL;
}
}
private void UpdateUI()
{
if (traceData == null)
{
return;
}
BuildExecutionTree();
sortAscending = true;
UIBuilder.BuildAllSQLList(sqlListView, traceData.SQLStatements);
UIBuilder.BuildStackTraceList(stackTraceListView, traceData.StackTraces);
var tabPage = UIBuilder.BuildStatisticsPage(traceData.Statistics, handleStatisticDoubleClick);
StatsTab.Controls.Add(tabPage);
previousSortColumn = 0;
currentSQLDisplay = SQLDisplayType.ALL;
}
