package desguace;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;

import desguaceForms.registroVehiculosForm;


public class registrarVehicDAO {
   public void registrarVehic(registroVehiculosForm rvehiculosForm){

	 try {
		 Class.forName("oracle.jdbc.OracleDriver");
	     Connection conexion = DriverManager.getConnection(
	     "jdbc:oracle:thin:@127.0.0.1:1521:TALLER","TALLER","TALLER");
	     //recogemos el nom_modelo del formulario y comprobamos si existe en la BBDD

	     String existe = ("SELECT ID_MODELO FROM MODELO WHERE NOM_MODELO='"+ rvehiculosForm.getNom_modelo()+"'");
	     PreparedStatement pst1 = conexion.prepareStatement(existe);
	     ResultSet rs1 = pst1.executeQuery();
	     String insertar;
	     String insertar2;

	     if (rs1== null){
	     insertar2 = ("INSERT INTO MODELO (id_modelo, nom_modelo) VALUES" +
	     		" (MAX(id_modelo)+1, "+ rvehiculosForm.getNom_modelo()+")");
	     PreparedStatement pst2 = conexion.prepareStatement(insertar2);
	     pst2.executeUpdate();
	   	 insertar = ("INSERT INTO COCHE (matricula, id_modelo, id_entrada, id_salida) VALUES " +
	   	 		"(?,(SELECT id_modelo FROM MODELO WHERE id_modelo=MAX(id_modelo)),?,?)");

	     }
	     else {
	     insertar = ("INSERT INTO COCHE (matricula, id_modelo, id_entrada, id_salida) VALUES" +
	     		" (?,(SELECT id_modelo FROM MODELO WHERE nom_modelo= "+ rvehiculosForm.getNom_modelo()+"),?,?)");

	     }
	     PreparedStatement pst =conexion.prepareStatement(insertar);

	     SimpleDateFormat sdf= new SimpleDateFormat("dd/MM/yyyy");

	     Date entrada = sdf.parse(rvehiculosForm.getId_entrada());
	     Date salida = sdf.parse(rvehiculosForm.getId_salida());

	     java.sql.Date entradaS = new java.sql.Date(entrada.getTime());
	     java.sql.Date salidaS = new java.sql.Date(salida.getTime());

	     pst.setString(1, rvehiculosForm.getMatricula());
	     //pst.setInt(2, Integer.parseInt(rvehiculosForm.getId_modelo()));
	     pst.setDate(2, entradaS);
	     pst.setDate(3, salidaS);

	     pst.executeUpdate();

	     pst.close();

	     conexion.close();
	 }catch (Exception e){
		 e.printStackTrace();
     }
   }

//fin clase
}