package net.inver.productmanager.dao;

import net.inver.productmanager.domain.Domain;
import net.inver.productmanager.domain.Product;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;

import java.util.ArrayList;
import java.util.List;


public class SimpleDAOImpl implements SimpleDao{


    @Autowired
    protected SessionFactory sessionFactory;

    protected String tableName;
    private List listItems;
    private Domain domain;

    public SimpleDAOImpl() {
        tableName = createTableName();
        listItems = createListItems();
        domain = createItem();
    }

    public String createTableName() {
        return new String("domain");
    }

    public List createListItems() {
        return new ArrayList<Domain>();
    }

    public Domain createItem() {
        return null;
    }

    @Override
    @SuppressWarnings("unchecked")
    public <TypeDomain extends Domain> List<TypeDomain> getAllItems() {
        Session session = sessionFactory.getCurrentSession();
        session.beginTransaction();
        listItems = session.createQuery("from " + tableName).list();
        session.getTransaction().commit();
        return listItems;
    }

    @Override
    public Integer getCountItems() {
        Session session = sessionFactory.getCurrentSession();
        session.beginTransaction();
        Integer count = 0;
        // = (Integer)session.createQuery("select count from " + tableName).list();
        session.getTransaction().commit();
        return count;
    }

    @Override
    public Domain getItemById(Integer id) {
        Session session = sessionFactory.getCurrentSession();
        session.beginTransaction();
        domain = (Domain)session.get(domain.getClass(), id);
        session.getTransaction().commit();
        return domain;
    }

    @Override
    public void updateItem(Domain item) {
        Session session = sessionFactory.getCurrentSession();
        session.beginTransaction();
        session.update(item);
        session.getTransaction().commit();
    }

    @Override
    public void addItem(Domain item) {
        Session session = sessionFactory.getCurrentSession();
        session.beginTransaction();
        session.save(item);
        session.getTransaction().commit();
    }

    @Override
    public void deleteItem(Integer id) {
        Session session = sessionFactory.getCurrentSession();
        session.beginTransaction();
        domain = (Domain)session.load(domain.getClass(), id);
        if(null != domain) session.delete(domain);
        session.getTransaction().commit();
    }
}