#region License
// Copyright 2005-2019 Paul Kohler (https://github.com/paulkohler/minisqlquery). All rights reserved.
// This source code is made available under the terms of the GNU Lesser General Public License v3.0
// https://github.com/paulkohler/minisqlquery/blob/master/LICENSE
#endregion
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Windows.Forms;
using MiniSqlQuery.Core;
using MiniSqlQuery.Core.Commands;
using MiniSqlQuery.Properties;
using WeifenLuo.WinFormsUI.Docking;
namespace MiniSqlQuery
{
/// <summary>The main form.</summary>
public partial class MainForm : Form, IHostWindow
{
/// <summary>The _services.</summary>
private readonly IApplicationServices _services;
/// <summary>The _settings.</summary>
private readonly IApplicationSettings _settings;
/// <summary>The _arguements.</summary>
private string[] _arguements;
/// <summary>The _db inspector.</summary>
private IDatabaseInspector _dbInspector;
/// <summary>The _initialized.</summary>
private bool _initialized;
/// <summary>Initializes a new instance of the <see cref="MainForm"/> class.</summary>
public MainForm()
{
InitializeComponent();
SetPointerState(Cursors.AppStarting);
}
/// <summary>Initializes a new instance of the <see cref="MainForm"/> class.</summary>
/// <param name="services">The services.</param>
/// <param name="settings">The settings.</param>
public MainForm(IApplicationServices services, IApplicationSettings settings)
: this()
{
_services = services;
_settings = settings;
AllowDrop = true;
DragEnter += WindowDragEnter;
DragDrop += WindowDragDrop;
}
/// <summary>Gets or sets ActiveChildForm.</summary>
public Form ActiveChildForm { get; internal set; }
/// <summary>Gets DatabaseInspector.</summary>
public IDatabaseInspector DatabaseInspector
{
get
{
if (_dbInspector == null || ((Form)_dbInspector).IsDisposed)
{
return null;
}
return _dbInspector;
}
}
/// <summary>Gets Instance.</summary>
public Form Instance
{
get { return this; }
}
/// <summary>Gets ToolStrip.</summary>
[DebuggerNonUserCode]
public ToolStrip ToolStrip
{
get { return toolStripConnection; }
}
/// <summary>The add plugin command.</summary>
/// <typeparam name="TCommand"></typeparam>
public void AddPluginCommand<TCommand>() where TCommand : ICommand, new()
{
pluginsMenu.DropDownItems.Add(CommandControlBuilder.CreateToolStripMenuItem<TCommand>());
}
/// <summary>The add tool strip command.</summary>
/// <param name="index">The index.</param>
/// <typeparam name="TCommand"></typeparam>
public void AddToolStripCommand<TCommand>(int? index) where TCommand : ICommand, new()
{
ToolStripButton item = CommandControlBuilder.CreateToolStripButton<TCommand>();
if (index == null)
{
toolStripConnection.Items.Add(item);
}
else
{
toolStripConnection.Items.Insert(index.Value, item);
}
}
/// <summary>The add tool strip seperator.</summary>
/// <param name="index">The index.</param>
public void AddToolStripSeperator(int? index)
{
ToolStripSeparator item = CommandControlBuilder.CreateToolStripMenuItemSeparator();
if (index == null)
{
toolStripConnection.Items.Add(item);
}
else
{
toolStripConnection.Items.Insert(index.Value, item);
}
}
/// <summary>The display docked form.</summary>
/// <param name="frm">The frm.</param>
public void DisplayDockedForm(DockContent frm)
{
if (frm != null)
{
frm.Show(dockPanel, DockState.Document);
}
}
/// <summary>The display message box.</summary>
/// <param name="source">The source.</param>
/// <param name="text">The text.</param>
/// <param name="caption">The caption.</param>
/// <param name="buttons">The buttons.</param>
/// <param name="icon">The icon.</param>
/// <param name="defaultButton">The default button.</param>
/// <param name="options">The options.</param>
/// <param name="helpFilePath">The help file path.</param>
/// <param name="keyword">The keyword.</param>
/// <returns></returns>
public DialogResult DisplayMessageBox(
Form source, string text, string caption, MessageBoxButtons buttons,
MessageBoxIcon icon, MessageBoxDefaultButton defaultButton,
MessageBoxOptions options, string helpFilePath, string keyword)
{
if (helpFilePath == null && keyword == null)
{
return MessageBox.Show(source, text, caption, buttons, icon, defaultButton, options);
}
return MessageBox.Show(source, text, caption, buttons, icon, defaultButton, options, helpFilePath, keyword);
}
/// <summary>The display simple message box.</summary>
/// <param name="source">The source.</param>
/// <param name="text">The text.</param>
/// <param name="caption">The caption.</param>
/// <returns></returns>
public DialogResult DisplaySimpleMessageBox(Form source, string text, string caption)
{
return MessageBox.Show(source, text, caption);
}
/// <summary>The get menu item.</summary>
/// <param name="name">The name.</param>
/// <returns></returns>
public ToolStripMenuItem GetMenuItem(string name)
{
ToolStripMenuItem menuItem = null;
foreach (ToolStripMenuItem item in MainMenuStrip.Items)
{
if (item.Text.Replace("&", string.Empty).ToLower() == name.ToLower())
{
menuItem = item;
break;
}
}
return menuItem;
}
/// <summary>The set arguments.</summary>
/// <param name="args">The args.</param>
public void SetArguments(string[] args)
{
_arguements = args;
}
/// <summary>The set pointer state.</summary>
/// <param name="cursor">The cursor.</param>
public void SetPointerState(Cursor cursor)
{
Cursor = cursor;
Application.DoEvents();
}
/// <summary>The set status.</summary>
/// <param name="source">The source.</param>
/// <param name="text">The text.</param>
public void SetStatus(Form source, string text)
{
if (source == null || ActiveMdiChild == source)
{
if (text != null)
{
text = text.Replace("\r", string.Empty).Replace("\n", " ");
}
toolStripStatusLabel.Text = text;
}
}
public void SetResultCount(Form source, int? count)
{
if (source == null || ActiveMdiChild == source)
{
string result = string.Empty;
if (count != null)
{
if (count.Value == 1)
{
result = "1 row";
}
else
{
result = count.Value + " rows";
}
}
toolStripStatusLabelResultCount.Text = result;
}
}
/// <summary>The show database inspector.</summary>
/// <param name="databaseInspector">The database inspector.</param>
/// <param name="dockState">The dock state.</param>
/// <exception cref="InvalidOperationException"></exception>
public void ShowDatabaseInspector(IDatabaseInspector databaseInspector, DockState dockState)
{
if (_dbInspector != null && _dbInspector != databaseInspector)
{
_dbInspector.Close();
}
_dbInspector = databaseInspector;
DockContent frm = _dbInspector as DockContent;
if (frm == null)
{
throw new InvalidOperationException(
"The 'databaseInspector' must be a 'WeifenLuo.WinFormsUI.Docking.DockContent' based form.");
}
frm.Show(dockPanel, dockState);
}
/// <summary>The show tool window.</summary>
/// <param name="form">The form.</param>
/// <param name="dockState">The dock state.</param>
public void ShowToolWindow(DockContent form, DockState dockState)
{
form.Show(dockPanel, dockState);
}
/// <summary>The app settings connection definitions changed.</summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
private void AppSettingsConnectionDefinitionsChanged(object sender, EventArgs e)
{
LoadUpConnections();
}
/// <summary>The load up connections.</summary>
private void LoadUpConnections()
{
DbConnectionDefinitionList definitionList = _settings.GetConnectionDefinitions();
if (_initialized) // if initialized, just sync the lists
{
// add missing
foreach (var connDef in definitionList.Definitions)
{
if (!toolStripComboBoxConnection.Items.Contains(connDef))
{
toolStripComboBoxConnection.Items.Add(connDef);
}
}
// remove if missing
var defList = new List<DbConnectionDefinition>(definitionList.Definitions);
for (int i = toolStripComboBoxConnection.Items.Count - 1; i >= 0; i--)
{
var connDef = (DbConnectionDefinition)toolStripComboBoxConnection.Items[i];
if (!defList.Contains(connDef))
{
toolStripComboBoxConnection.Items.RemoveAt(i);
}
}
}
else
{
// first populate
toolStripComboBoxConnection.Items.Clear();
foreach (var connDef in definitionList.Definitions)
{
toolStripComboBoxConnection.Items.Add(connDef);
}
}
// Bug fix - don't automatically refresh as it can try to reconnect to a connection you don't have etc.
//foreach (var connDef in definitionList.Definitions)
//{
// if (connDef.Name == Settings.Default.NammedConnection)
// {
// toolStripComboBoxConnection.SelectedItem = connDef;
// _settings.ConnectionDefinition = connDef;
// SetWindowTitle(connDef.Name);
// }
//}
}
/// <summary>The main form_ form closing.</summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
private void MainForm_FormClosing(object sender, FormClosingEventArgs e)
{
if (e.Cancel)
{
return;
}
if (_settings.ConnectionDefinition != null)
{
Settings.Default.NammedConnection = _settings.ConnectionDefinition.Name;
Settings.Default.Save();
}
List<IPlugIn> plugins = new List<IPlugIn>(_services.Plugins.Values);
plugins.Reverse();
foreach (IPlugIn plugin in plugins)
{
plugin.UnloadPlugIn();
}
_services.Container.Dispose();
}
/// <summary>The main form_ load.</summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
private void MainForm_Load(object sender, EventArgs e)
{
_settings.ConnectionDefinitionsChanged += AppSettingsConnectionDefinitionsChanged;
toolStripStatusLabelResultCount.Text = string.Empty;
Utility.CreateConnectionStringsIfRequired();
_settings.SetConnectionDefinitions(Utility.LoadDbConnectionDefinitions());
}
/// <summary>The main form_ mdi child activate.</summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
private void MainForm_MdiChildActivate(object sender, EventArgs e)
{
ActiveChildForm = ActiveMdiChild;
}
/// <summary>The main form_ shown.</summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
private void MainForm_Shown(object sender, EventArgs e)
{
_services.InitializePlugIns();
DockContent dbInspectorForm = _dbInspector as DockContent;
if (dbInspectorForm != null)
{
// the activate for "DockContent" is different to that of "Form".
dbInspectorForm.Activate();
}
_initialized = true;
SetPointerState(Cursors.Default);
SetStatus(null, string.Empty);
// now check for command line args that are "command type names"
if (_arguements != null && _arguements.Length > 0)
{
foreach (string arg in _arguements)
{
if (arg.StartsWith("/cmd:"))
{
string cmdName = arg.Substring(5);
ICommand cmd = CommandManager.GetCommandInstanceByPartialName(cmdName);
if (cmd != null)
{
cmd.Execute();
}
}
}
}
else
{
CommandManager.GetCommandInstance<NewQueryFormCommand>().Execute();
}
}
/// <summary>The set window title.</summary>
/// <param name="connectionName">The connection name.</param>
private void SetWindowTitle(string connectionName)
{
Text = string.Format("Mini SQL Query [{0}]", connectionName);
}
/// <summary>The window drag drop.</summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
private void WindowDragDrop(object sender, DragEventArgs e)
{
if (e.Data.GetDataPresent(DataFormats.FileDrop))
{
string[] filePaths = (string[])e.Data.GetData(DataFormats.FileDrop);
IFileEditorResolver resolver = _services.Resolve<IFileEditorResolver>();
foreach (string filename in filePaths)
{
// todo: check for file exist file in open windows;
IEditor editor = resolver.ResolveEditorInstance(filename);
editor.FileName = filename;
editor.LoadFile();
DisplayDockedForm(editor as DockContent);
}
}
}
/// <summary>The window drag enter.</summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
private void WindowDragEnter(object sender, DragEventArgs e)
{
if (e.Data.GetDataPresent(DataFormats.FileDrop))
{
e.Effect = DragDropEffects.Copy;
}
else
{
e.Effect = DragDropEffects.None;
}
}
/// <summary>The exit tool strip menu item_ click.</summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
private void exitToolStripMenuItem_Click(object sender, EventArgs e)
{
CommandManager.GetCommandInstance<ExitApplicationCommand>().Execute();
}
/// <summary>The hide show tool strip menu item_ click.</summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
private void hideShowToolStripMenuItem_Click(object sender, EventArgs e)
{
if (WindowState == FormWindowState.Normal)
{
Hide();
WindowState = FormWindowState.Minimized;
}
else
{
Show();
WindowState = FormWindowState.Normal;
}
}
/// <summary>The sys icon_ double click.</summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
private void sysIcon_DoubleClick(object sender, EventArgs e)
{
if (WindowState == FormWindowState.Normal)
{
Hide();
WindowState = FormWindowState.Minimized;
}
else
{
Show();
WindowState = FormWindowState.Normal;
}
}
/// <summary>The tool strip combo box connection_ selected index changed.</summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
private void toolStripComboBoxConnection_SelectedIndexChanged(object sender, EventArgs e)
{
if (_initialized)
{
DbConnectionDefinition dbConnectionDefinition = (DbConnectionDefinition)toolStripComboBoxConnection.SelectedItem;
_settings.ConnectionDefinition = dbConnectionDefinition;
SetWindowTitle(dbConnectionDefinition.Name);
}
}
private void dockPanel_ActiveContentChanged(object sender, EventArgs e)
{
}
}
}
|