} // get
public static VConnection Get()
{
if (s_cc == null)
{
////String attributes = Ini.GetProperty(Ini.P_CONNECTION);
// if ((attributes == null) || (attributes.Length == 0))
//{
// VConnection cc = new VConnection();
// cc.SetAttributes(); // initial environment
// // CConnectionDialog ccd = new CConnectionDialog(cc);
// // s_cc = ccd.GetConnection();
// // set also in ALogin and Ctrl
// // Ini.SetProperty(Ini.P_CONNECTION, s_cc.ToStringLong());
// // Ini.SaveProperties(Ini.IsClient());
//}
//else // existing environment properties
//{
s_cc = new VConnection();
//s_cc.SetAttributes(attributes);
//}
//log.Fine(s_cc.ToString());
}
return(s_cc);
} // get
public static string CreateConnectionString()
{
string connection_string = "";
//if (db_to_match.Equals(VEnvironment.DBTYPE_PG))
//{
// connection_string = "Server=" + host_name + ";Port=" + port_number + ";User Id=" + user_id + ";Password="******";Database=" + database + ";";
//}
//else if (db_to_match.Equals(VEnvironment.DBTYPE_ORACLE))
//{
// connection_string = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + host_name + ")(PORT=" + port_number + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + database + ")));User Id=" + user_id + ";Password="******";";
//}
//else if (db_to_match.Equals(VEnvironment.DBTYPE_MS))
//{
// connection_string = "Server=" + host_name + "," + port_number + ";uid=" + user_id + ";Password="******";Database=" + database;
//}
//else if (db_to_match.Equals(VEnvironment.DBTYPE_DB2))
//{
// connection_string = "Server=" + host_name + ";Port=" + port_number + ";User Id=" + user_id + ";Password="******";Database=" + database;
//}
if (connectionString == null)
{
//connectionString = System.Configuration.ConfigurationSettings.AppSettings["oracleConnectionString"].ToString();
connectionString = System.Configuration.ConfigurationManager.AppSettings["oracleConnectionString"].ToString();
VConnection vconn = VConnection.Get();
vconn.SetAttributes(connectionString);
}
return(connectionString); //return the connection string to the caller
}
} // setAttributes
/// <summary>
///
/// </summary>
/// <param name="vc"></param>
public VConnection(VConnection vc)
{
this.Db_Type = vc.Db_Type;
Db_host = vc.Db_host;
Db_port = vc.Db_port;
Db_name = vc.Db_name;
Db_uid = vc.Db_uid;
Db_pwd = vc.Db_pwd;
}
public static void SetOracleConnectionString(string host_name, string port_number, string user_id, string password, string serviceName)
{
connectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + host_name + ")(PORT=" + port_number + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + serviceName + ")));User Id=" + user_id + ";Password="******";";
VConnection vconn = VConnection.Get();
vconn.Db_Type = DatabaseType.DB_ORACLE;
vconn.SetAttributes(connectionString);
DB.SetDBTarget(VConnection.Get());
}
public static void SetOracleConnectionString(string connString)
{
VConnection vconn = VConnection.Get();
vconn.Db_Type = DatabaseType.DB_ORACLE;
vconn.SetAttributes(connString);
DB.SetDBTarget(VConnection.Get());
connectionString = connString;
}
public static void SetPostgresConnectionString(string connString)
{
VConnection vconn = VConnection.Get();
vconn.Db_Type = DatabaseType.DB_POSTGRESQL;
vconn.SetAttributes(connString);
vconn.GetDatabase().SetConnectionString(connString);
DB.SetDBTarget(VConnection.Get());
connectionString = connString;
}
} // equals
public bool EqualsDatabase(Object o)
{
if (o is VConnection)
{
VConnection cc = (VConnection)o;
if ((cc.Apps_port == m_apps_port) &&
cc.Db_host.Equals(m_db_host) &&
(cc.Db_port == m_db_port) &&
cc.Db_name.Equals(m_db_name) &&
cc.Db_Type.Equals(m_type) &&
cc.Db_uid.Equals(m_db_uid) &&
cc.Db_pwd.Equals(m_db_pwd))
{
return(true);
}
}
return(false);
}
/// <summary>
///
/// </summary>
/// <param name="type"></param>
/// <param name="db_host"></param>
/// <param name="db_port"></param>
/// <param name="db_name"></param>
/// <param name="db_uid"></param>
/// <param name="db_pwd"></param>
/// <returns></returns>
public static VConnection Get(String type, String db_host, String db_port, String db_name, String db_uid, String db_pwd)
{
VConnection cc = new VConnection();
cc.Apps_host = db_host;
cc.Db_Type = type;
cc.Db_host = db_host;
cc.Db_port = db_port;
cc.Db_name = db_name;
//
if (db_uid != null)
{
cc.Db_uid = db_uid;
}
if (db_pwd != null)
{
cc.Db_pwd = db_pwd;
}
return(cc);
} // get
public static string connectionString = null;// System.Configuration.ConfigurationSettings.AppSettings["oracleConnectionString"];
public static string CreateConnectionString(VConnection vconn)
{
return(CreateConnectionString(vconn.Db_host, vconn.Db_port.ToString(), vconn.Db_uid, vconn.Db_pwd, vconn.Db_name, vconn.Db_Type));
}
public static string CreateConnectionString()
{
if (DataBase.DB.UseMigratedConnection)
{
if (DataBase.DB.MigrationConnection != null && DataBase.DB.MigrationConnection != "")
{
VConnection vconn = VConnection.Get();
vconn.SetAttributes(DataBase.DB.MigrationConnection);
return(DataBase.DB.MigrationConnection);
}
return("");// Ini.CreateConnectionString(WindowMigration.MDialog.GetMConnection());
}
else
{
if (connectionString == null)
{
//connectionString = System.Configuration.ConfigurationSettings.AppSettings["oracleConnectionString"];
VConnection vconn = VConnection.Get();
connectionString = System.Configuration.ConfigurationManager.AppSettings["oracleConnectionString"];
if (!string.IsNullOrEmpty(connectionString))
{
vconn.Db_Type = DatabaseType.DB_ORACLE;
connectionString = TrimUnicode(connectionString);
vconn.SetAttributes(connectionString);
vconn.GetDatabase().SetConnectionString(connectionString);
return(connectionString);
}
connectionString = System.Configuration.ConfigurationManager.AppSettings["PostgreSQLConnectionString"];
if (!string.IsNullOrEmpty(connectionString))
{
vconn.Db_Type = DatabaseType.DB_POSTGRESQL;
vconn.SetAttributes(connectionString);
vconn.GetDatabase().SetConnectionString(connectionString);
return(connectionString);
}
connectionString = System.Configuration.ConfigurationManager.AppSettings["PostgreSQLPlusConnectionString"];
if (!string.IsNullOrEmpty(connectionString))
{
vconn.Db_Type = DatabaseType.DB_POSTGRESQL;
vconn.SetAttributes(connectionString);
vconn.GetDatabase().SetConnectionString(connectionString);
return(connectionString);
}
connectionString = System.Configuration.ConfigurationManager.AppSettings["MSSQLConnectionString"];
if (!string.IsNullOrEmpty(connectionString))
{
vconn.Db_Type = DatabaseType.DB_MSSQL;
vconn.SetAttributes(connectionString);
vconn.GetDatabase().SetConnectionString(connectionString);
return(connectionString);
}
// connectionString = vconn.CreateDBConnectionString();
//return Ini.CreateConnectionString(vconn);
}
return(connectionString);
//VConnection vconn = VConnection.Get();
// return Ini.CreateConnectionString(vconn);
}
//s_conn.Add(1, constr);
//}
//return constr; //return the connection string to the user
}
public static void SetConnectionString()
{
CreateConnectionString();
DB.SetDBTarget(VConnection.Get());
}
