public DataSet ExecuteDbDataSet(DbCommand scdCommand)
{
DbConnection Conn = Conexao.abrirConexao();
scdCommand.Connection = Conn;
DbDataAdapter daAdapter = Conexao.obterDataAdapter(scdCommand.Connection);
try
{
DataSet dsDados = new DataSet();
daAdapter.SelectCommand = scdCommand;
daAdapter.Fill(dsDados);
daAdapter = null;
return(dsDados);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
finally
{
daAdapter.Dispose();
Conexao.fecharConexao(scdCommand.Connection);
scdCommand.Dispose();
}
}
protected virtual void ConfigureParameter(DbParameter param,
string name,
DbType dbType,
int size,
ParameterDirection direction,
bool nullable,
byte precision,
byte scale,
string sourceColumn,
DataRowVersion sourceVersion,
object value)
{
try
{
param.DbType = dbType;
param.Size = size;
param.Value = value ?? DBNull.Value;
param.Direction = direction;
param.IsNullable = nullable;
param.SourceColumn = sourceColumn;
param.SourceVersion = sourceVersion;
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
}
public DataTable ExecuteDbDataTable(DbCommand scdCommand, DbConnection Conn)
{
scdCommand.Connection = Conn;
DbDataAdapter daAdapter = Conexao.obterDataAdapter(scdCommand.Connection);
try
{
DataTable dtTable = new DataTable();
daAdapter.SelectCommand = scdCommand;
daAdapter.Fill(dtTable);
return(dtTable);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
finally
{
daAdapter.Dispose();
scdCommand.Dispose();
}
}
public object ExecuteScalar(DbCommand scdCommand, DbConnection Conn)
{
try
{
scdCommand.Connection = Conn;
return(scdCommand.ExecuteScalar());
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
}
public object GetParameterValue(DbCommand command,
string name)
{
try
{
return(command.Parameters[BuildParameterName(name)].Value);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
}
public DbParameter createParameter(DbCommand command, string name, DbType type, object value, int size)
{
try
{
DbParameter p = createParameter(command, name, type, value);
p.Size = size;
return(p);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
}
public void AddOutParameter(DbCommand command,
string name,
DbType dbType,
int size)
{
try
{
AddParameter(command, name, dbType, size, ParameterDirection.Output, true, 0, 0, String.Empty, DataRowVersion.Default, DBNull.Value);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
}
private DbProviderFactory GetFactoty()
{
try
{
string strProviderName = ConfigurationManager.ConnectionStrings[ConnectionStringName].ProviderName;
DbProviderFactory factory = DbProviderFactories.GetFactory(strProviderName);
return(factory);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
}
public DbParameter createOutputParameter(DbCommand command, string name, DbType type)
{
try
{
DbParameter p = command.CreateParameter();
p.ParameterName = name;
p.DbType = type;
p.Direction = ParameterDirection.ReturnValue;
return(p);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
}
protected DbParameter CreateParameter(string name)
{
try
{
DbProviderFactory factory = this.GetFactoty();
DbParameter param = factory.CreateParameter();
param.ParameterName = BuildParameterName(name);
return(param);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
}
public void AddParameter(DbCommand command,
string name,
DbType dbType,
ParameterDirection direction,
string sourceColumn,
DataRowVersion sourceVersion,
object value)
{
try
{
AddParameter(command, name, dbType, 0, direction, false, 0, 0, sourceColumn, sourceVersion, value);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
}
public object ExecuteScalar(DbCommand scdCommand)
{
try
{
DbConnection Conn = Conexao.abrirConexao();
scdCommand.Connection = Conn;
return(scdCommand.ExecuteScalar());
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
finally
{
Conexao.fecharConexao(scdCommand.Connection);
scdCommand.Dispose();
}
}
public DbDataReader ExecuteReader(DbCommand scdCommand)
{
try
{
OracleCommand cm = (OracleCommand)scdCommand;
OracleConnection cn = (OracleConnection)Conexao.abrirConexao();
cm.Connection = cn;
cm.Parameters.Add(CursorRetorno, OracleType.Cursor).Direction = ParameterDirection.Output;
return(cm.ExecuteReader(CommandBehavior.CloseConnection));
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
finally
{
//Conexao.fecharConexao(scdCommand.Connection);
//scdCommand.Dispose();
}
}
public int InserirOracle(DbCommand scdCommand)
{
try
{
DbConnection Conn = Conexao.abrirConexao();
scdCommand.Connection = Conn;
this.AddOutParameter(scdCommand, "IDENTITY", DbType.Int32, 4);
scdCommand.ExecuteNonQuery();
return((int)scdCommand.Parameters["IDENTITY"].Value);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
finally
{
Conexao.fecharConexao(scdCommand.Connection);
scdCommand.Dispose();
}
}
public int ExecuteNonQuery(DbCommand scdCommand, DbTransaction Trans)
{
if (Trans != null)
{
try
{
scdCommand.Connection = Trans.Connection;
scdCommand.Transaction = Trans;
return(scdCommand.ExecuteNonQuery());
}
catch (DbException ex)
{
// TrataException.SetError(ex); //AAS - 2008-09-23
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
}
else
{
return(this.ExecuteNonQuery(scdCommand));
}
}
protected DbParameter CreateParameter(string name,
DbType dbType,
int size,
ParameterDirection direction,
bool nullable,
byte precision,
byte scale,
string sourceColumn,
DataRowVersion sourceVersion,
object value)
{
try
{
DbParameter param = CreateParameter(name);
ConfigureParameter(param, name, dbType, size, direction, nullable, precision, scale, sourceColumn, sourceVersion, value);
return(param);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
}
public virtual void AddParameter(DbCommand command,
string name,
DbType dbType,
int size,
ParameterDirection direction,
bool nullable,
byte precision,
byte scale,
string sourceColumn,
DataRowVersion sourceVersion,
object value)
{
try
{
DbParameter parameter = CreateParameter(name, dbType, size, direction, nullable, precision, scale, sourceColumn, sourceVersion, value);
command.Parameters.Add(parameter);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception("Ocorreu um erro ao tentar acessar o Banco de Dados. Err.ID " + numeroErro);
}
}
public DataTable ExecuteOracleDataTable(DbCommand scdCommand)
{
try
{
OracleCommand cm = (OracleCommand)scdCommand;
OracleConnection cn = (OracleConnection)Conexao.abrirConexao();
cm.Connection = cn;
cm.Parameters.Add(CursorRetorno, OracleType.Cursor).Direction = ParameterDirection.Output;
OracleDataReader dr = cm.ExecuteReader(CommandBehavior.CloseConnection);
DataTable dt = new DataTable();
dt.Load(dr);
return(dt);
}
catch (Exception ex)
{
int numeroErro = LogEventError.Write(ex.Message);
throw new Exception(string.Format("Ocorreu um erro número:{0}. Descrição: {1}", numeroErro, ex.Message));
}
finally
{
Conexao.fecharConexao(scdCommand.Connection);
scdCommand.Dispose();
}
}