package controllers;

import java.sql.*;
import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.*;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class PublishServlet
 */
@WebServlet("/PublishServlet")
public class PublishServlet extends HttpServlet {

	/**
	 *
	 */
	private static final long serialVersionUID = 7416565882855256169L;

	public PublishServlet() {
		super();
	}

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String label = request.getParameter("label");
		String model = request.getParameter("model");
		String engine = request.getParameter("engine");
		String gearbox = request.getParameter("gearbox");
		String price = request.getParameter("price");
		String month = request.getParameter("month");
		String year = request.getParameter("year");
		String km = request.getParameter("km");
		boolean twoThreeDoors = Boolean.parseBoolean(request.getParameter("twoThreeDoors"));
		boolean fourFiveDoors = Boolean.parseBoolean(request.getParameter("fourFiveDoors"));
		boolean ledLights = Boolean.parseBoolean(request.getParameter("ledLights"));
		boolean ksenonLights = Boolean.parseBoolean(request.getParameter("ksenonLights"));
		boolean halogenLights = Boolean.parseBoolean(request.getParameter("halogenLights"));
		boolean letiDjanti = Boolean.parseBoolean(request.getParameter("letiDjanti"));
		boolean teglich = Boolean.parseBoolean(request.getParameter("teglich"));
		boolean shibedah = Boolean.parseBoolean(request.getParameter("shibedah"));
		boolean alarma = Boolean.parseBoolean(request.getParameter("alarma"));
		boolean imobilizer = Boolean.parseBoolean(request.getParameter("imobilizer"));
		boolean kasko = Boolean.parseBoolean(request.getParameter("kasko"));
		boolean centralLocking = Boolean.parseBoolean(request.getParameter("centralLocking"));
		boolean fourXfour = Boolean.parseBoolean(request.getParameter("fourXfour"));
		boolean barter = Boolean.parseBoolean(request.getParameter("barter"));
		boolean gasSystem = Boolean.parseBoolean(request.getParameter("gasSystem"));
		boolean lizing = Boolean.parseBoolean(request.getParameter("lizing"));
		boolean newEntry = Boolean.parseBoolean(request.getParameter("newEntry"));
		boolean onParts = Boolean.parseBoolean(request.getParameter("onParts"));
		boolean withRegistration = Boolean.parseBoolean(request.getParameter("withRegistration"));
		boolean serviceBook = Boolean.parseBoolean(request.getParameter("serviceBook"));

		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/cars", "root",
					"Supergirl148752563-");

			String query = " insert into cars.cars_info (id, label, model, engine, gearbox, price, month, year, km, two_three_doors, four_five_doors, LED_lights, ksenon_lights, halogen_lights, leti_djanti, teglich, shibedah, alarm, imobilizer, casco, central_locking, fourXfour, barter, gasSystem, lizing, new_entry,on_parts, with_registration,serviceBook)"
					+ " values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

			// create the mysql insert preparedstatement
			PreparedStatement preparedStmt = con.prepareStatement(query);
			preparedStmt.setString(1, label);
			preparedStmt.setString(2, model);
			preparedStmt.setString(3, engine);
			preparedStmt.setString(4, gearbox);
			preparedStmt.setString(5, price);
			preparedStmt.setString(6, month);
			preparedStmt.setString(7, year);
			preparedStmt.setString(8, km);
			preparedStmt.setBoolean(9, twoThreeDoors);
			preparedStmt.setBoolean(10, fourFiveDoors);
			preparedStmt.setBoolean(11, ledLights);
			preparedStmt.setBoolean(12, ksenonLights);
			preparedStmt.setBoolean(13, halogenLights);
			preparedStmt.setBoolean(14, letiDjanti);
			preparedStmt.setBoolean(15, teglich);
			preparedStmt.setBoolean(16, shibedah);
			preparedStmt.setBoolean(17, alarma);
			preparedStmt.setBoolean(18, imobilizer);
			preparedStmt.setBoolean(19, kasko);
			preparedStmt.setBoolean(20, centralLocking);
			preparedStmt.setBoolean(21, fourXfour);
			preparedStmt.setBoolean(22, barter);
			preparedStmt.setBoolean(23, gasSystem);
			preparedStmt.setBoolean(24, lizing);
			preparedStmt.setBoolean(25, newEntry);
			preparedStmt.setBoolean(26, onParts);
			preparedStmt.setBoolean(27, withRegistration);
			preparedStmt.setBoolean(28, serviceBook);

			// execute the preparedstatement
			preparedStmt.execute();

			con.close();
		} catch (Exception e) {
			System.out.println(e);
		}
	}
}