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

import com.bestray.trastrack.domain.DriverStaffPayment;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.ResultSetExtractor;

/**
 *
 * @author user2
 */
public class DriverStaffPaymentResultSetExtractor implements  ResultSetExtractor<Object>{

    public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
         List <DriverStaffPayment> driverstaffpayments = new ArrayList<DriverStaffPayment>();
         
          while (rs.next()) {
            DriverStaffPayment driverstaffpayment = new DriverStaffPayment();
            driverstaffpayment.setId(rs.getLong("id"));
            //driverstaffpayment.setPayment_scroll_id(rs.getLong("payment_scroll_id"));
            driverstaffpayment.setPayment_date(rs.getDate("payment_date"));
            driverstaffpayment.setVehicle_number_id(rs.getLong("vehicle_number_id"));
            driverstaffpayment.setEmployee_name_id(rs.getLong("employee_name_id"));
            driverstaffpayment.setEmployee_type_id(rs.getLong("employee_type_id"));
            driverstaffpayment.setPayment_amount(rs.getFloat("payment_amount"));
            driverstaffpayment.setNote_1(rs.getString("note_1"));
            driverstaffpayment.setNote_2(rs.getString("note_2"));
            driverstaffpayments.add(driverstaffpayment);
        }
        return driverstaffpayments;
    }
    
}