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

import com.bestray.transtracking.dao.AlertDao;
import com.bestray.transtracking.dao.mapper.VehicleResultSetExtractor;
import com.bestray.trastrack.domain.Vehicle;
import com.bestray.trastrack.domain.VehicleMaintenance;
import java.lang.String;
import java.util.List;
import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;

/**
 *
 * @author sumitHome
 */
public class AlertDaoImpl implements AlertDao{
    
    private DataSource ds;
    private JdbcTemplate jdbcTemplate;

    public AlertDaoImpl(DataSource ds) {
        
        jdbcTemplate = new JdbcTemplate(ds);
        
    }

    public int updateAlert(VehicleMaintenance vehicleMaintenance) throws Exception{
         String sql = "update vehicle_maintenance_alert set status_id =? where id = ?";      
        return jdbcTemplate.update(sql, new Object[]{vehicleMaintenance.getMaintenance_status(),vehicleMaintenance.getId()});
        
    }

    @Override
    public void updateVehicleMaster(Long vehicle_id) throws Exception {
        Double currmtr=0.0;
        String sql1="select * from vehicle_master where id= ?"; 
        List<Vehicle> vehicle=(List<Vehicle>)jdbcTemplate.query(sql1, new Object[]{vehicle_id},new VehicleResultSetExtractor()); 
        for(Vehicle v:vehicle){
          currmtr=v.getCurrentMeterReading();  
        }
      
        
        String sql = "update vehicle_master set last_meter_reading=? where vehicle_master.`id` = ?";      
       jdbcTemplate.update(sql, new Object[]{currmtr,vehicle_id});
    }
    
        
}