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.");
}
}
}
