public static void ClearAllHiddenMenuItem(DBTableControl.DBEditorTableControl mainTable)
{
//Prompt for confirmation.
string text = "Are you sure you want to clear all saved hidden column information?";
string caption = "Clear Confirmation";
MessageBoxButton button = MessageBoxButton.YesNo;
MessageBoxImage image = MessageBoxImage.Question;
MessageBoxResult result = MessageBox.Show(text, caption, button, image);
if (result == MessageBoxResult.Yes)
{
// Clear internal list.
mainTable._hiddenColumns.Clear();
// Clear saved list.
mainTable._savedconfig.HiddenColumns.Clear();
}
mainTable.UpdateConfig();
if (mainTable.ShowAllColumns)
{
mainTable.Refresh();
}
}
public static void EditVisibleListMenuItem(object sender, DBTableControl.DBEditorTableControl mainTable)
{
var hiddencolumnslisteditor = ColumnVisiblityHelper.Show(mainTable);
System.Windows.Forms.DialogResult result = hiddencolumnslisteditor.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
mainTable._hiddenColumns.Clear();
mainTable._hiddenColumns = hiddencolumnslisteditor.RightList;
foreach (DataColumn column in mainTable.CurrentTable.Columns)
{
if (hiddencolumnslisteditor.LeftList.Contains(column.ColumnName))
{
column.ExtendedProperties["Hidden"] = false;
mainTable.dbDataGrid.Columns[column.Ordinal].Visibility = System.Windows.Visibility.Visible;
}
else
{
column.ExtendedProperties["Hidden"] = true;
if (mainTable.ShowAllColumns)
{
mainTable.dbDataGrid.Columns[column.Ordinal].Visibility = System.Windows.Visibility.Visible;
}
else
{
mainTable.dbDataGrid.Columns[column.Ordinal].Visibility = System.Windows.Visibility.Hidden;
}
}
}
mainTable.UpdateConfig();
if (mainTable.ShowAllColumns)
{
mainTable.Refresh();
}
}
}
public static void ClearTableHiddenMenuItem(DBTableControl.DBEditorTableControl mainTable)
{
foreach (DataGridColumn column in mainTable.dbDataGrid.Columns)
{
DataColumn datacolumn = mainTable.CurrentTable.Columns[(string)column.Header];
if (!datacolumn.ExtendedProperties.ContainsKey("Hidden"))
{
datacolumn.ExtendedProperties.Add("Hidden", false);
}
datacolumn.ExtendedProperties["Hidden"] = false;
column.Visibility = Visibility.Visible;
}
// Clear the internal hidden columns list.
mainTable._hiddenColumns.Clear();
mainTable.UpdateConfig();
if (mainTable.ShowAllColumns)
{
mainTable.Refresh();
}
}