/*
 * 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.CostToVehicleDao;
import com.bestray.transtracking.dao.EmployeeDao;
import com.bestray.transtracking.dao.VehicleDao;
import com.bestray.transtracking.dao.VehicleExpenseDao;
import com.bestray.transtracking.dao.impl.CodeDaoImpl;
import com.bestray.transtracking.dao.impl.CostToVehicleDaoImpl;
import com.bestray.transtracking.dao.impl.EmployeeDaoImpl;
import com.bestray.transtracking.dao.impl.VehicleDaoImpl;
import com.bestray.transtracking.dao.impl.VehicleExpenseDaoImpl;
import com.bestray.transtracking.dto.CostToVehicleSearchDTO;
import com.bestray.transtracking.exceptions.TransTrackException;
import com.bestray.transtracking.service.CostToVehicleService;
import com.bestray.transtracking.service.VehicleService;
import com.bestray.trastrack.domain.CostToVehicle;
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 CostToVehicleServiceImpl implements CostToVehicleService{
    
    private CostToVehicleDao vehiclecostDao;
    private CodeDao codedao;
    private EmployeeDao employeeDao;
    private VehicleDao vehicledao;

    public CostToVehicleServiceImpl() {
    }
    
    public List<Vehicle> getOwnedVehicleList() throws TransTrackException {
        try {
            vehiclecostDao = new CostToVehicleDaoImpl(DataSourceObject.getDataSourceObject());
            return vehiclecostDao.findOwnedVehicleList();
        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching  Vehicle Deails");
        }
    }

    
    public boolean SaveCostToVehicleEntry(CostToVehicle costTovehicle) {
       try {
            vehiclecostDao= new CostToVehicleDaoImpl(DataSourceObject.getDataSourceObject());
            if (costTovehicle.getId() != null && costTovehicle.getId() > 0) 
            {
                vehiclecostDao.update(costTovehicle);
            } 
            else 
            {
                vehiclecostDao.addCostToVehicle(costTovehicle);
            }
            return true;
        } catch (Exception ex) {
            Logger.getLogger(CostToVehicleServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Cost to Vehicle Data");
        }
    }

    
    public List<CostToVehicle> getSearchResult(CostToVehicleSearchDTO search) {
        try {
            DataSource ds = DataSourceObject.getDataSourceObject();
            codedao = new CodeDaoImpl(ds);
            vehicledao = new VehicleDaoImpl(ds);
            employeeDao = new EmployeeDaoImpl(ds);
            

            List<CostToVehicle> results = vehiclecostDao.getSearchResults(search);
            for (CostToVehicle object : results) {
                object.setVehicle(vehicledao.findVehicleRegistraion(object.getVehicle_id()));
                object.setEmployee(employeeDao.findEmplRegistraion(object.getPaid_by_id()));
            }

            return results;
        } catch (Exception ex) {
            Logger.getLogger(VehicleExpenseServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Vehicle Expense records");
        }
    }

    @Override
    public CostToVehicle getCostToVehicleRegistrationDetails(Long costovehicleID) {
        DataSource ds = DataSourceObject.getDataSourceObject();
        try{    
        codedao = new CodeDaoImpl(ds);
            vehicledao = new VehicleDaoImpl(ds);
            employeeDao = new EmployeeDaoImpl(ds);
            vehiclecostDao = new CostToVehicleDaoImpl(ds);
            CostToVehicle costvehicle = vehiclecostDao.findCostToVehicleEntryRegistraion(costovehicleID);
            return costvehicle;
        }catch(Exception ex)
        {
            Logger.getLogger(CostToVehicleServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching job Records");
        }
    }

    @Override
    public void delete(Long id) throws TransTrackException {
        DataSource ds = DataSourceObject.getDataSourceObject();
        try {
            vehiclecostDao = new CostToVehicleDaoImpl(ds);
            vehiclecostDao.delete(id);
        } catch (Exception ex) {
            Logger.getLogger(CostToVehicleServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in deleting Cost to Vehicle Data");
        }
    }

    public Double getTotalOfficeExpense() throws TransTrackException {
        
        try {
            vehiclecostDao = new CostToVehicleDaoImpl(DataSourceObject.getDataSourceObject());
            return vehiclecostDao.getTotalOfficeExpense();
        } catch (Exception ex) {
            Logger.getLogger(CostToVehicleServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in getting Total Office Expenses");
        }
    }

    public Double getTotalCostToVehicles() throws TransTrackException {
        try {
            vehiclecostDao = new CostToVehicleDaoImpl(DataSourceObject.getDataSourceObject());
            return vehiclecostDao.getTotalCostToVehicles();
        } catch (Exception ex) {
            Logger.getLogger(CostToVehicleServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in getting Total Office Expenses");
        }
    }

    @Override
    public List<Vehicle> getOwnedVehicleSearchList() throws TransTrackException {
        try {
            vehiclecostDao = new CostToVehicleDaoImpl(DataSourceObject.getDataSourceObject());
            return vehiclecostDao.findOwnedVehicleSearchList();
        } catch (Exception ex) {
            Logger.getLogger(JobEntryServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching  Vehicle Deails");
        }
    }
    
}