private static List <PessoaBean> SetInstance(OracleDataReader dr) { List <PessoaBean> list = new List <PessoaBean>(); try { while (dr.Read()) { PessoaBean obj = new PessoaBean(); obj.idPessoa = Convert.ToInt32(dr["id_pessoa"].ToString()); obj.nome = dr["nome"].ToString(); obj.apelido = dr["apelido"].ToString(); obj.numDoc = dr["num_Doc"].ToString(); obj.tipoDoc = dr["tipo_Doc"].ToString(); obj.tel1 = dr["tel1"].ToString(); obj.tel2 = dr["tel2"].ToString(); obj.tel3 = dr["tel3"].ToString(); obj.logradouro = dr["logradouro"].ToString(); obj.numero = dr["numero"].ToString(); obj.complemento = dr["complemento"].ToString(); obj.bairro = dr["bairro"].ToString(); obj.cep = dr["cep"].ToString(); obj.pontoRef = dr["ponto_ref"].ToString(); obj.obs = dr["obs"].ToString(); obj.grupoPessoa = GrupoPessoaDAO.getRecord(Convert.ToInt32(dr["id_grupo_pessoa"])); list.Add(obj); } } catch (Exception ex) { throw (ex); } finally { if (!dr.IsClosed) { dr.Close(); } } return(list); }
private static bool SetInstance(OracleDataReader dr, PessoaBean bean) { try { if (dr.Read()) { bean.idPessoa = Convert.ToInt32(dr["id_pessoa"].ToString()); bean.nome = dr["nome"].ToString(); bean.apelido = dr["apelido"].ToString(); bean.numDoc = dr["num_Doc"].ToString(); bean.tipoDoc = dr["tipo_Doc"].ToString(); bean.tel1 = dr["tel1"].ToString(); bean.tel2 = dr["tel2"].ToString(); bean.tel3 = dr["tel3"].ToString(); bean.logradouro = dr["logradouro"].ToString(); bean.numero = dr["numero"].ToString(); bean.complemento = dr["complemento"].ToString(); bean.bairro = dr["bairro"].ToString(); bean.cep = dr["cep"].ToString(); bean.pontoRef = dr["ponto_ref"].ToString(); bean.obs = dr["obs"].ToString(); bean.grupoPessoa = GrupoPessoaDAO.getRecord(Convert.ToInt32(dr["id_grupo_pessoa"])); return(true); } else { return(false); } } catch (Exception ex) { throw (ex); } finally { if (!dr.IsClosed) { dr.Close(); } } }