private void BindChartToData()
{
// Create a series
Series series = new Series("Series", ViewType.Line);
series.ArgumentScaleType = ScaleType.DateTime;
series.ValueScaleType = ScaleType.Numerical;
((LineSeriesView)series.View).LineMarkerOptions.Size = 20;
// Bind series to data
series.DataSource = ManualDataSet.RetrieveDataCache().Tables[0];
series.ArgumentDataMember = "MyDateTime";
series.ValueDataMembers.AddRange(new string[] { "MyData" });
WebChartControl1.Series.Add(series);
// Adjust X axis options
((XYDiagram)WebChartControl1.Diagram).AxisX.DateTimeOptions.Format = DateTimeFormat.Custom;
((XYDiagram)WebChartControl1.Diagram).AxisX.DateTimeOptions.FormatString = "HH:mm:ss";
((XYDiagram)WebChartControl1.Diagram).AxisX.Label.Staggered = true;
((XYDiagram)WebChartControl1.Diagram).AxisX.DateTimeMeasureUnit = DateTimeMeasurementUnit.Hour;
//((XYDiagram)WebChartControl1.Diagram).AxisX.GridSpacingAuto = false;
//((XYDiagram)WebChartControl1.Diagram).AxisX.GridSpacing = 1;
WebChartControl1.DataBind();
}
public static DataSet RetrieveDataCache()
{
if (HttpContext.Current.Session["dataset"] == null)
{
HttpContext.Current.Session["dataset"] = ManualDataSet.CreateData();
}
return((DataSet)HttpContext.Current.Session["dataset"]);
}
public static ManualDataSet CreateData()
{
ManualDataSet ds = new ManualDataSet();
DataTable table = ds.Tables["table"];
table.Rows.Add(new object[] { 0, DateTime.Today, "A", 103 });
table.Rows.Add(new object[] { 1, DateTime.Today, "B", 200 });
table.Rows.Add(new object[] { 2, DateTime.Today, "C", 446 });
return(ds);
}
public static ManualDataSet CreateData()
{
ManualDataSet ds = new ManualDataSet();
DataTable table = ds.Tables["table"];
table.Rows.Add(new object[] { 0, DateTime.Today, "A", 103 });
table.Rows.Add(new object[] { 1, DateTime.Today, "B", 200 });
table.Rows.Add(new object[] { 2, DateTime.Today.AddDays(1), "A", 788 });
table.Rows.Add(new object[] { 3, DateTime.Today.AddDays(1), "B", 787 });
table.Rows.Add(new object[] { 4, DateTime.Today.AddDays(2), "A", 152 });
table.Rows.Add(new object[] { 5, DateTime.Today.AddDays(2), "B", 565 });
return(ds);
}
public static DataSet CreateData()
{
DataSet ds = new ManualDataSet();
DataTable table = ds.Tables["table"];
table.Rows.Add(new object[] { 0, DateTime.Today.AddHours(1), "A", 103 });
table.Rows.Add(new object[] { 1, DateTime.Today.AddHours(3), "B", 200 });
table.Rows.Add(new object[] { 2, DateTime.Today.AddHours(6), "C", 446 });
table.Rows.Add(new object[] { 3, DateTime.Today.AddHours(10), "D", 788 });
table.Rows.Add(new object[] { 4, DateTime.Today.AddHours(15), "E", 674 });
table.Rows.Add(new object[] { 5, DateTime.Today.AddHours(20), "F", 452 });
return(ds);
}
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 WebChartControl1_CustomCallback(object sender, DevExpress.XtraCharts.Web.CustomCallbackEventArgs e)
{
string[] parameters = e.Parameter.Split(';');
DateTime originalArgument = Convert.ToDateTime(hfOriginalArgument.Value, CultureInfo.InvariantCulture);
DateTime argument = Convert.ToDateTime(parameters[0], CultureInfo.InvariantCulture);
double value = Convert.ToDouble(parameters[1]);
DataTable table = ManualDataSet.RetrieveDataCache().Tables[0];
for (int i = 0; i < table.Rows.Count; i++)
{
if (Convert.ToDateTime(table.Rows[i]["MyDateTime"]) == originalArgument)
{
table.Rows[i]["MyDateTime"] = argument;
table.Rows[i]["MyData"] = value;
break;
}
}
}
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"];
}
