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; }
public static void ConfigureDataSource(DataSourceInMemoryStorage storage) { // Registers an Entity Framework data source. DashboardEFDataSource efDataSource = new DashboardEFDataSource("EF Data Source"); efDataSource.ConnectionParameters = new EFConnectionParameters(typeof(OrderContext)); storage.RegisterDataSource("efDataSource", efDataSource.SaveToXml()); }
public static void RegisterService(RouteCollection routes) { routes.MapDashboardRoute("dashboardControl", "DefaultDashboard"); DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); DashboardConfigurator.Default.SetDashboardStorage(dashboardFileStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an Entity Framework data source. DashboardEFDataSource efDataSource = new DashboardEFDataSource("EF Data Source"); efDataSource.ConnectionParameters = new EFConnectionParameters(typeof(NorthwindDataModel)); dataSourceStorage.RegisterDataSource("efDataSource", efDataSource.SaveToXml()); DashboardConfigurator.Default.SetDataSourceStorage(dataSourceStorage); }
public CustomDataSourceStorage() { DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource(sqlDataSourceId, "sqlCategories"); SelectQuery query = SelectQueryFluentBuilder .AddTable("Categories") .SelectAllColumnsFromTable() .Build("Categories"); query.Parameters.Add(new QueryParameter("CategoryNameStartsWith", typeof(DevExpress.DataAccess.Expression), new DevExpress.DataAccess.Expression("[Parameters.CategoryPattern]"))); sqlDataSource.Queries.Add(query); DashboardJsonDataSource jsonDataSource = new DashboardJsonDataSource(jsonDataSourceId) { RootElement = "Customers", ConnectionName = "jsonCustomers" }; DashboardObjectDataSource objDataSource = new DashboardObjectDataSource(odsDataSourceId) { DataId = "odsSales" }; DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource(olapDataSourceId, "olapAdventureWorks"); DashboardExtractDataSource extractDataSource = new DashboardExtractDataSource(extractDataSourceId) { ConnectionName = "extractSalesPerson" }; DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource(excelDataSourceId) { ConnectionName = "excelSales", SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Sheet1")) }; DashboardEFDataSource efDataSource = new DashboardEFDataSource(efDataSourceId, new EFConnectionParameters(typeof(NorthwindDbContext))); documents[sqlDataSourceId] = new XDocument(sqlDataSource.SaveToXml()); documents[jsonDataSourceId] = new XDocument(jsonDataSource.SaveToXml()); documents[odsDataSourceId] = new XDocument(objDataSource.SaveToXml()); documents[olapDataSourceId] = new XDocument(olapDataSource.SaveToXml()); documents[extractDataSourceId] = new XDocument(extractDataSource.SaveToXml()); documents[excelDataSourceId] = new XDocument(excelDataSource.SaveToXml()); documents[efDataSourceId] = new XDocument(efDataSource.SaveToXml()); }
public static void RegisterService(RouteCollection routes) { routes.MapDashboardRoute("DashboardControl"); //routes.MapDashboardRoute("DashboardMain", "DashboardMain", new[] { "MvcDashboard_ServerSideApi" }); DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); DashboardConfigurator.Default.SetDashboardStorage(dashboardFileStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an Entity Framework data source. DashboardEFDataSource efDataSource = new DashboardEFDataSource("EF Data Source"); efDataSource.ConnectionParameters = new EFConnectionParameters(typeof(Persistence.EntitiesDataModel)); dataSourceStorage.RegisterDataSource("efDataSource", efDataSource.SaveToXml()); DashboardConfigurator.Default.SetDataSourceStorage(dataSourceStorage); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboardEf.SetDashboardStorage(dashboardFileStorage); // Uncomment the next line to allow users to create new data sources based on predefined connection strings. //ASPxDashboardEf.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); // Create a data source storage. DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Register an Entity Framework data source. DashboardEFDataSource efDataSource = new DashboardEFDataSource("EF Core Data Source"); efDataSource.ConnectionParameters = new EFConnectionParameters(typeof(OrdersContext)); dataSourceStorage.RegisterDataSource("efDataSource", efDataSource.SaveToXml()); // Set the configured data source storage. ASPxDashboardEf.SetDataSourceStorage(dataSourceStorage); ASPxDashboardEf.InitialDashboardId = "dashboardEf"; }
static IDashboardDataSource CreateDataSourceCopy(IDashboardDataSource dataSourceToCopy) { DashboardEFDataSource efDataSource = dataSourceToCopy as DashboardEFDataSource; if (efDataSource != null) { XElement element = efDataSource.SaveToXml(); DashboardEFDataSource newDataSource = new DashboardEFDataSource(); newDataSource.LoadFromXml(element); newDataSource.Fill(); return(newDataSource); } DashboardExcelDataSource excelDataSource = dataSourceToCopy as DashboardExcelDataSource; if (excelDataSource != null) { XElement element = excelDataSource.SaveToXml(); DashboardExcelDataSource newDataSource = new DashboardExcelDataSource(); newDataSource.LoadFromXml(element); newDataSource.Fill(); return(newDataSource); } DashboardExtractDataSource extractDataSource = dataSourceToCopy as DashboardExtractDataSource; if (extractDataSource != null) { XElement element = extractDataSource.SaveToXml(); DashboardExtractDataSource newDataSource = new DashboardExtractDataSource(); newDataSource.LoadFromXml(element); return(newDataSource); } DashboardObjectDataSource objectDataSource = dataSourceToCopy as DashboardObjectDataSource; if (objectDataSource != null) { XElement element = objectDataSource.SaveToXml(); DashboardObjectDataSource newDataSource = new DashboardObjectDataSource(); newDataSource.LoadFromXml(element); newDataSource.Fill(); return(newDataSource); } DashboardOlapDataSource olapDataSource = dataSourceToCopy as DashboardOlapDataSource; if (olapDataSource != null) { XElement element = olapDataSource.SaveToXml(); DashboardOlapDataSource newDataSource = new DashboardOlapDataSource(); newDataSource.LoadFromXml(element); newDataSource.Fill(); return(newDataSource); } DashboardSqlDataSource sqlDataSource = dataSourceToCopy as DashboardSqlDataSource; if (sqlDataSource != null) { XElement element = sqlDataSource.SaveToXml(); DashboardSqlDataSource newDataSource = new DashboardSqlDataSource(); newDataSource.LoadFromXml(element); newDataSource.Fill(); return(newDataSource); } return(null); }