public bool CheckUserCredentialsInTNS()
{
if (!string.IsNullOrEmpty(TNSCalculated) && TNSCalculated.ToLower().Contains("data source=") && TNSCalculated.ToLower().Contains("password="******"user id="))
{
return(true);
}
else
{
return(false);
}
}
public string CreateConnectionString()
{
//Default ConnectionString format
Database.ConnectionString = "Data Source=" + Database.TNS + ";User Id={USER};Password={PASS};";
//Change ConnectionString according to DBType
if (Database.DBType == eDBTypes.MSAccess)
{
string strProvider;
if (TNSCalculated.Contains(".accdb"))
{
strProvider = "Provider=Microsoft.ACE.OLEDB.12.0;";
}
else
{
strProvider = "Provider=Microsoft.Jet.OLEDB.4.0;";
}
Database.ConnectionString = strProvider + Database.ConnectionString;
}
else if (Database.DBType == eDBTypes.DB2)
{
Database.ConnectionString = "Server=" + Database.TNS + ";Database=" + Database.Name + ";UID={USER};PWD={PASS}";
}
else if (Database.DBType == eDBTypes.PostgreSQL)
{
string[] host = TNSCalculated.Split(':');
if (host.Length == 2)
{
Database.ConnectionString = "Server=" + host[0] + ";Port=" + host[1] + ";User Id={USER}; Password={PASS};Database=" + Database.Name + ";";
}
else
{
// connStr = "Server=" + TNS + ";Database=" + Name + ";UID=" + User + "PWD=" + deCryptValue;
Database.ConnectionString = "Server=" + Database.TNS + ";User Id={USER}; Password={PASS};Database=" + Database.Name + ";";
}
}
else if (Database.DBType == eDBTypes.MySQL)
{
Database.ConnectionString = "Server=" + Database.TNS + ";Database=" + Database.Name + ";UID={USER};PWD={PASS}";
}
return(ConnectionStringCalculated);
}
public string GetConnectionString()
{
string connStr = null;
bool res;
res = false;
if (String.IsNullOrEmpty(ConnectionStringCalculated) == false)
{
connStr = ConnectionStringCalculated.Replace("{USER}", UserCalculated);
String deCryptValue = EncryptionHandler.DecryptString(PassCalculated, ref res, false);
if (res == true)
{
connStr = connStr.Replace("{PASS}", deCryptValue);
}
else
{
connStr = connStr.Replace("{PASS}", PassCalculated);
}
}
else
{
String strConnString = TNSCalculated;
String strProvider;
connStr = "Data Source=" + TNSCalculated + ";User Id=" + UserCalculated + ";";
String deCryptValue = EncryptionHandler.DecryptString(PassCalculated, ref res, false);
if (res == true)
{
connStr = connStr + "Password="******";";
}
else
{
connStr = connStr + "Password="******";";
}
if (DBType == eDBTypes.MSAccess)
{
if (strConnString.Contains(".accdb"))
{
strProvider = "Provider=Microsoft.ACE.OLEDB.12.0;";
}
else
{
strProvider = "Provider=Microsoft.Jet.OLEDB.4.0;";
}
connStr = strProvider + connStr;
}
else if (DBType == eDBTypes.DB2)
{
connStr = "Server=" + TNSCalculated + ";Database=" + Name + ";UID=" + UserCalculated + "PWD=" + deCryptValue;
}
else if (DBType == eDBTypes.PostgreSQL)
{
string[] host = TNSCalculated.Split(':');
if (host.Length == 2)
{
connStr = String.Format("Server ={0};Port={1};User Id={2}; Password={3};Database={4};", host[0], host[1], UserCalculated, deCryptValue, Name);
}
else
{
// connStr = "Server=" + TNS + ";Database=" + Name + ";UID=" + User + "PWD=" + deCryptValue;
connStr = String.Format("Server ={0};User Id={1}; Password={2};Database={3};", TNSCalculated, UserCalculated, deCryptValue, Name);
}
}
else if (DBType == eDBTypes.MySQL)
{
connStr = "Server=" + TNSCalculated + ";Database=" + Name + ";UID=" + UserCalculated + ";PWD=" + deCryptValue;
}
}
return(connStr);
}