package web.dao;

import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import web.model.Product;
import java.util.List;

@Repository
public class ProductDaoImpl implements ProductDao {

    @Autowired
    private SessionFactory sessionFactory;

    @Override
    @SuppressWarnings("unchecked")
    public List<Product> getAll() {
        return (List<Product>) sessionFactory.getCurrentSession()
                                             .createQuery("select product from Product order by product.id desc").list();
    }

    @Override
    public void insert(Product product) {
        sessionFactory.getCurrentSession().save(product);
    }

    @Override
    public Product getById(Long id) {
        return (Product) sessionFactory.getCurrentSession().get(Product.class, id);
    }

    @Override
    public void delete(Product product) {
        sessionFactory.getCurrentSession().delete(product);
    }

    @Override
    public void edit(Product product) {
        sessionFactory.getCurrentSession().merge(product);
    }
}


//////////////////////////////
package web.dao;

import web.model.Product;

import java.util.List;


public interface ProductDao {
    void insert(Product product);
    List<Product> getAll();
    Product getById(Long id);

    void delete(Product product);
    void edit(Product product);

}