private static CABDAVEntity FillEntityObject(ref FbDataReader DataReader)
{
CABDAVEntity entity = new CABDAVEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.NUMERO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMERO"));
entity.CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CLIENTE"));
entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME"));
entity.CNPJ_CNPF = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CNPJ_CNPF"));
entity.DATA_DAV = getData.ConvertDBValueToDateTime(DataReader, DataReader.GetOrdinal("DATA_DAV"));
entity.NUMERO_COO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMERO_COO"));
entity.NUMERO_COO_DAV = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMERO_COO_DAV"));
entity.NUMERO_SEQ_ECF = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMERO_SEQ_ECF"));
entity.TITULO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TITULO"));
entity.VENDEDOR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("VENDEDOR"));
entity.OBSERVACOES = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACOES"));
entity.VALOR_TOT_DES = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR_TOT_DES"));
entity.VALOR_TOT_PRO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR_TOT_PRO"));
entity.VALOR_TOT_DAV = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR_TOT_DAV"));
entity.IMPRESSO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IMPRESSO"));
entity.CHAVE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CHAVE"));
return(entity);
}
public CABDAVEntity Read(string NUMERO)
{
FbDataReader reader = null;
try
{
//Verificando a existência de um transação aberta
if (dbTransaction != null)
{
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Rea_CABDAV", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Rea_CABDAV", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.Parameters.AddWithValue("@NUMERO", NUMERO); //PrimaryKey
reader = dbCommand.ExecuteReader();
CABDAVEntity entity = null;
if (reader.HasRows)
{
while (reader.Read())
{
entity = FillEntityObject(ref reader);
}
}
// Deleta reader
if (reader != null)
{
reader.Close();
reader.Dispose();
}
// Fecha conexão
if (dbTransaction == null)
{
dbCommand.Transaction.Commit();
if (dbCnn.State == ConnectionState.Open)
{
dbCnn.Close();
}
}
return(entity);
}
catch (Exception ex)
{
// Deleta reader
if (reader != null)
{
reader.Close();
reader.Dispose();
}
if (dbTransaction != null)
{
this.RollbackTransaction();
}
else
{
if (dbCommand.Transaction != null)
{
dbCommand.Transaction.Rollback();
}
if (dbCnn.State == ConnectionState.Open)
{
dbCnn.Close();
}
}
throw ex;
}
}
public int Save(CABDAVEntity Entity)
{
int result = 0;
try
{
//Verificando a existência de um transação aberta
if (dbTransaction != null)
{
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Sav_CABDAV", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Sav_CABDAV", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.Parameters.AddWithValue("@NUMERO", Entity.NUMERO); //PrimaryKey
dbCommand.Parameters.AddWithValue("@CLIENTE", Entity.CLIENTE); //Coluna
dbCommand.Parameters.AddWithValue("@NOME", Entity.NOME); //Coluna
dbCommand.Parameters.AddWithValue("@CNPJ_CNPF", Entity.CNPJ_CNPF); //Coluna
if (Entity.DATA_DAV != null)
{
dbCommand.Parameters.AddWithValue("@DATA_DAV", Entity.DATA_DAV); //Coluna
}
else
{
dbCommand.Parameters.AddWithValue("@DATA_DAV", DBNull.Value); //Coluna 3
}
dbCommand.Parameters.AddWithValue("@NUMERO_COO", Entity.NUMERO_COO); //Coluna
dbCommand.Parameters.AddWithValue("@NUMERO_COO_DAV", Entity.NUMERO_COO_DAV); //Coluna
dbCommand.Parameters.AddWithValue("@NUMERO_SEQ_ECF", Entity.NUMERO_SEQ_ECF); //Coluna
dbCommand.Parameters.AddWithValue("@TITULO", Entity.TITULO); //Coluna
dbCommand.Parameters.AddWithValue("@VENDEDOR", Entity.VENDEDOR); //Coluna
dbCommand.Parameters.AddWithValue("@OBSERVACOES", Entity.OBSERVACOES); //Coluna
dbCommand.Parameters.AddWithValue("@VALOR_TOT_DES", Entity.VALOR_TOT_DES); //Coluna
dbCommand.Parameters.AddWithValue("@VALOR_TOT_PRO", Entity.VALOR_TOT_PRO); //Coluna
dbCommand.Parameters.AddWithValue("@VALOR_TOT_DAV", Entity.VALOR_TOT_DAV); //Coluna
dbCommand.Parameters.AddWithValue("@IMPRESSO", Entity.IMPRESSO); //Coluna
dbCommand.Parameters.AddWithValue("@CHAVE", Entity.CHAVE); //Coluna
//Retorno da Procedure
FbParameter returnValue;
returnValue = dbCommand.CreateParameter();
dbCommand.Parameters["@NUMERO"].Direction = ParameterDirection.InputOutput;
//Executando consulta
dbCommand.ExecuteNonQuery();
result = int.Parse(dbCommand.Parameters["@NUMERO"].Value.ToString());
if (dbTransaction == null)
{
dbCommand.Transaction.Commit();
dbCnn.Close();
}
}
catch (Exception ex)
{
if (dbTransaction != null)
{
this.RollbackTransaction();
}
else
{
if (dbCommand.Transaction != null)
{
dbCommand.Transaction.Rollback();
}
if (dbCnn.State == ConnectionState.Open)
{
dbCnn.Close();
}
}
throw ex;
}
return(result);
}
