/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package fact.it.www;

import fact.it.www.beans.Periode;
import fact.it.www.beans.Aanbod;
import fact.it.www.beans.Hotel;
import fact.it.www.beans.Skigebied;
import fact.it.www.dataaccess.DaAanbod;
import fact.it.www.dataaccess.DaHotel;
import fact.it.www.dataaccess.DaPeriode;
import fact.it.www.dataaccess.DaSkigebied;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.annotation.WebInitParam;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet(name = "ManageServlet", urlPatterns = {"/ManageServlet"}, initParams = {
    @WebInitParam(name = "url", value = "jdbc:oracle:thin:@localhost:1521:XE"),
    @WebInitParam(name = "login", value = "admin"),
    @WebInitParam(name = "password", value = "sql"),
    @WebInitParam(name = "driver", value = "oracle.jdbc.driver.OracleDriver")})

public class ManageServlet extends HttpServlet {

        private DaAanbod daaanbod = null;
        private DaHotel dahotel = null;
        private DaPeriode daperiode = null;
        private DaSkigebied daskigebied = null;

        @Override
        public void init() throws ServletException {
            try {
                String url = getInitParameter("url");
                String login = getInitParameter("login");
                String password = getInitParameter("password");
                String driver = getInitParameter("driver");
                if (daaanbod == null) {
                    daaanbod = new DaAanbod(url, login, password, driver);
                }
                if (dahotel == null) {
                    dahotel = new DaHotel(url, login, password, driver);
                }
                if (daperiode == null) {
                    daperiode = new DaPeriode(url, login, password, driver);
                }
                if (daskigebied == null) {
                    daskigebied = new DaSkigebied(url, login, password, driver);
                }
            } catch (ClassNotFoundException | SQLException e) {
                throw new ServletException(e);
            }
        }

        @Override
        public void destroy() {
            try {
                if (daaanbod != null) {
                    daaanbod.close();
                }
                if (dahotel != null) {
                    dahotel.close();
                }
                if (daperiode != null) {
                    daperiode.close();
                }
                if (daskigebied != null) {
                    daskigebied.close();
                }
            } catch (SQLException ex) {

            }
        }

    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        RequestDispatcher rd = null;
        if (request.getParameter("skigebiedKnop") !=null){
            Skigebied skigebied = daskigebied.getSkigebied();
            request.setAttribute("skigebied", skigebied);
            rd = request.getRequestDispatcher("skigebied.jsp");
        } else if (request.getParameter("hotelKnop") != null) {
            Hotel hotel = dahotel.getHotel();
            request.setAttribute("hotel", hotel);
            rd = request.getRequestDispatcher("hotel.jsp");
        } else if (request.getParameter("skigebiedZoek") != null) {
            String skigebiedZoek = request.getParameter("skigebiedZoek");
            Skigebied skigebied = daskigebied.getSkigebied(skigebiedZoek);
            if (skigebied != null) {
                request.setAttribute("skigebied", skigebied);
                rd = request.getRequestDispatcher("skigebied.jsp");
            } else {
                String foutboodschap = "Geen skigebied gevonden.";
                request.setAttribute("foutboodschap", foutboodschap);
                rd = request.getRequestDispatcher("fout.jsp");
            }
        }
        if (request.getParameter("lijsthotelKnop") != null) {

            ArrayList<Hotel> hotels = dahotel.getHotels();
            request.setAttribute("hotels", hotels);
            rd = request.getRequestDispatcher("overzichtHotels.jsp");
         }
        else if(request.getParameter("hotelid") != null) {
            int hotelid = Integer.parseInt(request.getParameter("hotelid"));
            Hotel hotel = dahotel.getHotel(hotelid);
            if(hotel != null){
            request.setAttribute("hotel", hotel);
            rd = request.getRequestDispatcher("hoteldetails.jsp");
            }
        }
        if (request.getParameter("lijstaanbodKnop") != null) {
            ArrayList<Periode> periodelijst = daperiode.getPeriodelijst();
            ArrayList<Aanbod> aanbodfilter = daaanbod.getAanbodfilter();
            request.setAttribute("periodelijst", periodelijst);
            request.setAttribute("aanbodfilter", aanbodfilter);
            rd = request.getRequestDispatcher("aanbod.jsp");
         }
        else if (request.getParameter("periodefilterKnop") != null) {
            int periodefilter = Integer.parseInt(request.getParameter("periodefilter"));
            ArrayList<Aanbod> aanbodfilter = daaanbod.getAanbodfilter(periodefilter);
            request.setAttribute("aanbodfilter", aanbodfilter);
            ArrayList<Periode> periodelijst = daperiode.getPeriodelijst();
            request.setAttribute("periodelijst", periodelijst);
            rd = request.getRequestDispatcher("aanbod.jsp");
        }
        if (request.getParameter("zoekKnop") != null){
            rd = request.getRequestDispatcher("zoek.jsp");
        }
        if (request.getParameter("adminKnop") != null){
            ArrayList<Hotel> hotels = dahotel.getHotels();
            request.setAttribute("hotels", hotels);
            rd = request.getRequestDispatcher("admin.jsp");
        }

    rd.forward(request, response);
}
    // <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>

}