private void ColumnSelect_Click(object sender, RoutedEventArgs args) { //populate columns in conditions listbox FullQuery += "SELECT "; foreach (string s in ColumnsListBox.SelectedItems) { SelectedColumns.Add(s); FullQuery += s + ", "; } //trim last comma FullQuery = FullQuery.Substring(0, (FullQuery.Length - 2)); //add view FullQuery += " FROM " + View; FullQueryBox.Text = FullQuery; #region ResetToggles ConditionsListBox.ClearValue(ItemsControl.ItemsSourceProperty); ConditionsListBox.ItemsSource = SelectedColumns; ColumnButton.IsEnabled = false; BackToCol.IsEnabled = true; BackToView.IsEnabled = false; ExecuteQuery.IsEnabled = true; #endregion }
private void ApplyConditionButton_Click(object sender, RoutedEventArgs e) { if (!InputBox.IsEnabled && InputBox.Text == "[DATE CRITERIA]") { //date criteria entered, pull from class string clause = DateCriteriaData.ConstructClause(); if (InitialCondition == false) { WhereClause += " AND "; } else { WhereClause += " WHERE "; } WhereClause += clause; InputBox.IsEnabled = true; } else { string Comparator = ComparatorBox.Text; string Criteria = InputBox.Text; string Condition = (string)ConditionsListBox.SelectedItem; if (Comparator == "" || Criteria == "" || Condition == null) { MessageBox.Show("Please enter a comparator and criteria, and also a column."); } else { if (InitialCondition == false) { WhereClause += " AND "; } else { WhereClause += " WHERE "; } WhereClause += Condition + " " + Comparator + " " + Criteria; } } FullQueryBox.Text = (FullQuery += WhereClause); InitialCondition = false; #region ResetToggles ComparatorBox.Text = ""; ConditionsListBox.UnselectAll(); InputBox.Text = ""; WhereClause = ""; #endregion }
private void BackToCol_Click(object sender, RoutedEventArgs e) { #region ResetToggles ConditionsListBox.ClearValue(ItemsControl.ItemsSourceProperty); SelectedColumns.Clear(); ConditionsListBox.ItemsSource = SelectedColumns; ColumnButton.IsEnabled = true; BackToView.IsEnabled = true; BackToCol.IsEnabled = false; FullQuery = ""; FullQueryBox.Text = FullQuery; WhereClause = ""; InitialCondition = true; ExecuteQuery.IsEnabled = false; #endregion }