private bool Connect(ProductDbType dbType, DatabaseProperties databaseProperties)
{
IDatabaseFunctions databaseFunctions;
if (dbType == ProductDbType.Oracle)
{
databaseFunctions = new OracleOperationFunctions(databaseProperties);
}
else
{
databaseFunctions = new SqlServerOperationFunctions(databaseProperties);
}
try
{
_isConnectionDefined = databaseFunctions.TestConnection();
DatabaseFunctions = databaseFunctions;
return(_isConnectionDefined);
}
catch (Exception ex)
{
Logger.Error(ex, ex.Message);
throw ex;
}
}
public static string GetConnectionString(DatabaseProperties databaseProperties, ProductDbType dbType)
{
if (dbType == ProductDbType.Oracle)
{
return(string.Format(_oracleConnectionString, databaseProperties.DatabaseUser, databaseProperties.DatabasePassword, databaseProperties.ServerOrTns));
}
else if (dbType == ProductDbType.SqlServer)
{
if (databaseProperties.IsTrustedConnection)
{
return(string.Format(_sqlServerTrustedConnectionString, databaseProperties.ServerOrTns, databaseProperties.DatabaseName));
}
else
{
return(string.Format(_sqlServerConnectionString, databaseProperties.ServerOrTns, databaseProperties.DatabaseName, databaseProperties.DatabaseUser, databaseProperties.DatabasePassword));
}
}
return(null);
}
public SqlServerOperationFunctions(DatabaseProperties databaseProperties)
: base(databaseProperties)
{
SetConnectionString(ProductConnectionString.GetConnectionString(databaseProperties, ProductDbType.SqlServer));
}
public OracleOperationFunctions(DatabaseProperties databaseProperties)
: base(databaseProperties)
{
base.SetConnectionString(ProductConnectionString.GetConnectionString(databaseProperties, ProductDbType.Oracle));
Environment.SetEnvironmentVariable("nls_lang", "AMERICAN_AMERICA.WE8MSWIN1252");
}
protected BaseDatabaseOperationFunctions(DatabaseProperties databaseProperties)
{
DatabaseProperties = databaseProperties;
}
public bool SetConnection(ProductDbType dbType, DatabaseProperties databaseProperties) => Connect(dbType, databaseProperties);
private bool Connect(ProductDbType dbType)
{
DatabaseProperties databaseProperties = RequestDbInputsProperties(dbType);
return(Connect(dbType, databaseProperties));
}
