protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); // Uncomment this string to allow end users to create new data sources based on predefined connection strings. //ASPxDashboard1.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); SelectQuery query = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectAllColumns() .Build("Sales Person"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); // Registers an Object data source. DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source"); dataSourceStorage.RegisterDataSource("objDataSource", objDataSource.SaveToXml()); // Registers an Excel data source. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource("Excel Data Source"); excelDataSource.FileName = HostingEnvironment.MapPath(@"~/App_Data/Sales.xlsx"); excelDataSource.SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Sheet1")); dataSourceStorage.RegisterDataSource("excelDataSource", excelDataSource.SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); using (Workbook workbook = new Workbook()) { Directory .EnumerateFiles(HostingEnvironment.MapPath(@"~/App_Data/ExcelFiles/"), "*.xlsx") .SelectMany(file => { workbook.LoadDocument(file); return(workbook.Worksheets.Select(sheet => { var dataSourceId = string.Format("{0} - {1}", Path.GetFileNameWithoutExtension(file), sheet.Name); var excelDataSource = new DashboardExcelDataSource(dataSourceId); excelDataSource.ConnectionName = dataSourceId; excelDataSource.FileName = file; var worksheetSettings = new ExcelWorksheetSettings() { WorksheetName = sheet.Name }; excelDataSource.SourceOptions = new ExcelSourceOptions(worksheetSettings); return new { Name = excelDataSource.Name, Xml = excelDataSource.SaveToXml() }; })); }) .ToList() .ForEach(ds => dataSourceStorage.RegisterDataSource(ds.Name, ds.Xml)); } ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
protected void Page_Load(object sender, EventArgs e) { DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("extractDataSource", CreateExtractDataSource().SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
// This method gets called by the runtime. Use this method to add services to the container. // For more information on how to configure your application, visit https://go.microsoft.com/fwlink/?LinkID=398940 public void ConfigureServices(IServiceCollection services) { services.AddMvc() .AddDefaultDashboardController(configurator => { // Register Dashboard Storage configurator.SetDashboardStorage(new DashboardFileStorage(_physicalProvider.GetFileInfo("App_Data/Dashboards").PhysicalPath)); // Create a sample JSON data source DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardJsonDataSource jsonDataSourceUrl = new DashboardJsonDataSource("JSON Data Source (URL)"); jsonDataSourceUrl.JsonSource = new UriJsonSource(new Uri("https://raw.githubusercontent.com/DevExpress-Examples/DataSources/master/JSON/customers.json")); jsonDataSourceUrl.RootElement = "Customers"; jsonDataSourceUrl.Fill(); dataSourceStorage.RegisterDataSource("jsonDataSourceUrl", jsonDataSourceUrl.SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); configurator.AllowExecutingCustomSql = true; }); services.AddRazorPages(); services.AddServerSideBlazor(); services.AddHttpContextAccessor(); services.AddSingleton <XpoDataStoreProviderAccessor>(); services.AddScoped <CircuitHandler, CircuitHandlerProxy>(); services.AddXaf <XAFBlazorDashboardsBlazorApplication>(Configuration); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddMvc(); services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); // Create and configure a dashboard storage. DashboardFileStorage dashboardFileStorage = new DashboardFileStorage(FileProvider.GetFileInfo("Data/Dashboards").PhysicalPath); configurator.SetDashboardStorage(dashboardFileStorage); // Create and configure a data source storage. DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); SqlDataSourceConfigurator.ConfigureDataSource(dataSourceStorage); ExcelDataSourceConfigurator.ConfigureDataSource(configurator, dataSourceStorage, FileProvider); ObjectDataSourceConfigurator.ConfigureDataSource(configurator, dataSourceStorage); EFDataSourceConfigurator.ConfigureDataSource(dataSourceStorage); JsonDataSourceConfigurator.ConfigureDataSource(configurator, dataSourceStorage, FileProvider); ExtractDataSourceConfigurator.ConfigureDataSource(configurator, dataSourceStorage, FileProvider); OlapDataSourceConfigurator.ConfigureDataSource(configurator, dataSourceStorage); XpoDataSourceConfigurator.ConfigureDataSource(dataSourceStorage); configurator.SetDataSourceStorage(dataSourceStorage); // Uncomment the next line to allow users to create new data sources based on predefined connection strings. // configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); return(configurator); }); services.AddDevExpressControls(); }
protected void Application_Start() { DashboardDesignerConfig.RegisterService(RouteTable.Routes); AreaRegistration.RegisterAllAreas(); WebApiConfig.Register(GlobalConfiguration.Configuration); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); ModelBinders.Binders.DefaultBinder = new DevExpress.Web.Mvc.DevExpressEditorsBinder(); DevExpress.Web.ASPxWebControl.CallbackError += Application_Error; DataBaseEditaleDashboardStorage dataBaseDashboardStorage = new DataBaseEditaleDashboardStorage(MVCDashboardDesigner.Properties.Settings.Default.DashboardStorageConnection); DashboardConfigurator.Default.SetDashboardStorage(dataBaseDashboardStorage); DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source"); SelectQuery customerReportsQuery = SelectQueryFluentBuilder .AddTable("CustomerReports") .SelectColumn("CompanyName") .SelectColumn("ProductName") .SelectColumn("OrderDate") .SelectColumn("ProductAmount") .Build("CustomerReportsQuery"); sqlDataSource.Queries.Add(customerReportsQuery); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("sqlDataSource1", sqlDataSource.SaveToXml()); DashboardConfigurator.Default.SetDataSourceStorage(dataSourceStorage); DashboardConfigurator.Default.ConfigureDataConnection += DataApi_ConfigureDataConnection; }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services .AddDevExpressControls() .AddControllersWithViews(); services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); var dataBaseDashboardStorage = new DataBaseEditaleDashboardStorage( Configuration.GetConnectionString("DashboardStorageConnection")); configurator.SetDashboardStorage(dataBaseDashboardStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source", typeof(SalesPersonData)); objDataSource.DataMember = "GetSalesData"; dataSourceStorage.RegisterDataSource("objectDataSource", objDataSource.SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); return(configurator); }); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboardSql.SetDashboardStorage(dashboardFileStorage); // Uncomment the next line to allow users to create new data sources based on predefined connection strings. //ASPxDashboardSql.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); // Create a data source storage. DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Register an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); SelectQuery query = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectAllColumnsFromTable() .Build("Sales Person"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); // Set the configured data source storage. ASPxDashboardSql.SetDataSourceStorage(dataSourceStorage); ASPxDashboardSql.InitialDashboardId = "dashboardSql"; }
public static void RegisterService(RouteCollection routes) { routes.MapDashboardRoute("dashboardControl", "DefaultDashboard"); DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); DashboardConfigurator.Default.SetDashboardStorage(dashboardFileStorage); DashboardSqlDataSource xmlDataSource = new DashboardSqlDataSource("XML Data Source", "xmlConnection"); SelectQuery countriesQuery = SelectQueryFluentBuilder .AddTable("Countries") .SelectColumns("Country", "Latitude", "Longitude", "Year", "EnergyType", "Production", "Import") .Build("Countries"); xmlDataSource.Queries.Add(countriesQuery); DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource("OLAP Data Source", "olapConnection"); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource("xmlDataSource1", xmlDataSource.SaveToXml()); dataSourceStorage.RegisterDataSource("olapDataSource1", olapDataSource.SaveToXml()); DashboardConfigurator.Default.SetDataSourceStorage(dataSourceStorage); DashboardConfigurator.Default.ConfigureDataConnection += Default_ConfigureDataConnection; }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); ASPxDashboardExcel.SetDashboardStorage(dashboardFileStorage); // Uncomment the next line to allow users to create new data sources based on predefined connection strings. //ASPxDashboardExcel.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); // Create a data source storage. DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Register an Excel data source. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource("Excel Data Source"); excelDataSource.ConnectionName = "excelDataConnection"; excelDataSource.SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Sheet1")); dataSourceStorage.RegisterDataSource("excelDataSource", excelDataSource.SaveToXml()); // Set the configured data source storage. ASPxDashboardExcel.SetDataSourceStorage(dataSourceStorage); ASPxDashboardExcel.ConfigureDataConnection += ASPxDashboardExcel_ConfigureDataConnection; ASPxDashboardExcel.InitialDashboardId = "dashboardExcel"; }
public static void RegisterService(RouteCollection routes) { routes.MapDashboardRoute("dashboardControl", "DefaultDashboard"); // Configure a dashboard storage: DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); DashboardConfigurator.Default.SetDashboardStorage(dashboardFileStorage); // Configure a data source storage: DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); SqlDataSourceConfigurator.ConfigureDataSource(dataSourceStorage); ExcelDataSourceConfigurator.ConfigureDataSource(DashboardConfigurator.Default, dataSourceStorage); ObjectDataSourceConfigurator.ConfigureDataSource(DashboardConfigurator.Default, dataSourceStorage); EFDataSourceConfigurator.ConfigureDataSource(dataSourceStorage); JsonDataSourceConfigurator.ConfigureDataSource(DashboardConfigurator.Default, dataSourceStorage); ExtractDataSourceConfigurator.ConfigureDataSource(DashboardConfigurator.Default, dataSourceStorage); OlapDataSourceConfigurator.ConfigureDataSource(DashboardConfigurator.Default, dataSourceStorage); XpoDataSourceConfigurator.ConfigureDataSource(dataSourceStorage); DashboardConfigurator.Default.SetDataSourceStorage(dataSourceStorage); // Uncomment the next line to allow users to create new data sources based on predefined connection strings. // DashboardConfigurator.Default.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services .AddResponseCompression() .AddDevExpressControls() .AddMvc(); services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); DashboardFileStorage dashboardFileStorage = new DashboardFileStorage(FileProvider.GetFileInfo("Data/Dashboards").PhysicalPath); configurator.SetDashboardStorage(dashboardFileStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); sqlDataSource.DataProcessingMode = DataProcessingMode.Client; SelectQuery query = SelectQueryFluentBuilder .AddTable("Categories") .Join("Products", "CategoryID") .SelectAllColumns() .Build("Products_Categories"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); return(configurator); }); }
public void ConfigureServices(IServiceCollection services) { services.AddResponseCompression(opts => { opts.MimeTypes = ResponseCompressionDefaults.MimeTypes.Concat( new[] { "application/octet-stream" }); }); services.AddDevExpressControls(); services.AddMvc() .AddDefaultDashboardController(configurator => { // Register Dashboard Storage configurator.SetDashboardStorage(new DashboardFileStorage(_physicalProvider.GetFileInfo("App_Data/Dashboards").PhysicalPath)); // Create a sample JSON data source DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardJsonDataSource jsonDataSourceUrl = new DashboardJsonDataSource("JSON Data Source (URL)"); jsonDataSourceUrl.JsonSource = new UriJsonSource(new Uri("https://raw.githubusercontent.com/DevExpress-Examples/DataSources/master/JSON/customers.json")); jsonDataSourceUrl.RootElement = "Customers"; jsonDataSourceUrl.Fill(); dataSourceStorage.RegisterDataSource("jsonDataSourceUrl", jsonDataSourceUrl.SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); configurator.AllowExecutingCustomSql = true; }); services.AddRazorPages(); services.AddServerSideBlazor(); services.AddSingleton <WeatherForecastService>(); }
public static void RegisterService(RouteCollection routes) { routes.MapDashboardRoute("dashboardControl", "DefaultDashboard"); DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); DashboardConfigurator.Default.SetDashboardStorage(dashboardFileStorage); // Uncomment this string to allow end users to create new data sources based on predefined connection strings. //DashboardConfigurator.Default.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); SelectQuery query = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectAllColumns() .Build("Sales Person"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); // Registers an Excel data source. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource("Excel Data Source"); excelDataSource.FileName = HostingEnvironment.MapPath(@"~/App_Data/Sales.xlsx"); excelDataSource.SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Sheet1")); dataSourceStorage.RegisterDataSource("excelDataSource", excelDataSource.SaveToXml()); DashboardConfigurator.Default.SetDataSourceStorage(dataSourceStorage); }
public void ConfigureServices(IServiceCollection services) { services .AddResponseCompression() .AddMvc() .AddDefaultDashboardController((configurator, serviceProvider) => { configurator.SetDashboardStorage(serviceProvider.GetService <SessionDashboardStorage>()); //configurator.SetDashboardStorage(new DashboardFileStorage(Path.Combine(dataDirectoryPath, "Dashboards"))); // Uncomment this line to use the App_Data/Dashboards folder to store dashboards. DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource(DataSourceGenerator.CreateNWindDataSource().SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); configurator.SetConnectionStringsProvider(serviceProvider.GetService <SessionConnectionStringsStorage>()); configurator.DataLoading += (s, e) => { DataLoader.LoadData(e); }; }); services.AddDevExpressControls(); services .AddDistributedMemoryCache() .AddSession(); services.TryAddSingleton <IHttpContextAccessor, HttpContextAccessor>(); services.AddTransient <SessionDashboardStorage>(); services.AddTransient <SessionConnectionStringsStorage>(); }
protected void Page_Load(object sender, EventArgs e) { //DashboardFileStorage dashboardFileStorage = new DashboardFileStorage("~/App_Data/Dashboards"); //ASPxDashboard1.SetDashboardStorage(dashboardFileStorage); ASPxDashboard1.SetDashboardStorage(SessionDashboardStorage.Instance); ASPxDashboard1.CustomExport += (s, args) => { ChartConstantLinesExtension.CustomExport(args); }; // Uncomment this string to allow end users to create new data sources based on predefined connection strings. //ASPxDashboard1.SetConnectionStringsProvider(new DevExpress.DataAccess.Web.ConfigFileConnectionStringsProvider()); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); ASPxDashboard1.ConfigureItemDataCalculation += (s, args) => { args.CalculateAllTotals = true; }; // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); SelectQuery query = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectAllColumns() .Build("Sales Person"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
public static void ConfigureDataSource(DashboardConfigurator configurator, DataSourceInMemoryStorage storage, IFileProvider fileProvider) { // Registers a JSON data source from URL. DashboardJsonDataSource jsonDataSourceUrl = new DashboardJsonDataSource("JSON Data Source (URL)"); jsonDataSourceUrl.JsonSource = new UriJsonSource(new Uri("https://raw.githubusercontent.com/DevExpress-Examples/DataSources/master/JSON/customers.json")); jsonDataSourceUrl.RootElement = "Customers"; jsonDataSourceUrl.Fill(); storage.RegisterDataSource("jsonDataSourceUrl", jsonDataSourceUrl.SaveToXml()); // Registers a JSON data source from a JSON file. DashboardJsonDataSource jsonDataSourceFile = new DashboardJsonDataSource("JSON Data Source (File)"); jsonDataSourceFile.ConnectionName = "jsonConnection"; jsonDataSourceFile.RootElement = "Customers"; storage.RegisterDataSource("jsonDataSourceFile", jsonDataSourceFile.SaveToXml()); // Registers a JSON data source from JSON string. DashboardJsonDataSource jsonDataSourceString = new DashboardJsonDataSource("JSON Data Source (String)"); string json = "{\"Customers\":[{\"Id\":\"ALFKI\",\"CompanyName\":\"Alfreds Futterkiste\",\"ContactName\":\"Maria Anders\",\"ContactTitle\":\"Sales Representative\",\"Address\":\"Obere Str. 57\",\"City\":\"Berlin\",\"PostalCode\":\"12209\",\"Country\":\"Germany\",\"Phone\":\"030-0074321\",\"Fax\":\"030-0076545\"}],\"ResponseStatus\":{}}"; jsonDataSourceString.JsonSource = new CustomJsonSource(json); jsonDataSourceString.RootElement = "Customers"; storage.RegisterDataSource("jsonDataSourceString", jsonDataSourceString.SaveToXml()); JsonDataSourceConfigurator.fileProvider = fileProvider; configurator.ConfigureDataConnection += Configurator_ConfigureDataConnection; }
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 ConfigureDataSource(DashboardConfigurator configurator, DataSourceInMemoryStorage storage) { // Registers an OLAP data source. DashboardOlapDataSource olapDataSource = new DashboardOlapDataSource("OLAP Data Source", "olapConnection"); storage.RegisterDataSource("olapDataSource", olapDataSource.SaveToXml()); configurator.ConfigureDataConnection += Configurator_ConfigureDataConnection; }
public DataSourceInMemoryStorage CreateDataSourceStorage() { DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("ObjectDataSource", typeof(ProductSales)); objDataSource.DataMember = "GetProductSales"; dataSourceStorage.RegisterDataSource("objectDataSource", objDataSource.SaveToXml()); return(dataSourceStorage); }
public DataSourceInMemoryStorage CreateDataSourceStorage() { DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardJsonDataSource jsonDataSource = new DashboardJsonDataSource("Customers"); jsonDataSource.RootElement = "Customers"; dataSourceStorage.RegisterDataSource("jsonDataSourceSupport", jsonDataSource.SaveToXml()); return(dataSourceStorage); }
public static void ConfigureDataSource(DataSourceInMemoryStorage storage) { // Registers an XPO data source. DashboardXpoDataSource xpoDataSource = new DashboardXpoDataSource("XPO Data Source"); xpoDataSource.ConnectionStringName = "NWindConnectionString"; xpoDataSource.SetEntityType(typeof(Category)); storage.RegisterDataSource("xpoDataSource", xpoDataSource.SaveToXml()); }
protected void Page_Load(object sender, EventArgs e) { DashboardFileStorage storage = new DashboardFileStorage(dashboardsPath); ASPxDashboard1.SetDashboardStorage(storage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource(DataSourceGenerator.CreateNWindDataSource().SaveToXml()); ASPxDashboard1.SetDataSourceStorage(dataSourceStorage); }
public static void ConfigureDataSource(DashboardConfigurator configurator, DataSourceInMemoryStorage storage) { // Registers an Object data source. DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source"); objDataSource.DataId = "objectDataSource"; storage.RegisterDataSource("objDataSource", objDataSource.SaveToXml()); configurator.DataLoading += DataLoading; }
public static void ConfigureDataSource(DashboardConfigurator configurator, DataSourceInMemoryStorage storage) { // Registers an Excel data source. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource("Excel Data Source"); excelDataSource.ConnectionName = "excelDataConnection"; excelDataSource.SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Sheet1")); storage.RegisterDataSource("excelDataSource", excelDataSource.SaveToXml()); configurator.ConfigureDataConnection += Configurator_ConfigureDataConnection; }
/// <summary> /// Registers the object data source with the dashboard. /// </summary> /// <returns>The storage of the dashboard data source.</returns> public DataSourceInMemoryStorage CreateDataSourceStorage() { DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source"); objDataSource.DataSource = typeof(SalesPersonData); dataSourceStorage.RegisterDataSource("objectDataSource1", objDataSource.SaveToXml()); return(dataSourceStorage); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1); services.AddDevExpressControls(); services.AddMvc() .AddDefaultReportingControllers() .AddDefaultDashboardController((configurator, serviceProvider) => { configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); DashboardFileStorage dashboardFileStorage = new DashboardFileStorage(FileProvider.GetFileInfo("Data/Dashboards").PhysicalPath); configurator.SetDashboardStorage(dashboardFileStorage); DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); sqlDataSource.DataProcessingMode = DataProcessingMode.Client; SelectQuery query = SelectQueryFluentBuilder .AddTable("Categories") .Join("Products", "CategoryID") .SelectAllColumns() .Build("Products_Categories"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); // Registers an Object data source. DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source"); dataSourceStorage.RegisterDataSource("objDataSource", objDataSource.SaveToXml()); // Registers an Excel data source. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource("Excel Data Source"); excelDataSource.FileName = FileProvider.GetFileInfo("Data/Sales.xlsx").PhysicalPath; excelDataSource.SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Sheet1")); dataSourceStorage.RegisterDataSource("excelDataSource", excelDataSource.SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); configurator.DataLoading += (s, e) => { if (e.DataSourceName == "Object Data Source") { e.Data = Invoices.CreateData(); } }; }); services.ConfigureReportingServices(configurator => { configurator.ConfigureReportDesigner(designerConfigurator => { designerConfigurator.RegisterDataSourceWizardConfigFileConnectionStringsProvider(); }); }); services.AddSpaStaticFiles(configuration => { configuration.RootPath = "ClientApp/dist"; }); }
public static void ConfigureDataSource(DashboardConfigurator configurator, DataSourceInMemoryStorage storage) { // Registers an Extract data source. DashboardExtractDataSource extractDataSource = new DashboardExtractDataSource("Extract Data Source"); extractDataSource.Name = "Extract Data Source"; extractDataSource.ConnectionName = "dataExtract"; storage.RegisterDataSource("extractDataSource ", extractDataSource.SaveToXml()); configurator.ConfigureDataConnection += Configurator_ConfigureDataConnection; }
public static void ConfigureDataSource(DataSourceInMemoryStorage storage) { // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); SelectQuery query = SelectQueryFluentBuilder .AddTable("SalesPerson") .SelectAllColumnsFromTable() .Build("Sales Person"); sqlDataSource.Queries.Add(query); storage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services .AddCors(options => { options.AddPolicy("AllowAnyOrigin", builder => { builder.AllowAnyOrigin(); builder.AllowAnyHeader(); builder.AllowAnyMethod(); }); }) .AddMvc(); services.AddDevExpressControls(); services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); //DashboardFileStorage dashboardFileStorage = new DashboardFileStorage(FileProvider.GetFileInfo("Data/Dashboards").PhysicalPath); //configurator.SetDashboardStorage(dashboardFileStorage); configurator.SetDashboardStorage(serviceProvider.GetService <SessionDashboardStorage>()); configurator.CustomExport += (s, e) => { ChartConstantLinesExtension.CustomExport(e); }; configurator.ConfigureItemDataCalculation += (s, e) => { e.CalculateAllTotals = true; }; DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); // Registers an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); sqlDataSource.DataProcessingMode = DataProcessingMode.Client; SelectQuery query = SelectQueryFluentBuilder .AddTable("Categories") .Join("Products", "CategoryID") .SelectAllColumns() .Build("Products_Categories"); sqlDataSource.Queries.Add(query); dataSourceStorage.RegisterDataSource("sqlDataSource", sqlDataSource.SaveToXml()); return(configurator); }); services .AddDistributedMemoryCache() .AddSession(); services.TryAddSingleton <IHttpContextAccessor, HttpContextAccessor>(); services.AddTransient <SessionDashboardStorage>(); }