package fact.it.www;

import fact.it.www.beans.Bestelling;
import fact.it.www.beans.Bon;
import fact.it.www.beans.Klant;
import fact.it.www.beans.Thema;
import fact.it.www.dataaccess.DABestelling;
import fact.it.www.dataaccess.DABon;
import fact.it.www.dataaccess.DAKlant;
import fact.it.www.dataaccess.DAThema;
import java.io.IOException;
import java.io.PrintWriter;
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;

/**
 *
 * @author Alexander
 */
@WebServlet(name = "ManageServlet", urlPatterns = {"/ManageServlet"}, initParams = {
    @WebInitParam(name = "url", value = "jdbc:oracle:thin:@localhost:1521:XE"),
    @WebInitParam(name = "login", value = "r0620593"),
    @WebInitParam(name = "password", value = "3649"),
    @WebInitParam(name = "driver", value = "oracle.jdbc.driver.OracleDriver")})
public class ManageServlet extends HttpServlet {

   private DABon dabon = null;
   private DAThema dathema = null;
   private DABestelling dabestelling = null;
   private DAKlant daklant = null;

    @Override
    public void init() throws ServletException {
        try {
            String url = getInitParameter("url");
            String password = getInitParameter("password");
            String login = getInitParameter("login");
            String driver = getInitParameter("driver");
            if (dabon == null) {
                dabon = new DABon(url, login, password, driver);
            }
            if (dathema == null) {
                dathema = new DAThema(url, login, password, driver);
            }
            if (dabestelling == null) {
                dabestelling = new DABestelling(url, login, password, driver);
            }
            if (daklant == null) {
                daklant = new DAKlant(url, login, password, driver);
            }
        } catch (ClassNotFoundException | SQLException e) {
            throw new ServletException(e);
        }
    }

    @Override
    public void destroy() {
        try {
            if (dabon != null) {
                dabon.close();
            }
            if (dathema != null) {
                dathema.close();
            }
            if(dabestelling != null) {
                dabestelling.close();
            }
            if(daklant != null) {
                daklant.close();
            }
        } catch (SQLException ex) {

        }
    }

    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        RequestDispatcher rd = null;

        if(request.getParameter("knopOverzicht") != null) {
            ArrayList<Bon> bonnen = dabon.getBonnen();
            request.setAttribute("bonnen", bonnen);
            rd = request.getRequestDispatcher("overzichtCadeaubons.jsp");
        }
        else if(request.getParameter("knopZoeken") != null) {
            ArrayList<Thema> themas = dathema.getThemas();
            request.setAttribute("themas", themas);
            rd = request.getRequestDispatcher("zoek.jsp");
        }
        else if(request.getParameter("knopZoekPrijs") != null) {
            double prijs = Double.parseDouble(request.getParameter("zoekPrijs"));
            ArrayList<Bon> bonnen = dabon.getPrijsBonnen(prijs);
            request.setAttribute("bonnen", bonnen);
            rd = request.getRequestDispatcher("overzichtCadeaubons.jsp");
        }
        else if(request.getParameter("knopZoekNaam") != null) {
            String naam = request.getParameter("zoekNaam");
            ArrayList<Bon> bonnen = dabon.getNaamBonnen(naam);
            request.setAttribute("bonnen", bonnen);
            rd = request.getRequestDispatcher("overzichtCadeaubons.jsp");
        }
        else if(request.getParameter("knopZoekThema") != null) {
            int id = Integer.parseInt(request.getParameter("zoekThema"));
            ArrayList<Bon> bonnen = dabon.getThemaBonnen(id);
            request.setAttribute("bonnen", bonnen);
            rd = request.getRequestDispatcher("overzichtCadeaubons.jsp");
        }
        else if(request.getParameter("nummerBon") != null) {
            String bonnummer = request.getParameter("nummerBon");
            Bon bon = dabon.getNummerBon(bonnummer);
            request.setAttribute("bon", bon);
            int id = bon.getId();
            ArrayList<Bestelling> bestellingen = dabestelling.getBonBestellingen(id);
            request.setAttribute("bestellingen", bestellingen);
            rd = request.getRequestDispatcher("details.jsp");
        }
        else if(request.getParameter("nieuweBestelling") != null) {
            String nummer = request.getParameter("nieuweBestelling");
            ArrayList<Klant> klanten = daklant.getKlanten();
            Bon bon = dabon.getNummerBon(nummer);
            request.setAttribute("bon", bon);
            request.setAttribute("klanten", klanten);
            rd = request.getRequestDispatcher("nieuwebestelling.jsp");
        }
        else if(request.getParameter("bestellingPlaatsen") != null) {
            int bonId = Integer.parseInt(request.getParameter("bonId"));
            String bonNr = request.getParameter("bonNr");
            int klantId = Integer.parseInt(request.getParameter("klant"));
            int aantal = Integer.parseInt(request.getParameter("aantal"));

            if(dabestelling.insertBestelling(bonId, klantId, aantal)) {
                Bon bon = dabon.getNummerBon(bonNr);
                request.setAttribute("bon", bon);
                int id = bon.getId();
                ArrayList<Bestelling> bestellingen = dabestelling.getBonBestellingen(id);
                request.setAttribute("bestellingen", bestellingen);
                rd = request.getRequestDispatcher("details.jsp");
            } else {
                ArrayList<Klant> klanten = daklant.getKlanten();
                Bon bon = dabon.getNummerBon(bonNr);
                request.setAttribute("bon", bon);
                request.setAttribute("klanten", klanten);
                rd = request.getRequestDispatcher("nieuwebestelling.jsp");
            }
        }
        else if(request.getParameter("bestellingAnnuleren") != null) {
            String bonNr = request.getParameter("bonNr");
            Bon bon = dabon.getNummerBon(bonNr);
            request.setAttribute("bon", bon);
            int id = bon.getId();
            ArrayList<Bestelling> bestellingen = dabestelling.getBonBestellingen(id);
            request.setAttribute("bestellingen", bestellingen);
            rd = request.getRequestDispatcher("details.jsp");
        }
        else if(request.getParameter("klantToevoegen") != null) {
            String naam = request.getParameter("naamKlant");
            String voornaam = request.getParameter("voornaamKlant");
            String telefoon = request.getParameter("telefoonKlant");
            String email = request.getParameter("emailKlant");
            String nummer = request.getParameter("bonNr");

            if(daklant.insertKlant(naam, voornaam, telefoon, email)) {
                ArrayList<Klant> klanten = daklant.getKlanten();
                Bon bon = dabon.getNummerBon(nummer);
                request.setAttribute("bon", bon);
                request.setAttribute("klanten", klanten);
                rd = request.getRequestDispatcher("nieuwebestelling.jsp");
            } else {
                rd = request.getRequestDispatcher("nieuweklant.jsp?bonNr=" + nummer);
            }
        }

        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>

}