public NewDatabaseParameters GetNewExternalDBParameters(Durados.SqlProduct sqlProduct, string id, out string server, out int port, string sampleApp)//, out string catalog
{
// set all the database parameters for the createapp
Durados.Web.Mvc.UI.Helpers.NewDatabaseParameters newDbParameters = new Durados.Web.Mvc.UI.Helpers.RDSNewDatabaseFactory().GetNewParameters(sqlProduct, id);
//catalog = newDbParameters.DbName;
CreateNewSchemaAndUser(sqlProduct, out server, out port, newDbParameters, sampleApp);
//server = newDbParameters.InstanceName; //System.Configuration.ConfigurationManager.AppSettings["AWSServer"]??".";//aws database server
//catalog = sqlProduct == Durados.SqlProduct.SqlServer ? newDbParameters.InstanceName : newDbParameters.DbName;
return(newDbParameters);
}
private static System.Data.Common.DbConnectionStringBuilder GetConnectionStringBuilder(Durados.SqlProduct product)
{
if (product == SqlProduct.MySql)
{
return(new MySql.Data.MySqlClient.MySqlConnectionStringBuilder());
}
return(new System.Data.SqlClient.SqlConnectionStringBuilder());
}
public static string GetConnectionString(string server, string username, string password, bool isMaster = false, Durados.SqlProduct product = Durados.SqlProduct.SqlServer)
{
System.Data.Common.DbConnectionStringBuilder builder = GetConnectionStringBuilder(product);
builder["data source"] = server;
builder["User ID"] = username;
builder["Password"] = password;
if (isMaster)
{
builder["initial catalog"] = "master";
}
return(builder.ConnectionString);
}
public static System.Data.IDbConnection GetConnection(Durados.SqlProduct sqlProduct, string connectionString)
{
return(Durados.DataAccess.DataAccessObject.GetNewConnection(sqlProduct, connectionString));
}
public static string GetConnectionString(string serverName, string catalog, bool?integratedSecurity, string username, string password, string duradosuserId, Durados.SqlProduct sqlProduct, int localPort, bool usesSsh, bool usesSsl)
{
string connectionString = null;
System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
builder.ConnectionString = Maps.Instance.ConnectionString;
bool hasServer = !string.IsNullOrEmpty(serverName);
bool hasCatalog = !string.IsNullOrEmpty(catalog);
if (!hasCatalog)
{
throw new Durados.DuradosException("Catalog Name is missing");
}
if (integratedSecurity.HasValue && integratedSecurity.Value)
{
if (!hasServer)
{
serverName = builder.DataSource;
}
connectionString = "Data Source={0};Initial Catalog={1};Integrated Security=True;";
return(string.Format(connectionString, serverName, catalog));
}
else
{
connectionString = "Data Source={0};Initial Catalog={1};User ID={2};Password={3};Integrated Security=False;";
if (sqlProduct == Durados.SqlProduct.MySql)
{
if (usesSsh)
{
connectionString = "server=localhost;database={1};User Id={2};password={3};port={4};convert zero datetime=True";
}
else
{
connectionString = "server={0};database={1};User Id={2};password={3};port={4};convert zero datetime=True";
}
}
if (sqlProduct == Durados.SqlProduct.Postgre)
{
if (usesSsl)
{
if (usesSsh)
{
connectionString = "server=localhost;database={1};User Id={2};password={3};port={4};SSL=true;SslMode=Require;";
}
else
{
connectionString = "server={0};database={1};User Id={2};password={3};port={4};SSL=true;SslMode=Require;";
}
}
else
if (usesSsh)
{
connectionString = "server=localhost;database={1};User Id={2};password={3};port={4};Encoding=UNICODE;";
}
else
{
connectionString = "server={0};database={1};User Id={2};password={3};port={4};Encoding=UNICODE;";
}
}
if (sqlProduct == Durados.SqlProduct.Oracle)
{
connectionString = Durados.DataAccess.OracleAccess.GetConnectionStringSchema();
}
bool hasUsername = !string.IsNullOrEmpty(username);
bool hasPassword = !string.IsNullOrEmpty(password);
if (!hasServer)
{
if (Maps.AllowLocalConnection)
{
serverName = builder.DataSource;
}
else
{
throw new Durados.DuradosException("Server Name is missing");
}
}
if (!hasUsername)
{
if (Maps.AllowLocalConnection)
{
username = builder.UserID;
}
else
{
throw new Durados.DuradosException("Username is missing");
}
}
if (!hasPassword)
{
if (Maps.AllowLocalConnection)
{
password = builder.Password;
}
else
{
throw new Durados.DuradosException("Password is missing");
}
}
return(string.Format(connectionString, serverName, catalog, username, password, localPort));
}
}
