/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.bestray.healthcarepharmacy.daoimpl;

import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.vo.TPharmacyBilling;
import com.bestray.healthcarecommonutil.vo.TStockiestDetailMaster;
import com.bestray.healthcarepharmacy.dao.BillingDao;
import java.util.Date;
import java.util.List;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.springframework.stereotype.Repository;

/**
 *
 * @author Bestray
 */
@Repository
public class BillingDaoImpl extends HibernateDaoSupport implements BillingDao{
    
    @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }

    @Override
    public List<TPharmacyBilling> getBillingData(String billType,Date date) throws DataAccessException {
        try{
             return  getHibernateTemplate().findByNamedQuery("findBillByDate",billType,date);
           
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TPharmacyBilling> getBillingId(String billNo) throws DataAccessException {
        try{
             return  getHibernateTemplate().findByNamedQuery("findBillByBillNo",billNo);
           
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TPharmacyBilling> getAvailablePurchaseByStockistByDate(TStockiestDetailMaster selectedStockiest,Date date) throws DataAccessException {
        try{
             return  getHibernateTemplate().findByNamedQuery("getAvailablePurchaseByStockistByDate",selectedStockiest,date);           
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TPharmacyBilling> getavailableTransactionsByStockistByBalanceamount(){
        
         return  getHibernateTemplate().findByNamedQuery("getAvailablePurchaseByStockistByBalanceAmount"); 
    }
    
    @Override
    public List<TPharmacyBilling> getAvailablePurchaseByStockistByMonth(TStockiestDetailMaster selectedStockiest,String month,int year) throws DataAccessException {
        try{
             return  getHibernateTemplate().findByNamedQuery("getAvailablePurchaseByStockistByMonth",selectedStockiest,month,year);           
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TPharmacyBilling> getAvailablePurchaseByStockistByYear(TStockiestDetailMaster selectedStockiest,int year) throws DataAccessException {
        try{
             return  getHibernateTemplate().findByNamedQuery("getAvailablePurchaseByStockistByYear",selectedStockiest,year);           
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }

    @Override
    public boolean updateDuePayment(TPharmacyBilling billingToUpdate) {
        boolean isUpdated = false;
        try {
            getHibernateTemplate().saveOrUpdate(billingToUpdate);
            isUpdated = true;
        } catch (Exception e) {isUpdated = false; e.printStackTrace(); }
        return  isUpdated;
    }
    
}