private void SetColumnFilter()
{
if (txtColumnFilter.Text.Equals("Filter..."))
{
return;
}
ColumnsListBox.SuspendLayout();
filteredColumnsList.Clear();
ColumnsListBox.DataSource = null;
EnumerableRowCollection <DataRow> filterQuery;
if (rdoColumnContains.Checked)
{
filterQuery = from c in dbUtils.SchemaDataSet.Tables["TableColumns"].AsEnumerable()
where c.Field <string>("COLUMN_NAME").Contains(txtColumnFilter.Text.Trim())
select c;
}
else
{
filterQuery = from c in dbUtils.SchemaDataSet.Tables["TableColumns"].AsEnumerable()
where c.Field <string>("COLUMN_NAME").StartsWith(txtColumnFilter.Text.Trim())
select c;
}
filteredColumnsList = PopulateTheColumnList(filterQuery);
ColumnsListBox.DataSource = filteredColumnsList;
ColumnsListBox.ResumeLayout();
}
private void ViewSelect_Click(object sender, RoutedEventArgs args)
{
DbConnect.Connect();
//populate DB cols for view
View = (string)ViewListBox.SelectedItem; //check this casting works
string query = "SELECT * FROM " + View;
var command = new MySqlCommand(query, DbConnect.Connection);
var reader = command.ExecuteReader(CommandBehavior.SchemaOnly);
schema = reader.GetSchemaTable();
foreach (DataRow col in schema.Rows)
{
ColumnList.Add(col.Field <String>("ColumnName"));
}
DbConnect.Close();
#region ResetToggles
ColumnsListBox.ClearValue(ItemsControl.ItemsSourceProperty);
ColumnsListBox.ItemsSource = ColumnList;
reader.Close();
ViewButton.IsEnabled = false;
BackToView.IsEnabled = true;
ColumnButton.IsEnabled = true;
#endregion
}
/// <summary>
/// Selects all tables in the database schema for searching
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSelectAllTables_Click(object sender, EventArgs e)
{
TablesListBox.SuspendLayout();
ColumnsListBox.SuspendLayout();
for (int i = 0; i < TablesListBox.Items.Count; i++)
{
TablesListBox.SetSelected(i, true);
}
TablesListBox.TopIndex = 0;
RefreshColumnList();
TablesListBox.ResumeLayout();
ColumnsListBox.ResumeLayout();
}
private void BackToView_Click(object sender, RoutedEventArgs e)
{
#region ResetToggles
ColumnsListBox.ClearValue(ItemsControl.ItemsSourceProperty);
ColumnList.Clear();
ColumnsListBox.ItemsSource = ColumnList;
ViewButton.IsEnabled = true;
ColumnButton.IsEnabled = false;
BackToCol.IsEnabled = false;
BackToView.IsEnabled = false;
FullQuery = "";
FullQueryBox.Text = FullQuery;
#endregion
}
private void LoadColumns()
{
// If no database currently open, don't do anything
if (string.IsNullOrEmpty(dbUtils.CurrentDatabase))
{
return;
}
ColumnsListBox.SuspendLayout();
columnsList.Clear();
ColumnsListBox.DataSource = null;
string selectedTables = string.Empty;
foreach (string item in TablesListBox.SelectedItems)
{
selectedTables += item + ",";
}
var columnQuery = from c in dbUtils.SchemaDataSet.Tables["TableColumns"].AsEnumerable()
where selectedTables.Contains(c.Field <string>("TABLE_NAME"))
select c;
columnsList = PopulateTheColumnList(columnQuery);
ColumnsListBox.DataSource = columnsList;
ColumnsListBox.ResumeLayout();
}
