public static OracleConnection GetNewInstance(DataBaseHostEnum databasehost)
{
OracleConnection instance = null;
switch (databasehost)
{
case DataBaseHostEnum.OPPN:
instance = new OracleConnection(GetConnectionStringTopp());
break;
case DataBaseHostEnum.LAP:
instance = new OracleConnection(GetConnectionStringLap());
break;
case DataBaseHostEnum.KPP:
instance = new OracleConnection(GetConnectionStringKpp());
break;
case DataBaseHostEnum.KPR:
instance = new OracleConnection(GetConnectionStringKpr());
break;
}
if (instance.State == ConnectionState.Closed)
{
instance.Open();
}
return(instance);
}
/// <summary>
/// ดึง Oracle Connection Instant ตาม Database Host
/// </summary>
/// <param name="databasehost"></param>
public static OracleConnection GetDatabaseInstanceByHost(DataBaseHostEnum databasehost)
{
// ConnectionFactory cf = new ConnectionFactory();
// return cf.GetNewInstance(databasehost);
OracleConnection instance = null;
switch (databasehost)
{
case DataBaseHostEnum.OPPN:
instance = ConnectionFactory.InstanceTopp;
break;
case DataBaseHostEnum.LAP:
instance = ConnectionFactory.InstanceLap;
break;
case DataBaseHostEnum.KPP:
instance = ConnectionFactory.InstanceKpp;
break;
case DataBaseHostEnum.KPR:
instance = ConnectionFactory.InstanceKpr;
break;
}
return(instance);
}
/// <summary>
/// ดึง Connection String ตาม Database Host
/// </summary>
/// <param name="databasehost"></param>
public static string GetConnectionStringByHost(DataBaseHostEnum databasehost)
{
string connectionString = string.Empty;
switch (databasehost)
{
case DataBaseHostEnum.OPPN:
connectionString = ConnectionFactory.ToppConnectionString;
break;
case DataBaseHostEnum.LAP:
connectionString = ConnectionFactory.LapConnectionString;
break;
case DataBaseHostEnum.KPP:
connectionString = ConnectionFactory.KppConnectionString;
break;
}
return(connectionString);
}
/// <summary>
/// ดึง Oracle Connection Instant ตาม Database Host โดยเป็นการประกาศใหม่
/// </summary>
/// <param name="databasehost"></param>
public static OracleConnection GetNewDatabaseInstanceByHost(DataBaseHostEnum databasehost)
{
ConnectionFactory conFac = new ConnectionFactory();
OracleConnection instance = null;
switch (databasehost)
{
case DataBaseHostEnum.OPPN:
instance = conFac.GetNewInstanceOpp();
break;
case DataBaseHostEnum.LAP:
instance = conFac.GetNewInstanceLap();
break;
case DataBaseHostEnum.KPP:
instance = conFac.GetNewInstanceKpp();
break;
}
return(instance);
}
/// <summary>
/// ดึง Oracle Connection Instant ตาม Database Host
/// </summary>
/// <param name="org"></param>
public static DataBaseHostEnum GetDatabaseHostByName(string org)
{
// ConnectionFactory cf = new ConnectionFactory();
// return cf.GetNewInstance(databasehost);
DataBaseHostEnum host = DataContextConfiguration.DEFAULT_DATABASE;
switch (org)
{
case "OPP":
case "TOPP":
host = DataBaseHostEnum.OPPN;
break;
case "LAP":
host = DataBaseHostEnum.LAP;
break;
case "KPP":
host = DataBaseHostEnum.KPP;
break;
}
return(host);
}
