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); }