// 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); }); }
public void ConfigureServices(IServiceCollection services) { services // Configures CORS policies. .AddCors(options => { options.AddPolicy("CorsPolicy", builder => { builder.AllowAnyOrigin(); builder.AllowAnyMethod(); builder.WithHeaders("Content-Type"); }); }) // Adds the DevExpress middleware. .AddDevExpressControls() // Adds controllers. .AddControllers(); // Configures the dashboard backend. services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); configurator.SetDashboardStorage(new DashboardFileStorage(FileProvider.GetFileInfo("App_Data/Dashboards").PhysicalPath)); configurator.SetDataSourceStorage(CreateDataSourceStorage()); configurator.ConfigureDataConnection += Configurator_ConfigureDataConnection; return(configurator); }); }
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; }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { // Configures services to use the Web Dashboard Control. services .AddCors(options => { options.AddPolicy("CorsPolicy", builder => { builder.AllowAnyOrigin(); builder.AllowAnyMethod(); builder.WithHeaders("Content-Type"); }); }) .AddDevExpressControls() .AddControllers(); services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); configurator.SetDashboardStorage(new DashboardFileStorage(FileProvider.GetFileInfo("App_Data/Dashboards").PhysicalPath)); configurator.SetDataSourceStorage(CreateDataSourceStorage()); configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); configurator.ConfigureDataConnection += Configurator_ConfigureDataConnection; return(configurator); }); }
// 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); }); }
// 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(); }
static PublicDashboardController() { var dashboardInMemoryStorage = new DashboardInMemoryStorage(); dashboardInMemoryStorage.RegisterDashboard("publicId", XDocument.Load(HostingEnvironment.MapPath(@"~/App_Data/PublicDashboard.xml"))); dashboardConfigurator = new DashboardConfigurator(); dashboardConfigurator.SetDashboardStorage(dashboardInMemoryStorage); }
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 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; }
static DashboardWithAntiForgegyTokenController() { // sample data var dashboardInMemoryStorage = new DashboardInMemoryStorage(); dashboardInMemoryStorage.RegisterDashboard("editId", XDocument.Load(HostingEnvironment.MapPath(@"~/App_Data/PublicDashboard.xml"))); dashboardConfigurator = new DashboardConfigurator(); dashboardConfigurator.SetDashboardStorage(dashboardInMemoryStorage); }
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; }
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 void ConfigureServices(IServiceCollection services) { services.AddMvc(); services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); configurator.SetDashboardStorage(new DashboardFileStorage(FileProvider.GetFileInfo("App_Data/Dashboards").PhysicalPath)); configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); return(configurator); }); services.AddDevExpressControls(); }
// 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>(); }
// 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(); DashboardFileStorage dashboardFileStorage = new DashboardFileStorage(FileProvider.GetFileInfo("Data/Dashboards").PhysicalPath); configurator.SetDashboardStorage(dashboardFileStorage); configurator.ConfigureDataConnection += (s, e) => { e.ConnectionParameters = new ExtractDataSourceConnectionParameters(FileProvider.GetFileInfo("Data/SalesPerson.dat").PhysicalPath); }; return(configurator); }); }
// 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.AddRazorPages(); services.AddServerSideBlazor(); services.AddMvc(); services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); configurator.SetDashboardStorage(new DashboardFileStorage(FileProvider.GetFileInfo("App_Data/Dashboards").PhysicalPath)); configurator.SetDataSourceStorage(new DataSourceInMemoryStorage()); configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); configurator.ConfigureDataConnection += Configurator_ConfigureDataConnection; return(configurator); }); }
public void ConfigureServices(IServiceCollection services) { services .AddDevExpressControls() .AddMvc(); services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); configurator.SetDashboardStorage(new DashboardFileStorage("Dashboards")); configurator.SetConnectionStringsProvider(new DashboardConnectionStringsProvider(Configuration)); configurator.SetDataSourceStorage(CreateDataSourceStorage()); configurator.ConfigureDataConnection += Configurator_ConfigureDataConnection; return(configurator); }); }
public override IController CreateController(RequestContext requestContext, string controllerName) { if (controllerName.Equals("Tablero")) { short sesionUsuarioID = 1; byte moduloID = 5; string connectionString = ConfigurationManager.ConnectionStrings["DBConexion"].ConnectionString; bool editable = true; DashboardConfigurator dashboardConfigurator = new DashboardConfigurator(); //Definir donde se guardan los dashboard //dashboardConfigurator.SetDashboardStorage(new DashboardFileStorage(@"~/App_Data/Dashboards")); DataBaseEditableDashboardStorage dataBaseDashboardStorage = new DataBaseEditableDashboardStorage(connectionString, moduloID, sesionUsuarioID, editable); dashboardConfigurator.SetDashboardStorage(dataBaseDashboardStorage); //Definir un datasource que se cargue por defecto en el dashboard DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage(); dataSourceStorage.RegisterDataSource(DataSourceGenerator.CreateDefaultDataSource(moduloID).SaveToXml()); dashboardConfigurator.SetDataSourceStorage(dataSourceStorage); //Estabecer datos de conexión a la base de datos //DashboardConfigurator.Default.SetConnectionStringsProvider(new ConnectionStringsProvider()); //Establecer esquema para mostrar solo las tablas o vistas que se requiera dashboardConfigurator.SetDBSchemaProvider(new CustomDBSchemaProvider()); dashboardConfigurator.ConfigureDataConnection += (s, e) => { if (e.DataSourceName == "DataSource") { string dsConnectionString = ConfigurationManager.ConnectionStrings["DASHBOARDS_CR"].ConnectionString; e.ConnectionParameters = new CustomStringConnectionParameters(dsConnectionString); } }; return(new DashboardController(dashboardConfigurator)); } else { return(base.CreateController(requestContext, controllerName)); } }
// 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.AddRazorPages(); services.AddServerSideBlazor(); services.AddMvc(); services.AddScoped <DashboardConfigurator>((IServiceProvider serviceProvider) => { DashboardConfigurator configurator = new DashboardConfigurator(); // Register Dashboard Storage configurator.SetDashboardStorage(new DashboardFileStorage(FileProvider.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"; dataSourceStorage.RegisterDataSource("jsonDataSourceUrl", jsonDataSourceUrl.SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); return(configurator); }); }
public override IController CreateController(RequestContext requestContext, string controllerName) { if (controllerName == "SalesDashboard") { DashboardConfigurator salesConfigurator = new DashboardConfigurator(); salesConfigurator.SetDashboardStorage(new DashboardFileStorage(@"~/App_Data/Sales")); salesConfigurator.ConfigureDataConnection += (s, e) => { string databasePath = HostingEnvironment.MapPath("~/App_Data/nwind.mdb"); if (e.ConnectionName == "Northwind connection") { e.ConnectionParameters = new Access97ConnectionParameters(databasePath, "", ""); } }; return(new DashboardController(salesConfigurator)); } else if (controllerName == "MarketingDashboard") { DashboardConfigurator marketingConfigurator = new DashboardConfigurator(); marketingConfigurator.SetDashboardStorage(new DashboardFileStorage(@"~/App_Data/Marketing")); marketingConfigurator.ConfigureDataConnection += (s, e) => { string connectionString = @"provider=MSOLAP; data source=https://demos.devexpress.com/Services/OLAP/msmdpump.dll; initial catalog=Adventure Works DW Standard Edition; cube name=Adventure Works;"; if (e.ConnectionName == "Adventure Works connection") { e.ConnectionParameters = new OlapConnectionParameters(connectionString); } }; return(new DashboardController(marketingConfigurator)); } else { return(base.CreateController(requestContext, controllerName)); } }
public DefaultDashboardController(DashboardConfigurator configurator, IDataProtectionProvider dataProtectionProvider = null) : base(configurator, dataProtectionProvider) { }
public SenDevXafDashboardController(DashboardConfigurator configurator, IDataProtectionProvider dataProtectionProvider, IXafApplicationProvider xafApplicationProvider) : base(configurator, dataProtectionProvider) { configurator.ConfigureDataConnection += Configurator_ConfigureDataConnection; XafApplicationProvider = xafApplicationProvider; }
// 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(); // Configures an SQL data source. DashboardSqlDataSource sqlDataSource = new DashboardSqlDataSource("SQL Data Source", "NWindConnectionString"); sqlDataSource.DataProcessingMode = DataProcessingMode.Client; SelectQuery query = SelectQueryFluentBuilder .AddTable("Orders") .SelectAllColumnsFromTable() .Build("SQL Orders"); sqlDataSource.Queries.Add(query); // Configures an Object data source. DashboardObjectDataSource objDataSource = new DashboardObjectDataSource("Object Data Source"); objDataSource.DataId = "odsInvoices"; // Configures an Excel data source. DashboardExcelDataSource excelDataSource = new DashboardExcelDataSource("Excel Data Source"); excelDataSource.ConnectionName = "excelSales"; excelDataSource.FileName = FileProvider.GetFileInfo("Data/SalesPerson.xlsx").PhysicalPath; excelDataSource.SourceOptions = new ExcelSourceOptions(new ExcelWorksheetSettings("Data")); // Configures a JSON data source. DashboardJsonDataSource jsonDataSource = new DashboardJsonDataSource("JSON Data Source"); jsonDataSource.ConnectionName = "jsonCategories"; Uri fileUri = new Uri(FileProvider.GetFileInfo("Data/Categories.json").PhysicalPath, UriKind.RelativeOrAbsolute); jsonDataSource.JsonSource = new UriJsonSource(fileUri); // Registers a Federated data source. dataSourceStorage.RegisterDataSource("federatedDataSource", CreateFederatedDataSource(sqlDataSource, excelDataSource, objDataSource, jsonDataSource).SaveToXml()); configurator.SetDataSourceStorage(dataSourceStorage); configurator.DataLoading += (s, e) => { if (e.DataId == "odsInvoices") { e.Data = Invoices.CreateData(); } }; configurator.ConfigureDataConnection += (s, e) => { if (e.ConnectionName == "excelSales") { (e.ConnectionParameters as ExcelDataSourceConnectionParameters).FileName = FileProvider.GetFileInfo("Data/SalesPerson.xlsx").PhysicalPath; } else if (e.ConnectionName == "jsonCategories") { UriJsonSource source = new UriJsonSource(new Uri(FileProvider.GetFileInfo("Data/Categories.json").PhysicalPath, UriKind.RelativeOrAbsolute)); (e.ConnectionParameters as JsonSourceConnectionParameters).JsonSource = source; } }; return(configurator); }); }
public DefaultDashboardController(DashboardConfigurator dashboardConfigurator) : base(dashboardConfigurator) { }