public static void SetParamDataSource(SqlDataSource sqs, AppConfigIts appConf)
{
var param = new DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters()
{
ServerName = appConf.ServerName,
DatabaseName = appConf.Database,
UserName = appConf.User,
Password = appConf.Password
};
if (appConf.Password.IsNullOrEmpty())
{
param.AuthorizationType = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.Windows;
}
else
{
param.AuthorizationType = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.SqlServer;
}
sqs.ConnectionParameters = param;
}
/// <summary>
/// Recupera o DataSource da string de conexão atual
/// </summary>
/// <returns></returns>
public static MsSqlConnectionParameters GetParamDataSource()
{
AppConfigIts appConf = AppConfigManager.Configuration.AppConfig;
var param = new DevExpress.DataAccess.ConnectionParameters.MsSqlConnectionParameters()
{
ServerName = appConf.ServerName,
DatabaseName = appConf.Database,
UserName = appConf.User,
Password = appConf.Password
};
if (appConf.Password.IsNullOrEmpty())
{
param.AuthorizationType = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.Windows;
}
else
{
param.AuthorizationType = DevExpress.DataAccess.ConnectionParameters.MsSqlAuthorizationType.SqlServer;
}
return(param);
}
