public ActionResult PdfExport(string gridModel) { GridPdfExport exp = new GridPdfExport(); Syncfusion.EJ2.Grids.Grid gridProperty = ConvertGridObject(gridModel); return(exp.PdfExport <OrdersDetails>(gridProperty, OrdersDetails.GetRecords())); }
public ActionResult ExportToPdf(string GridModel) { PdfExport exp = new PdfExport(); var DataSource = _context.Orders.Take(100).ToList(); GridProperties gridProp = ConvertGridObject(GridModel); GridPdfExport pdfExp = new GridPdfExport(); pdfExp.FileName = "Export.pdf"; pdfExp.Theme = "flat-saffron"; return(exp.Export(gridProp, DataSource, pdfExp)); }
protected void EmployeesGrid_ServerPdfExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e) { PdfExport exp = new PdfExport(); GridProperties obj = ConvertGridObject(e.Arguments["model"].ToString()); GridPdfExport exp1 = new GridPdfExport() { IsTemplateColumnIncluded = true, IsHideColumnIncude = false, Theme = "flat-lime", FileName = "Export.pdf" }; exp.Export(obj, (IEnumerable)EmployeesGrid.DataSource, exp1); }
public ActionResult HierarchyExportToPdf(string GridModel) { PdfExport exp = new PdfExport(); var DataSource = emp; GridProperties gridProp = ConvertGridModel(GridModel); gridProp.ChildGrid.DataSource = _context.Orders.Take(100).ToList(); GridPdfExport pdfExp = new GridPdfExport(); pdfExp.FileName = "Export.pdf"; pdfExp.Theme = "flat-saffron"; pdfExp.IncludeChildGrid = true; return(exp.Export(gridProp, DataSource, pdfExp)); }
public void ExportHierarchyToPdf(string GridModel) { PdfExport exp = new PdfExport(); var DataSource = new NorthwindDataContext().EmployeeViews.ToList(); GridProperties obj = ConvertGridObject(GridModel); obj.ChildGrid.DataSource = new NorthwindDataContext().OrdersViews.Take(100).ToList(); GridPdfExport expo = new GridPdfExport(); expo.IncludeChildGrid = true; expo.Unicode = true; exp.Export(obj, DataSource, expo); }
public ActionResult ExportToPdf(string GridModel) { PdfExport exp = new PdfExport(); var DataSource = _context.Clients .Include(c => c.Country) .Include(o => o.Occupation).Take(100).ToList(); GridProperties gridProp = ConvertGridObject(GridModel); GridPdfExport pdfExp = new GridPdfExport { FileName = "Export.pdf", Theme = "flat-saffron" }; return(exp.Export(gridProp, DataSource, pdfExp)); }
protected override void Invoke(object parameter) { if (parameter is SelectionChangedEventArgs) { SelectionChangedEventArgs eventArgs = parameter as SelectionChangedEventArgs; ComboBox comboBox = eventArgs.OriginalSource as ComboBox; ExportAsPivotTable = comboBox.SelectedIndex == 1; } else if (parameter is RoutedEventArgs) { try { RoutedEventArgs eventArgs = parameter as RoutedEventArgs; Button exportButton = eventArgs.OriginalSource as Button; SaveFileDialog savedialog = new SaveFileDialog(); savedialog.AddExtension = true; savedialog.FileName = "Sample"; switch (exportButton.Content.ToString()) { case "Export To Excel": savedialog.DefaultExt = "xlsx"; savedialog.Filter = "Excel file (.xlsx)|*.xlsx"; if (savedialog.ShowDialog() == true) { GridExcelExport excelExport = new GridExcelExport(this.Target, Syncfusion.XlsIO.ExcelVersion.Excel2007); excelExport.ExportMode = ExportAsPivotTable ? ExportModes.PivotTable : ExportModes.Cell; excelExport.Export(savedialog.FileName); MessageBox.Show("Excel sheet exported successfully!"); } break; case "Export To PDF": savedialog.DefaultExt = "pdf"; savedialog.Filter = "Pdf file (.pdf)|*.pdf"; if (savedialog.ShowDialog() == true) { GridPdfExport pdfExport = new GridPdfExport(this.Target); pdfExport.Export(savedialog.FileName); MessageBox.Show("PDF document exported successfully!"); } break; case "Export To Word": savedialog.DefaultExt = "Doc"; savedialog.Filter = "Word file (.Doc)|*.Doc"; if (savedialog.ShowDialog() == true) { GridWordExport wordExport = new GridWordExport(this.Target); wordExport.Export(savedialog.FileName); MessageBox.Show("Word document exported successfully!"); } break; case "Export To CSV": savedialog.DefaultExt = "CSV"; savedialog.Filter = "Csv file (.csv)|*.csv"; if (savedialog.ShowDialog() == true) { GridCsvExport csvExport = new GridCsvExport(this.Target); csvExport.Delimiter = ","; csvExport.Export(savedialog.FileName); MessageBox.Show("CSV document exported successfully!"); } break; } } catch (Exception ex) { MessageBox.Show("Error while exporting." + Environment.NewLine + "Exception Message: " + ex.Message, "Error on export", MessageBoxButton.OK, MessageBoxImage.Error); } } }
private void DoExport(object parm) { if (parm != null) { if (parm.ToString().Equals("Export to Excel")) { try { SaveFileDialog savedialog = new SaveFileDialog(); savedialog.AddExtension = true; savedialog.FileName = "Sample"; savedialog.DefaultExt = "xls"; savedialog.Filter = "Excel file (.xls)|*.xls"; if (savedialog.ShowDialog() == true) { GridExcelExport gridExcelExport = new GridExcelExport(this.GridDataManager.PivotEngine, this.ExportGridStyleInfo, this.GridLayout, savedialog.DefaultExt, false); gridExcelExport.Export(savedialog.FileName); MessageBox.Show("Exported successfully!."); } } catch (Exception ex) { MessageBox.Show("Error on Excel export.\nException Message: " + ex.Message + "\nStack Trace: " + ex.StackTrace, "Export error", MessageBoxButton.OK, MessageBoxImage.Error); } } else if (parm.ToString().Equals("Export to Word")) { try { SaveFileDialog savedialog = new SaveFileDialog(); savedialog.AddExtension = true; savedialog.FileName = "Sample"; savedialog.DefaultExt = "Doc"; savedialog.Filter = "Word file (.Doc)|*.Doc"; if (savedialog.ShowDialog() == true) { GridWordExport gridWordExport = new GridWordExport(this.GridDataManager.PivotEngine, this.GridLayout); gridWordExport.Export(savedialog.FileName, this.ExportGridStyleInfo); MessageBox.Show("Exported successfully!."); } } catch (Exception ex) { MessageBox.Show("Error on Word export.\nException Message: " + ex.Message + "\nStack Trace: " + ex.StackTrace, "Export error", MessageBoxButton.OK, MessageBoxImage.Error); } } else if (parm.ToString().Equals("Export to Pdf")) { try { SaveFileDialog savedialog = new SaveFileDialog(); savedialog.AddExtension = true; savedialog.FileName = "Sample"; savedialog.DefaultExt = "pdf"; savedialog.Filter = "Pdf file (.pdf)|*.pdf"; if (savedialog.ShowDialog() == true) { GridPdfExport gridPdfExport = new GridPdfExport(this.GridDataManager.PivotEngine, this.ExportGridStyleInfo); gridPdfExport.Export(savedialog.FileName); MessageBox.Show("Exported successfully!."); } } catch (Exception ex) { MessageBox.Show("Error on PDF export.\nException Message: " + ex.Message + "\nStack Trace: " + ex.StackTrace, "Export error", MessageBoxButton.OK, MessageBoxImage.Error); } } else if (parm.ToString().Equals("Export to CSV")) { try { SaveFileDialog savedialog = new SaveFileDialog(); savedialog.AddExtension = true; savedialog.FileName = "Sample"; savedialog.DefaultExt = "CSV"; savedialog.Filter = "Csv file (.csv)|*.csv"; if (savedialog.ShowDialog() == true) { GridCsvExport gridCsvExport = new GridCsvExport(this.GridDataManager.PivotEngine); gridCsvExport.Export(savedialog.FileName); MessageBox.Show("CSV document exported successfully!."); } } catch (Exception ex) { MessageBox.Show("Error on CSV export.\nException Message: " + ex.Message + "\nStack Trace: " + ex.StackTrace, "Export error", MessageBoxButton.OK, MessageBoxImage.Error); } } } }