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