private void GetDropContador() { try { CONTADORProvider CONTADORP = new CONTADORProvider(); CONTADORCollection CONTADORColl = new CONTADORCollection(); CONTADORColl = CONTADORP.ReadCollectionByParameter(null, "NOME"); cbContador.DisplayMember = "NOME"; cbContador.ValueMember = "CONTADORID"; CONTADOREntity CONTADORTy = new CONTADOREntity(); CONTADORTy.NOME = ConfigMessage.Default.MsgDrop; CONTADORTy.CONTADORID = -1; CONTADORColl.Add(CONTADORTy); Phydeaux.Utilities.DynamicComparer <CONTADOREntity> comparer = new Phydeaux.Utilities.DynamicComparer <CONTADOREntity>(cbContador.DisplayMember); CONTADORColl.Sort(comparer.Comparer); cbContador.DataSource = CONTADORColl; } catch (Exception ex) { MessageBox.Show("Erro técnico: " + ex.Message); } }
private static CONTADOREntity FillEntityObject(ref FbDataReader DataReader) { CONTADOREntity entity = new CONTADOREntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.CONTADORID = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("CONTADORID")); entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME")); entity.CPF = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CPF")); entity.CNPJ = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CNPJ")); entity.CRC = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CRC")); entity.CEP = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CEP")); entity.ENDERECO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("ENDERECO")); entity.NUMERO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NUMERO")); entity.COMPLEMENTO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("COMPLEMENTO")); entity.BAIRRO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("BAIRRO")); entity.FONE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FONE")); entity.FAX = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FAX")); entity.EMAIL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("EMAIL")); entity.COD_MUN = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("COD_MUN")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); entity.FLAGATIVO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGATIVO")); return(entity); }
public CONTADOREntity Read(int CONTADORID) { 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_CONTADOR", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Rea_CONTADOR", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.Parameters.AddWithValue("@CONTADORID", CONTADORID); //PrimaryKey reader = dbCommand.ExecuteReader(); CONTADOREntity 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(CONTADOREntity 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_CONTADOR", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Sav_CONTADOR", 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.CONTADORID == -1) { dbCommand.Parameters.AddWithValue("@CONTADORID", DBNull.Value); } else { dbCommand.Parameters.AddWithValue("@CONTADORID", Entity.CONTADORID); } dbCommand.Parameters.AddWithValue("@NOME", Entity.NOME); //Coluna dbCommand.Parameters.AddWithValue("@CPF", Entity.CPF); //Coluna dbCommand.Parameters.AddWithValue("@CNPJ", Entity.CNPJ); //Coluna dbCommand.Parameters.AddWithValue("@CRC", Entity.CRC); //Coluna dbCommand.Parameters.AddWithValue("@CEP", Entity.CEP); //Coluna dbCommand.Parameters.AddWithValue("@ENDERECO", Entity.ENDERECO); //Coluna dbCommand.Parameters.AddWithValue("@NUMERO", Entity.NUMERO); //Coluna dbCommand.Parameters.AddWithValue("@COMPLEMENTO", Entity.COMPLEMENTO); //Coluna dbCommand.Parameters.AddWithValue("@BAIRRO", Entity.BAIRRO); //Coluna dbCommand.Parameters.AddWithValue("@FONE", Entity.FONE); //Coluna dbCommand.Parameters.AddWithValue("@FAX", Entity.FAX); //Coluna dbCommand.Parameters.AddWithValue("@EMAIL", Entity.EMAIL); //Coluna if (Entity.COD_MUN != null) { dbCommand.Parameters.AddWithValue("@COD_MUN", Entity.COD_MUN); //ForeignKey } else { dbCommand.Parameters.AddWithValue("@COD_MUN", DBNull.Value); //ForeignKey 5 } dbCommand.Parameters.AddWithValue("@OBSERVACAO", Entity.OBSERVACAO); //Coluna dbCommand.Parameters.AddWithValue("@FLAGATIVO", Entity.FLAGATIVO); //Coluna //Retorno da Procedure FbParameter returnValue; returnValue = dbCommand.CreateParameter(); dbCommand.Parameters["@CONTADORID"].Direction = ParameterDirection.InputOutput; //Executando consulta dbCommand.ExecuteNonQuery(); result = int.Parse(dbCommand.Parameters["@CONTADORID"].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); }