/// <summary>
/// Configures Dashboard Data Connection
/// </summary>
/// <param name="sender">Sending Object</param>
/// <param name="e">Event Args</param>
protected void ASPxDashboardViewer1_ConfigureDataConnection(object sender, DevExpress.DashboardWeb.ConfigureDataConnectionWebEventArgs e)
{
////Cast As Connection Parm
//MsSqlConnectionParameters parm = e.ConnectionParameters as MsSqlConnectionParameters;
////Create Connection Builder
//SqlConnectionStringBuilder builder =
// new SqlConnectionStringBuilder(System.Configuration.ConfigurationManager.ConnectionStrings["connection"].ConnectionString);
////Check For Null
//if (parm != null)
//{
// //Set SQL Server Authentication
// parm.AuthorizationType = MsSqlAuthorizationType.SqlServer;
// //Set Username
// parm.UserName = builder.UserID;
// //Set Password
// parm.Password = builder.Password;
// //Set Server
// parm.ServerName = builder.DataSource;
// //Set Catalog
// parm.DatabaseName = builder.InitialCatalog;
//}
}
protected void ConfigureDataConnection(object sender, DevExpress.DashboardWeb.ConfigureDataConnectionWebEventArgs e)
{
//var parameters = e.ConnectionParameters as MsSqlConnectionParameters;
//if (parameters != null)
//{
// parameters.AuthorizationType = MsSqlAuthorizationType.SqlServer;
// parameters.UserName = "******";
// parameters.Password = "******";
//}
}
protected void ASPxDashboardViewer1_ConfigureDataConnection(object sender, DevExpress.DashboardWeb.ConfigureDataConnectionWebEventArgs e)
{
MySqlConnectionParameters param = e.ConnectionParameters as MySqlConnectionParameters;
if (param != null)
{
param.DatabaseName = new InstanceConfigServices().GetConfig("dbname");
param.Password = new InstanceConfigServices().GetConfig("dbpws");
param.ServerName = new InstanceConfigServices().GetConfig("dbserver");
param.UserName = new InstanceConfigServices().GetConfig("dbuser");
}
}
protected void dbvPrincipal_ConfigureDataConnection(object sender, DevExpress.DashboardWeb.ConfigureDataConnectionWebEventArgs e)
{
MySqlConnectionParameters parameters = e.ConnectionParameters as MySqlConnectionParameters;
if (parameters != null)
{
parameters.ServerName = Session["server"].ToString();
parameters.Port = Session["porta"].ToString();
parameters.UserName = Session["user"].ToString();
parameters.DatabaseName = Session["banco"].ToString();
parameters.Password = Session["senha"].ToString();
}
}
protected void dashViewer_ConfigureDataConnection(object sender, DevExpress.DashboardWeb.ConfigureDataConnectionWebEventArgs e)
{
try
{
MsSqlConnectionParameters parameters = e.ConnectionParameters as MsSqlConnectionParameters;
if (parameters != null)
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder((string)Session["userConnString"]);
parameters.AuthorizationType = MsSqlAuthorizationType.SqlServer;
parameters.ServerName = builder.DataSource;
parameters.DatabaseName = builder.InitialCatalog;
parameters.UserName = builder.UserID;
parameters.Password = builder.Password;
}
}
catch (Exception ex) { return; }
}
protected void ASPxDashboardViewer1_ConfigureDataConnection(object sender, DevExpress.DashboardWeb.ConfigureDataConnectionWebEventArgs e)
{
string conString = ConfigurationManager.ConnectionStrings["firs_portalCon"].ConnectionString;
SqlConnectionStringBuilder con = new SqlConnectionStringBuilder(conString);
if (e.ConnectionName == "firs_portalCon")
{
// Gets the connection parameters used to establish a connection to the database.
MsSqlConnectionParameters parameters =
(MsSqlConnectionParameters)e.ConnectionParameters;
// Specifies the user name used to access the database file.
parameters.UserName = con.UserID;
// Specifies the password used to access the database file.
parameters.Password = con.Password;
// Specifies the datasource.
parameters.ServerName = con.DataSource;
}
}
