private static EQUIPAMENTOEntity FillEntityObject(ref FbDataReader DataReader) { EQUIPAMENTOEntity entity = new EQUIPAMENTOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDEQUIPAMENTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDEQUIPAMENTO")); entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); entity.CACAMBA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CACAMBA")); entity.PESOOPERACIONAL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PESOOPERACIONAL")); entity.CONSUMOHORA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CONSUMOHORA")); entity.PROFESCAVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("PROFESCAVACAO")); entity.POTENCIAHP = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("POTENCIAHP")); entity.VALOR = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALOR")); entity.IDSTATUS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDSTATUS")); entity.LOCALIZACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("LOCALIZACAO")); // entity.FOTO = getData.ConvertDBValueToBytes(DataReader, DataReader.GetOrdinal("FOTO")); entity.VALORDIA = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORDIA")); entity.VALORMES = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("VALORMES")); entity.IDENTIFICACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("IDENTIFICACAO")); return(entity); }
private void GetDropEquipamento() { EQUIPAMENTOProvider EQUIPAMENTOP = new EQUIPAMENTOProvider(); EQUIPAMENTOColl = EQUIPAMENTOP.ReadCollectionByParameter(null, "NOME"); cbEquipamento.DisplayMember = "NOME"; cbEquipamento.ValueMember = "IDEQUIPAMENTO"; EQUIPAMENTOEntity EQUIPAMENTOTy = new EQUIPAMENTOEntity(); EQUIPAMENTOTy.NOME = ConfigMessage.Default.MsgDrop; EQUIPAMENTOTy.IDEQUIPAMENTO = -1; EQUIPAMENTOColl.Add(EQUIPAMENTOTy); Phydeaux.Utilities.DynamicComparer <EQUIPAMENTOEntity> comparer = new Phydeaux.Utilities.DynamicComparer <EQUIPAMENTOEntity>(cbEquipamento.DisplayMember); EQUIPAMENTOColl.Sort(comparer.Comparer); cbEquipamento.DataSource = EQUIPAMENTOColl; cbEquipamento.SelectedIndex = 0; }
public EQUIPAMENTOEntity Read(int IDEQUIPAMENTO) { 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_EQUIPAMENTO", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Rea_EQUIPAMENTO", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.Parameters.AddWithValue("@IDEQUIPAMENTO", IDEQUIPAMENTO); //PrimaryKey reader = dbCommand.ExecuteReader(); EQUIPAMENTOEntity 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(EQUIPAMENTOEntity 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_EQUIPAMENTO", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Sav_EQUIPAMENTO", 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.IDEQUIPAMENTO == -1) { dbCommand.Parameters.AddWithValue("@IDEQUIPAMENTO", DBNull.Value); } else { dbCommand.Parameters.AddWithValue("@IDEQUIPAMENTO", Entity.IDEQUIPAMENTO); } dbCommand.Parameters.AddWithValue("@NOME", Entity.NOME); //Coluna dbCommand.Parameters.AddWithValue("@OBSERVACAO", Entity.OBSERVACAO); //Coluna dbCommand.Parameters.AddWithValue("@CACAMBA", Entity.CACAMBA); //Coluna dbCommand.Parameters.AddWithValue("@PESOOPERACIONAL", Entity.PESOOPERACIONAL); //Coluna dbCommand.Parameters.AddWithValue("@CONSUMOHORA", Entity.CONSUMOHORA); //Coluna dbCommand.Parameters.AddWithValue("@PROFESCAVACAO", Entity.PROFESCAVACAO); //Coluna dbCommand.Parameters.AddWithValue("@POTENCIAHP", Entity.POTENCIAHP); //Coluna dbCommand.Parameters.AddWithValue("@VALOR", Entity.VALOR); //Coluna if (Entity.IDSTATUS != null) { dbCommand.Parameters.AddWithValue("@IDSTATUS", Entity.IDSTATUS); //ForeignKey } else { dbCommand.Parameters.AddWithValue("@IDSTATUS", DBNull.Value); //ForeignKey 5 } dbCommand.Parameters.AddWithValue("@LOCALIZACAO", Entity.LOCALIZACAO); //Coluna dbCommand.Parameters.AddWithValue("@FOTO", Entity.FOTO); //Coluna dbCommand.Parameters.AddWithValue("@VALORDIA", Entity.VALORDIA); //Coluna dbCommand.Parameters.AddWithValue("@VALORMES", Entity.VALORMES); //Coluna dbCommand.Parameters.AddWithValue("@IDENTIFICACAO", Entity.IDENTIFICACAO); //Coluna //Retorno da Procedure FbParameter returnValue; returnValue = dbCommand.CreateParameter(); dbCommand.Parameters["@IDEQUIPAMENTO"].Direction = ParameterDirection.InputOutput; //Executando consulta dbCommand.ExecuteNonQuery(); result = int.Parse(dbCommand.Parameters["@IDEQUIPAMENTO"].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); }