private static PRODUTOPEDMARC2Entity FillEntityObject(ref FbDataReader DataReader) { PRODUTOPEDMARC2Entity entity = new PRODUTOPEDMARC2Entity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDPRODUTOPEDMARC2 = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDPRODUTOPEDMARC2")); entity.PEDIDOMARC = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("PEDIDOMARC")); entity.QUANT = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("QUANT")); entity.ALTURA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("ALTURA")); entity.LARGURA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("LARGURA")); entity.COMPRIMENTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("COMPRIMENTO")); entity.TOTALMT3 = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("TOTALMT3")); entity.VLUNITARIO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLUNITARIO")); entity.VLTOTAL = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VLTOTAL")); entity.DADOSADICIONAIS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("DADOSADICIONAIS")); entity.IDPRODUTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDPRODUTO")); return(entity); }
public PRODUTOPEDMARC2Entity Read(int IDPRODUTOPEDMARC2) { 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_PRODUTOPEDMARC2", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Rea_PRODUTOPEDMARC2", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.Parameters.AddWithValue("@IDPRODUTOPEDMARC2", IDPRODUTOPEDMARC2); //PrimaryKey reader = dbCommand.ExecuteReader(); PRODUTOPEDMARC2Entity 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(PRODUTOPEDMARC2Entity 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_PRODUTOPEDMARC2", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Sav_PRODUTOPEDMARC2", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; //PrimaryKey com valor igual a null, indica um novo registro, //o valor da chave será fornecido pelo banco. Qualquer outro valor indicará edição do registro. if (Entity.IDPRODUTOPEDMARC2 == -1) { dbCommand.Parameters.AddWithValue("@IDPRODUTOPEDMARC2", DBNull.Value); } else { dbCommand.Parameters.AddWithValue("@IDPRODUTOPEDMARC2", Entity.IDPRODUTOPEDMARC2); } if (Entity.PEDIDOMARC != null) { dbCommand.Parameters.AddWithValue("@PEDIDOMARC", Entity.PEDIDOMARC); //ForeignKey } else { dbCommand.Parameters.AddWithValue("@PEDIDOMARC", DBNull.Value); //ForeignKey 5 } dbCommand.Parameters.AddWithValue("@QUANT", Entity.QUANT); //Coluna dbCommand.Parameters.AddWithValue("@ALTURA", Entity.ALTURA); //Coluna dbCommand.Parameters.AddWithValue("@LARGURA", Entity.LARGURA); //Coluna dbCommand.Parameters.AddWithValue("@COMPRIMENTO", Entity.COMPRIMENTO); //Coluna dbCommand.Parameters.AddWithValue("@TOTALMT3", Entity.TOTALMT3); //Coluna dbCommand.Parameters.AddWithValue("@VLUNITARIO", Entity.VLUNITARIO); //Coluna dbCommand.Parameters.AddWithValue("@VLTOTAL", Entity.VLTOTAL); //Coluna dbCommand.Parameters.AddWithValue("@DADOSADICIONAIS", Entity.DADOSADICIONAIS); //Coluna if (Entity.IDPRODUTO != null) { dbCommand.Parameters.AddWithValue("@IDPRODUTO", Entity.IDPRODUTO); //ForeignKey } else { dbCommand.Parameters.AddWithValue("@IDPRODUTO", DBNull.Value); //ForeignKey 5 } //Retorno da Procedure FbParameter returnValue; returnValue = dbCommand.CreateParameter(); dbCommand.Parameters["@IDPRODUTOPEDMARC2"].Direction = ParameterDirection.InputOutput; //Executando consulta dbCommand.ExecuteNonQuery(); result = int.Parse(dbCommand.Parameters["@IDPRODUTOPEDMARC2"].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); }