private static RECEBEREntity FillEntityObject(ref FbDataReader DataReader)
{
RECEBEREntity entity = new RECEBEREntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.DOCUMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DOCUMENTO"));
entity.HISTORICO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("HISTORICO"));
entity.COD_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("COD_CLIENTE"));
entity.NOM_CLIENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOM_CLIENTE"));
entity.EMISSAO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("EMISSAO"));
entity.VENCIMENTO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("VENCIMENTO"));
entity.VALOR_DUP = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR_DUP"));
entity.RECEBIMENTO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("RECEBIMENTO"));
entity.VALOR_REC = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR_REC"));
entity.VALOR_JUR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR_JUR"));
entity.VALOR_DES = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR_DES"));
entity.ESPECIE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("ESPECIE"));
entity.NUM_CONTA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUM_CONTA"));
entity.CTO_CUSTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CTO_CUSTO"));
entity.PORTADOR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PORTADOR"));
entity.TIPO_DOC = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TIPO_DOC"));
entity.COMP = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("COMP"));
entity.BANCO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("BANCO"));
entity.AGENCIA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("AGENCIA"));
entity.CONTA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CONTA"));
entity.CHEQUE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CHEQUE"));
entity.OBSERVACOES = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACOES"));
entity.NOSSO_NUM = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOSSO_NUM"));
return(entity);
}
public RECEBEREntity Read(string DOCUMENTO)
{
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_RECEBER", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Rea_RECEBER", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.Parameters.AddWithValue("@DOCUMENTO", DOCUMENTO); //PrimaryKey
reader = dbCommand.ExecuteReader();
RECEBEREntity 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 string Save(RECEBEREntity Entity)
{
string 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_RECEBER", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Sav_RECEBER", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.Parameters.AddWithValue("@DOCUMENTO", Entity.DOCUMENTO); //PrimaryKey
dbCommand.Parameters.AddWithValue("@HISTORICO", Entity.HISTORICO); //Coluna
dbCommand.Parameters.AddWithValue("@COD_CLIENTE", Entity.COD_CLIENTE); //Coluna
dbCommand.Parameters.AddWithValue("@NOM_CLIENTE", Entity.NOM_CLIENTE); //Coluna
dbCommand.Parameters.AddWithValue("@EMISSAO", Entity.EMISSAO); //Coluna
dbCommand.Parameters.AddWithValue("@VENCIMENTO", Entity.VENCIMENTO); //Coluna
dbCommand.Parameters.AddWithValue("@VALOR_DUP", Entity.VALOR_DUP); //Coluna
dbCommand.Parameters.AddWithValue("@RECEBIMENTO", Entity.RECEBIMENTO); //Coluna
dbCommand.Parameters.AddWithValue("@VALOR_REC", Entity.VALOR_REC); //Coluna
dbCommand.Parameters.AddWithValue("@VALOR_JUR", Entity.VALOR_JUR); //Coluna
dbCommand.Parameters.AddWithValue("@VALOR_DES", Entity.VALOR_DES); //Coluna
dbCommand.Parameters.AddWithValue("@ESPECIE", Entity.ESPECIE); //Coluna
dbCommand.Parameters.AddWithValue("@NUM_CONTA", Entity.NUM_CONTA); //Coluna
dbCommand.Parameters.AddWithValue("@CTO_CUSTO", Entity.CTO_CUSTO); //Coluna
dbCommand.Parameters.AddWithValue("@PORTADOR", Entity.PORTADOR); //Coluna
dbCommand.Parameters.AddWithValue("@TIPO_DOC", Entity.TIPO_DOC); //Coluna
dbCommand.Parameters.AddWithValue("@COMP", Entity.COMP); //Coluna
dbCommand.Parameters.AddWithValue("@BANCO", Entity.BANCO); //Coluna
dbCommand.Parameters.AddWithValue("@AGENCIA", Entity.AGENCIA); //Coluna
dbCommand.Parameters.AddWithValue("@CONTA", Entity.CONTA); //Coluna
dbCommand.Parameters.AddWithValue("@CHEQUE", Entity.CHEQUE); //Coluna
dbCommand.Parameters.AddWithValue("@OBSERVACOES", Entity.OBSERVACOES); //Coluna
dbCommand.Parameters.AddWithValue("@NOSSO_NUM", Entity.NOSSO_NUM); //Coluna
//Retorno da Procedure
FbParameter returnValue;
returnValue = dbCommand.CreateParameter();
dbCommand.Parameters["@DOCUMENTO"].Direction = ParameterDirection.InputOutput;
//Executando consulta
dbCommand.ExecuteNonQuery();
result = dbCommand.Parameters["@DOCUMENTO"].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);
}
