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

import com.bestray.transporttracking.DataSourceObject;
import com.bestray.transtracking.dao.ClientCollectionDao;
import com.bestray.transtracking.dao.ClientDao;
import com.bestray.transtracking.dao.CodeDao;
import com.bestray.transtracking.dao.EmployeeDao;
import com.bestray.transtracking.dao.impl.ClientCollectionDaoImpl;
import com.bestray.transtracking.dao.impl.ClientDaoImpl;
import com.bestray.transtracking.dao.impl.CodeDaoImpl;
import com.bestray.transtracking.dao.impl.EmployeeDaoImpl;
import com.bestray.transtracking.dto.ClientCollectionSearchDTO;
import com.bestray.transtracking.service.ClientCollectionService;
import com.bestray.trastrack.domain.ClientCollection;
import com.bestray.trastrack.domain.ClientUser;
import com.bestray.trastrack.domain.Employee;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.sql.DataSource;
import com.bestray.transtracking.exceptions.TransTrackException;
import com.bestray.trastrack.domain.CollectionCalcu;
import java.util.ArrayList;
/**
 *
 * @author user3
 */
public class ClientCollectionServiceImpl implements ClientCollectionService{
    private ClientCollectionDao collectiondao;
    private EmployeeDao employeeDao;
    private ClientDao clientdao;
    private CodeDao codedao;
    
    
    public ClientCollectionServiceImpl(){
        
    }
    
    public List<ClientCollection> getSearchResult(ClientCollectionSearchDTO search) {
        List<ClientCollection> results = new ArrayList<ClientCollection>();
        try{
        DataSource ds =  DataSourceObject.getDataSourceObject();
        //vehicleService = new VehicleServiceImpl();
         collectiondao = new ClientCollectionDaoImpl(ds);
         employeeDao = new EmployeeDaoImpl(ds);
             results = collectiondao.getSearchResults(search);
            for(ClientCollection object :results){
                object.setEmployee(employeeDao.findEmplRegistraion(object.getRecived_person_id()));
                //object.setClient(clientdao.findClientRegistraion(object.getClient_id()));
                //object.setVehicle(vehicleService.getVehicleRegistrationDetails(object.getVehicleId()));
            }
             }catch(Exception e){
           throw new TransTrackException("Error in Fetching Job Entry");
       }
         return results; 
    }
    
    public boolean collectClient(ClientCollection collect) throws TransTrackException{
      boolean flag = false;
        try{
          
        clientdao = new ClientDaoImpl( DataSourceObject.getDataSourceObject());
        codedao = new CodeDaoImpl( DataSourceObject.getDataSourceObject());
        employeeDao = new EmployeeDaoImpl( DataSourceObject.getDataSourceObject()); 
        collectiondao = new ClientCollectionDaoImpl( DataSourceObject.getDataSourceObject());
        if(collect.getId()!=null && collect.getId()>0){
          collectiondao.updateCollection(collect);
       }
        else{
            if(collect.getId()==null){
                collectiondao.saveCollection(collect);
                flag = true;
            }
        }
         }catch(Exception e){
           throw new TransTrackException("Error in Fetching Job Entry");
       }
        return flag;
    }
    
    public List<ClientUser> getClientNameList() {
        List<ClientUser> list = new ArrayList<ClientUser>(); 
       try{
        collectiondao = new ClientCollectionDaoImpl( DataSourceObject.getDataSourceObject());
        list =  collectiondao.findAllClients();
       }catch(Exception e){
           throw new TransTrackException("Error in Fetching Client Name");
       }
        return list;
    }

    public ClientCollection getClientCollectionDetails(Long collectionId) throws TransTrackException{
        ClientCollection collection ;
       try{
        collectiondao = new ClientCollectionDaoImpl( DataSourceObject.getDataSourceObject());
        clientdao = new ClientDaoImpl( DataSourceObject.getDataSourceObject());
        codedao = new CodeDaoImpl( DataSourceObject.getDataSourceObject());
       collection = collectiondao.findCollectionDetails(collectionId);
 }catch(Exception e){
           throw new TransTrackException("Error in Fetching Client Collection");
       }
        return collection;
    }

    public void deleteTransaction(Long clientId) throws TransTrackException{
      try{
        ClientCollection collection = collectiondao.findCollectionDetails(clientId);
        if(collection.getClient_id()!=null){
            
                collectiondao.delete(clientId);
                 }
            }catch(Exception ex){
                 Logger.getLogger(ClientCollectionServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
                 
                 throw new TransTrackException("Error in Delete Transaction");
            }
       
    }

    public List<Employee> getEmployeeNameList() {
        List<Employee> list = new ArrayList<Employee>();
        collectiondao = new ClientCollectionDaoImpl( DataSourceObject.getDataSourceObject());
        try {
            list = collectiondao.findAllEmployees();
        } catch (Exception ex) {
            Logger.getLogger(ClientCollectionServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in Fetching Employee Name List");
        }
       return list;
    }

    public CollectionCalcu getPayment(Long clientId) throws TransTrackException {
        try {
            collectiondao = new ClientCollectionDaoImpl(DataSourceObject.getDataSourceObject());
            return collectiondao.getTotalPayment(clientId);
        } catch (Exception ex) {
            Logger.getLogger(ClientCollectionServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching total balance");
        }
    }
    
}