/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package com.bestray.healthcareemr.DaoImpl;

import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.vo.TDoctorInformation;
import com.bestray.healthcarecommonutil.vo.TInpatientCharges;
import com.bestray.healthcarecommonutil.vo.TOutDoorBilling;
import com.bestray.healthcarecommonutil.vo.TPatient;
import com.bestray.healthcareemr.Dao.OutDoorBillingDao;
import java.text.SimpleDateFormat;
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.orm.hibernate4.HibernateOptimisticLockingFailureException;

/**
 *
 * @author dell
 */
public class OutDoorBillingDaoImpl extends HibernateDaoSupport implements OutDoorBillingDao{
 @Autowired
    public void init(SessionFactory sessionfactory) {
        setSessionFactory(sessionfactory);
    }
    private SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-YYYY");
    @Override
    public void saveOutDoorBilling(TOutDoorBilling outDoorBilling) throws DataAccessException, HibernateOptimisticLockingFailureException {
        System.out.println("inside billing DaoImpl");
        try{ 
            getHibernateTemplate().saveOrUpdate(outDoorBilling);
        }catch(org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }

    @Override
    public List<TOutDoorBilling> getBillingDetails() throws DataAccessException {
        try{
            return getHibernateTemplate().findByNamedQuery("findAllBillingNameList");
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TPatient findPatientDetailsById(Long id) throws DataAccessException {
       System.out.println("inside Billing DaoImpl ----33333333333333");
        try{
            return getHibernateTemplate().get(TPatient.class, id);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public TOutDoorBilling getChargeDetailById(long id) throws DataAccessException {
        try{
            return getHibernateTemplate().get(TOutDoorBilling.class, id);
        }catch(Exception e){
            throw new DataAccessException();
        }
    }

    @Override
    public void saveOutDoorBillingElse(TOutDoorBilling outDoorBilling) throws DataAccessException {
       
        System.out.println("inside edit Billing DaoImpl");
        try{ 
            getHibernateTemplate().save(outDoorBilling);
        }catch(org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException e){
            throw e;
        }catch(Exception e){
            e.printStackTrace();
            throw new DataAccessException();
        }
    }

//        System.out.println("inside invoice daoImpl-----------------------");
//        try{
//            List<TOutDoorBilling> invoiceNos = getHibernateTemplate().findByNamedQuery("findInvoiceIdForOutDoorBilling");
//            if(invoiceNos.isEmpty()){
//               /* String date = sdf.format(new Date());
//                date = date.substring(0,2)+date.substring(3,5)+date.substring(6);
//                return date+"0000";*/
//                return "1";
//            }else{
//                for (TOutDoorBilling en : invoiceNos) {
//                    System.out.println("1=======================> "+en.getInpatientOutDoorBillingEnc().getEncId());
//                    System.out.println("2=======================> "+en.getInvoiceNo());
//                    System.out.println("3=======================> "+en.getId());  
//                }
//                
//                String lastEncId=""+(invoiceNos.get(0)).getInpatientOutDoorBillingEnc().getEncId();
//                String lastInvoiceNo=(invoiceNos.get(0)).getInvoiceNo();
//                lastInvoiceNo=(lastInvoiceNo==null || lastInvoiceNo.trim().equalsIgnoreCase(""))?"1":lastInvoiceNo;
//                String inId=(invoiceNos.get(0)).getInvoiceNo();
//                Long invoiceNo=Long.parseLong(inId);
//                invoiceNo+=1;
//                System.out.println("=======================> "+invoiceNo);
//                //return (invoiceNos.get(0)).getInvoiceNo();
//                return (""+invoiceNo);
//
//            }
//        }catch(Exception e){
//            throw new DataAccessException();
//        }
//    }

  
    

    @Override
    public String getInvoiceNoToInsert() throws DataAccessException {
        System.out.println("inside invoice daoImpl-----------------------");
        try{
            List<TOutDoorBilling> invoiceNos = getHibernateTemplate().findByNamedQuery("findInvoiceIdForOutDoorBilling");
            if(invoiceNos.isEmpty()){
               /* String date = sdf.format(new Date());
                date = date.substring(0,2)+date.substring(3,5)+date.substring(6);
                return date+"0000";*/
                return "0";
            }else{
                for (TOutDoorBilling en : invoiceNos) {
                    
                    System.out.println("1=======================> "+en.getInpatientOutDoorBillingEnc().getEncId());
                    System.out.println("2=======================> "+en.getInvoiceNo());
                    System.out.println("3=======================> "+en.getId());  
                }
                
                String lastEncId=""+(invoiceNos.get(0)).getInpatientOutDoorBillingEnc().getEncId();
                String lastInvoiceNo=(invoiceNos.get(0)).getInvoiceNo();
                //lastInvoiceNo=(lastInvoiceNo==null || lastInvoiceNo.trim().equalsIgnoreCase(""))?"1":lastInvoiceNo;
                
                String currInvoiceNo=(invoiceNos.get(0)).getInvoiceNo();
                Long invoiceNo=Long.parseLong(currInvoiceNo);
                //invoiceNo+=1;
                //System.out.println("=======================> "+invoiceNo);
                
                if(lastEncId !=null && lastInvoiceNo!=null){
                    currInvoiceNo=""+invoiceNo;
                }else{
                    currInvoiceNo=""+(invoiceNo+1);
                }
                System.out.println("3=======================> "+currInvoiceNo);
                //return (invoiceNos.get(0)).getInvoiceNo();
                return (currInvoiceNo);

            }
        }catch(Exception e){
            throw new DataAccessException();
        }
    }
    
}