private static ITEVENDAS_ECFEntity FillEntityObject(ref FbDataReader DataReader)
{
ITEVENDAS_ECFEntity entity = new ITEVENDAS_ECFEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.CUPOM = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CUPOM"));
entity.N_CAIXA = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("N_CAIXA"));
entity.DATA = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DATA"));
entity.OPERADOR = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("OPERADOR"));
entity.ITEM = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("ITEM"));
entity.CODIGO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CODIGO"));
entity.BARRAS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("BARRAS"));
entity.DESCRICAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DESCRICAO"));
entity.QTD = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QTD"));
entity.PRECO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PRECO"));
entity.TRIBUTACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TRIBUTACAO"));
entity.ICMS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ICMS"));
entity.ISS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ISS"));
entity.UND = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("UND"));
entity.GRADE_X = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("GRADE_X"));
entity.GRADE_Y = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("GRADE_Y"));
entity.GRADE_QUA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("GRADE_QUA"));
entity.GRADE_VENDIDA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("GRADE_VENDIDA"));
entity.SERIAL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("SERIAL"));
entity.DESCONTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("DESCONTO"));
entity.ACRESCIMO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ACRESCIMO"));
entity.TOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTAL"));
entity.OUTRAS_DESP_ACRE = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("OUTRAS_DESP_ACRE"));
entity.CANCELADO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CANCELADO"));
entity.OPERADOR_SUP = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("OPERADOR_SUP"));
entity.LOTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("LOTE"));
entity.TIPO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("TIPO"));
entity.TABELA_PRECO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TABELA_PRECO"));
entity.PIS_ST = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PIS_ST"));
entity.PIS_VALOR_BC = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PIS_VALOR_BC"));
entity.PIS_ALIQ = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PIS_ALIQ"));
entity.TOT_PIS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOT_PIS"));
entity.COFINS_ST = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("COFINS_ST"));
entity.COFINS_VALOR_BC = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COFINS_VALOR_BC"));
entity.COFINS_ALIQ = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COFINS_ALIQ"));
entity.TOT_COFINS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOT_COFINS"));
entity.CST_ICMS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CST_ICMS"));
entity.PRECO_CUSTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PRECO_CUSTO"));
return(entity);
}
public ITEVENDAS_ECFEntity Read()
{
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_ITEVENDAS_ECF", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Rea_ITEVENDAS_ECF", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
reader = dbCommand.ExecuteReader();
ITEVENDAS_ECFEntity 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(ITEVENDAS_ECFEntity 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_ITEVENDAS_ECF", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Sav_ITEVENDAS_ECF", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
if (Entity.CUPOM != null)
{
dbCommand.Parameters.AddWithValue("@CUPOM", Entity.CUPOM); //Coluna
}
else
{
dbCommand.Parameters.AddWithValue("@CUPOM", DBNull.Value); //Coluna 3
}
dbCommand.Parameters.AddWithValue("@N_CAIXA", Entity.N_CAIXA); //Coluna
dbCommand.Parameters.AddWithValue("@DATA", Entity.DATA); //Coluna
dbCommand.Parameters.AddWithValue("@HORA", Entity.HORA); //Coluna
if (Entity.OPERADOR != null)
{
dbCommand.Parameters.AddWithValue("@OPERADOR", Entity.OPERADOR); //Coluna
}
else
{
dbCommand.Parameters.AddWithValue("@OPERADOR", DBNull.Value); //Coluna 3
}
if (Entity.ITEM != null)
{
dbCommand.Parameters.AddWithValue("@ITEM", Entity.ITEM); //Coluna
}
else
{
dbCommand.Parameters.AddWithValue("@ITEM", DBNull.Value); //Coluna 3
}
if (Entity.CODIGO != null)
{
dbCommand.Parameters.AddWithValue("@CODIGO", Entity.CODIGO); //Coluna
}
else
{
dbCommand.Parameters.AddWithValue("@CODIGO", DBNull.Value); //Coluna 3
}
dbCommand.Parameters.AddWithValue("@BARRAS", Entity.BARRAS); //Coluna
dbCommand.Parameters.AddWithValue("@DESCRICAO", Entity.DESCRICAO); //Coluna
dbCommand.Parameters.AddWithValue("@QTD", Entity.QTD); //Coluna
dbCommand.Parameters.AddWithValue("@PRECO", Entity.PRECO); //Coluna
dbCommand.Parameters.AddWithValue("@TRIBUTACAO", Entity.TRIBUTACAO); //Coluna
dbCommand.Parameters.AddWithValue("@ICMS", Entity.ICMS); //Coluna
dbCommand.Parameters.AddWithValue("@ISS", Entity.ISS); //Coluna
dbCommand.Parameters.AddWithValue("@UND", Entity.UND); //Coluna
dbCommand.Parameters.AddWithValue("@GRADE_X", Entity.GRADE_X); //Coluna
dbCommand.Parameters.AddWithValue("@GRADE_Y", Entity.GRADE_Y); //Coluna
dbCommand.Parameters.AddWithValue("@GRADE_QUA", Entity.GRADE_QUA); //Coluna
dbCommand.Parameters.AddWithValue("@GRADE_VENDIDA", Entity.GRADE_VENDIDA); //Coluna
dbCommand.Parameters.AddWithValue("@SERIAL", Entity.SERIAL); //Coluna
dbCommand.Parameters.AddWithValue("@DESCONTO", Entity.DESCONTO); //Coluna
dbCommand.Parameters.AddWithValue("@ACRESCIMO", Entity.ACRESCIMO); //Coluna
dbCommand.Parameters.AddWithValue("@TOTAL", Entity.TOTAL); //Coluna
dbCommand.Parameters.AddWithValue("@OUTRAS_DESP_ACRE", Entity.OUTRAS_DESP_ACRE); //Coluna
if (Entity.CANCELADO != null)
{
dbCommand.Parameters.AddWithValue("@CANCELADO", Entity.CANCELADO); //Coluna
}
else
{
dbCommand.Parameters.AddWithValue("@CANCELADO", DBNull.Value); //Coluna 3
}
if (Entity.OPERADOR_SUP != null)
{
dbCommand.Parameters.AddWithValue("@OPERADOR_SUP", Entity.OPERADOR_SUP); //Coluna
}
else
{
dbCommand.Parameters.AddWithValue("@OPERADOR_SUP", DBNull.Value); //Coluna 3
}
dbCommand.Parameters.AddWithValue("@LOTE", Entity.LOTE); //Coluna
dbCommand.Parameters.AddWithValue("@TIPO", Entity.TIPO); //Coluna
dbCommand.Parameters.AddWithValue("@TABELA_PRECO", Entity.TABELA_PRECO); //Coluna
dbCommand.Parameters.AddWithValue("@PIS_ST", Entity.PIS_ST); //Coluna
dbCommand.Parameters.AddWithValue("@PIS_VALOR_BC", Entity.PIS_VALOR_BC); //Coluna
dbCommand.Parameters.AddWithValue("@PIS_ALIQ", Entity.PIS_ALIQ); //Coluna
dbCommand.Parameters.AddWithValue("@TOT_PIS", Entity.TOT_PIS); //Coluna
dbCommand.Parameters.AddWithValue("@COFINS_ST", Entity.COFINS_ST); //Coluna
dbCommand.Parameters.AddWithValue("@COFINS_VALOR_BC", Entity.COFINS_VALOR_BC); //Coluna
dbCommand.Parameters.AddWithValue("@COFINS_ALIQ", Entity.COFINS_ALIQ); //Coluna
dbCommand.Parameters.AddWithValue("@TOT_COFINS", Entity.TOT_COFINS); //Coluna
dbCommand.Parameters.AddWithValue("@CST_ICMS", Entity.CST_ICMS); //Coluna
dbCommand.Parameters.AddWithValue("@PRECO_CUSTO", Entity.PRECO_CUSTO); //Coluna
//Retorno da Procedure
FbParameter returnValue;
returnValue = dbCommand.CreateParameter();
dbCommand.Parameters[""].Direction = ParameterDirection.InputOutput;
//Executando consulta
dbCommand.ExecuteNonQuery();
result = int.Parse(dbCommand.Parameters[""].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);
}
