/// <summary>
/// Open the auery dialog
/// </summary>
private void OpenQueryDialog()
{
try
{
TraceLog.WriteLine(new StackFrame().GetMethod().Name, "Calling LoadQueries()");
LoadQueries();
var queries = GetQueriesForActiveSheet();
TraceLog.WriteLine(new StackFrame().GetMethod().Name, string.Format(CultureInfo.InstalledUICulture, "Found {0} queries for (active) sheet {1}.", queries.Count(), Excel.GetNameActiveSheet()));
if (!queries.Any())
{
queries.AddDefaultQuery();
}
TraceLog.WriteLine(new StackFrame().GetMethod().Name, "Ready to show the query window.");
_ribbon.ShowQueryWindow(queries);
}
catch (Exception ex)
{
TraceLog.WriteLine(new StackFrame().GetMethod().Name, ex.Message);
_ribbon.AlertUser(ex.Message);
}
}
