/// <summary>
/// Closes the current connection, editing dialogs and puts the welcome panel in focus.
/// </summary>
/// <param name="givePanelFocus">Flag indicating whether the <see cref="WelcomePanel"/> is given focus.</param>
public void CloseConnection(bool givePanelFocus)
{
WbConnection = null;
if (givePanelFocus)
{
WelcomePanel1.BringToFront();
}
// Free up open Edit Dialogs
WorkbookConnectionInfos.CloseWorkbookEditConnectionInfos(Globals.ThisAddIn.ActiveWorkbook);
}
/// <summary>
/// Closes the current connection, editing tables and puts the schema panel in focus.
/// </summary>
/// <param name="askToCloseConnections">Flag indicating whether users are asked for confirmation before closing active <see cref="EditConnectionInfo"/>.</param>
/// <param name="givePanelFocus">Flag indicating whether the <see cref="SchemaSelectionPanel"/> is given focus.</param>
/// <returns><c>true</c> if the schema and its open <see cref="EditConnectionInfo"/> objects are closed, <c>false</c> otherwise.</returns>
public bool CloseSchema(bool askToCloseConnections, bool givePanelFocus)
{
if (askToCloseConnections && WorkbookConnectionInfos.GetWorkbookEditConnectionInfos(Globals.ThisAddIn.ActiveWorkbook).Count > 0)
{
// If there are Active OldStoredEditConnectionInfos warn the users that by closing the schema the active EditConnectionInfos will be closed.
var dr = MiscUtilities.ShowCustomizedWarningDialog(Resources.ActiveEditConnectionInfosCloseWarningTitle, Resources.ActiveEditConnectionInfosCloseWarningDetail);
if (dr == DialogResult.No)
{
return(false);
}
}
WorkbookConnectionInfos.CloseWorkbookEditConnectionInfos(Globals.ThisAddIn.ActiveWorkbook);
if (givePanelFocus)
{
SchemaSelectionPanel2.BringToFront();
}
return(true);
}