/// <summary>
/// Called when [visible column changed].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.DependencyPropertyChangedEventArgs"/> instance containing the event data.</param>
private static void OnVisibleColumnChanged(DependencyObject sender, DependencyPropertyChangedEventArgs args)
{
GridDataControl DataGrid = sender as GridDataControl;
if (DataGrid != null && args.NewValue != null)
{
List <string> ListofColumn = args.NewValue as List <string>;
DataGrid.VisibleColumns.Clear();
foreach (string ColumnName in ListofColumn)
{
GridDataVisibleColumn gridVisiblecolumn = new GridDataVisibleColumn();
gridVisiblecolumn.AllowDrag = true;
gridVisiblecolumn.AllowFilter = true;
gridVisiblecolumn.AllowGroup = true;
gridVisiblecolumn.AllowSort = true;
gridVisiblecolumn.MappingName = ColumnName;
gridVisiblecolumn.HeaderText = ColumnName;
gridVisiblecolumn.HeaderStyle = new GridDataColumnStyle()
{
HorizontalAlignment = HorizontalAlignment.Center
};
DataGrid.VisibleColumns.Add(gridVisiblecolumn);
}
}
}
private void OnItemsSourceChanged(SyncfusionRoutedEventArgs args)
{
GridDataControl grid = args.Source as GridDataControl;
if (grid.GroupedColumns.Count > 0)
{
grid.Model.Table.ExpandAllGroupsAtLevel(1);
}
}
/// <summary>
/// Called when [execute collapse all].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
private static void OnExecuteCollapseAll(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl grid = args.Source as GridDataControl;
if (grid.Model.Table.HasNestedTables)
{
grid.Model.Table.CollapseAll();
}
}
/// <summary>
/// Called when [execute expand all].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
private static void OnExecuteExpandAll(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl grid = args.Source as GridDataControl;
if (grid.Model.Table.HasGroups)
{
grid.Model.Table.ExpandAllGroups();
}
}
private static void OnSetCommandParameterCallback
(DependencyObject dependencyObject, DependencyPropertyChangedEventArgs e)
{
GridDataControl control = dependencyObject as GridDataControl;
if (control != null)
{
GridQueryCellStyleInfoBehavior behavior = GetOrCreateBehavior(control);
behavior.CommandParameter = e.NewValue;
}
}
/// <summary>
/// Called when [executeprint].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
private static void OnExecuteprint(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl gridDatacontrol = args.Source as GridDataControl;
var window = gridDatacontrol.FindParentElementOfType <MainWindow>();
gridDatacontrol.ShowPrintDialog((o) =>
{
o.Owner = window;
o.WindowStartupLocation = System.Windows.WindowStartupLocation.CenterOwner;
});
}
private static void OnSetCommandCallback
(DependencyObject dependencyObject, DependencyPropertyChangedEventArgs e)
{
GridDataControl control = dependencyObject as GridDataControl;
if (control != null)
{
GridItemsSourceChangedBehavior behavior = GetOrCreateBehavior(control);
behavior.Command = e.NewValue as ICommand;
}
}
private static GridQueryCellStyleInfoBehavior GetOrCreateBehavior(GridDataControl control)
{
GridQueryCellStyleInfoBehavior behavior =
control.GetValue(GridQueryCellStyleInfoBehaviorProperty) as GridQueryCellStyleInfoBehavior;
if (behavior == null)
{
behavior = new GridQueryCellStyleInfoBehavior(control);
control.SetValue(GridQueryCellStyleInfoBehaviorProperty, behavior);
}
return(behavior);
}
private static GridItemsSourceChangedBehavior GetOrCreateBehavior(GridDataControl control)
{
GridItemsSourceChangedBehavior behavior =
control.GetValue(GridItemsSourceChangedBehaviorProperty) as GridItemsSourceChangedBehavior;
if (behavior == null)
{
behavior = new GridItemsSourceChangedBehavior(control);
control.SetValue(GridItemsSourceChangedBehaviorProperty, behavior);
}
return(behavior);
}
/// <summary>
/// Called when [execute expand].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
public static void OnExecuteExpand(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl GDC = args.Source as GridDataControl;
if ((string)args.Parameter == "Expand")
{
GDC.Model.Table.ExpandAllGroups();
}
else if (((string)args.Parameter) == "Collapse")
{
GDC.Model.Table.CollapseAllGroups();
}
}
/// <summary>
/// Called when [execute export all to excel].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
private static void OnExecuteExportAllToExcel(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl grid = args.Source as GridDataControl;
try
{
grid.ExportToExcel("Sample.xls", ExcelVersion.Excel97to2003);
System.Diagnostics.Process.Start("Sample.xls");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private static void OnExecutePrint(object sender, ExecutedRoutedEventArgs args)
{
ScalingOptions option = ScalingOptions.NoScaling;
if (args.Parameter != null)
{
option = GetScaling(args.Parameter.ToString());
}
GridDataControl dataGrid = args.Source as GridDataControl;
dataGrid.Model.ActiveGridView.ScalingOptions = option;
dataGrid.Print();
}
/// <summary>
/// Called when [execute export all to CSV].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
private static void OnExecuteExportAllToCSV(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl gdc = args.Source as GridDataControl;
try
{
gdc.Model.ExportToCSV(GridRangeInfo.Cells(0, 0, gdc.Model.RowCount - 1, gdc.Model.ColumnCount - 1), "Sample.csv");
System.Diagnostics.Process.Start("Sample.csv");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
/// <summary>
/// Called after the behavior is attached to an AssociatedObject.
/// </summary>
/// <remarks>Override this to hook up functionality to the AssociatedObject.</remarks>
protected override void OnAttached()
{
var window = this.AssociatedObject;
this.DataGrid = window.FindName("dataGrid") as GridDataControl;
this.FirstColumn = window.FindName("FirstColumn") as CheckBox;
this.LastColumn = window.FindName("LastColumn") as CheckBox;
this.BandedColumn = window.FindName("BandedColumn") as CheckBox;
FirstColumn.Click += OnFirstOrLastClicked;
LastColumn.Click += OnFirstOrLastClicked;
BandedColumn.Click += OnBandedColumnClicked;
this.DataGrid.ModelLoaded += OnModelLoaded;
}
/// <summary>
/// Called when [exported].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
public static void OnStyleApplied(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl gridDataControl = args.Source as GridDataControl;
if (!IsAppliedAlready)
{
DefaultAlternateRowbackground = gridDataControl.AlternatingRowBackground;
gridDataControl.AlternatingRowBackground = Brushes.Gainsboro;
IsAppliedAlready = true;
}
else
{
gridDataControl.AlternatingRowBackground = DefaultAlternateRowbackground;
IsAppliedAlready = false;
}
}
protected void ShowTableForm(IStrategyDataItemInfoOwner visual)
{
XtraForm form = new XtraForm();
GridDataControl control = new GridDataControl();
control.Grid.DoubleClick += OnGridControlDoubleClick;
control.Dock = DockStyle.Fill;
form.Controls.Add(control);
StrategyDataVisualiser visualiser = new StrategyDataVisualiser(visual);
visualiser.Visualize(control.Grid);
form.Text = visual.Name + " - Data Table";
//form.MdiParent = this;
//form.WindowState = FormWindowState.Maximized;
form.Show();
}
private static void OnExecuteShowPrintDialog(object sender, ExecutedRoutedEventArgs args)
{
ScalingOptions option = ScalingOptions.NoScaling;
if (args.Parameter != null)
{
option = GetScaling(args.Parameter.ToString());
}
GridDataControl dataGrid = args.Source as GridDataControl;
dataGrid.ShowPrintDialog((p) =>
{
p.ScalingOptions = option;
// p.ShowDialog();
});
}
/// <summary>
/// Called when [exported].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
public static void OnBordersApplied(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl gridDataControl = args.Source as GridDataControl;
if (HasBorder)
{
gridDataControl.Model.TableStyle.Borders.All = new Pen(Brushes.Transparent, 0);
HasBorder = false;
}
else
{
gridDataControl.Model.TableStyle.Borders.Right = new Pen(Brushes.LightGray, 0.7);
gridDataControl.Model.TableStyle.Borders.Bottom = new Pen(Brushes.LightGray, 0.7);
HasBorder = true;
}
gridDataControl.Model.Grid.InvalidateCells();
}
/// <summary>
/// Called when [execute export selected to excel].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
private static void OnExecuteExportSelectedToExcel(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl grid = args.Source as GridDataControl;
if (grid != null && !grid.Model.SelectedRanges.ActiveRange.IsEmpty)
{
try
{
grid.ExportToExcel(grid.Model.SelectedRanges.ActiveRange, "Sample.xls", ExcelVersion.Excel97to2003);
System.Diagnostics.Process.Start("Sample.xls");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
private static GridDataVisibleColumns Validate(object s, RoutedEventArgs args)
{
GridDataControl gridData = Application.Current.MainWindow.FindName("grid") as GridDataControl;
var visibleColumns = gridData.VisibleColumns;
var totalVisibleColumns = gridData.Model.GetVisibleColumns();
ObservableCollection <ColumnChooserItems> totalColumns = GetColumnsDetails(totalVisibleColumns, visibleColumns);
ColumnChooserViewModel viewModel = new ColumnChooserViewModel(totalColumns);
ColumnChooserWindow ColumnChooserView = new ColumnChooserWindow(viewModel);
ColumnChooserView.Owner = Application.Current.MainWindow;
if ((bool)ColumnChooserView.ShowDialog())
{
ClickOKButton(viewModel.ColumnCollection, gridData);
}
return(null);
}
/// <summary>
/// Called when [execute export selected to CSV].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
private static void OnExecuteExportSelectedToCSV(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl gdc = args.Source as GridDataControl;
if (gdc != null && !gdc.Model.SelectedRanges.ActiveRange.IsEmpty)
{
try
{
gdc.Model.ExportToCSV(gdc.Model.SelectedRanges.ActiveRange, "Sample.csv");
System.Diagnostics.Process.Start("Sample.csv");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}
/// <summary>
/// Called when [exported].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
public static void OnGrouped(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl gridDataControl = args.Source as GridDataControl;
gridDataControl.Model.TableStyle.Borders.All = new System.Windows.Media.Pen(Brushes.Blue, 0);
if (gridDataControl.GroupedColumns.Count > 0)
{
gridDataControl.GroupedColumns.Clear();
}
else
{
gridDataControl.GroupedColumns.Add(new GridDataGroupColumn()
{
ColumnName = "CustomerID"
});
gridDataControl.Model.Table.ExpandAllGroups();
}
}
/// <summary>
/// Called when [execute column resize].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
private static void OnExecuteColumnResize(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl grid = args.Source as GridDataControl;
var parameter = args.Parameter as MultiBindingStructure;
if (grid != null && args.Parameter != null)
{
if (parameter.SelectedSizer == GridControlLengthUnitType.Star || parameter.SelectedSizer == GridControlLengthUnitType.Auto || parameter.SelectedSizer == GridControlLengthUnitType.None)
{
Int32 rowValue = 0;
if (Int32.TryParse(parameter.width.ToString(), out rowValue))
{
grid.VisibleColumns[parameter.SelectedColumn].Width = new GridDataControlLength(parameter.width, parameter.SelectedSizer);
}
else
{
MessageBox.Show("Please Enter valid number in the TextBox");
}
}
}
}
/// <summary>
/// Called when [exported].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
public static void OnExported(object sender, ExecutedRoutedEventArgs args)
{
SaveFileDialog sfd = new SaveFileDialog
{
DefaultExt = ".pdf",
Filter = "Adobe PDF Files(*.pdf)|*.pdf",
FilterIndex = 1
};
PdfDocument document = new PdfDocument();
if (sfd.ShowDialog() == true)
{
using (Stream stream = sfd.OpenFile())
{
GridDataControl grid = args.Source as GridDataControl;
document = grid.Model.ExportToPdfGridDocument(GridRangeInfo.Table());
document.Save(stream);
Process.Start(sfd.FileName);
}
}
}
public static ICommand GetCommand(GridDataControl control)
{
return(control.GetValue(CommandProperty) as ICommand);
}
public static void SetCommand(GridDataControl control, ICommand command)
{
control.SetValue(CommandProperty, command);
}
public static void SetCommandParameter(GridDataControl control, object parameter)
{
control.SetValue(CommandParameterProperty, parameter);
}
public static object GetCommandParameter(GridDataControl control)
{
return(control.GetValue(CommandParameterProperty));
}
/// <summary>
/// Clicks the OK button.
/// </summary>
/// <param name="ColumnCollection">The column collection.</param>
/// <param name="dataGrid">The data grid.</param>
public static void ClickOKButton(ObservableCollection <ColumnChooserItems> ColumnCollection, GridDataControl dataGrid)
{
foreach (var item in ColumnCollection)
{
var isFound = dataGrid.VisibleColumns.FirstOrDefault(v => v.MappingName == item.Name) != null;
if (!isFound)
{
if (item.IsChecked == true)
{
dataGrid.VisibleColumns.Add(new GridDataVisibleColumn()
{
MappingName = item.Name
});
}
}
else
{
if (item.IsChecked == false)
{
var column = dataGrid.VisibleColumns.Where(c => c.MappingName == item.Name).FirstOrDefault();
dataGrid.VisibleColumns.Remove(column);
}
}
}
}
/// <summary>
/// <summary>
/// Called when [execute load new changes].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
private static void OnExecuteLoadNewChanges(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl GDC = args.Source as GridDataControl;
GDC.Model.Deserialize("newChanges.xml");
}
