public ActionResult ExportPivotChart()
{
PrintingSystem ps = new PrintingSystem();
PrintableComponentLink pclPivot = new PrintableComponentLink(ps);
pclPivot.Component = PivotGridExtension.CreatePrintableObject(GetPivotGridSettings(), GetSalesPersonData());
PrintableComponentLink pclChart = new PrintableComponentLink(ps);
using (MemoryStream chartLayout = new MemoryStream())
{
GetChartSettings().SaveToStream(chartLayout);
MVCxChartControl chart = new MVCxChartControl();
chart.LoadFromStream(chartLayout);
chart.DataSource = PivotGridExtension.GetDataObject(GetPivotGridSettings(), GetSalesPersonData(), true);
chart.Width = 900;
chart.Height = 400;
chart.DataBind();
pclChart.Component = ((IChartContainer)chart).Chart;
}
CompositeLink compositeLink = new CompositeLink(ps);
compositeLink.Links.AddRange(new object[] { pclPivot, pclChart });
compositeLink.CreateDocument();
MemoryStream stream = new MemoryStream();
compositeLink.PrintingSystem.ExportToXls(stream);
stream.Position = 0;
ps.Dispose();
return(File(stream, "application/ms-excel", "PivotWithChart.xls"));
}
public ActionResult ExportToXLSX_WYSIWYG()
{
PivotXlsxExportOptions options = new PivotXlsxExportOptions();
options.ExportType = DevExpress.Export.ExportType.WYSIWYG;
return(PivotGridExtension.ExportToXlsx(PivotGridHelper.Settings, Models.NwindModel.GetData(), options));
}
public ActionResult ChartPartial()
{
ViewBag.ChartSettings = GetChartSettings();
var chartModel = PivotGridExtension.GetDataObject(GetPivotGridSettings(), GetSalesPersonData());
return(PartialView("ChartPartial", chartModel));
}
public ActionResult ExportToXLS(string ExportType)
{
switch (ExportType)
{
case "Excel": return(PivotGridExtension.ExportToXlsx(Settings, GetList())); //break;
case "PDF": return(PivotGridExtension.ExportToPdf(Settings, GetList())); //break;
default: return(PivotGridExtension.ExportToImage(Settings, GetList())); //break;
}
}
public ActionResult DrillDownGridViewPartial(int?rowIndex, int?columnIndex, bool?isResetGridViewPageIndex)
{
object dataObject = rowIndex != null && columnIndex != null
? PivotGridExtension.CreateDrillDownDataSource(PivotGridDemoHelper.DrillDownPivotGridSettings, NorthwindDataProvider.GetCustomerReports(), columnIndex.Value, rowIndex.Value)
: null;
if (isResetGridViewPageIndex != null)
{
ViewBag.IsResetGridViewPageIndex = isResetGridViewPageIndex.Value;
}
return(PartialView("DrillDownGridViewPartial", dataObject));
}
public ActionResult ExportToXLS()
{
string start = (string)Session["Start"];
string end = (string)Session["End"];
string companyId = (string)Session["CompanyID"];
string accountId = string.Empty;
PivotXlsxExportOptions exportOptions = new PivotXlsxExportOptions()
{
ExportType = DevExpress.Export.ExportType.WYSIWYG
};
List <JournalViewModel> model = (List <JournalViewModel>)IWSLookUp.GetJournal(start, end, accountId, companyId);
return(PivotGridExtension.ExportToXlsx(PivotGridHelper.Settings, model.ToList(), exportOptions));
}
public ActionResult Index(string filter)
{
ViewBag.Filter = filter;
var data = GetSalesPersonData(filter);
if (Request["Export"] != null)
{
return(PivotGridExtension.ExportToPdf(PivotGridHelper.CreateGeneralSettings(), data));
}
else
{
return(View(data));
}
}
public ActionResult Export()
{
var model = Product.GetProducts();
IBasePrintable gridViewPrintable = GridViewExtension.CreatePrintableObject(ViewsHelper.CreateGridViewSettings(), model);
IBasePrintable pivotGridPrintable = PivotGridExtension.CreatePrintableObject(ViewsHelper.CreatePivotGridSettings(), model);
XtraReport report = new SampleReport(gridViewPrintable, pivotGridPrintable);
MemoryStream stream = new MemoryStream();
report.ExportToPdf(stream);
return(File(stream.ToArray(), "application/pdf"));
}
public ActionResult ExportTo(string exportCommand)
{
var settings = CreatePivotGridSettings();
var data = NwindModel.GetInvoices();
switch (exportCommand)
{
case "XlsWysiwyg":
return(PivotGridExtension.ExportToXls(settings, data,
new DevExpress.Web.ASPxPivotGrid.PivotXlsExportOptions()
{
ExportType = DevExpress.Export.ExportType.WYSIWYG
}));
case "XlsDataAware":
return(PivotGridExtension.ExportToXls(settings, data));
case "XlsxWysiwyg":
return(PivotGridExtension.ExportToXlsx(settings, data,
new DevExpress.Web.ASPxPivotGrid.PivotXlsxExportOptions()
{
ExportType = DevExpress.Export.ExportType.WYSIWYG
}));
case "XlsxDataAware":
return(PivotGridExtension.ExportToXlsx(settings, data));
case "Csv":
return(PivotGridExtension.ExportToCsv(settings, data));
case "Pdf":
return(PivotGridExtension.ExportToPdf(settings, data));
case "Rtf":
return(PivotGridExtension.ExportToRtf(settings, data));
}
return(new EmptyResult());
}
public ActionResult ChartsIntegrationChartPartial()
{
var chartModel = PivotGridExtension.GetDataObject(PivotGridDemoHelper.PivotChartIntegrationSettings(), NorthwindDataProvider.GetSalesPerson());
return(PartialView("ChartsIntegrationChartPartial", chartModel));
}
public ActionResult ChartsIntegrationChartPartial()
{
var chartModel = PivotGridExtension.GetDataObject(PivotGridHelper.PivotGridSettings, PivotGridHelper.OlapConexionString);
return(PartialView("_ChartPartial", chartModel));
}
public ActionResult ExportQ()
{
return(PivotGridExtension.ExportToXlsx(SettingsQ, GetListQ(_FromQuater, _FromYearQuater, _ToQuater, _ToYearQuater, _WarehouseId)));
}
public ActionResult ExportD()
{
return(PivotGridExtension.ExportToXlsx(SettingsD, GetList(_Fromdate, _Todate, _WarehouseId)));
}
public ActionResult ExportToPDF()
{
return(PivotGridExtension.ExportToPdf(PivotGridHelper.Settings, Models.NwindModel.GetData()));
}
public ActionResult ExportToXLSX_DataAware()
{
return(PivotGridExtension.ExportToXlsx(PivotGridHelper.Settings, Models.NwindModel.GetData(), PivotGridHelper.XlsxOptions));
}
public ActionResult ExportM()
{
return(PivotGridExtension.ExportToXlsx(SettingsM, GetListM(_FromMonth, _FromYearMonth, _ToMonth, _ToYearMonth, _WarehouseId)));
}
public ActionResult ModelPivotChartPartial()
{
return(PartialView("ModelPivotChartPartial", PivotGridExtension.GetDataObject(ModelPivotSettings(), OLAP_XSTRING)));
}
