private Dashboard CreateDashboard()
{
DashboardExcelDataSource excelDataSource = CreateExcelDataSource();
Dashboard dBoard = new Dashboard();
dBoard.DataSources.Add(excelDataSource);
dBoard.BeginUpdate();
// Create dashboard items.
ChartDashboardItem chart = CreateChart(excelDataSource);
dBoard.Items.Add(chart);
DateFilterDashboardItem dateFilterItem = CreateDateFilterItem(excelDataSource);
dBoard.Items.Add(dateFilterItem);
DashboardItemGroup group = CreateGroup();
dBoard.Groups.Add(group);
group.AddRange(dateFilterItem, chart);
// Create layout tree.
DashboardLayoutItem dateFilterLayoutItem = new DashboardLayoutItem(dateFilterItem, 30);
DashboardLayoutItem chartLayoutItem = new DashboardLayoutItem(chart, 70);
DashboardLayoutGroup groupLayoutItem = new DashboardLayoutGroup(group, 100);
groupLayoutItem.ChildNodes.AddRange(dateFilterLayoutItem, chartLayoutItem);
DashboardLayoutGroup rootGroup = new DashboardLayoutGroup(null, 100);
rootGroup.ChildNodes.Add(groupLayoutItem);
rootGroup.Orientation = DashboardLayoutGroupOrientation.Vertical;
dBoard.LayoutRoot = rootGroup;
dBoard.EndUpdate();
return(dBoard);
}
private DateFilterDashboardItem CreateDateFilterItem(DashboardExcelDataSource excelDataSource)
{
DateFilterDashboardItem dateFilter = new DateFilterDashboardItem();
dateFilter.Name = string.Empty;
dateFilter.ShowCaption = false;
dateFilter.DataSource = excelDataSource;
dateFilter.Dimension = new Dimension("orderDateId", "OrderDate", DateTimeGroupInterval.DayMonthYear);
dateFilter.Dimension.DateTimeFormat.DateTimeFormat = DateTimeFormat.Short;
dateFilter.ArrangementMode = DateFilterArrangementMode.Vertical;
dateFilter.FilterType = DateFilterType.Between;
dateFilter.DatePickerLocation = DatePickerLocation.Hidden;
dateFilter.DateTimePeriods.AddRange(
DateTimePeriod.CreateLastYear(),
DateTimePeriod.CreateNextDays("Next 7 Days", 7),
new DateTimePeriod
{
Name = "Month-to-date",
Start = new FlowDateTimePeriodLimit
{
Interval = DateTimeInterval.Month,
Offset = 0
},
End = new FlowDateTimePeriodLimit
{
Interval = DateTimeInterval.Day,
Offset = 1
}
},
new DateTimePeriod
{
Name = "Jul-18-2018 - Jan-18-2019",
Start = new FixedDateTimePeriodLimit
{
Date = new DateTime(2018, 7, 18)
},
End = new FixedDateTimePeriodLimit
{
Date = new DateTime(2019, 1, 18)
}
}
);
return(dateFilter);
}
