Example #1
0
    private void OpenCurrentObject()
    {
      if (_bs.Current == null)
      {
        return;
      }

      DataRowView rw = _bs.Current as DataRowView;
      if (rw == null)
        return;

      int objId = (int)rw.Row.ItemArray[0];
      string objOwner = (string)rw.Row.ItemArray[1];
      string objName = (string)rw.Row.ItemArray[2];
      string objType = (string)rw.Row.ItemArray[3];
      string objQuotedFullName = (string)rw.Row.ItemArray[4];
      string objFullName = (string)rw.Row.ItemArray[5];

      if (DBConstants.DoesObjectTypeHoldsData(objType))
      {
        int type = DBConstants.GetDBObjectType(objType);
        string caption = objFullName + " [" + _connParams.InfoDbServer + "]";
        string script = " select * from " + objQuotedFullName;
        bool isReadOnly = (type == DBObjectType.View) ? true : false;

        frmDataViewer viewer = DataViewerFactory.CreateDataViewer(_connParams, _connParams.Database, objName, caption, script, isReadOnly, false);
        viewer.LoadData(true);
        DataViewerFactory.ShowDataViewer(viewer);
      }


    }
Example #2
0
    private void PerformActionOnCurrentRow()
    {
      if (_bs.Current == null)
      {
        return;
      }

      DataRowView rw = _bs.Current as DataRowView;
      if (rw == null)
        return;

      int objId = (int)rw.Row.ItemArray[0];
      string objType = (string)rw.Row.ItemArray[3];
      string objName = (string)rw.Row.ItemArray[2];

      if (DBConstants.DoesObjectTypeHasScript(objType))
      {
        int type = DBConstants.GetDBObjectType(objType);
        string script = ScriptingHelper.GetAlterScript(_connParams, _connParams.Database, objId, type);
        frmScriptEditor editor = ScriptEditorFactory.Create(objName, script, objId, type, _connParams, _connParams.Database);
        ScriptEditorFactory.ShowScriptEditor(editor);
      }
      else if (DBConstants.DoesObjectTypeHoldsData(objType))
      {
        int type = DBConstants.GetDBObjectType(objType);
        string caption = objName + "{" + _connParams.InfoDbServer + "}";
        string script = " select * from [" + objName + "]";
        bool isReadOnly = (type == DBObjectType.View) ? true : false;

        frmDataViewer viewer = DataViewerFactory.CreateDataViewer(_connParams, _connParams.Database, objName, caption, script, isReadOnly, true);
        DataViewerFactory.ShowDataViewer(viewer);
      }

    }
        private void OnShowObjectGroupingStatistics(object sender, EventArgs e)
        {
#if PERSONAL_EDITION
            throw new PersonalEditionLimitation();
#endif
            FireBeforeContextMenuActionExecuted(sender, ObjectExplorerAction.ShowObjectGroupingStatistics);

            NodeData data = GetCurrentSelectedNodeData();
            if (data == null)
            {
                return;
            }

            ObjectGroupingService svc = new ObjectGroupingService();
            svc.ConnParams          = data.ConnParams.CreateCopy();
            svc.ConnParams.Database = data.DBName;
            svc.ConnParams.Server   = data.ServerName;
            if (!svc.IsObjectGroupingSupportInstalled())
            {
                MessageBox.Show("Object grouping not installed to this database!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            string        caption = "Obj. Grp. Stat. for " + data.Name + " {" + data.DBName + " on " + data.ServerName + "}";
            string        script  = String.Format(PragmaSQL.Core.ResManager.GetDBScript("Script_ObjectGroupingSupportGroupStats"), data.Name);
            frmDataViewer editor  = DataViewerFactory.CreateDataViewer(data, caption, script, true, true);
            editor.Icon = global::PragmaSQL.Properties.Resources.library_icon;
            DataViewerFactory.ShowDataViewer(editor);
            FireAfterContextMenuActionExecuted(sender, ObjectExplorerAction.ShowObjectGroupingStatistics);
        }
Example #4
0
        private void PerformActionOnFirstSelectedRow( )
        {
            if (grd.SelectedRows.Count == 0)
            {
                return;
            }

            int    objId   = -1;
            string objType = String.Empty;
            string objName = String.Empty;


            DataGridViewRow row = grd.SelectedRows[0];

            DataGridViewCell cellName  = row.Cells[0];
            DataGridViewCell cellType  = row.Cells[1];
            DataGridViewCell cellObjid = row.Cells[2];

            if (cellName.ValueType != typeof(string) || cellName.Value == null)
            {
                return;
            }

            if (cellType.ValueType != typeof(string) || cellType.Value == null)
            {
                return;
            }

            if (cellObjid.ValueType != typeof(int) || cellObjid.Value == null)
            {
                return;
            }

            objId   = (int)cellObjid.Value;
            objType = (string)cellType.Value;
            objName = (string)cellName.Value;

            if (DBConstants.DoesObjectTypeHasScript(objType))
            {
                int    type   = DBConstants.GetDBObjectType(objType);
                string script = String.Empty;
                using (SqlConnection conn = _connParams.CreateSqlConnection(true, false))
                {
                    script = ScriptingHelper.GetAlterScript(conn, objId, type);
                }
                frmScriptEditor editor = ScriptEditorFactory.Create(objName, script, objId, type, _connParams, _dbName);
                ScriptEditorFactory.ShowScriptEditor(editor);
            }
            else if (DBConstants.DoesObjectTypeHoldsData(objType))
            {
                int    type       = DBConstants.GetDBObjectType(objType);
                string caption    = objName + "{" + _dbName + " on " + _connParams.Server + "}";
                string script     = " select * from [" + objName + "]";
                bool   isReadOnly = (type == DBObjectType.View) ? true : false;

                frmDataViewer viewer = DataViewerFactory.CreateDataViewer(_connParams, _dbName, objName, caption, script, isReadOnly, true);
                DataViewerFactory.ShowDataViewer(viewer);
            }
        }
Example #5
0
    private void OpenSelectedObjectsEx()
    {
      if (grd.SelectedRows.Count == 0)
      {
        return;
      }

      int objId = -1;
      string objType = String.Empty;
      string objName = String.Empty;
      IList<frmDataViewer> viewers = new List<frmDataViewer>();

      foreach (DataGridViewRow row in grd.SelectedRows)
      {
        DataGridViewCell cellObjid = row.Cells[0];
        DataGridViewCell cellName = row.Cells[2];
        DataGridViewCell cellType = row.Cells[3];

        if (cellName.ValueType != typeof(string) || cellName.Value == null)
        {
          continue;
        }

        if (cellType.ValueType != typeof(string) || cellType.Value == null)
        {
          continue;
        }

        if (cellObjid.ValueType != typeof(int) || cellObjid.Value == null)
        {
          continue;
        }

        objId = (int)cellObjid.Value;
        objType = (string)cellType.Value;
        objName = (string)cellName.Value;

        if (DBConstants.DoesObjectTypeHoldsData(objType))
        {
          int type = DBConstants.GetDBObjectType(objType);
          string caption = objName + "{" + _connParams.InfoDbServer + "}";
          string script = " select * from [" + objName + "]";
          bool isReadOnly = (type == DBObjectType.View) ? true : false;

          frmDataViewer viewer = DataViewerFactory.CreateDataViewer(_connParams, _connParams.Database, objName, caption, script, isReadOnly, false);
          viewers.Add(viewer);
        }
      }

      foreach (frmDataViewer viewer in viewers)
      {
        viewer.LoadData(true);
        DataViewerFactory.ShowDataViewer(viewer);
      }
    }
Example #6
0
        public void OpenSelectedObjects( )
        {
            string error = String.Empty;
            IList <frmDataViewer> viewers = new List <frmDataViewer>();

            foreach (TreeNode node in tv.SelectedNodes)
            {
                ObjectGroupingItemData data = ObjectGroupingItemDataFactory.GetNodeData(node);
                if (data == null)
                {
                    continue;
                }

                ObjectInfo objInfo = ProgrammabilityHelper.GetObjectInfo(_connParams, String.Empty, data.Name);
                if (objInfo == null)
                {
                    error += " - " + data.Name + "\r\n";
                    continue;
                }

                if (!DBConstants.DoesObjectTypeHoldsData(data.Type ?? -1))
                {
                    continue;
                }
                string caption    = data.Name + "{" + cmbDatabases.Text + " on " + cmbServers.Text + "}";
                string script     = " select * from [" + data.Name + "]";
                bool   isReadOnly = (data.Type == DBObjectType.View) ? true : false;

                frmDataViewer viewer = DataViewerFactory.CreateDataViewer(_connParams, cmbDatabases.Text, data.Name, caption, script, isReadOnly, false);
                viewers.Add(viewer);
            }

            foreach (frmDataViewer viewer in viewers)
            {
                viewer.LoadData(true);
                DataViewerFactory.ShowDataViewer(viewer);
            }

            if (!String.IsNullOrEmpty(error))
            {
                MessageService.ShowError("Objects listed below do not exist in the database!\r\n" + error);
            }
        }
        private void OnOpenViewDataEditorClick(object sender, EventArgs e)
        {
            FireBeforeContextMenuActionExecuted(sender, ObjectExplorerAction.ViewDataEditor);

            NodeData data = GetCurrentSelectedNodeData();

            if (data == null)
            {
                return;
            }

            if (data.Type != DBObjectType.View)
            {
                return;
            }

            string        caption = data.QualifiedFullName + " [ " + data.DBName + " on " + data.ServerName + " ]";
            string        script  = "select * from " + data.QualifiedFullName;
            frmDataViewer editor  = DataViewerFactory.CreateDataViewer(data, caption, script, true, true);

            editor.Icon = global::PragmaSQL.Properties.Resources.Preview;
            DataViewerFactory.ShowDataViewer(editor);
            FireAfterContextMenuActionExecuted(sender, ObjectExplorerAction.ViewDataEditor);
        }