/*
 * 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.ClientDao;
import com.bestray.transtracking.dao.EmployeeDao;
import com.bestray.transtracking.dao.JobEntryDao;
import com.bestray.transtracking.dao.VehicleDao;
import com.bestray.transtracking.dao.impl.ClientDaoImpl;
import com.bestray.transtracking.dao.impl.EmployeeDaoImpl;
import com.bestray.transtracking.dao.impl.JobEntryDaoImpl;
import com.bestray.transtracking.dto.JobEntrySearchDTO;
import com.bestray.transtracking.exceptions.TransTrackException;
import com.bestray.transtracking.service.JobEntryService;
import com.bestray.transtracking.service.VehicleService;
import com.bestray.trastrack.domain.ClientUser;
import com.bestray.trastrack.domain.Employee;
import com.bestray.trastrack.domain.JobEntry;
import com.bestray.trastrack.domain.Party;
import com.bestray.trastrack.domain.Vehicle;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.sql.DataSource;

/**
 *
 * @author User1
 */
public class JobEntryServiceImpl implements JobEntryService {

    private JobEntryDao jedao;
    private DataSourceObject dobj;
    private VehicleService vehicleService;
    private ClientDao clientDao;
    private EmployeeDao empdao;
    private VehicleDao vehicleDao;

    public JobEntryServiceImpl() {
    }

    /*public boolean registerJob(JobEntry jobentry) {
        try {
            jedao = new JobEntryDaoImpl(DataSourceObject.getDataSourceObject());
            if (jobentry.getId() != null && jobentry.getId() > 0) {
                jedao.updateJob(jobentry);
            } else {
                if (jobentry.getId() == null) {
                    jedao.scheduleJob(jobentry);
                }
            }
            return true;
        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in registering a job Records");
        }
    }*/
    
    public Long saveJobEntry(JobEntry jobentry) {
        try {
            jedao = new JobEntryDaoImpl(DataSourceObject.getDataSourceObject());
            
            Long jobentryId;
            if (jobentry.getId() != null && jobentry.getId() > 0) {
                jobentryId = jedao.updateJob(jobentry);
            } else {
                //if (jobentry.getId() == null) {
                jobentryId = jedao.saveVehicleJobEntry(jobentry);
             
            }

            return jobentryId;
        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in Saveing Vehicle Job Entry");
        }

    }

    public List<JobEntry> getSearchResult(JobEntrySearchDTO search) {
        try {
            DataSource ds = DataSourceObject.getDataSourceObject();
            vehicleService = new VehicleServiceImpl();
            jedao = new JobEntryDaoImpl(ds);
            clientDao = new ClientDaoImpl(ds);
            empdao = new EmployeeDaoImpl(ds);
            List<JobEntry> results = jedao.getSearchResults(search);
            for (JobEntry object : results) {
                object.setClient(clientDao.findClientRegistraion(object.getClient_name_id()));
                object.setVehicle(vehicleService.getVehicleRegistrationDetails(object.getVehicle_number_id()));
                object.setDriver(empdao.findEmplRegistraion(object.getVehicle_driver_id()));
            }
            return results;
        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching job Records");
        }
    }

    public JobEntry getJobRegistrationDetails(Long JobId) {
        try {
            jedao = new JobEntryDaoImpl(DataSourceObject.getDataSourceObject());
            //vehicleDao = new VehicleDaoImpl( DataSourceObject.getDataSourceObject());
            clientDao = new ClientDaoImpl(DataSourceObject.getDataSourceObject());

            JobEntry jentry = jedao.findJobEntryRegistraion(JobId);

            /* if(jentry != null && jentry.getVehicle_number_id() != null){
             jentry.setVehicle(vehicleDao.getVehicleNumberById(jentry.getVehicle_number_id()));
             }
        
             if(jentry != null && jentry.getClient_name_id() != null){
             jentry.setClient(clientDao.getClientNameById(jentry.getClient_name_id()));
             }*/
            return jentry;
        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching job Records");
        }
    }

    public void deleteJobEntryRecord(Long JobId) {
        //JobEntry jentry = jedao.findJobEntryRegistraion(JobId);
        try {
            jedao.delete(JobId);

        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in deleteing Job Entry Records");
        }
    }

    public List<JobEntry> getSearchResult2(JobEntrySearchDTO search) {
        try {
            DataSource ds = DataSourceObject.getDataSourceObject();
            vehicleService = new VehicleServiceImpl();
            jedao = new JobEntryDaoImpl(ds);
            clientDao = new ClientDaoImpl(ds);
            empdao = new EmployeeDaoImpl(ds);
            List<JobEntry> results = jedao.getSearchResults2(search);
            for (JobEntry object : results) {
                object.setClient(clientDao.findClientRegistraion(object.getClient_name_id()));
                object.setVehicle(vehicleService.getVehicleRegistrationDetails(object.getVehicle_number_id()));
                object.setDriver(empdao.findEmplRegistraion(object.getVehicle_driver_id()));
            }
            return results;
        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching job Records");
        }
    }

    public List<Vehicle> getvehicleNumberList() throws TransTrackException {
        try {
            jedao = new JobEntryDaoImpl(DataSourceObject.getDataSourceObject());
            return jedao.findVehiclesList();
        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching  Vehicle Details");
        }
    }

    public List<Employee> getDriverNameList() throws TransTrackException {
        try {
            jedao = new JobEntryDaoImpl(DataSourceObject.getDataSourceObject());
            return jedao.findEmployeesList();
        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Driver Record");
        }
    }

    public List<ClientUser> getAllClientNameList() throws TransTrackException {
        try {
            jedao = new JobEntryDaoImpl(DataSourceObject.getDataSourceObject());
            return jedao.findAllClientsList();
        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Driver Record");
        }
    }

    public List<Employee> getAllDriverNameList() throws TransTrackException {
        try {
            jedao = new JobEntryDaoImpl(DataSourceObject.getDataSourceObject());
            return jedao.findAllEmployeesList();
        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Driver Record");
        }
    }

    public List<Vehicle> getALLvehicleNumberList() throws TransTrackException {
        try {
            jedao = new JobEntryDaoImpl(DataSourceObject.getDataSourceObject());
            return jedao.findAllVehicleList();
        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Driver Record");
        }
    }

    @Override
    public List<Party> getAllPartyNameList() throws TransTrackException {
       try {
            jedao = new JobEntryDaoImpl(DataSourceObject.getDataSourceObject());
            return jedao.findAllPartysNames();
        } catch (Exception ex) {
            Logger.getLogger(PaymentVoucherServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Employee Name List");
        }
    }
}