private void SetupConnectionString(DashboardConfigureDataConnectionEventArgs e)
{
// There is a duplicate code in Module.Web too.. Dont forget to change it.
var connectionStringSettings = ConfigurationManager.ConnectionStrings[e.ConnectionName];
ConnectionStringParser parser;
if (connectionStringSettings != null)
{
parser = new ConnectionStringParser(connectionStringSettings.ConnectionString);
}
else
{
parser = new ConnectionStringParser(Application.ConnectionString);
}
var connectionParameters = e.ConnectionParameters as CustomStringConnectionParameters;
if (connectionParameters != null && connectionParameters.ConnectionString.Contains("XpoProvider=MSSqlServer"))
// SqlServer
{
var sqlConnectionParameters = new MsSqlConnectionParameters();
sqlConnectionParameters.ServerName = !string.IsNullOrWhiteSpace(parser.GetPartByName("Data Source")) ? parser.GetPartByName("Data Source") : parser.GetPartByName("Server");
sqlConnectionParameters.DatabaseName = parser.GetPartByName("Initial Catalog");
sqlConnectionParameters.AuthorizationType =
parser.GetPartByName("Integrated Security").ToLower() == "true"
? MsSqlAuthorizationType.Windows
: MsSqlAuthorizationType.SqlServer;
sqlConnectionParameters.UserName = parser.GetPartByName("User ID");
sqlConnectionParameters.Password = parser.GetPartByName("Password");
e.ConnectionParameters = sqlConnectionParameters;
}
}
private void dashboardViewer1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e)
{
if (e.DataSourceName == "SQL Data Source 1")
{
e.ConnectionParameters = new Access97ConnectionParameters(@"..\..\Data\nwind.mdb", "", "");
}
}
private void ConfigureDataConnection(DashboardConfigureDataConnectionEventArgs e)
{
if (e.ConnectionName == "GlobalSales_XCRM")
{
e.ConnectionParameters = SqlDashboardHelper.GetSqlParameters(ObjectSpace);
}
}
private void DashboardViewer1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e)
{
if (e.DataSourceName == "SalesPerson")
{
((ExcelDataSourceConnectionParameters)e.ConnectionParameters).FileName = @"Data\SalesPerson.xlsx";
}
}
private void ConfigureDataConnection(DashboardConfigureDataConnectionEventArgs 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 void ConfigureDataConnection(DashboardConfigureDataConnectionEventArgs e)
{
if (e.ConnectionName == "GlobalSales_XCRM")
{
e.ConnectionParameters = new MsSqlConnectionParameters();
SqlDashboardHelper.SetupSqlParameters(ObjectSpace, (MsSqlConnectionParameters)e.ConnectionParameters);
}
}
private void dashboardViewer1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e)
{
ExtractDataSourceConnectionParameters parameters = e.ConnectionParameters as ExtractDataSourceConnectionParameters;
if (parameters != null)
{
parameters.FileName = Path.GetFileName(parameters.FileName);
}
}
private void dashboardControl1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e)
{
CustomStringConnectionParameters parameters = e.ConnectionParameters as CustomStringConnectionParameters;
if (e.DataSourceName == "MySqlDataSource")
{
parameters.ConnectionString =
@"XpoProvider=MSSqlServer;Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\NWind.mdf;Integrated Security=True";
}
}
private void dashboardViewer1_ConfigureDataConnection(object sender,
DashboardConfigureDataConnectionEventArgs e)
{
if (e.DataSourceName == "SQL Data Source 1")
{
Access97ConnectionParameters parameters =
(Access97ConnectionParameters)e.ConnectionParameters;
parameters.UserName = "******";
parameters.Password = "******";
}
}
private void DashboardViewer_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e)
{
switch (DBManager.PrimaryDBManagerType)
{
case DBManagerType.MySql:
e.ConnectionParameters = new MySqlConnectionParameters(DBManager.InitDatabaseServer, DBManager.InitDatabaseName, DBManager.InitDatabaseID, DBManager.InitDatabasePass, 3306);
break;
case DBManagerType.SQLServer:
e.ConnectionParameters = new MsSqlConnectionParameters();
break;
}
}
private void Dashboard1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e)
{
if (e.DataSourceName == "SQL Data Source 1")
{
// Gets connection parameters used to establish a connection to the database.
Access97ConnectionParameters parameters =
(Access97ConnectionParameters)e.ConnectionParameters;
string databasePath = @"..\..\Data\nwind.mdb";
// Specifies the path to a database file.
parameters.FileName = databasePath;
}
}
private void DashboardViewer_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e)
{
if (e.ConnectionParameters is ExtractDataSourceConnectionParameters extractParameters)
{
if (Guid.TryParse(extractParameters.FileName, out var id))
{
var extract = ObjectSpace.GetObjectByKey <DashboardDataExtract>(id);
if (extract != null)
{
extract.ConfigureConnectionParameters(extractParameters);
}
}
}
}
private void DashboardViewer_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e)
{
if (e.ConnectionParameters is ExtractDataSourceConnectionParameters extractParameters)
{
if (Guid.TryParse(extractParameters.FileName, out var id))
{
var extract = DashboardHelper.GetDataExtract(Application, ObjectSpace, id);
if (extract != null)
{
extract.ConfigureConnectionParameters(Application, extractParameters);
}
}
}
}
private void DashboardViewer_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e)
{
try
{
switch (DBManager.PrimaryDBManagerType)
{
case DBManagerType.MySql:
e.ConnectionParameters = new MySqlConnectionParameters(DBManager.InitDatabaseServer, DBManager.InitDatabaseName, DBManager.InitDatabaseID, DBManager.InitDatabasePass, 3306);
break;
case DBManagerType.SQLServer:
e.ConnectionParameters = new MsSqlConnectionParameters();
break;
}
}
catch (ExceptionManager pExceptionManager)
{
CoFAS_DevExpressManager.ShowErrorMessage(string.Format("{0}\n{1}", pExceptionManager.Exception.Message.ToString(), pExceptionManager));
}
}
private void DashboardViewer1_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e)
{
ExtractDataSourceConnectionParameters connParameters = e.ConnectionParameters as ExtractDataSourceConnectionParameters;
connParameters.FileName = "Data\\SalesPerson.dat";
}
private void Viewer_ConfigureDataConnection(object sender, DashboardConfigureDataConnectionEventArgs e)
{
ConfigureDataConnection(e);
}
