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);
}
