/*
 * 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.VehicleMaintenance;
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 VehicleMaintenanceResultSetExtractor implements  ResultSetExtractor<Object>{

    public Object extractData(ResultSet rs) throws SQLException, DataAccessException {
        List <VehicleMaintenance> maintenancelist = new ArrayList<VehicleMaintenance>();
                   
                   while (rs.next()) {
            VehicleMaintenance maintenance = new VehicleMaintenance();
            maintenance.setId(rs.getLong("id"));
            //maintenance.setMaintenance_scroll_id(rs.getLong("vehicle_maintenance_scroll"));
            maintenance.setMaintenance_date(rs.getDate("alert_setup_date"));
            maintenance.setVehicle_id(rs.getLong("vehicle_id"));
            maintenance.setMaintenance_id(rs.getLong("maintenance_id"));
            maintenance.setNext_job_date(rs.getDate("maintenenance_job_date"));
            maintenance.setRemind_me_on(rs.getDate("remind_me_on"));
            maintenance.setMaintenance_status(rs.getLong("status_id"));
            maintenance.setNote(rs.getString("notes"));
            maintenance.setDistance(rs.getDouble("distance"));
            maintenance.setMaintenace_mtr_reading(rs.getDouble("maintenance_mtr_reading"));
            //maintenance.setNote2(rs.getString("note_2"));
            
            maintenancelist.add(maintenance);
        }
        return maintenancelist;
    }
    
}