/// <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);
}
}
