/*
 * 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.TInventoryMaster;
import com.bestray.healthcarecommonutil.vo.TPharmacyBilling;
import com.bestray.healthcarecommonutil.vo.TPharmacySales;
import com.bestray.healthcarepharmacy.dao.SalesBillingDao;
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;
import org.springframework.transaction.annotation.Transactional;

/**
 *
 * @author user3
 */
@Repository
public class SalesBillingDaoimpl extends HibernateDaoSupport implements SalesBillingDao{
     
    @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }

    @Override
    public List<TPharmacySales> saveSalesDetails(List<TPharmacySales> sales) throws DataAccessException {
         try{
            getHibernateTemplate().saveOrUpdateAll(sales);
            return sales;
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }
    @Transactional(readOnly=true)
    @Override
    public String getSalesBillingNo(String s) throws DataAccessException {
          String billNumber = null;
        try{
            List<TPharmacyBilling> billNo = getHibernateTemplate().findByNamedQuery("findBillingNumber",s);
            int size =billNo.size();
            if(billNo.isEmpty()){
                return "0";
            }else {
                billNumber = billNo.get(size-1).getBillingNumber();
            }   
         }catch(Exception e){
            throw new DataAccessException();
        }
        return billNumber;
    }
    
    @Override
    public List<TPharmacySales> getSalesBillingDetails(TPharmacyBilling billingId) throws DataAccessException {
        try{
             return  getHibernateTemplate().findByNamedQuery("findSalesDataByBillNo",billingId);
           
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TPharmacySales> getavailableSalesTransactionsByDate(Date date) throws DataAccessException {
        try{
             return  getHibernateTemplate().findByNamedQuery("getAvailableSalesTransactionByDate",date);           
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TPharmacySales> getavailableSalesTransactionsByMonth(String month,int year) throws DataAccessException {
        try{
             return  getHibernateTemplate().findByNamedQuery("getAvailableSalesTransactionByMonth",month,year);           
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TPharmacySales> getavailableSalesTransactionsByYear(int year) throws DataAccessException {
        try{
             return  getHibernateTemplate().findByNamedQuery("getAvailableSalesTransactionByYear",year);           
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TPharmacySales> getSalesDetailBeforeGivenDate(TInventoryMaster inventoryMaster,Date fromDate) throws DataAccessException {
        try{
             return  getHibernateTemplate().findByNamedQuery("findSalesDataByMedicationByDate",inventoryMaster,fromDate);
           
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
    @Override
    public List<TPharmacySales> getSalesDetailBetweenTwoDate(TInventoryMaster inventoryMaster,Date fromDate,Date toDate) throws DataAccessException {
        try{
             return  getHibernateTemplate().findByNamedQuery("findSalesDataByMedicationBetweenTwoDates",inventoryMaster,fromDate,toDate);
           
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
}