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"]; }