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