private static EMPRESAEMISSORAEntity FillEntityObject(ref FbDataReader DataReader) { EMPRESAEMISSORAEntity entity = new EMPRESAEMISSORAEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDEMPRESAEMISSORA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDEMPRESAEMISSORA")); entity.RAZAOSOCIAL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("RAZAOSOCIAL")); entity.NOMEFANTASIA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEFANTASIA")); entity.TELEFONE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TELEFONE")); entity.CNPJ = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CNPJ")); entity.IE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("IE")); entity.EMAIL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("EMAIL")); 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.CEP = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CEP")); entity.IMUNICIPAL = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("IMUNICIPAL")); entity.CRT = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CRT")); entity.IEST = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("IEST")); entity.CNAE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CNAE")); entity.NOMECERTIFICADO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECERTIFICADO")); entity.SERIACERTIFICADO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("SERIACERTIFICADO")); entity.VALIDADECERTIFICADO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("VALIDADECERTIFICADO")); entity.COD_MUN_IBGE = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("COD_MUN_IBGE")); return(entity); }
public EMPRESAEMISSORAEntity Read(int IDEMPRESAEMISSORA) { 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_EMPRESAEMISSORA", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Rea_EMPRESAEMISSORA", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.Parameters.AddWithValue("@IDEMPRESAEMISSORA", IDEMPRESAEMISSORA); //PrimaryKey reader = dbCommand.ExecuteReader(); EMPRESAEMISSORAEntity 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(EMPRESAEMISSORAEntity 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_EMPRESAEMISSORA", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Sav_EMPRESAEMISSORA", 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.IDEMPRESAEMISSORA == -1) { dbCommand.Parameters.AddWithValue("@IDEMPRESAEMISSORA", DBNull.Value); } else { dbCommand.Parameters.AddWithValue("@IDEMPRESAEMISSORA", Entity.IDEMPRESAEMISSORA); } dbCommand.Parameters.AddWithValue("@RAZAOSOCIAL", Entity.RAZAOSOCIAL); //Coluna dbCommand.Parameters.AddWithValue("@NOMEFANTASIA", Entity.NOMEFANTASIA); //Coluna dbCommand.Parameters.AddWithValue("@TELEFONE", Entity.TELEFONE); //Coluna dbCommand.Parameters.AddWithValue("@CNPJ", Entity.CNPJ); //Coluna dbCommand.Parameters.AddWithValue("@IE", Entity.IE); //Coluna dbCommand.Parameters.AddWithValue("@EMAIL", Entity.EMAIL); //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("@CEP", Entity.CEP); //Coluna dbCommand.Parameters.AddWithValue("@IMUNICIPAL", Entity.IMUNICIPAL); //Coluna dbCommand.Parameters.AddWithValue("@CRT", Entity.CRT); //Coluna dbCommand.Parameters.AddWithValue("@IEST", Entity.IEST); //Coluna dbCommand.Parameters.AddWithValue("@CNAE", Entity.CNAE); //Coluna dbCommand.Parameters.AddWithValue("@NOMECERTIFICADO", Entity.NOMECERTIFICADO); //Coluna dbCommand.Parameters.AddWithValue("@SERIACERTIFICADO", Entity.SERIACERTIFICADO); //Coluna dbCommand.Parameters.AddWithValue("@VALIDADECERTIFICADO", Entity.VALIDADECERTIFICADO); //Coluna if (Entity.COD_MUN_IBGE != null) { dbCommand.Parameters.AddWithValue("@COD_MUN_IBGE", Entity.COD_MUN_IBGE); //ForeignKey } else { dbCommand.Parameters.AddWithValue("@COD_MUN_IBGE", DBNull.Value); //ForeignKey 5 } //Retorno da Procedure FbParameter returnValue; returnValue = dbCommand.CreateParameter(); dbCommand.Parameters["@IDEMPRESAEMISSORA"].Direction = ParameterDirection.InputOutput; //Executando consulta dbCommand.ExecuteNonQuery(); result = int.Parse(dbCommand.Parameters["@IDEMPRESAEMISSORA"].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); }