public List <Subdepartamento> findAll() { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT * FROM Sub_departamento"; SqlDataReader dr = Conexao.selecionar(cmd); List <Subdepartamento> objs = new List <Subdepartamento>(); if (dr.HasRows) { while (dr.Read()) { dr.Read(); Subdepartamento obj = new Subdepartamento(); obj.Id = (int)dr["id"]; obj.Nome = dr["nome"].ToString(); obj.Descricao = dr["descricao"].ToString(); obj.Departamento = DepartamentoDAO.findById((int)dr["fk_departamento"]); objs.Add(obj); } } else { objs = null; } return(objs); }
public static Subdepartamento findById(int id) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SELECT * FROM Sub_departamento WHERE id = @id"; cmd.Parameters.AddWithValue("@id", id); SqlDataReader dr = Conexao.selecionar(cmd); Subdepartamento obj = new Subdepartamento(); if (dr.HasRows) { dr.Read(); obj.Id = (int)dr["id"]; obj.Nome = dr["nome"].ToString(); obj.Descricao = dr["descricao"].ToString(); obj.Departamento = DepartamentoDAO.findById((int)dr["fk_departamento"]); } else { obj = null; } return(obj); }