/// <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"); }