package enquêtes;

import java.sql.ResultSet;
import eskuel.CMI_SQL;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import javax.servlet.*;
import javax.servlet.http.*;

public class Beeld3 extends HttpServlet {
    String databaselocatie = "jdbc:mysql://mysql.cmi-hro.nl:3306/cmi0800004";
    String gebruikernaam = "cmi0800004";
    String toegangscode = "n84pc7vj";
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();



        String klantID = (String) request.getSession().getAttribute("Username"); //aanpassen: kijken hoe de klant id in de inlog wordt geïnitialiseerd.

        CMI_SQL sql = new CMI_SQL(databaselocatie, gebruikernaam, toegangscode); //aanpassen: sasahs school database.
        String verblijf;
        String gegevens = "";

        String query = "select accomodatie.accoType from accomodatie join booking on (accomodatie.accoType = booking.accoID) join klant on (booking.accoID = klant.klandID) where klant.klantID = " + klantID + ""; // sarah deze string laten testen in haar database. string kom je aan door system.out.println
        ResultSet accomodatie = sql.selectieQuery(query);

        String acco = "";
        acco += accomodatie;
        try {
            while (accomodatie.next()) {
                verblijf = accomodatie.getString("accomodatie"); // in de database: kolom naam waar de acco's in staan.
                gegevens +=verblijf;
            }
            if (acco.equals("Hotel")) {
               String v1 = request.getParameter("v1");
               String v2 = request.getParameter("v2");
               String v3 = request.getParameter("v3");
               String v4 = request.getParameter("v4");
               String v5 = request.getParameter("v5");
               String v7 = request.getParameter("v7");
               String query2 = "insert into DATABASE (v1, v2, v3, v4, v5, v7) values ('" + v1 + "','" + v2 + "','" + v3 + "','" + v4 + "','" + v5 + "','"+ v7 +"')";
               sql.insertQuery(query2);
            }
            if (acco.equals("Appartement")) {
               String v1 = request.getParameter("v1");
               String v2 = request.getParameter("v2");
               String v3 = request.getParameter("v3");
               String v4 = request.getParameter("v4");
               String v5 = request.getParameter("v5");
               String v6 = request.getParameter("v6");
               String v7 = request.getParameter("v7");
               String query2 = "insert into DATABASE (v1, v2, v3, v4, v5, v6, v7) values ('" + v1 + "','" + v2 + "','" + v3 + "','" + v4 + "','" + v5 + "','" + v6 + "','"+ v7 +"')";
               sql.insertQuery(query2);
            }
            if (acco.equals("Vakantiewoning")) {
               String v1 = request.getParameter("v1");
               String v2 = request.getParameter("v2");
               String v3 = request.getParameter("v3");
               String v4 = request.getParameter("v4");
               String v5 = request.getParameter("v5");
               String v6 = request.getParameter("v6");
               String query2 = "insert into DATABASE (v1, v2, v3, v4, v5, v6) values ('" + v1 + "','" + v2 + "','" + v3 + "','" + v4 + "','" + v5 + "','" + v6 + "')";
               sql.insertQuery(query2);
            }
            if (acco.equals("Stacaravan")) {
               String v1 = request.getParameter("v1");
               String v2 = request.getParameter("v2");
               String v3 = request.getParameter("v3");
               String v4 = request.getParameter("v4");
               String v5 = request.getParameter("v5");
               String v6 = request.getParameter("v6");
               String query2 = "insert into DATABASE (v1, v2, v3, v4, v5, v6) values ('" + v1 + "','" + v2 + "','" + v3 + "','" + v4 + "','" + v5 + "','" + v6 + "')";
               sql.insertQuery(query2);
            }
            if (acco.equals("Tent")) {
                String v6 = request.getParameter("v6");
                String query2 = "insert into DATABASE (v6) values ('" + v6 + "')";
                sql.insertQuery(query2);
            }

            request.setAttribute("Accomodatie", gegevens);// dit geeft de gegevens van deze servlet door naar alleen de volgende jsp

            String nextJSP = "/scherm3.jsp";
            RequestDispatcher dispatcher = getServletContext().getRequestDispatcher(nextJSP);
            dispatcher.forward(request, response); // dit forward de browser naar de behorende jsp. met gegevens.

        } catch (SQLException e_sql) {
        }




//            //haal alle producten uit product tabel
//            String query = "Select * from VRAAG where PaginaNr='1' ";
//            //voer de query uit
//            ResultSet resultaat = sql.selectieQuery(query);
//            // toon de resultaten in een tabel
//            while(resultaat.next()){
//                String vraagID = resultaat.getString("VRAAG.VraagID");
//                out.print("<select name='"+vraagID+"'>");
//                while(/*get the related options from meerkeuze table*/){
//                    String waarde = /*..the value of option at this row...*/
//                    out.println("<option value='"+waarde+"'>"+waarde+"</option>");
//                }
//                out.println("</select>");
//            }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}