/*
 * 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.CostToVehicle;
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 User1
 */
public class CostToVehicleResultSetExtractor implements  ResultSetExtractor<Object>{
    
    public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
         List <CostToVehicle> costtovehicles = new ArrayList<CostToVehicle>();
         
          while (rs.next()) {
            CostToVehicle costtovehicle = new CostToVehicle();
            costtovehicle.setId(rs.getLong("id"));
            costtovehicle.setCost_to_vehicle_date(rs.getDate("cost_to_vehicle_date"));
            costtovehicle.setVehicle_id(rs.getLong("vehicle_id"));
            costtovehicle.setPaid_mode_id(rs.getLong("paid_mode_id"));
            costtovehicle.setCost_amount(rs.getDouble("cost_amount"));
            costtovehicle.setPaid_by_id(rs.getLong("paid_by_id"));
            costtovehicle.setNote(rs.getString("note"));
            costtovehicles.add(costtovehicle);
        }
        return costtovehicles;
    }
    
}