package com.netshop.domain.dao.hibernate;

import java.util.List;
import com.netshop.domain.dao.UserinfoDao;
import com.netshop.domain.model.UserInfo;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import net.sf.hibernate.*;
import org.springframework.dao.DataAccessException;
import com.netshop.util.*;

public class UserinfoDAOImpl implements UserinfoDao {

    private static Log log = LogFactory.getLog(UserinfoDAOImpl.class);

    /*
     * (non-Javadoc)
     * 
     * @see org.digitstore.dao.AccountDao#getAccount(java.lang.String,
     *      java.lang.String)
     */
    public UserInfo getAccount(String username, String password)
            throws DataAccessException {
        // TODO Auto-generated method stub
        try {
            Session s = HibernateUtil.currentSession();
            List results = (List) s
                    .find("from UserInfo userinfo where userinfo.username='" + username
                            + "'" + " and userinfo.password='" + password + "'");
            if (results != null && results.size() > 0) {
                return (UserInfo) results.get(0);
            }
        } catch (HibernateException e) {
            log.fatal(e);
        }
        return null;
    }

    /*
     * (non-Javadoc)
     * 
     * @see org.digitstore.dao.AccountDao#getAccount(java.lang.String)
     */
    public UserInfo getAccount(String username) throws DataAccessException {
        // TODO Auto-generated method stub
        try {
            Session s = HibernateUtil.currentSession();
            List results = (List) s
                    .find("from UserInfo userinfo where userinfo.username='" + username
                            + "'");
            if (results != null && results.size() > 0) {
                return (UserInfo) results.get(0);
            }
        } catch (HibernateException e) {
            log.fatal(e);
        }
        return null;
    }

    /*
     * (non-Javadoc)
     * 
     * @see org.digitstore.dao.AccountDao#getUsernameList()
     */
    public List getUsernameList() throws DataAccessException {
        // TODO Auto-generated method stub
        return null;
    }

    /*
     * (non-Javadoc)
     * 
     * @see org.digitstore.dao.AccountDao#insertAccount(org.digitstore.domain.Account)
     */
    public void insertAccount(UserInfo account) throws DataAccessException {
        // TODO Auto-generated method stub
        try {
            Session s = HibernateUtil.currentSession();
            s.beginTransaction();
            s.save(account);
        } catch (HibernateException e) {
            log.fatal(e);
        }
    }

    /*
     * (non-Javadoc)
     * 
     * @see org.digitstore.dao.AccountDao#updateAccount(org.digitstore.domain.Account)
     */
    public void updateAccount(UserInfo account) throws DataAccessException {
        // TODO Auto-generated method stub
        try {
            Session s = HibernateUtil.currentSession();
            s.beginTransaction();
            s.saveOrUpdate(account);
        } catch (HibernateException e) {
            log.fatal(e);
        }
    }
}