protected void ASPxDashboard1_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { Access97ConnectionParameters parameters = new Access97ConnectionParameters(); parameters.FileName = Server.MapPath("~/App_Data/nwind.mdb"); e.ConnectionParameters = parameters; }
private void DashboardDesigner_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "GlobalSales_XCRM") { e.ConnectionParameters = SqlDashboardHelper.GetSqlParameters(ObjectSpace); } }
private void DashboardDesigner_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { // ToDo: Complete the connection string resolving process. 2F4D197A-9BF1-4DEE-A1DC-52447F969889 // Detail link: https://www.devexpress.com/Support/Center/Question/Details/T473885 SetupConnectionString(e); }
private static void Default_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "xmlConnection") { string databasePath = HostingEnvironment.MapPath("~/App_Data/DashboardEnergyStatictics.xml"); e.ConnectionParameters = new XmlFileConnectionParameters(databasePath); } }
private void DashboardDesigner_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "GlobalSales_XCRM") { e.ConnectionParameters = new MsSqlConnectionParameters(); SqlDashboardHelper.SetupSqlParameters(ObjectSpace, (MsSqlConnectionParameters)e.ConnectionParameters); } }
private void ASPxDashboardExcel_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "excelDataConnection") { var excelParams = new ExcelDataSourceConnectionParameters(HostingEnvironment.MapPath(@"~/App_Data/Sales.xlsx")); e.ConnectionParameters = excelParams; } }
protected void ASPxDashboard1_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "xlsProducts") { ((ExcelDataSourceConnectionParameters)e.ConnectionParameters).FileName = HostingEnvironment.MapPath(@"~/App_Data/ExcelDataSource.xlsx"); } }
private static void Configurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "excelDataConnection") { ExcelDataSourceConnectionParameters excelParams = new ExcelDataSourceConnectionParameters(fileProvider.GetFileInfo("Data/Sales.xlsx").PhysicalPath); e.ConnectionParameters = excelParams; } }
void DataApi_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.DataSourceName == "SQL Data Source") { Access97ConnectionParameters accessParams = new Access97ConnectionParameters(); accessParams.FileName = HostingEnvironment.MapPath("~/App_Data/nwind.mdb"); e.ConnectionParameters = accessParams; } }
protected void ASPxDashboard1_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "access97Connection") { Access97ConnectionParameters access97Params = new Access97ConnectionParameters(); access97Params.FileName = HostingEnvironment.MapPath(@"~/App_Data/nwind.mdb"); e.ConnectionParameters = access97Params; } }
private static void Configurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "dataExtract") { ExtractDataSourceConnectionParameters extractParams = new ExtractDataSourceConnectionParameters(); extractParams.FileName = HostingEnvironment.MapPath(@"~/App_Data/SalesPersonExtract.dat"); e.ConnectionParameters = extractParams; } }
protected void ASPxDashboard1_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "sqlConn") { Access97ConnectionParameters connectionParams = new Access97ConnectionParameters(); connectionParams.FileName = Server.MapPath(@"~/App_Data/nwind.mdb"); e.ConnectionParameters = connectionParams; } }
protected void ASPxDashboard1_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "edsSales") { ExtractDataSourceConnectionParameters extractParams = new ExtractDataSourceConnectionParameters(); extractParams.FileName = HostingEnvironment.MapPath(@"~/App_Data/SalesPersonExtract.dat"); e.ConnectionParameters = extractParams; } }
private void Configurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "sqliteConnection") { SQLiteConnectionParameters sqliteParams = new SQLiteConnectionParameters(); sqliteParams.FileName = "file:Data/nwind.db"; e.ConnectionParameters = sqliteParams; } }
protected void ASPxDashboard1_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { ExtractDataSourceConnectionParameters extractCP = e.ConnectionParameters as ExtractDataSourceConnectionParameters; if (extractCP != null) { extractCP.FileName = extractFileName; } }
private static void Configurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "dataExtract") { ExtractDataSourceConnectionParameters extractParams = new ExtractDataSourceConnectionParameters(); extractParams.FileName = fileProvider.GetFileInfo("Data/SalesPersonExtract.dat").PhysicalPath; e.ConnectionParameters = extractParams; } }
private static void Configurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "jsonConnection") { Uri fileUri = new Uri(fileProvider.GetFileInfo("Data/customers.json").PhysicalPath, UriKind.RelativeOrAbsolute); JsonSourceConnectionParameters jsonParams = new JsonSourceConnectionParameters(); jsonParams.JsonSource = new UriJsonSource(fileUri); e.ConnectionParameters = jsonParams; } }
private void Configurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.DataSourceName.Contains("Customers")) { Uri fileUri = new Uri("https://raw.githubusercontent.com/DevExpress-Examples/DataSources/master/JSON/customers.json"); JsonSourceConnectionParameters jsonParams = new JsonSourceConnectionParameters(); jsonParams.JsonSource = new UriJsonSource(fileUri); e.ConnectionParameters = jsonParams; } }
private void dashboard_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (ConfigureDataConnection != null) { Application.Update(this, () => { ConfigureDataConnection(sender, e); }); } }
private void Configurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { var application = XafApplicationProvider.GetApplication(); using var objectSpace = application.CreateObjectSpace(); DashboardConnectionHelper connectionHelper = new DashboardConnectionHelper(application, objectSpace); var extract = connectionHelper.ConfigureDataConnection(e.ConnectionParameters); extract.PreserveTempFile = true; }
private static void Configurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "jsonConnection") { Uri fileUri = new Uri(HostingEnvironment.MapPath(@"~/App_Data/customers.json"), UriKind.RelativeOrAbsolute); JsonSourceConnectionParameters jsonParams = new JsonSourceConnectionParameters(); jsonParams.JsonSource = new UriJsonSource(fileUri); e.ConnectionParameters = jsonParams; } }
private static void Configurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "olapConnection") { OlapConnectionParameters olapParams = new OlapConnectionParameters(); olapParams.ConnectionString = "Provider=MSOLAP;Data Source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;" + "Initial catalog=Adventure Works DW Standard Edition;Cube name=Adventure Works;Query Timeout=100;"; e.ConnectionParameters = olapParams; } }
private void Dashboard_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionParameters is ExtractDataSourceConnectionParameters extractParameters) { if (Guid.TryParse(extractParameters.FileName, out var id)) { DashboardDataExtract extract = GetDataExtract(id); if (extract != null) extract.ConfigureConnectionParameters(extractParameters); } } }
static void DefaultOnConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "mongoDataSourceConnection") { // MongoDB without authentication credentials. e.ConnectionParameters = new MongoDBConnectionParameters("dataaccessdbxs", false, 27017); } if (e.ConnectionName == "Northwind") { e.ConnectionParameters = new MsSqlConnectionParameters("dataaccessdbxs", "Northwind", "sa", "dx", MsSqlAuthorizationType.SqlServer); } }
protected void ASPxDashboard1_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "excelSales") { (e.ConnectionParameters as ExcelDataSourceConnectionParameters).FileName = HostingEnvironment.MapPath(@"~/App_Data/SalesPerson.xlsx"); } else if (e.ConnectionName == "jsonCategories") { e.ConnectionParameters = new JsonSourceConnectionParameters() { JsonSource = new UriJsonSource(new Uri(HostingEnvironment.MapPath(@"~/App_Data/Categories.json"), UriKind.RelativeOrAbsolute)) }; } }
private void Configurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.DataSourceName.Contains("Support")) { Uri fileUri = new Uri(FileProvider.GetFileInfo("App_data/Support.json").PhysicalPath, UriKind.RelativeOrAbsolute); JsonSourceConnectionParameters jsonParams = new JsonSourceConnectionParameters(); jsonParams.JsonSource = new UriJsonSource(fileUri); e.ConnectionParameters = jsonParams; } if (e.DataSourceName.Contains("Categories")) { Uri fileUri = new Uri(FileProvider.GetFileInfo("App_data/Categories.json").PhysicalPath, UriKind.RelativeOrAbsolute); JsonSourceConnectionParameters jsonParams = new JsonSourceConnectionParameters(); jsonParams.JsonSource = new UriJsonSource(fileUri); e.ConnectionParameters = jsonParams; } }
private void ASPxDashboardJson_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "jsonUrlConnection") { JsonSourceConnectionParameters jsonParams = new JsonSourceConnectionParameters(); jsonParams.JsonSource = new UriJsonSource(new Uri("https://raw.githubusercontent.com/DevExpress-Examples/DataSources/master/JSON/support.json")); e.ConnectionParameters = jsonParams; } if (e.ConnectionName == "jsonFileConnection") { Uri fileUri = new Uri(HostingEnvironment.MapPath(@"~/App_Data/customers.json"), UriKind.RelativeOrAbsolute); JsonSourceConnectionParameters jsonParams = new JsonSourceConnectionParameters(); jsonParams.JsonSource = new UriJsonSource(fileUri); e.ConnectionParameters = jsonParams; } if (e.ConnectionName == "jsonStringConnection") { 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\":{}}"; JsonSourceConnectionParameters jsonParams = new JsonSourceConnectionParameters(); jsonParams.JsonSource = new CustomJsonSource(json); e.ConnectionParameters = jsonParams; } }
private void Configurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { if (e.ConnectionName == "jsonSupport") { Uri fileUri = new Uri(FileProvider.GetFileInfo("App_data/Support.json").PhysicalPath, UriKind.RelativeOrAbsolute); JsonSourceConnectionParameters jsonParams = new JsonSourceConnectionParameters(); jsonParams.JsonSource = new UriJsonSource(fileUri); e.ConnectionParameters = jsonParams; } if (e.ConnectionName == "jsonCategories") { Uri fileUri = new Uri(FileProvider.GetFileInfo("App_data/Categories.json").PhysicalPath, UriKind.RelativeOrAbsolute); JsonSourceConnectionParameters jsonParams = new JsonSourceConnectionParameters(); jsonParams.JsonSource = new UriJsonSource(fileUri); e.ConnectionParameters = jsonParams; } if (e.ConnectionName == "jsonCustomers") { JsonSourceConnectionParameters jsonParams = new JsonSourceConnectionParameters(); jsonParams.JsonSource = new UriJsonSource( new Uri("https://raw.githubusercontent.com/DevExpress-Examples/DataSources/master/JSON/customers.json")); e.ConnectionParameters = jsonParams; } }
// Conditional data loading for other datasource types private void DashboardConfigurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { var userName = contextAccessor.HttpContext.Session.GetString("CurrentUser"); if (e.ConnectionName == "sqlCategories") { var sqlConnectionParameters = e.ConnectionParameters as CustomStringConnectionParameters; if (userName == "Admin") { sqlConnectionParameters.ConnectionString = @"XpoProvider=SQLite; Data Source=App_Data/nwind_admin.db;"; } else if (userName == "User") { sqlConnectionParameters.ConnectionString = @"XpoProvider=SQLite; Data Source=App_Data/nwind_user.db;"; } } else if (e.ConnectionName == "jsonCustomers") { if (e.DashboardId == "JSON") { string jsonFileName = ""; if (userName == "Admin") { jsonFileName = "customers_admin.json"; } else if (userName == "User") { jsonFileName = "customers_user.json"; } var fileUri = new Uri(fileProvider.GetFileInfo("App_Data/").PhysicalPath + jsonFileName, UriKind.RelativeOrAbsolute); ((JsonSourceConnectionParameters)e.ConnectionParameters).JsonSource = new UriJsonSource(fileUri); } else if (e.DashboardId == "JSONFilter") { var remoteUri = new Uri(GetBaseUrl() + "Home/GetCustomers"); var jsonSource = new UriJsonSource(remoteUri); if (userName == "User") { jsonSource.QueryParameters.AddRange(new[] { // "CountryPattern" is a dashboard parameter whose value is used for the "CountryStartsWith" query parameter new QueryParameter("CountryStartsWith", typeof(Expression), new Expression("Parameters.CountryPattern")) }); } else if (userName != "Admin") { throw new ApplicationException("You are not authorized to access JSON data."); } ((JsonSourceConnectionParameters)e.ConnectionParameters).JsonSource = jsonSource; } } else if (e.ConnectionName == "excelSales") { var excelConnectionParameters = e.ConnectionParameters as ExcelDataSourceConnectionParameters; if (userName == "Admin") { excelConnectionParameters.FileName = fileProvider.GetFileInfo("App_Data/sales_admin.xlsx").PhysicalPath; } else if (userName == "User") { excelConnectionParameters.FileName = fileProvider.GetFileInfo("App_Data/sales_user.xlsx").PhysicalPath; } } else if (e.ConnectionName == "extractSalesPerson") { if (userName == "Admin") { ((ExtractDataSourceConnectionParameters)e.ConnectionParameters).FileName = fileProvider.GetFileInfo("App_Data/SalesPersonExtract.dat").PhysicalPath; } else { throw new ApplicationException("You are not authorized to access Extract data."); } } }
// Conditional data loading for other datasource types private static void DashboardConfigurator_ConfigureDataConnection(object sender, ConfigureDataConnectionWebEventArgs e) { var userName = (string)HttpContext.Current.Session["CurrentUser"]; if (e.ConnectionName == "sqlCategories") { var sqlConnectionParameters = e.ConnectionParameters as CustomStringConnectionParameters; if (userName == "Admin") { sqlConnectionParameters.ConnectionString = @"XpoProvider=MSAccess;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\nwind_admin.mdb;"; } else if (userName == "User") { sqlConnectionParameters.ConnectionString = @"XpoProvider=MSAccess;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\nwind_user.mdb;"; } } else if (e.ConnectionName == "jsonCustomers") { if (e.DashboardId == "JSON") { string jsonFileName = ""; if (userName == "Admin") { jsonFileName = "customers_admin.json"; } else if (userName == "User") { jsonFileName = "customers_user.json"; } var fileUri = new Uri(HttpContext.Current.Server.MapPath(@"~/App_Data/" + jsonFileName), UriKind.RelativeOrAbsolute); ((JsonSourceConnectionParameters)e.ConnectionParameters).JsonSource = new UriJsonSource(fileUri); } else if (e.DashboardId == "JSONFilter") { var remoteUri = new Uri(GetBaseUrl() + "Home/GetCustomers"); var jsonSource = new UriJsonSource(remoteUri); if (userName == "User") { jsonSource.QueryParameters.AddRange(new[] { // "CountryPattern" is a dashboard parameter whose value is used for the "CountryStartsWith" query parameter new QueryParameter("CountryStartsWith", typeof(Expression), new Expression("Parameters.CountryPattern")) }); } ((JsonSourceConnectionParameters)e.ConnectionParameters).JsonSource = jsonSource; } } else if (e.ConnectionName == "excelSales") { var excelConnectionParameters = e.ConnectionParameters as ExcelDataSourceConnectionParameters; if (userName == "Admin") { excelConnectionParameters.FileName = HttpContext.Current.Server.MapPath(@"~/App_Data/sales_admin.xlsx"); } else if (userName == "User") { excelConnectionParameters.FileName = HttpContext.Current.Server.MapPath(@"~/App_Data/sales_user.xlsx"); } } else if (e.ConnectionName == "olapAdventureWorks") { if (userName == "Admin") { ((OlapConnectionParameters)e.ConnectionParameters).ConnectionString = @"provider=MSOLAP;data source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;initial catalog=Adventure Works DW Standard Edition;cube name=Adventure Works;"; } else if (userName == "User") { throw new ApplicationException("You are not authorized to access OLAP data."); } } else if (e.ConnectionName == "extractSalesPerson") { if (userName == "Admin") { ((ExtractDataSourceConnectionParameters)e.ConnectionParameters).FileName = HttpContext.Current.Server.MapPath(@"~/App_Data/SalesPersonExtract.dat"); } else { throw new ApplicationException("You are not authorized to access Extract data."); } } }