/// <summary> /// Load Event of Query Builder /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void QueryBuilder_Load(object sender, EventArgs e) { try { //Initialization of Queries tablelayour where the QueryGridGrup will be added InitializeQueriesTableLayoutPanel(); //Initialization of Attribute List InitializeAttributesDataGrid(); InitializeRecentQueries(); defaultGroup = AddDataGridViewToPanel(); OMETrace.WriteFunctionStart(); Events events = ApplicationObject.Events; _windowsEvents = events.get_WindowEvents(null); _windowsEvents.WindowActivated += _windowsEvents_WindowActivated; OMETrace.WriteFunctionEnd(); SetLiterals(); recentQueriesToolTip = new ToolTip(); } catch (Exception oEx) { LoggingHelper.ShowMessage(oEx); } }
/// <summary> /// Initialize DataGridView Group /// </summary> /// <returns></returns> private DataGridViewGroup InitializeDataGridViewGroup() { dataGridViewGroup = new DataGridViewGroup(); try { dataGridViewGroup.Dock = DockStyle.Fill; dataGridViewGroup.LabelQueryGroup = Helper.GetResourceString(Constants.QUERY_GROUP_CAPTION) + QueryGroupCount; tableLayoutPanelQueries.Width = dataGridViewGroup.Width; dataGridViewGroup.OnDataGridViewDragEnter += dataGridViewGroup_OnDataGridViewDragEnter; dataGridViewGroup.OnRemoveClick += dataGridViewGroup_OnRemoveClick; dataGridViewGroup.OnDataGridViewComboBoxIndexChanged += dataGridViewGroup_OnDataGridViewComboBoxIndexChanged; dataGridViewGroup.OnRowsRemoved += dataGridViewGroup_OnRowsRemoved; } catch (Exception oEx) { LoggingHelper.ShowMessage(oEx); } return dataGridViewGroup; }
private void TreeView_OnContextMenuItemClicked(object sender, DBContextItemClickedEventArg e) { try { queryBuilder = ((ViewBase.GetWindow(Constants.QUERYBUILDER)).Object) as QueryBuilder; switch (e.Tag.ToString()) { case Common.Constants.CONTEXT_MENU_SHOW_ALL_OBJECTS: ShowAllObjects(); break; case Common.Constants.CONTEXT_MENU_ADD_TO_ATTRIBUTE: if (queryBuilder != null) { AddToAttributeList(queryBuilder.DataGridViewAttributes, (TreeNode)e.Data); ApplicationObject.ToolWindows.DTE.Windows.Item(Constants.QUERYBUILDER).Activate(); } break; case Common.Constants.CONTEXT_MENU_EXPRESSION_GROUP: string itmName = ((ToolStripItem)e.Item).Name; char[] splitChar = { '_' }; int lastIndex = itmName.LastIndexOf("_"); int index = Convert.ToInt32(itmName.Split(splitChar, itmName.Length - lastIndex)[1].Split(splitChar)[1]); DataGridViewGroup dgvGroup = (DataGridViewGroup)queryBuilder.TableLayoutPanelQueries.Controls[index]; dbDataGridView datagridObject = dgvGroup.DataGridViewQuery; bool rowAdded = datagridObject.AddToQueryBuilder((TreeNode)e.Data, queryBuilder); if (rowAdded) { queryBuilder = ((ViewBase.GetWindow(Constants.QUERYBUILDER)).Object) as QueryBuilder; queryBuilder.EnableRunQuery = true; } ApplicationObject.ToolWindows.DTE.Windows.Item(Constants.QUERYBUILDER).Activate(); break; case "Rename": dbtreeviewObject.LabelEdit = true; dbtreeviewObject.SelectedNode.BeginEdit(); break; case "Delete Folder": FavouriteFolder Fav = new FavouriteFolder(null, ((TreeNode)e.Data).Text); OMEInteraction.UpdateFavourite(Fav); dbtreeviewObject.Nodes.Remove((TreeNode)e.Data); break; case "Delete Class": TreeNode tNode = (TreeNode)e.Data; TreeNode parentNode = ((TreeNode)e.Data).Parent; if (tNode != null && parentNode != null) { Fav = new FavouriteFolder(null, tNode.Parent.Text); parentNode.Nodes.Remove(tNode); if (parentNode.Nodes.Count > 0) { List <string> lststr = new List <string>(); foreach (TreeNode tempNode in parentNode.Nodes) { lststr.Add(tempNode.Text); } Fav.ListClass = lststr; } OMEInteraction.SaveFavourite(Fav); } break; } } catch (Exception oEx) { LoggingHelper.ShowMessage(oEx); } }