public string GetConnectionString(IConfiguration configuration, DBConnectionMode dbConnectionMode)
{
string SSPConnectionString = configuration.GetSection("ConnectionStrings").GetSection("FOCiSSSP").Value;
string FOCISConnectionString = configuration.GetSection("ConnectionStrings").GetSection("FOCiS").Value;
var connectionString = dbConnectionMode == DBConnectionMode.FOCiS ? FOCISConnectionString : SSPConnectionString;
return(connectionString);
}
private DataTable FillDatatableBasedonOutParameterReturn(DBConnectionMode dbConnectionMode, string commandText, IDbDataParameter[] parameters)
{
DataTable dt = new DataTable();
using (OracleConnection mConnection = new OracleConnection(
(dbConnectionMode == DBConnectionMode.FOCiS ? FOCISConnectionString : SSPConnectionString)
))
{
if (mConnection.State == ConnectionState.Closed)
{
mConnection.Open();
}
using (OracleCommand mCommand = mConnection.CreateCommand())
{
mCommand.CommandText = commandText;
mCommand.CommandType = CommandType.StoredProcedure;
if (parameters != null && parameters.Length > 0)
{
mCommand.Parameters.Clear();
mCommand.BindByName = true;
foreach (OracleParameter param in parameters)
{
mCommand.Parameters.Add(param);
}
}
try
{
using (OracleDataReader reader = mCommand.ExecuteReader())
dt.Load(reader);
}
catch (Exception ex)
{
throw new Exception(commandText, ex);
}
finally
{
mConnection.Close();
}
return(dt);
}
}
}
internal IEnumerable <dynamic> ReadDynamic(DBConnectionMode dbConnectionMode, string commandText, IDbDataParameter[] parameters, CommandType commandType)
{
using (OracleConnection mConnection = new OracleConnection(
(dbConnectionMode == DBConnectionMode.FOCiS ? FOCISConnectionString : SSPConnectionString)
))
{
if (mConnection.State == ConnectionState.Closed)
{
mConnection.Open();
}
using (OracleCommand mCommand = mConnection.CreateCommand())
{
mCommand.CommandText = commandText;
mCommand.CommandType = commandType;
if (parameters != null && parameters.Length > 0)
{
mCommand.Parameters.Clear();
mCommand.BindByName = true;
foreach (OracleParameter param in parameters)
{
mCommand.Parameters.Add(param);
}
}
using (OracleDataReader reader = mCommand.ExecuteReader())
{
var names = Enumerable.Range(0, reader.FieldCount).Select(reader.GetName).ToList();
foreach (IDataRecord record in reader as IEnumerable)
{
var expando = new ExpandoObject() as IDictionary <string, object>;
foreach (var name in names)
{
expando[name.ToLowerInvariant()] = record[name];
}
yield return(expando);
}
}
}
}
}
internal DataTable ReturnCursorDatatable(DBConnectionMode dbConnectionMode, string commandText, IDbDataParameter[] parameters)
{
DataTable dtData = FillDatatableBasedonOutParameterReturn(dbConnectionMode, commandText, parameters);
return(dtData);
}
