private static SqlDataSource InitData()
{
MsSqlConnectionParameters connectionParameters = new MsSqlConnectionParameters("localhost", "nwind.mdf", "username", "password", MsSqlAuthorizationType.SqlServer);
SqlDataSource ds = new SqlDataSource(connectionParameters);
CustomSqlQuery query = new CustomSqlQuery();
query.Name = "customQuery1";
query.Sql = "SELECT * FROM Products";
ds.Queries.Add(query);
ds.Fill();
return(ds);
}
public DatabaseConnectionSI()
{
ApplicationConfig config = new ApplicationConfig("GeneralAppSettings");
DatabaseConnection = new MsSqlConnectionParameters()
{
ServerName = config.GetValue(GeneralAppSettings.ServerName),
DatabaseName = config.GetValue(GeneralAppSettings.DatabaseName),
UserName = config.GetValue(GeneralAppSettings.UserName),
Password = config.GetValue(GeneralAppSettings.UserPassword),
AuthorizationType = MsSqlAuthorizationType.SqlServer
};
}
public static SqlDataSource CreateSqlDataSource()
{
MsSqlConnectionParameters connectionParameters = new MsSqlConnectionParameters(".", "NorthWind", null, null, MsSqlAuthorizationType.Windows);
var sqlDataSource = new SqlDataSource(connectionParameters)
{
Name = "Sql_Categories"
};
var categoriesQuery = SelectQueryFluentBuilder.AddTable("Categories").
SelectAllColumnsFromTable().
Build("Categories");
sqlDataSource.Queries.Add(categoriesQuery);
sqlDataSource.RebuildResultSchema();
return(sqlDataSource);
}
private static MsSqlConnectionParameters GetMsSqlParameters(EntityConnection connection)
{
MsSqlConnectionParameters connectionParameters = new MsSqlConnectionParameters();
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connection.StoreConnection.ConnectionString);
connectionParameters.ServerName = connection.DataSource;
connectionParameters.DatabaseName = builder.InitialCatalog;
connectionParameters.AuthorizationType = MsSqlAuthorizationType.Windows;
if (builder.IntegratedSecurity == false)
{
connectionParameters.AuthorizationType = MsSqlAuthorizationType.SqlServer;
connectionParameters.UserName = builder.UserID;
connectionParameters.Password = builder.Password;
}
return(connectionParameters);
}
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; }
}
private MsSqlConnectionParameters setConnectionString()
{
var list = splitConnectionString();
string serverName, dbName, userId, password;
serverName = list.FirstOrDefault(x => x.Key == "data source").Value;
dbName = list.FirstOrDefault(x => x.Key == "initial catalog").Value;
userId = list.FirstOrDefault(x => x.Key == "user id").Value;
password = list.FirstOrDefault(x => x.Key == "password").Value;
MsSqlConnectionParameters ms = new MsSqlConnectionParameters(
serverName, dbName, userId, password,
(userId != null && password != null) ?
MsSqlAuthorizationType.SqlServer : MsSqlAuthorizationType.Windows);
return(ms);
}
internal static SqlDataSource BindToData(string queryComand)
{
//BUSCAR LA CADENA DE CONEXXION DEL CONTENEDOR DE DATOS SELLECCIONADO StoredProcQuery
var cnnContext = new SiroDb();
var cnn = cnnContext.Database.Connection.ConnectionString.Split(';');
//// Create a data source with the required connection parameters.
MsSqlConnectionParameters connectionParameters = new MsSqlConnectionParameters(cnn[0].Split('=')[1], cnn[1].Split('=')[1], cnn[3].Split('=')[1], cnn[4].Split('=')[1], MsSqlAuthorizationType.SqlServer);
SqlDataSource ds = new SqlDataSource(connectionParameters);
CustomSqlQuery query = new CustomSqlQuery();
query.Name = @"customQuery";
query.Sql = queryComand;
// Add the query to the collection.
ds.Queries.Add(query);
// Make the data source structure displayed
// in the Field List of an End-User Report Designer.
ds.RebuildResultSchema();
return(ds);
}
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;
}
}
public static void SetupSqlParameters(IObjectSpace objectSpace, MsSqlConnectionParameters connectionParameters)
{
EFObjectSpace efObjectSpace = objectSpace as EFObjectSpace;
if (efObjectSpace != null)
{
EntityConnection connection = efObjectSpace.ObjectContext.Connection as EntityConnection;
if (connection != null && connectionParameters != null)
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connection.StoreConnection.ConnectionString);
connectionParameters.ServerName = connection.DataSource;
connectionParameters.DatabaseName = builder.InitialCatalog;
connectionParameters.AuthorizationType = MsSqlAuthorizationType.Windows;
if (builder.IntegratedSecurity == false)
{
connectionParameters.AuthorizationType = MsSqlAuthorizationType.SqlServer;
connectionParameters.UserName = builder.UserID;
connectionParameters.Password = builder.Password;
}
}
}
}
