|
<ej-grid id="Grid" #Grid [allowPaging]="true" [dataSource]="data" [toolbarSettings]="toolbarSettings" (toolbarClick)="toolbar($event)" >
<e-columns>
……………………………
</e-columns>
</ej-grid>
export class PlanningComponent {
@ViewChild('Grid') Grid: EJComponents<any, any>;
…………….
toolbar(e: any) {
if (e.itemName == "Excel Export") {
this.Grid.widget.export('/api/planning/ExcelExport');
e.cancel = true;
}
else if (e.itemName == "Word Export") {
this.Grid.widget.export('/api/planning/WordExport')
e.cancel = true;//prevent the default action
}
else if (e.itemName == "PDF Export") {
this.Grid.widget.export('/api/planning/PdfExport')
e.cancel = true;
}
}
………..
}
}
// Controller Page
[Route("api/planning/ExcelExport")]
[ActionName("ExcelExport")]
[HttpPost]
public IActionResult ExcelExport(string GridModel)
{
BindDataSource();
ExcelExport exp = new ExcelExport();
var DataSource = order;
GridProperties gridProperty = ConvertGridObject(GridModel);
GridExcelExport excelExp = new GridExcelExport();
excelExp.FileName = "Export.xlsx"; excelExp.Excelversion = ExcelVersion.Excel2010;
excelExp.Theme = "flat-saffron";
return exp.Export(gridProperty, DataSource, excelExp);
}
//Word Export Method.
[Route("api/planning/WordExport")]
[ActionName("WordExport")]
[HttpPost]
public IActionResult WordExport(string GridModel)
{
BindDataSource();
var DataSource = order;
WordExport exp = new WordExport();
GridProperties gridProperty = ConvertGridObject(GridModel);
GridWordExport wordExp = new GridWordExport();
wordExp.FileName = "Export.docx";
wordExp.Theme = "flat-saffron";
return exp.Export(gridProperty, DataSource, wordExp);
}
//PDF Export Method.
[Route("api/planning/PdfExport")]
[ActionName("PdfExport")]
[HttpPost]
public IActionResult PdfExport(string GridModel)
{
BindDataSource();
var DataSource = order;
PdfExport exp = new PdfExport();
GridProperties gridProperty = ConvertGridObject(GridModel);
GridPdfExport pdfexp = new GridPdfExport();
pdfexp.FileName = "Export.pdf";
pdfexp.Theme = "flat-saffron";
return exp.Export(gridProperty, DataSource, pdfexp);
}
public GridProperties ConvertGridObject(string gridProperty)
{
GridProperties gridProp = new GridProperties();
gridProp = (GridProperties)JsonConvert.DeserializeObject(gridProperty, typeof(GridProperties));
return gridProp;
}
|
