private static PRODUTOS2NFEEntity FillEntityObject(ref FbDataReader DataReader)
{
PRODUTOS2NFEEntity entity = new PRODUTOS2NFEEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDPRODUTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTO"));
entity.NOMEPRODUTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEPRODUTO"));
entity.CODPRODUTOFORNECEDOR = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODPRODUTOFORNECEDOR"));
entity.CODBARRA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CODBARRA"));
entity.LOCALIZACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("LOCALIZACAO"));
entity.DATACADASTRO = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATACADASTRO"));
entity.IDUNIDADE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDUNIDADE"));
entity.IDMARCA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDMARCA"));
entity.IDMOEDA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDMOEDA"));
entity.VALORCUSTOINICIAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCUSTOINICIAL"));
entity.FRETEPRODUTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("FRETEPRODUTO"));
entity.ENCARGOSPRODUTOS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ENCARGOSPRODUTOS"));
entity.VALORCUSTOFINAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORCUSTOFINAL"));
entity.MARGEMLUCRO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("MARGEMLUCRO"));
entity.VALORVENDA1 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORVENDA1"));
entity.VALORVENDA2 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORVENDA2"));
entity.VALORVENDA3 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORVENDA3"));
entity.COMISSAO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COMISSAO"));
entity.IPI = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("IPI"));
entity.ICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ICMS"));
entity.QUANTIDADEMINIMA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANTIDADEMINIMA"));
entity.ESTOQUEATUAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ESTOQUEATUAL"));
entity.IDGRUPOCATEGORIA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDGRUPOCATEGORIA"));
entity.IDSTATUS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSTATUS"));
entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
entity.PORCFRETE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCFRETE"));
entity.PORCENCARGOS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCENCARGOS"));
entity.PORCMARGEMLUCRO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCMARGEMLUCRO"));
entity.PORCVENDA2 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCVENDA2"));
entity.PORCVENDA3 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCVENDA3"));
entity.PESO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PESO"));
entity.IDCLASSIFICACAO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCLASSIFICACAO"));
entity.IDCST = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDCST"));
entity.NCMSH = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NCMSH"));
entity.EXTIPI = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("EXTIPI"));
entity.ALIQPIS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQPIS"));
entity.ALIQCOFINS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALIQCOFINS"));
entity.CSTPISCONFIS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CSTPISCONFIS"));
return(entity);
}
public PRODUTOS2NFEEntity Read(int IDPRODUTO)
{
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_PRODUTOS", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Rea_PRODUTOS", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.Parameters.AddWithValue("@IDPRODUTO", IDPRODUTO); //PrimaryKey
reader = dbCommand.ExecuteReader();
PRODUTOS2NFEEntity 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(PRODUTOS2NFEEntity 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_PRODUTOS", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Sav_PRODUTOS", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
if (Entity.IDPRODUTO != -1)
{
dbCommand.Parameters.AddWithValue("@IDPRODUTO", Entity.IDPRODUTO); //PrimaryKey
}
else
{
dbCommand.Parameters.AddWithValue("@IDPRODUTO", DBNull.Value); //PrimaryKey
}
dbCommand.Parameters.AddWithValue("@NOMEPRODUTO", Entity.NOMEPRODUTO); //Coluna
dbCommand.Parameters.AddWithValue("@CODPRODUTOFORNECEDOR", Entity.CODPRODUTOFORNECEDOR); //Coluna
dbCommand.Parameters.AddWithValue("@CODBARRA", Entity.CODBARRA); //Coluna
dbCommand.Parameters.AddWithValue("@LOCALIZACAO", Entity.LOCALIZACAO); //Coluna
dbCommand.Parameters.AddWithValue("@DATACADASTRO", Entity.DATACADASTRO); //Coluna
dbCommand.Parameters.AddWithValue("@IDUNIDADE", Entity.IDUNIDADE); //Coluna
dbCommand.Parameters.AddWithValue("@IDMARCA", Entity.IDMARCA); //Coluna
dbCommand.Parameters.AddWithValue("@IDMOEDA", Entity.IDMOEDA); //Coluna
dbCommand.Parameters.AddWithValue("@VALORCUSTOINICIAL", Entity.VALORCUSTOINICIAL); //Coluna
dbCommand.Parameters.AddWithValue("@FRETEPRODUTO", Entity.FRETEPRODUTO); //Coluna
dbCommand.Parameters.AddWithValue("@ENCARGOSPRODUTOS", Entity.ENCARGOSPRODUTOS); //Coluna
dbCommand.Parameters.AddWithValue("@VALORCUSTOFINAL", Entity.VALORCUSTOFINAL); //Coluna
dbCommand.Parameters.AddWithValue("@MARGEMLUCRO", Entity.MARGEMLUCRO); //Coluna
dbCommand.Parameters.AddWithValue("@VALORVENDA1", Entity.VALORVENDA1); //Coluna
dbCommand.Parameters.AddWithValue("@VALORVENDA2", Entity.VALORVENDA2); //Coluna
dbCommand.Parameters.AddWithValue("@VALORVENDA3", Entity.VALORVENDA3); //Coluna
dbCommand.Parameters.AddWithValue("@COMISSAO", Entity.COMISSAO); //Coluna
dbCommand.Parameters.AddWithValue("@IPI", Entity.IPI); //Coluna
dbCommand.Parameters.AddWithValue("@ICMS", Entity.ICMS); //Coluna
dbCommand.Parameters.AddWithValue("@QUANTIDADEMINIMA", Entity.QUANTIDADEMINIMA); //Coluna
dbCommand.Parameters.AddWithValue("@ESTOQUEATUAL", Entity.ESTOQUEATUAL); //Coluna
dbCommand.Parameters.AddWithValue("@IDGRUPOCATEGORIA", Entity.IDGRUPOCATEGORIA); //Coluna
dbCommand.Parameters.AddWithValue("@IDSTATUS", Entity.IDSTATUS); //Coluna
dbCommand.Parameters.AddWithValue("@OBSERVACAO", Entity.OBSERVACAO); //Coluna
dbCommand.Parameters.AddWithValue("@PORCFRETE", Entity.PORCFRETE); //Coluna
dbCommand.Parameters.AddWithValue("@PORCENCARGOS", Entity.PORCENCARGOS); //Coluna
dbCommand.Parameters.AddWithValue("@PORCMARGEMLUCRO", Entity.PORCMARGEMLUCRO); //Coluna
dbCommand.Parameters.AddWithValue("@PORCVENDA2", Entity.PORCVENDA2); //Coluna
dbCommand.Parameters.AddWithValue("@PORCVENDA3", Entity.PORCVENDA3); //Coluna
dbCommand.Parameters.AddWithValue("@PESO", Entity.PESO); //Coluna
dbCommand.Parameters.AddWithValue("@IDCLASSIFICACAO", Entity.IDCLASSIFICACAO); //Coluna
dbCommand.Parameters.AddWithValue("@IDCST", Entity.IDCST); //Coluna
dbCommand.Parameters.AddWithValue("@NCMSH", Entity.NCMSH); //Coluna
dbCommand.Parameters.AddWithValue("@EXTIPI", Entity.EXTIPI); //Coluna
dbCommand.Parameters.AddWithValue("@ALIQPIS", Entity.ALIQPIS); //Coluna
dbCommand.Parameters.AddWithValue("@ALIQCOFINS", Entity.ALIQCOFINS); //Coluna
dbCommand.Parameters.AddWithValue("@CSTPISCONFIS", Entity.CSTPISCONFIS); //Coluna
//Retorno da Procedure
FbParameter returnValue;
returnValue = dbCommand.CreateParameter();
dbCommand.Parameters["@IDPRODUTO"].Direction = ParameterDirection.InputOutput;
//Executando consulta
dbCommand.ExecuteNonQuery();
result = int.Parse(dbCommand.Parameters["@IDPRODUTO"].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);
}
