private static void UpdateVisibilityOfColumns(object sender, string[] columnsToCheck, bool isVisible)
{
var vtrootUserControl = PhysicalTree.FindAncestor <UserControl>((DependencyObject)sender);
if (vtrootUserControl != null)
{
foreach (string column in columnsToCheck)
{
var found = vtrootUserControl.FindName(column);
if (found != null)
{
((GridColumn)found).Visible = isVisible;
}
}
}
else
{
var vtrootWindow = PhysicalTree.FindAncestor <DXWindow>((DependencyObject)sender);
foreach (string column in columnsToCheck)
{
var found = vtrootWindow.FindName(column);
if (found != null)
{
((GridColumn)found).Visible = isVisible;
}
}
}
}
private static void UpdateVisibilityOfGroupByPanel(object sender, bool isVisible)
{
var vtrootUserControl = PhysicalTree.FindAncestor <UserControl>((DependencyObject)sender);
if (vtrootUserControl != null)
{
var dg = PhysicalTree.FindChild <DataGrid>(vtrootUserControl, "dataGrid");
var tv = PhysicalTree.FindChild <TableView>(vtrootUserControl, "tableView");
if (isVisible)
{
tv.ShowGroupPanel = true;
}
else
{
tv.ShowGroupPanel = false;
}
}
else
{
var vtrootWindow = PhysicalTree.FindAncestor <DXWindow>((DependencyObject)sender);
var tv = PhysicalTree.FindChild <TableView>(vtrootWindow, "tableView");
if (isVisible)
{
tv.ShowGroupPanel = true;
}
else
{
tv.ShowGroupPanel = false;
}
}
}
//protected void PostDataToCSV(TableView tableView)
//{
// var dlg = new Microsoft.Win32.SaveFileDialog();
// dlg.FileName = "ServersDataGrid";
// dlg.DefaultExt = ".xls";
// dlg.Filter = "CSV Documents (*.csv)|*.csv";
// Nullable<bool> result = dlg.ShowDialog();
// if (result == true)
// {
// tableView.ExportToCsv(dlg.FileName);
// }
// //Common.ApplicationDataSet.Instances.WriteXml(outputFile);
//}
//protected void PostDataToXLSX(TableView tableView)
//{
// var dlg = new Microsoft.Win32.SaveFileDialog();
// dlg.FileName = "ServersDataGrid";
// dlg.DefaultExt = ".xlsx";
// dlg.Filter = "XLSX Documents (*.xlsx)|*.xlsx";
// Nullable<bool> result = dlg.ShowDialog();
// if (result == true)
// {
// tableView.ExportToXlsx(dlg.FileName);
// }
// //Common.ApplicationDataSet.Instances.WriteXml(outputFile);
//}
//protected void PostDataToXLS(TableView tableView)
//{
// var dlg = new Microsoft.Win32.SaveFileDialog();
// dlg.FileName = "ServersDataGrid";
// dlg.DefaultExt = ".xls";
// dlg.Filter = "XLS Documents (*.xls)|*.xls";
// Nullable<bool> result = dlg.ShowDialog();
// if (result == true)
// {
// tableView.ExportToXls(dlg.FileName);
// }
// //Common.ApplicationDataSet.Instances.WriteXml(outputFile);
//}
private void RowTemplateComboBox_SelectionChanged(object sender, DevExpress.Xpf.Editors.EditValueChangedEventArgs e)
{
ListBoxEdit lbe = (ListBoxEdit)sender;
TableView tableView = null;
GridControl gridControl = null;
var vtrootUserControl = PhysicalTree.FindAncestor <UserControl>((DependencyObject)sender);
if (vtrootUserControl != null)
{
gridControl = (GridControl)vtrootUserControl.FindName("dataGrid");
tableView = (TableView)vtrootUserControl.FindName("tableView");
}
else
{
var vtrootWindow = PhysicalTree.FindAncestor <DXWindow>((DependencyObject)sender);
gridControl = (GridControl)vtrootWindow.FindName("dataGrid");
tableView = (TableView)vtrootWindow.FindName("tableView");
}
switch (lbe.SelectedItem.ToString())
{
case "Tooltip":
// This uses the resources from the usercontrol/window.
//var tmplt = (DataTemplate)vtrootUserControl.Resources["rowTooltipDetailTemplate"];
//var tmplt = (DataTemplate)Application.Current.Resources["rowTooltipDetailTemplate"];
//tableView.DataRowTemplate = tmplt;
break;
case "SelectedRowDetails":
//tableView.DataRowTemplate = (DataTemplate)Resources["rowSelectedDetailTemplate"];
// This uses the Application scope resources.
//var tmplt1 = (DataTemplate)Application.Current.Resources["rowSelectedDetailTemplate"];
//tableView.DataRowTemplate = tmplt1;
break;
case "RowDetails":
// This uses FindResource.
var tmplt2 = (DataTemplate)vtrootUserControl.FindResource("rowDetailTemplate");
tableView.DataRowTemplate = tmplt2;
break;
case "None":
tableView.ClearValue(DevExpress.Xpf.Grid.TableView.DataRowTemplateProperty);
break;
default:
break;
}
}
protected void OnDisplayMonitoredColumns(object sender, RoutedEventArgs e)
{
var vtroot = PhysicalTree.FindAncestor <UserControl>((DependencyObject)sender);
string[] columnsToCheck =
{
"gc_IsMonitored", "gc_IsMonitored_Instance"
};
bool isVisible = (bool)((CheckBox)e.Source).IsChecked;
UpdateVisibilityOfColumns(sender, columnsToCheck, isVisible);
}
protected void OnDisplayOperatingSystemColumns(object sender, RoutedEventArgs e)
{
var vtroot = PhysicalTree.FindAncestor <UserControl>((DependencyObject)sender);
string[] columnsToCheck =
{
"gc_OSVersion", "gc_Processors", "gc_PhysicalMemory"
};
bool isVisible = (bool)((CheckBox)e.Source).IsChecked;
UpdateVisibilityOfColumns(sender, columnsToCheck, isVisible);
}
protected void OnDisplayEnvironmentColumns(object sender, RoutedEventArgs e)
{
var vtroot = PhysicalTree.FindAncestor <UserControl>((DependencyObject)sender);
string[] columnsToCheck =
{
"gc_ADDomain", "gc_Environment", "gc_SecurityZone"
};
bool isVisible = (bool)((CheckBox)e.Source).IsChecked;
UpdateVisibilityOfColumns(sender, columnsToCheck, isVisible);
}
protected void OnDisplayBackupColumns(object sender, RoutedEventArgs e)
{
var vtroot = PhysicalTree.FindAncestor <UserControl>((DependencyObject)sender);
string[] columnsToCheck =
{
"gc_LastBackupDate", "gc_LastDifferentialBackupDate", "gc_LastLogBackupDate",
"gc_RecoveryModel"
};
bool isVisible = (bool)((CheckBox)e.Source).IsChecked;
UpdateVisibilityOfColumns(sender, columnsToCheck, isVisible);
}
protected void OnDisplayExtendedPropertyColumns(object sender, RoutedEventArgs e)
{
var vtroot = PhysicalTree.FindAncestor <UserControl>((DependencyObject)sender);
string[] columnsToCheck =
{
"gc_EP_Area",
"gc_EP_Team", "gc_EP_PrimaryDBContact",
"gc_EP_DBApprover","gc_EP_DRTier"
};
bool isVisible = (bool)((CheckBox)e.Source).IsChecked;
UpdateVisibilityOfColumns(sender, columnsToCheck, isVisible);
}
protected void OnDisplaySQLVersionColumns(object sender, RoutedEventArgs e)
{
var vtroot = PhysicalTree.FindAncestor <UserControl>((DependencyObject)sender);
string[] columnsToCheck =
{
"gc_IsClustered", "gc_Edition", "gc_Version",
"gc_ProductLevel", "gc_BrowserStartMode", "gc_Collation",
"gc_EngineEdition", "gc_PerfMonMode", "gc_Product",
"gc_ServiceAccount", "gc_ServiceName"
};
bool isVisible = (bool)((CheckBox)e.Source).IsChecked;
UpdateVisibilityOfColumns(sender, columnsToCheck, isVisible);
}
protected void OnDisplayExpandColumns(object sender, RoutedEventArgs e)
{
var vtroot = PhysicalTree.FindAncestor <UserControl>((DependencyObject)sender);
string[] columnsToCheck =
{
"gc_DefaultInstanceExpandMask",
"gc_DefaultDatabaseExpandMask", "gc_DefaultJobExpandMask",
"gc_ExpandContent", "gc_ExpandStorage", "gc_ExpandJobServer",
"gc_ExpandLinkedServers", "gc_ExpandLogins", "gc_ExpandRoles", "gc_ExpandServerRoles","gc_ExpandTriggers",
"gc_ExpandUserDefinedFunctions","gc_ExpandUsers", "gc_ExpandViews", "gc_ExpandTables",
"gc_ExpandDataFiles", "gc_ExpandFileGroups", "gc_ExpandLogFiles", "gc_ExpandStoredProcedures"
};
bool isVisible = (bool)((CheckBox)e.Source).IsChecked;
UpdateVisibilityOfColumns(sender, columnsToCheck, isVisible);
}
private static void UpdateVisibilityOfFilterPanel(object sender, bool isVisible)
{
var vtrootUserControl = PhysicalTree.FindAncestor <UserControl>((DependencyObject)sender);
if (vtrootUserControl != null)
{
var tv = PhysicalTree.FindChild <TableView>(vtrootUserControl, "tableView");
if (isVisible)
{
tv.ShowFilterEditor(null);
//tv.ShowFilterPanelMode = ShowFilterPanelMode.ShowAlways;
}
else
{
tv.ShowFilterEditor(null);
//tv.ShowFilterPanelMode = ShowFilterPanelMode.Never;
}
}
else
{
var vtrootWindow = PhysicalTree.FindAncestor <DXWindow>((DependencyObject)sender);
var tv = PhysicalTree.FindChild <TableView>(vtrootWindow, "tableView");
if (isVisible)
{
tv.ShowFilterEditor(null);
//tv.ShowFilterPanelMode = ShowFilterPanelMode.ShowAlways;
}
else
{
tv.ShowFilterEditor(null);
//tv.ShowFilterPanelMode = ShowFilterPanelMode.Never;
}
}
}
public static void DisplayOptionsVisibility(ContentControl control)
{
var adminOptions = PhysicalTree.FindChild <WrapPanel>(control, "AdminOptions");
if (adminOptions == null)
{
Log.Warning(string.Format("Can't locate element {0}", "AdminOptions"), LOG_APPNAME);
return;
}
if (Common.UserMode.Administrator)
{
((WrapPanel)adminOptions).Visibility = Visibility.Visible;
}
else
{
((WrapPanel)adminOptions).Visibility = Visibility.Hidden;
}
var developerOptions = PhysicalTree.FindChild <WrapPanel>(control, "DeveloperOptions");
if (developerOptions == null)
{
Log.Warning(string.Format("Can't locate element {0}", "DeveoperOptions"), LOG_APPNAME);
return;
}
if (Common.DeveloperMode)
{
((WrapPanel)developerOptions).Visibility = Visibility.Visible;
}
else
{
((WrapPanel)developerOptions).Visibility = Visibility.Hidden;
}
}
