// Construtor com PK public Endereco(int codigo, Bairro neighborhood, Tipo_Endereco type,string Street, string number, int zipcode) { cod_end = codigo; Logradouro = Street; tipo_endereco = type.Cod_tp_endereco; Bairro_Endereco = neighborhood.Cod_Bairro; Numero = number; CEP = zipcode; }
public bool Insert(Tipo_Endereco type_address) { try { DadosdoTipoEnd.Inserir(type_address); return true; } catch (Exception e) { throw e; } }
public bool Delete(Tipo_Endereco type_address) { try { DadosdoTipoEnd.Excluir(type_address); return true; } catch (Exception e) { throw e; } }
public bool Excluir(Tipo_Endereco type_adress) { try { int codigo = type_adress.Cod_tp_endereco; using (OracleCommand cmd = new OracleCommand()) { cmd.Connection = _conn.ObterConexao(); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "DELETA_TP_END"; cmd.Parameters.Add("D_TP_END", OracleDbType.Int32).Value = type_adress.Cod_tp_endereco; cmd.ExecuteNonQuery(); return true; } } catch (OracleException ex) { throw ex; } }
public Tipo_Endereco Buscar(string tp_end) { Tipo_Endereco type_adress = null; using (OracleCommand c = _conn.ObterConexao().CreateCommand()) { c.CommandType = System.Data.CommandType.Text; c.CommandText = "select NOME FROM TP_END WHERE NOME = :nome"; c.Parameters.Add("@nome", OracleDbType.Varchar2).Value = tp_end; using (OracleDataReader leitor = c.ExecuteReader()) { if (leitor.HasRows) { leitor.Read(); int bd_cod_tp_end = leitor.GetInt32(0); string bd_nome_tp_end = leitor.GetString(1); type_adress = new Tipo_Endereco(bd_cod_tp_end, bd_nome_tp_end); } } } return type_adress; }
public bool Inserir(Tipo_Endereco type_adress) { try { int cod_tp_adress = type_adress.Cod_tp_endereco; string cod_nome_tp_adress = type_adress.Nome_tp_end; using (OracleCommand cmd = new OracleCommand()) { cmd.Connection = _conn.ObterConexao(); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "INSERE_TP_END"; cmd.Parameters.Add("DESCRICAO", OracleDbType.Int32).Value = type_adress.Nome_tp_end; cmd.ExecuteNonQuery(); return true; } } catch (OracleException ex) { throw ex; } }