예제 #1
0
        public static Item findById(int id)
        {
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "SELECT * FROM Item WHERE id = @id";
            cmd.Parameters.AddWithValue("@id", id);
            SqlDataReader dr = Conexao.selecionar(cmd);

            Item obj = new Item();

            if (dr.HasRows)
            {
                dr.Read();
                obj.Id          = (int)dr["id"];
                obj.Nome        = dr["nome"].ToString();
                obj.Complemento = dr["complemento"].ToString();
                obj.Imagem      = dr["imagem"].ToString();
                obj.QtdEstoque  = (int)dr["qtd_estoque"];
                obj.Marca       = MarcaDAO.findById((int)dr["fk_marca"]);
                obj.Setor       = SetorDAO.findById((int)dr["fk_setor"]);
            }
            else
            {
                obj = null;
            }
            return(obj);
        }
예제 #2
0
        public List <Item> findAll()
        {
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "SELECT * FROM Item";
            SqlDataReader dr   = Conexao.selecionar(cmd);
            List <Item>   objs = new List <Item>();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    dr.Read();
                    Item obj = new Item();
                    obj.Id          = (int)dr["id"];
                    obj.Nome        = dr["nome"].ToString();
                    obj.Complemento = dr["complemento"].ToString();
                    obj.Imagem      = dr["imagem"].ToString();
                    obj.QtdEstoque  = (int)dr["qtd_estoque"];
                    obj.Marca       = MarcaDAO.findById((int)dr["fk_marca"]);
                    obj.Setor       = SetorDAO.findById((int)dr["fk_setor"]);
                    objs.Add(obj);
                }
            }
            else
            {
                objs = null;
            }
            return(objs);
        }