protected void OnSelectQueryOnClipboard()
{
TableNode node = CurrentNode.DataItem as TableNode;
IEditSchemaProvider schemaProvider = (IEditSchemaProvider)node.ConnectionContext.SchemaProvider;
Gtk.Clipboard clp = Clipboard.Get(Gdk.Selection.Clipboard);
clp.Text = schemaProvider.GetSelectQuery(node.Table);
MessageService.ShowMessage(AddinCatalog.GetString("SELECT statement has been copied to Clipboard."));
}
protected void OnSelectQueryOnNewWindow()
{
TableNode node = CurrentNode.DataItem as TableNode;
IEditSchemaProvider schemaProvider = (IEditSchemaProvider)node.ConnectionContext.SchemaProvider;
SqlQueryView view = new SqlQueryView();
view.SelectedConnectionContext = node.ConnectionContext;
view.TextEditor.Insert(0, schemaProvider.GetSelectQuery(node.Table));
IdeApp.Workbench.OpenDocument(view, true);
}
protected void OnSelectQueryOnCurrentWindow()
{
TableNode node = CurrentNode.DataItem as TableNode;
IEditSchemaProvider schemaProvider = (IEditSchemaProvider)node.ConnectionContext.SchemaProvider;
if (IdeApp.Workbench.ActiveDocument.IsFile && !IdeApp.Workbench.ActiveDocument.IsViewOnly)
{
IdeApp.Workbench.ActiveDocument.Editor.InsertAtCaret(schemaProvider.GetSelectQuery(node.Table));
}
else
{
MessageService.ShowError(AddinCatalog.GetString("Cannot insert text into the current window."));
}
}
