package modelo;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

public class VeiculoDao {

    public static boolean cadastrar(VeiculoBean veiculo) {
        try {
            Connection con = ConexaoFactory.getConexao();
            StringBuilder sb = new StringBuilder();
            sb.append("INSERT INTO VEICULO VALUES(");
            sb.append("?,?,?,?,?,?,?,?");
            sb.append(")");
            PreparedStatement p = con.prepareStatement(sb.toString());
            p.setString(1, veiculo.getNumChassi());
            p.setString(2, veiculo.getMarca());
            p.setString(3, veiculo.getModelo());
            p.setString(4, veiculo.getCor());
            p.setString(5, veiculo.getTipoCombustivel() + "");
            p.setDouble(6, veiculo.getPreco());
            p.setInt(7, veiculo.getAnoFabricacao());
            p.setInt(8, veiculo.getAnoModelo());
            p.executeUpdate();
            p.close();
            ConexaoFactory.fechar();
            return true;
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
            return false;
        }
    }

    public static boolean atualizar(VeiculoBean veiculo) {
        return false;
    }

    public static boolean remover(String numChassi) {
        try {
            Connection con = ConexaoFactory.getConexao();
            StringBuilder sb = new StringBuilder();
            sb.append("DELETE FROM VEICULO WHERE NUMCHASSI = ?");
            PreparedStatement p = con.prepareStatement(sb.toString());
            p.setString(1, numChassi);
            p.executeUpdate();
            p.close();
            ConexaoFactory.fechar();
            return true;
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
            return false;
        }
    }

    public static ArrayList<VeiculoBean> getTodos() {
        ArrayList<VeiculoBean> todos = new ArrayList<VeiculoBean>();
        try {
            Connection con = ConexaoFactory.getConexao();
            StringBuilder sb = new StringBuilder();
            sb.append("SELECT * FROM VEICULO");
            PreparedStatement p = con.prepareStatement(sb.toString());
            ResultSet rs = p.executeQuery();
            todos = new ArrayList<VeiculoBean>();
            while (rs.next()) {
                VeiculoBean v = new VeiculoBean();
                v.setNumChassi(rs.getString("numChassi"));
                v.setMarca(rs.getString("marca"));
                v.setModelo(rs.getString("modelo"));
                v.setCor(rs.getString("cor"));
                v.setTipoCombustivel(rs.getString("tipo").charAt(0));
                v.setAnoFabricacao(rs.getInt("anofabricacao"));
                v.setAnoModelo(rs.getInt("anomodelo"));
                v.setPreco(rs.getDouble("preco"));
                todos.add(v);
            }
            p.close();
            ConexaoFactory.fechar();
        } catch (Exception ex) {
            System.out.println(ex.getMessage());
        }
        return todos;
    }

    public static VeiculoBean getNumChassi(String numChassi) {
        return null;
    }

    public static ArrayList<VeiculoBean> getMarcas(String marca) {
        return null;
    }

    public static ArrayList<VeiculoBean> getModelos(String modelo) {
        return null;
    }

}