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 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
}
