-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathForm1.cs
More file actions
39 lines (34 loc) · 1.6 KB
/
Form1.cs
File metadata and controls
39 lines (34 loc) · 1.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
using DevExpress.DashboardCommon;
using DevExpress.XtraEditors;
using DevExpress.DataAccess.EntityFramework;
namespace Dashboard_EntityFramework {
public partial class Form1 : XtraForm {
public Form1() {
InitializeComponent();
InitializeDashboard();
}
public void InitializeDashboard() {
Dashboard dashboard = new Dashboard();
DashboardEFDataSource efDataSource = new DashboardEFDataSource();
efDataSource.ConnectionParameters =
new EFConnectionParameters(typeof(OrdersContext));
dashboard.DataSources.Add(efDataSource);
PivotDashboardItem pivot = new PivotDashboardItem();
pivot.DataMember = "Orders";
pivot.DataSource = dashboard.DataSources[0];
pivot.Rows.AddRange(new Dimension("ShipCountry"), new Dimension("ShipCity"));
pivot.Columns.Add(new Dimension("OrderDate"));
pivot.Values.Add(new Measure("Freight"));
ChartDashboardItem chart = new ChartDashboardItem();
chart.DataSource = dashboard.DataSources[0];
chart.DataMember = "Orders";
chart.Arguments.Add(new Dimension("OrderDate", DateTimeGroupInterval.Year));
chart.Panes.Add(new ChartPane());
SimpleSeries freightSeries = new SimpleSeries(SimpleSeriesType.Bar);
freightSeries.Value = new Measure("Freight");
chart.Panes[0].Series.Add(freightSeries);
dashboard.Items.AddRange(pivot, chart);
dashboardViewer1.Dashboard = dashboard;
}
}
}