public DbParameterCollection ExecuteByStoredProcedureNonQuery(string nameStore,
IEnumerable <DbParameter> parameters = null,
enuTypeDataBase typeDataBase = enuTypeDataBase.OracleCanalP,
enuTypeExecute typeExecute = enuTypeExecute.ExecuteNonQuery
)
{
DbConnection DataConnection = ConnectionGet(typeDataBase);
DbCommand cmdCommand = DataConnection.CreateCommand();
cmdCommand.CommandText = nameStore;
cmdCommand.CommandType = CommandType.StoredProcedure;
if (parameters != null)
{
foreach (DbParameter parameter in parameters)
{
cmdCommand.Parameters.Add(parameter);
}
}
DataConnection.Open();
DbParameterCollection myReader = null;
if (typeExecute == enuTypeExecute.ExecuteNonQuery)
{
cmdCommand.ExecuteNonQuery();
myReader = cmdCommand.Parameters;
cmdCommand.Connection.Close();
}
return(myReader);
}
public DbConnection ConnectionGet(enuTypeDataBase typeDataBase = enuTypeDataBase.SqlServer)
{
DbConnection DataConnection = null;
switch (typeDataBase)
{
//case enuTypeDataBase.OracleCanalP:
// DataConnection = DataConnectionOracle;
// break;
//case enuTypeDataBase.OracleVTime:
// DataConnection = DataConnectionOracleTIME;
// break;
case enuTypeDataBase.SqlServer:
DataConnection = DataConnectionSQLServer;
break;
default:
break;
}
return(DataConnection);
}
public DbConnection ConnectionGet(enuTypeDataBase typeDataBase = enuTypeDataBase.OracleCanalP)
{
DbConnection DataConnection = null;
switch (typeDataBase)
{
case enuTypeDataBase.OracleCanalP:
DataConnection = DataConnectionOracle;
break;
case enuTypeDataBase.OracleVTime:
DataConnection = DataConnectionOracleTIME;
break;
case enuTypeDataBase.OracleConciliacion:
DataConnection = DataConnectionOracleConciliacion;
break;
default:
break;
}
return(DataConnection);
}
public DbDataReader ExecuteByStoredProcedure(string nameStore,
IEnumerable <DbParameter> parameters = null,
enuTypeDataBase typeDataBase = enuTypeDataBase.OracleCanalP,
enuTypeExecute typeExecute = enuTypeExecute.ExecuteReader
)
{
DbConnection DataConnection = ConnectionGet(typeDataBase);
DbCommand cmdCommand = DataConnection.CreateCommand();
cmdCommand.CommandText = nameStore;
cmdCommand.CommandType = CommandType.StoredProcedure;
if (parameters != null)
{
foreach (DbParameter parameter in parameters)
{
cmdCommand.Parameters.Add(parameter);
}
}
DataConnection.Open();
DbDataReader myReader;
if (typeDataBase == enuTypeDataBase.SqlServer && typeExecute == enuTypeExecute.ExecuteReader)
{
myReader = cmdCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
else
{
cmdCommand.ExecuteNonQuery();
ParamsCollectionResult = cmdCommand.Parameters;
cmdCommand.Connection.Close();
myReader = null;
}
return(myReader);
}
public DbDataReader ExecuteByStoredProcedureCupon(string nameStore,
IEnumerable <DbParameter> parameters = null,
enuTypeDataBase typeDataBase = enuTypeDataBase.OracleCanalP,
enuTypeExecute typeExecute = enuTypeExecute.ExecuteReader
)
{
DbConnection DataConnection = ConnectionGet(typeDataBase);
DbCommand cmdCommand = DataConnection.CreateCommand();
cmdCommand.CommandText = nameStore;
cmdCommand.CommandType = CommandType.StoredProcedure;
if (parameters != null)
{
foreach (DbParameter parameter in parameters)
{
cmdCommand.Parameters.Add(parameter);
}
}
DataConnection.Open();
DbDataReader myReader;
if (((cmdCommand.Parameters.Contains("CUR_TOUT") || cmdCommand.Parameters.Contains("CUR_COUPONS") || cmdCommand.Parameters.Contains("CUR_CUPONERA") || cmdCommand.Parameters.Contains("CUR_TREPORTOUT") || cmdCommand.Parameters.Contains("RC1") || IsOracleReader(cmdCommand))) && typeExecute == enuTypeExecute.ExecuteReader)
{
myReader = cmdCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
else
{
cmdCommand.ExecuteNonQuery();
ParamsCollectionResult = cmdCommand.Parameters;
//z = ParamsCollectionResult;
cmdCommand.Connection.Close();
myReader = null;
}
return(myReader);
}