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

import com.bestray.healthcarecommonutil.dao.CodeTypeDao;
import com.bestray.healthcarecommonutil.dao.CodeValuesDao;
import com.bestray.healthcarecommonutil.exception.DataAccessException;
import com.bestray.healthcarecommonutil.exception.HealthCareException;
import com.bestray.healthcarecommonutil.exception.ProcessingException;
import com.bestray.healthcarecommonutil.service.CodeValuesService;
import com.bestray.healthcarecommonutil.vo.TCCodeType;
import com.bestray.healthcarecommonutil.vo.TCCodeValues;
import java.sql.Timestamp;
import java.util.List;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;


// TODO: Auto-generated Javadoc
/**
 * The Class CodeValuesServiceImpl.
 *
 * @author user3
 */
@Transactional
@Service
public class CodeValuesServiceImpl implements CodeValuesService{
    
    /** The code type dao. */
    @Autowired
    private CodeTypeDao codeTypeDao;
    
    /** The codetype. */
    private TCCodeType codetype;
    
    /** The codevalues. */
    private TCCodeValues codevalues;
    
    /** The codeid. */
    private int codeid;
    
    /** The codetypeid. */
    private int codetypeid;
    
    /** The id. */
    private int id;
    
    /** The flag. */
    private boolean flag;
    
    /** The code values dao. */
    @Autowired
    private CodeValuesDao codeValuesDao;
    
    /** The date. */
    final java.util.Date date= new java.util.Date();

    public CodeValuesServiceImpl() {
        codetype = new TCCodeType();
        codevalues = new TCCodeValues();
        codeid=0;
        codetypeid=0;
    }
    
    /**
     * Instantiates a new code values service impl.
     *
     * @param codeTypeDao the code type dao
     * @param codeValuesDao the code values dao
     
    public CodeValuesServiceImpl(CodeTypeDao codeTypeDao,CodeValuesDao codeValuesDao){
        this.codeTypeDao = codeTypeDao;
        codetype = new TCCodeType();
        codevalues = new TCCodeValues();
        codeid=0;
        codetypeid=0;
        this.codeValuesDao = codeValuesDao;
    }
    
    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Service.CodeValuesService#createNewCodeValue(com.bestray.healthcareemr.Vo.TCCodeValues, java.lang.String)
     */
    @Override
    public boolean createNewCodeValue(TCCodeValues codevalues, String s)throws ProcessingException,HibernateOptimisticLockingFailureException {
          try{
              List<TCCodeType> codetypes = codeTypeDao.searchForCodeTypeName(s);
              flag = false;
              codetype = new TCCodeType();
              if(codetypes.isEmpty()){
                codetype.setCodeTypeName(s);
                codeTypeDao.addToCodeType(codetype);
                if(codevalues.getCodeValueName()!=null && codevalues.getCodeValueName().trim().length()>0){
                  List<TCCodeType> codetypess = codeTypeDao.searchForCodeTypeName(s);
                  TCCodeType ctype=null;
                  for(TCCodeType codetyp : codetypess){
                      ctype=codetyp;
                      codeid = codetyp.getCodeTypeId();
                 }
                  codevalues.setTccodetype(ctype);
                  codevalues.setCreatedDate(new Timestamp(date.getTime()));
                  codeValuesDao.addToCodeValues(codevalues);
                  flag=true;
              } 
              return flag;
          }
          else{
              for(TCCodeType codetype1 : codetypes){
            	  codetype=codetype1;
                  codetypeid=codetype1.getCodeTypeId();
              }
              

              if(codevalues.getCodeValueId()!=null && codevalues.getCodeValueId()>0){
                    codevalues.setUpdatedDate(new Timestamp(date.getTime()));
                    codeValuesDao.updateCodeValues(codevalues);
                    flag=true;
                }else{
                	List<TCCodeValues> codeval = codeValuesDao.searchForCodeValueName(codevalues.getCodeValueName(),codetype);
                    if(!codeval.isEmpty()){
                        JOptionPane.showMessageDialog(null, "Value Name Already Exist...");
                        flag=false;
                    }else{
                        
                        codevalues.setTccodetype(codetype);
                        codevalues.setCreatedDate(new Timestamp(date.getTime()));
                        codeValuesDao.addToCodeValues(codevalues);
                        flag=true;
                    }
                }
              return flag;
          }
          }catch(HibernateOptimisticLockingFailureException e){
            Logger.getLogger(CodeValuesServiceImpl.class.getName()).log(Level.SEVERE, null, e);
            throw e;
         }catch(DataAccessException e){
              Logger.getLogger(CodeValuesServiceImpl.class.getName()).log(Level.SEVERE, null, e);
              throw new ProcessingException();
         }catch(Exception e){
             Logger.getLogger(CodeValuesServiceImpl.class.getName()).log(Level.SEVERE, null, e);
             throw new HealthCareException("Error in Saving...");
        }
    }
    
    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Service.CodeValuesService#getValuesList(java.lang.String, java.lang.String, int, int)
     */
    @Transactional(readOnly = true)       
    @Override
    public Vector<Vector<String>> getValuesList(String codeType,String expr,int min,int max)throws ProcessingException {
        TCCodeType codetype=null;
        try {
            List<TCCodeType> codetypes = codeTypeDao.searchForCodeTypeName(codeType);
            for(TCCodeType code : codetypes){
                codetype = code;
                id = code.getCodeTypeId();
            }
            Vector<Vector<String>> value = new Vector<Vector<String>>();
            List<TCCodeValues> valuesList;
            
                valuesList = codeValuesDao.findAllValuesList(codetype,expr,min,max);
            
            for (TCCodeValues val : valuesList) {
                Vector<String> valss = new Vector<String>();
                valss.add(String.valueOf(val.getCodeValueId()));
                valss.add(String.valueOf(min+1));
                valss.add(String.valueOf(val.getCodeValueName()));
                if(val.getRecordStatus()==true){
                    valss.add("ACTIVE");
                }
                else{
                    valss.add("INACTIVE");
                }
                value.add(valss);
                min++;
            }
            return value;
        }catch (DataAccessException ex) {
            Logger.getLogger(CodeValuesServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new ProcessingException();
        }catch(Exception ex) {
            Logger.getLogger(CodeValuesServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new HealthCareException("Error in populating data");
         }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Service.CodeValuesService#getValues(java.lang.Long)
     */
    @Transactional(readOnly = true)
    @Override
    public TCCodeValues getValues(Long valuesId)throws ProcessingException {
        TCCodeValues values;
        try{
            values = codeValuesDao.getDetails(valuesId);
            return values;
        }catch(DataAccessException e){
            Logger.getLogger(CodeValuesServiceImpl.class.getName()).log(Level.SEVERE, null, e);
            throw new ProcessingException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Service.CodeValuesService#deleteValues(java.lang.Long)
     */
    @Override
    public void deleteValues(Long valuesId)throws ProcessingException,IllegalArgumentException {
        try{
            codeValuesDao.deleteValuesMaster(valuesId);
        }catch(IllegalArgumentException e){
            //Logger.getLogger(CodeValuesServiceImpl.class.getName()).log(Level.SEVERE, null, e);
            throw e;
        }catch(DataAccessException e){
            Logger.getLogger(CodeValuesServiceImpl.class.getName()).log(Level.SEVERE, null, e);
            throw new ProcessingException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Service.CodeValuesService#getMaxId()
     */
    @Override
    public Long getMaxId() throws ProcessingException {
        try{
             return codeValuesDao.getMaxId();
        }catch(DataAccessException e){
            Logger.getLogger(CodeValuesServiceImpl.class.getName()).log(Level.SEVERE, null, e);
            throw new ProcessingException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Service.CodeValuesService#numberOfCodeValueRecords(java.lang.String, java.lang.String)
     */
    @Override
    public int numberOfCodeValueRecords(String expr,String codeType) throws ProcessingException {
        TCCodeType codetype=null;
        try{
            List<TCCodeType> codetypes = codeTypeDao.searchForCodeTypeName(codeType);
            for(TCCodeType code : codetypes){
                codetype = code;
                //id = code.getCodeTypeId();
            }
            return codeValuesDao.numberOfCodeValueRecords(expr,codetype);
            
        }catch(DataAccessException e){
            Logger.getLogger(CodeValuesServiceImpl.class.getName()).log(Level.SEVERE, null, e);
            throw new ProcessingException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Service.CodeValuesService#getCodeAllType()
     */
    @Override
    public List<TCCodeType> getCodeAllType() throws ProcessingException {
        try{
            return codeTypeDao.getCodeAllType();
        }catch(DataAccessException e){
            Logger.getLogger(CodeValuesServiceImpl.class.getName()).log(Level.SEVERE, null, e);
            throw new ProcessingException();
        }
    }

    /* (non-Javadoc)
     * @see com.bestray.healthcareemr.Service.CodeValuesService#getCodeValues(java.lang.String)
     */
    @Override
    public List<TCCodeValues> getCodeValues(String codeTypeName)throws ProcessingException{
        TCCodeType codetype = null;
        try{
            List<TCCodeType> codeTypes = codeTypeDao.getCodeAllType();
            for(TCCodeType codeType:codeTypes){
                if(codeType.getCodeTypeName().equalsIgnoreCase(codeTypeName)){
                    codetype = codeType;
                }
            }
            return codeValuesDao.getCodeValues(codetype);
        }catch(DataAccessException e){
            Logger.getLogger(CodeValuesServiceImpl.class.getName()).log(Level.SEVERE, null, e);
            throw new ProcessingException();
        }
    }
}