public static DataSet RetrieveDataCache()
{
if (HttpContext.Current.Session["dataset"] == null)
{
HttpContext.Current.Session["dataset"] = ManualDataSet.CreateData();
}
return((DataSet)HttpContext.Current.Session["dataset"]);
}
private Stream ExecuteMerge(string templateName, DocumentFormat documentFormat)
{
Stream result = new MemoryStream();
MailMergeOptions mailMergeOptions = documentServer.CreateMailMergeOptions();
if (templateName == "preview1")
{
documentServer.LoadDocument(Page.MapPath("~/App_Data/InvoicesDetail.rtf"));
List <Invoice> invoices = new List <Invoice>(10);
invoices.Add(new Invoice(0, "Invoice1", 10.0m));
invoices.Add(new Invoice(1, "Invoice2", 15.0m));
invoices.Add(new Invoice(2, "Invoice3", 20.0m));
mailMergeOptions.DataSource = invoices;
}
else if (templateName == "preview2")
{
documentServer.LoadDocument(Page.MapPath("~/App_Data/SamplesDetail.rtf"));
mailMergeOptions.DataSource = ManualDataSet.CreateData().Tables[0];
}
else if (templateName == "all")
{
Stream part1 = ExecuteMerge("preview1", documentFormat);
Stream part2 = ExecuteMerge("preview2", documentFormat);
part1.Seek(0, SeekOrigin.Begin);
part2.Seek(0, SeekOrigin.Begin);
documentServer.LoadDocument(part1, documentFormat);
documentServer.Document.AppendDocumentContent(part2, documentFormat);
documentServer.SaveDocument(result, documentFormat);
return(result);
}
documentServer.Options.MailMerge.ViewMergedData = true;
documentServer.Options.Export.Html.EmbedImages = true;
mailMergeOptions.MergeMode = MergeMode.JoinTables;
documentServer.MailMerge(mailMergeOptions, result, documentFormat);
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
ASPxPivotGrid1.DataSource = ManualDataSet.CreateData().Tables[0];
ASPxPivotGrid1.DataBind();
if (!IsPostBack)
{
Session["selectedRowIndex"] = 0;
Session["selectedColIndex"] = 0;
ASPxPivotGrid1.RetrieveFields();
ASPxPivotGrid1.Fields["MyData"].Area = DevExpress.XtraPivotGrid.PivotArea.DataArea;
ASPxPivotGrid1.Fields["MyRow"].Area = DevExpress.XtraPivotGrid.PivotArea.RowArea;
ASPxPivotGrid1.Fields["MyDateTime"].Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea;
ASPxPivotGrid1.Fields["MyDateTime"].ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
ASPxPivotGrid1.Fields["MyDateTime"].ValueFormat.FormatString = "d";
((XYDiagram)WebChartControl1.Diagram).AxisX.DateTimeOptions.Format = DateTimeFormat.ShortDate;
}
PrepareChartData();
FillChart();
}
private DataSet GetSimpleChartDataCache() {
if(Session["chartData"] == null)
Session["chartData"] = ManualDataSet.CreateData();
return (DataSet)Session["chartData"];
}
