private void AddSelectFromColumnOption(string selectedValue, int desiredIndex) { DataItemModel fromTable = this.uxFromTable.SelectedItem.To <DataItemModel>(); bool haveChild = desiredIndex < this.uxSelectColumnsStack.Children.Count; ComboBoxTool resultBox = haveChild ? this.uxSelectColumnsStack.Children[desiredIndex].To <ComboBoxTool>() : new ComboBoxTool(); if (!haveChild) { resultBox.Items.Add(new DataItemModel { DisplayValue = Constants.None, ItemKey = Constants.None }); foreach (DataItemModel tableColumn in Integrity.GetColumnsForTable(fromTable.DisplayValue).OrderBy(t => t.DisplayValue)) { DataItemModel optionColumn = new DataItemModel { DisplayValue = $"{fromTable.DisplayValue}.{tableColumn.DisplayValue}", ItemKey = $"{fromTable.DisplayValue}.{tableColumn.DisplayValue}" }; resultBox.Items.Add(optionColumn); } resultBox.SelectionChanged += this.SelectColumnChanged; this.uxSelectColumnsStack.Children.Add(resultBox); } resultBox.SelectedValue = selectedValue; }
private void SetColumnOptions() { this.valueSelectColumns.Clear(); DataItemModel fromTable = this.uxTableName.SelectedItem.To <DataItemModel>(); if (fromTable == null) { return; } this.valueSelectColumns.Add(new DataItemModel { DisplayValue = Constants.None, ItemKey = Constants.None }); foreach (DataItemModel tableColumn in Integrity.GetColumnsForTable(fromTable.DisplayValue).OrderBy(t => t.DisplayValue)) { DataItemModel optionColumn = new DataItemModel { DisplayValue = $"{fromTable.DisplayValue}.{tableColumn.DisplayValue}", ItemKey = $"{fromTable.DisplayValue}.{tableColumn.DisplayValue}" }; this.valueSelectColumns.Add(optionColumn); } }
private void DataBaseTypeLink() { this.uxRelationName.Content = Integrity.BuildForeighKeyName(this.SelectedParentTable.ItemKey.ToString(), this.SelectedChildTable.ItemKey.ToString()); foreach (ColumnObjectModel keyColumn in Integrity.GetObjectModel(this.SelectedParentTable.ItemKey.ToString()).Where(pk => pk.InPrimaryKey)) { ComboBoxTool parentBox = new ComboBoxTool(); ComboBoxTool childBox = new ComboBoxTool(); parentBox.Name = $"{parentComboName}{this.uxParentColumns.Children.Count}"; childBox.Name = $"{childComboName}{this.uxChildColumns.Children.Count}"; parentBox.Items.Add(new DataItemModel { DisplayValue = keyColumn.ColumnName, ItemKey = keyColumn.ColumnName }); foreach (DataItemModel item in Integrity.GetColumnsForTable(this.SelectedChildTable.ItemKey.ToString())) { childBox.Items.Add(item); } parentBox.SelectedValue = keyColumn.ColumnName; this.uxParentColumns.Children.Add(parentBox); this.uxChildColumns.Children.Add(childBox); } }
private void FromTable_Changed(object sender, System.Windows.Controls.SelectionChangedEventArgs e) { try { this.replaceWheres.Clear(); this.uxSelectColumnsStack.Children.Clear(); this.uxWhereOptions.Children.Clear(); this.whereOptions.Clear(); this.AddSelectFromColumnOption(string.Empty, 0); DataItemModel fromTable = this.uxFromTable.SelectedItem.To <DataItemModel>(); this.whereOptions.Add(new DataItemModel { DisplayValue = Constants.None, ItemKey = Constants.None }); foreach (DataItemModel tableColumn in Integrity.GetColumnsForTable(fromTable.DisplayValue).OrderBy(t => t.DisplayValue)) { DataItemModel optionColumn = new DataItemModel { DisplayValue = $"{fromTable.DisplayValue}.{tableColumn.DisplayValue}", ItemKey = $"{fromTable.DisplayValue}.{tableColumn.DisplayValue}" }; this.whereOptions.Add(optionColumn); } if (this.uxFromTable.SelectedValue.ParseToString() != Constants.None) { this.AddReplaceWhere(); } } catch (Exception err) { MessageBox.Show(err.InnerExceptionMessage()); } }
private void VirtualTypeLink() { this.uxRelationName.Content = Integrity.BuildForeighKeyName(this.SelectedParentTable.ItemKey.ToString(), this.SelectedChildTable.ItemKey.ToString()); if (!this.wasLoaded) { foreach (ColumnRelationMapModel column in this.DatabaseRelation.Columns) { ComboBoxTool parentBox = new ComboBoxTool(); ComboBoxTool childBox = new ComboBoxTool(); parentBox.Name = $"{parentComboName}{this.uxParentColumns.Children.Count}"; childBox.Name = $"{childComboName}{this.uxChildColumns.Children.Count}"; foreach (DataItemModel item in Integrity.GetColumnsForTable(this.SelectedParentTable.ItemKey.ToString())) { parentBox.Items.Add(item); } foreach (DataItemModel item in Integrity.GetColumnsForTable(this.SelectedChildTable.ItemKey.ToString())) { childBox.Items.Add(item); } childBox.DropDownClosed += this.ChildBox_Closed; parentBox.SelectedValue = column.ParentColumn; this.uxParentColumns.Children.Add(parentBox); this.uxChildColumns.Children.Add(childBox); } } ComboBoxTool emptyParentBox = new ComboBoxTool(); ComboBoxTool emptyChildBox = new ComboBoxTool(); emptyParentBox.Name = $"{parentComboName}{this.uxParentColumns.Children.Count}"; emptyChildBox.Name = $"{childComboName}{this.uxChildColumns.Children.Count}"; foreach (DataItemModel item in Integrity.GetColumnsForTable(this.SelectedParentTable.ItemKey.ToString())) { emptyParentBox.Items.Add(item); } foreach (DataItemModel item in Integrity.GetColumnsForTable(this.SelectedChildTable.ItemKey.ToString())) { emptyChildBox.Items.Add(item); } emptyChildBox.DropDownClosed += this.ChildBox_Closed; //parentBox.SelectedValue = keyColumn.ColumnName; this.uxParentColumns.Children.Add(emptyParentBox); this.uxChildColumns.Children.Add(emptyChildBox); }