private static TIPOTRIBUTACAOEntity FillEntityObject(ref FbDataReader DataReader) { TIPOTRIBUTACAOEntity entity = new TIPOTRIBUTACAOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.CODIGO_TIPOTRIBUTACAO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CODIGO_TIPOTRIBUTACAO")); entity.NOME_TIPOTRIBUTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME_TIPOTRIBUTACAO")); entity.TIPO_TIPOTRIBUTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TIPO_TIPOTRIBUTACAO")); entity.REGIME_TIPOTRIBUTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("REGIME_TIPOTRIBUTACAO")); entity.CST_TIPOTRIBUTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CST_TIPOTRIBUTACAO")); entity.ALIQUOTA_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQUOTA_TIPOTRIBUTACAO")); entity.PERCBASE_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PERCBASE_TIPOTRIBUTACAO")); entity.ALIQUOTAST_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQUOTAST_TIPOTRIBUTACAO")); entity.PERCBASEST_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PERCBASEST_TIPOTRIBUTACAO")); entity.CFOPVENDA_DENTROESTADO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("CFOPVENDA_DENTROESTADO")); entity.CFOPVENDA_FORAESTADO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("CFOPVENDA_FORAESTADO")); entity.CODECF_TIPOTRIBUTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODECF_TIPOTRIBUTACAO")); entity.CONDICAO_TIPOTRIBUTACAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("CONDICAO_TIPOTRIBUTACAO")); entity.ALIQUOTAFE_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQUOTAFE_TIPOTRIBUTACAO")); entity.PERCBASEFE_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PERCBASEFE_TIPOTRIBUTACAO")); entity.ALIQUOTASTFE_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQUOTASTFE_TIPOTRIBUTACAO")); entity.PERCBASESTFE_TIPOTRIBUTACAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PERCBASESTFE_TIPOTRIBUTACAO")); return(entity); }
public TIPOTRIBUTACAOEntity Read(int CODIGO_TIPOTRIBUTACAO) { 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_TIPOTRIBUTACAO", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Rea_TIPOTRIBUTACAO", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.Parameters.AddWithValue("@CODIGO_TIPOTRIBUTACAO", CODIGO_TIPOTRIBUTACAO); //PrimaryKey reader = dbCommand.ExecuteReader(); TIPOTRIBUTACAOEntity 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(TIPOTRIBUTACAOEntity 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_TIPOTRIBUTACAO", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Sav_TIPOTRIBUTACAO", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; if (Entity.CODIGO_TIPOTRIBUTACAO != -1) { dbCommand.Parameters.AddWithValue("@CODIGO_TIPOTRIBUTACAO", Entity.CODIGO_TIPOTRIBUTACAO); //PrimaryKey } else { dbCommand.Parameters.AddWithValue("@CODIGO_TIPOTRIBUTACAO", DBNull.Value); //PrimaryKey } dbCommand.Parameters.AddWithValue("@TIPO_TIPOTRIBUTACAO", Entity.TIPO_TIPOTRIBUTACAO); //Coluna if (Entity.NOME_TIPOTRIBUTACAO != null) { dbCommand.Parameters.AddWithValue("@NOME_TIPOTRIBUTACAO", Entity.NOME_TIPOTRIBUTACAO); //Coluna } else { dbCommand.Parameters.AddWithValue("@NOME_TIPOTRIBUTACAO", DBNull.Value); //Coluna 3 } dbCommand.Parameters.AddWithValue("@REGIME_TIPOTRIBUTACAO", Entity.REGIME_TIPOTRIBUTACAO); //Coluna dbCommand.Parameters.AddWithValue("@CST_TIPOTRIBUTACAO", Entity.CST_TIPOTRIBUTACAO); //Coluna dbCommand.Parameters.AddWithValue("@ALIQUOTA_TIPOTRIBUTACAO", Entity.ALIQUOTA_TIPOTRIBUTACAO); //Coluna dbCommand.Parameters.AddWithValue("@PERCBASE_TIPOTRIBUTACAO", Entity.PERCBASE_TIPOTRIBUTACAO); //Coluna dbCommand.Parameters.AddWithValue("@ALIQUOTAST_TIPOTRIBUTACAO", Entity.ALIQUOTAST_TIPOTRIBUTACAO); //Coluna dbCommand.Parameters.AddWithValue("@PERCBASEST_TIPOTRIBUTACAO", Entity.PERCBASEST_TIPOTRIBUTACAO); //Coluna dbCommand.Parameters.AddWithValue("@CFOPVENDA_DENTROESTADO", Entity.CFOPVENDA_DENTROESTADO); //Coluna dbCommand.Parameters.AddWithValue("@CFOPVENDA_FORAESTADO", Entity.CFOPVENDA_FORAESTADO); //Coluna dbCommand.Parameters.AddWithValue("@CODECF_TIPOTRIBUTACAO", Entity.CODECF_TIPOTRIBUTACAO); //Coluna dbCommand.Parameters.AddWithValue("@CONDICAO_TIPOTRIBUTACAO", Entity.CONDICAO_TIPOTRIBUTACAO); //Coluna dbCommand.Parameters.AddWithValue("@ALIQUOTAFE_TIPOTRIBUTACAO", Entity.ALIQUOTAFE_TIPOTRIBUTACAO); //Coluna dbCommand.Parameters.AddWithValue("@PERCBASEFE_TIPOTRIBUTACAO", Entity.PERCBASEFE_TIPOTRIBUTACAO); //Coluna dbCommand.Parameters.AddWithValue("@ALIQUOTASTFE_TIPOTRIBUTACAO", Entity.ALIQUOTASTFE_TIPOTRIBUTACAO); //Coluna dbCommand.Parameters.AddWithValue("@PERCBASESTFE_TIPOTRIBUTACAO", Entity.PERCBASESTFE_TIPOTRIBUTACAO); //Coluna //Retorno da Procedure FbParameter returnValue; returnValue = dbCommand.CreateParameter(); dbCommand.Parameters["@CODIGO_TIPOTRIBUTACAO"].Direction = ParameterDirection.InputOutput; //Executando consulta dbCommand.ExecuteNonQuery(); result = int.Parse(dbCommand.Parameters["@CODIGO_TIPOTRIBUTACAO"].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); }