/*
 * 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.CodeDao;
import com.bestray.transtracking.dao.DriverStaffPaymentDao;
import com.bestray.transtracking.dao.EmployeeDao;
import com.bestray.transtracking.dao.VehicleDao;
import com.bestray.transtracking.dao.VehicleOwnerDao;
import com.bestray.transtracking.dao.impl.CodeDaoImpl;
import com.bestray.transtracking.dao.impl.DriverStaffPaymentDaoImpl;
import com.bestray.transtracking.dao.impl.EmployeeDaoImpl;
import com.bestray.transtracking.dao.impl.VehicleDaoImpl;
import com.bestray.transtracking.dto.EmployeePaymentSearchDTO;
import com.bestray.transtracking.exceptions.TransTrackException;
import com.bestray.transtracking.service.DriverStaffPaymentStaff;
import com.bestray.transtracking.service.EmployeeService;
import com.bestray.trastrack.domain.DriverStaffPayment;
import com.bestray.trastrack.domain.Employee;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.sql.DataSource;

/**
 *
 * @author user2
 */
public class DriverStaffPaymentServiceImpl implements DriverStaffPaymentStaff {

    private DriverStaffPaymentDao driverstaffpaymentdao;
    private DataSourceObject dobj;
    private CodeDao codeDao;
    private VehicleOwnerDao vehicleOwnerDao;
    private EmployeeDao employeeDao;
    private VehicleDao vehicleDao;
    private EmployeeService employeeService;

    public DriverStaffPaymentServiceImpl() {
    }

    public boolean registerDriverStaffPayment(DriverStaffPayment driverpaymentstaff) {
        try {
            driverstaffpaymentdao = new DriverStaffPaymentDaoImpl(DataSourceObject.getDataSourceObject());
            if (driverpaymentstaff.getId() != null && driverpaymentstaff.getId() > 0) {
                driverstaffpaymentdao.update(driverpaymentstaff);
            } else {
                if (driverpaymentstaff.getId() == null) {
                    driverstaffpaymentdao.addDriverStaffPayment(driverpaymentstaff);
                }
            }
        } catch (Exception ex) {
            Logger.getLogger(DriverStaffPaymentServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in registering Driver/Staff Payment");
        }
        return true;
    }

    /* public Vector<Vector<String>> getDriverStaffPaymentList() {
     codeDao = new CodeDaoImpl( DataSourceObject.getDataSourceObject());
     vehicleOwnerDao = new VehicleOwnerDaoImpl( DataSourceObject.getDataSourceObject());
     employeeDao = new EmployeeDaoImpl( DataSourceObject.getDataSourceObject());
     driverstaffpaymentdao = new DriverStaffPaymentDaoImpl( DataSourceObject.getDataSourceObject());
     Vector<Vector<String>> driverstaff = new Vector<Vector<String>>();
     List<DriverStaffPayment> driverstaffList = driverstaffpaymentdao.findAllDriverStaffPayment();
     for(DriverStaffPayment driverstaffpayment:driverstaffList){
     Code code = new Code();
     /*  Vector<String> driverStaffPaymentVector = new Vector<String>();
     driverStaffPaymentVector.add(String.valueOf(driverstaffpayment.getId()));
     driverStaffPaymentVector.add(driverstaffpayment.getEmployee_name_id());
              
     code = codeDao.getCodeById(driverstaffpayment.getCategoryCodeId()!= null?driverstaffpayment.getCategoryCodeId():0);
     if (code != null){
     driverStaffPaymentVector.add(code.getName());
              
        
        
        
     return null;*/
    public List<DriverStaffPayment> getSearchResult(EmployeePaymentSearchDTO search) {
        try {
            DataSource ds = DataSourceObject.getDataSourceObject();
            employeeDao = new EmployeeDaoImpl(ds);
            driverstaffpaymentdao = new DriverStaffPaymentDaoImpl(ds);
            List<DriverStaffPayment> results = driverstaffpaymentdao.getSearchResults(search);

            for (DriverStaffPayment object : results) {
                object.setEmployee(employeeDao.findEmplRegistraion((object.getEmployee_name_id())));
            }
            return results;
        } catch (Exception ex) {
            Logger.getLogger(DriverStaffPaymentServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in Fetching Search Details");
        }

    }

    public DriverStaffPayment getDriverPaymentDetails(Long driverpaymentId) {
        try {
            driverstaffpaymentdao = new DriverStaffPaymentDaoImpl(DataSourceObject.getDataSourceObject());
            codeDao = new CodeDaoImpl(DataSourceObject.getDataSourceObject());
            employeeDao = new EmployeeDaoImpl(DataSourceObject.getDataSourceObject());
            vehicleDao = new VehicleDaoImpl(DataSourceObject.getDataSourceObject());
            DriverStaffPayment driverstaffpayment = driverstaffpaymentdao.findDriverPaymentDetails(driverpaymentId);
            return driverstaffpayment;
        } catch (Exception ex) {
            Logger.getLogger(DriverStaffPaymentServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in Fetching Driver Payment Details");
        }

    }

    public void delete(Long id) {
        try {
            driverstaffpaymentdao = new DriverStaffPaymentDaoImpl(DataSourceObject.getDataSourceObject());
            driverstaffpaymentdao.delete(id);
        } catch (Exception ex) {
            Logger.getLogger(DriverStaffPaymentServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in Delete Record");
        }
    }

    public DriverStaffPayment getEmployeeRegistrationDetails(Long employeeID) throws TransTrackException {
         try { 
        driverstaffpaymentdao = new DriverStaffPaymentDaoImpl(DataSourceObject.getDataSourceObject());
         DriverStaffPayment driverstaffpayment = driverstaffpaymentdao.findEmployeeRegistration(employeeID);
        return driverstaffpayment;
        } catch (Exception ex) {
            Logger.getLogger(DriverStaffPaymentDaoImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Driver Record");
        }
        
    }

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

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