private static CONFIGBOLETAEntity FillEntityObject(ref FbDataReader DataReader)
{
CONFIGBOLETAEntity entity = new CONFIGBOLETAEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDCONFIGBOLETA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCONFIGBOLETA"));
entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME"));
entity.IDBANCO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDBANCO"));
entity.CARTEIRA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CARTEIRA"));
entity.CONVENIO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CONVENIO"));
entity.TIPOMODALIDADE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TIPOMODALIDADE"));
entity.CODCEDENTE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("CODCEDENTE"));
entity.NOMECEDENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECEDENTE"));
entity.CPFCNPJCEDENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CPFCNPJCEDENTE"));
entity.AGENCIA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("AGENCIA"));
entity.DIGAGENCIA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DIGAGENCIA"));
entity.CONTA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CONTA"));
entity.DIGCONTA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DIGCONTA"));
entity.ESPECIEDOC = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("ESPECIEDOC"));
entity.ACEITE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("ACEITE"));
entity.VALORTAXA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORTAXA"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.INSTRUCAO1 = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("INSTRUCAO1"));
entity.INSTRUCAO2 = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("INSTRUCAO2"));
entity.INSTRUCAO3 = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("INSTRUCAO3"));
entity.INSTRUCAO4 = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("INSTRUCAO4"));
entity.INSTRUCAO5 = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("INSTRUCAO5"));
entity.INSTRUCAO6 = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("INSTRUCAO6"));
entity.INSTRUCAO7 = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("INSTRUCAO7"));
entity.INSTRUCAO8 = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("INSTRUCAO8"));
entity.INSTRUCAO9 = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("INSTRUCAO9"));
entity.DIGCEDENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DIGCEDENTE"));
return(entity);
}
public CONFIGBOLETAEntity Read(int IDCONFIGBOLETA)
{
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_CONFIGBOLETA", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Rea_CONFIGBOLETA", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.Parameters.AddWithValue("@IDCONFIGBOLETA", IDCONFIGBOLETA); //PrimaryKey
reader = dbCommand.ExecuteReader();
CONFIGBOLETAEntity 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(CONFIGBOLETAEntity 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_CONFIGBOLETA", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Sav_CONFIGBOLETA", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
if (Entity.IDCONFIGBOLETA != -1)
{
dbCommand.Parameters.AddWithValue("@IDCONFIGBOLETA", Entity.IDCONFIGBOLETA); //PrimaryKey
}
else
{
dbCommand.Parameters.AddWithValue("@IDCONFIGBOLETA", DBNull.Value); //PrimaryKey
}
dbCommand.Parameters.AddWithValue("@NOME", Entity.NOME); //Coluna
dbCommand.Parameters.AddWithValue("@IDBANCO", Entity.IDBANCO); //Coluna
dbCommand.Parameters.AddWithValue("@CARTEIRA", Entity.CARTEIRA); //Coluna
dbCommand.Parameters.AddWithValue("@CONVENIO", Entity.CONVENIO); //Coluna
dbCommand.Parameters.AddWithValue("@TIPOMODALIDADE", Entity.TIPOMODALIDADE); //Coluna
dbCommand.Parameters.AddWithValue("@CODCEDENTE", Entity.CODCEDENTE); //Coluna
dbCommand.Parameters.AddWithValue("@NOMECEDENTE", Entity.NOMECEDENTE); //Coluna
dbCommand.Parameters.AddWithValue("@CPFCNPJCEDENTE", Entity.CPFCNPJCEDENTE); //Coluna
dbCommand.Parameters.AddWithValue("@AGENCIA", Entity.AGENCIA); //Coluna
dbCommand.Parameters.AddWithValue("@DIGAGENCIA", Entity.DIGAGENCIA); //Coluna
dbCommand.Parameters.AddWithValue("@CONTA", Entity.CONTA); //Coluna
dbCommand.Parameters.AddWithValue("@DIGCONTA", Entity.DIGCONTA); //Coluna
dbCommand.Parameters.AddWithValue("@ESPECIEDOC", Entity.ESPECIEDOC); //Coluna
dbCommand.Parameters.AddWithValue("@ACEITE", Entity.ACEITE); //Coluna
dbCommand.Parameters.AddWithValue("@VALORTAXA", Entity.VALORTAXA); //Coluna
dbCommand.Parameters.AddWithValue("@OBSERVACAO", Entity.OBSERVACAO); //Coluna
dbCommand.Parameters.AddWithValue("@INSTRUCAO1", Entity.INSTRUCAO1); //Coluna
dbCommand.Parameters.AddWithValue("@INSTRUCAO2", Entity.INSTRUCAO2); //Coluna
dbCommand.Parameters.AddWithValue("@INSTRUCAO3", Entity.INSTRUCAO3); //Coluna
dbCommand.Parameters.AddWithValue("@INSTRUCAO4", Entity.INSTRUCAO4); //Coluna
dbCommand.Parameters.AddWithValue("@INSTRUCAO5", Entity.INSTRUCAO5); //Coluna
dbCommand.Parameters.AddWithValue("@INSTRUCAO6", Entity.INSTRUCAO6); //Coluna
dbCommand.Parameters.AddWithValue("@INSTRUCAO7", Entity.INSTRUCAO7); //Coluna
dbCommand.Parameters.AddWithValue("@INSTRUCAO8", Entity.INSTRUCAO8); //Coluna
dbCommand.Parameters.AddWithValue("@INSTRUCAO9", Entity.INSTRUCAO9); //Coluna
dbCommand.Parameters.AddWithValue("@DIGCEDENTE", Entity.DIGCEDENTE); //Coluna
//Retorno da Procedure
FbParameter returnValue;
returnValue = dbCommand.CreateParameter();
dbCommand.Parameters["@IDCONFIGBOLETA"].Direction = ParameterDirection.InputOutput;
//Executando consulta
dbCommand.ExecuteNonQuery();
result = int.Parse(dbCommand.Parameters["@IDCONFIGBOLETA"].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);
}
