/*
 * 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.EmployeeDao;
import com.bestray.transtracking.dao.PaymentVoucherDao;
import com.bestray.transtracking.dao.impl.EmployeeDaoImpl;
import com.bestray.transtracking.dao.impl.PaymentVoucherDaoImpl;
import com.bestray.transtracking.dto.PaymentVoucherSearchDTO;
import com.bestray.transtracking.exceptions.TransTrackException;
import com.bestray.transtracking.service.PaymentVoucherService;
import com.bestray.trastrack.domain.Employee;
import com.bestray.trastrack.domain.Party;
import com.bestray.trastrack.domain.PaymentVoucher;
import com.bestray.trastrack.domain.ViewDomain;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.sql.DataSource;

/**
 *
 * @author Bitu
 */
public class PaymentVoucherServiceImpl implements PaymentVoucherService {

    private PaymentVoucherDao paymentdao;
    private EmployeeDao employeeDao;
    DataSource ds;

    public PaymentVoucherServiceImpl() {
        ds = DataSourceObject.getDataSourceObject();
    }

    /*public List<Party> getPartyNameList() {
     paymentdao = new PaymentVoucherDaoImpl( DataSourceObject.getDataSourceObject());
     return paymentdao.findallReceipt();
     }
     public PaymentVoucher getTotalPartyBalance(Long partyId) {
     paymentdao = new PaymentVoucherDaoImpl( DataSourceObject.getDataSourceObject());
     return paymentdao.getTotalPartyBalance(partyId);
     }*/
    public List<Employee> getEmployeeNameList() {
        try {
            paymentdao = new PaymentVoucherDaoImpl(DataSourceObject.getDataSourceObject());
            return paymentdao.findAllEmployees();
        } catch (Exception ex) {
            Logger.getLogger(PaymentVoucherServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Employee Name List");
        }
    }

    public boolean collectPayment(PaymentVoucher payment) {
        try {
            paymentdao = new PaymentVoucherDaoImpl(DataSourceObject.getDataSourceObject());
            if (payment.getId() != null && payment.getId() > 0) {
                paymentdao.updatePayment(payment);
            } else {
                if (payment.getId() == null) {
                    paymentdao.savePayment(payment);
                }
            }
            return true;
        } catch (Exception ex) {
            Logger.getLogger(PaymentVoucherServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Collection Payment");
        }
    }

    public List<PaymentVoucher> getSearchResult(PaymentVoucherSearchDTO search) {
        try {
            DataSource ds = DataSourceObject.getDataSourceObject();
            //vehicleService = new VehicleServiceImpl();
            paymentdao = new PaymentVoucherDaoImpl(ds);
            employeeDao = new EmployeeDaoImpl(ds);
            List<PaymentVoucher> results = paymentdao.getSearchResults(search);
            for (PaymentVoucher object : results) {
                object.setEmployee(employeeDao.findEmplRegistraion(object.getEmployee_name_id()));
                //object.setClient(clientdao.findClientRegistraion(object.getClient_id()));
                //object.setVehicle(vehicleService.getVehicleRegistrationDetails(object.getVehicleId()));
            }
            return results;

        } catch (Exception ex) {
            Logger.getLogger(PaymentVoucherServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Payment Voucher");
        }
    }

    public PaymentVoucher getLastBalance(Long partyId) {
        try {
            paymentdao = new PaymentVoucherDaoImpl(ds);
            return paymentdao.getLastBalance(partyId);
        } catch (Exception ex) {
            Logger.getLogger(PaymentVoucherServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Last Balance");
        }
    }

    public ViewDomain getTotalOilBalance(Long partyId) {
        try {
            paymentdao = new PaymentVoucherDaoImpl(ds);
            return paymentdao.getTotalOilBalance(partyId);
        } catch (Exception ex) {
            Logger.getLogger(PaymentVoucherServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Party Information cannot be deleted");
        }
    }

    public ViewDomain getTotalPaymentBalance(Long partyId) {
        try {
            paymentdao = new PaymentVoucherDaoImpl(ds);
            return paymentdao.getTotalPaymentBalance(partyId);
        } catch (Exception ex) {
            Logger.getLogger(PaymentVoucherServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching total Payment Balance");
        }
    }

    public ViewDomain getTotalExpenseBalance(Long partyId) {
        try {
            paymentdao = new PaymentVoucherDaoImpl(ds);
            return paymentdao.getTotalExpenseBalance(partyId);
        } catch (Exception ex) {
            Logger.getLogger(PaymentVoucherServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching total expense balance");
        }
    }

    public PaymentVoucher getPaymentChangeById(Long id) {
        try {
            paymentdao = new PaymentVoucherDaoImpl(ds);
            return paymentdao.findById(id);
        } catch (Exception ex) {
            Logger.getLogger(PaymentVoucherServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching Payment Voucher");
        }
    }

    public void delete(Long id) {
        //PaymentVoucher payment = paymentdao.findPaymentDetails(clientId); 
        try {
            paymentdao = new PaymentVoucherDaoImpl(ds);
            paymentdao.delete(id);
        } catch (Exception ex) {
            Logger.getLogger(PartyServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in deleting Payment Voucher");
        }
    }

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

    public ViewDomain getPayment(Long partyId) throws TransTrackException {
        try {
            paymentdao = new PaymentVoucherDaoImpl(ds);
            return paymentdao.getTotalPayment(partyId);
        } catch (Exception ex) {
            Logger.getLogger(PaymentVoucherServiceImpl.class.getName()).log(Level.SEVERE, null, ex);
            throw new TransTrackException("Error in fetching total expense balance");
        }
    }
}