/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */


import java.io.IOException;
import java.io.PrintWriter;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import java.sql.*;

/**
 *
 * @author Familia
 */
public class updatereg extends HttpServlet {

    /**
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException, SQLException {
        int err_cont=0;
        PrintWriter o = response.getWriter();
        HttpSession session = request.getSession(true);

        DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
        Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","Tarea1","poiuyt");
        Statement statement = connection.createStatement() ;

        String link = "/Tarea1BD/register.jsp?status=reg_edit";

        String user = session.getAttribute("username").toString();
        o.println("user = "+user+" ");

        ResultSet resultset = statement.executeQuery(""
                + "SELECT username, url_web, rol, campus_id, password "
                + "FROM Alumno "
                + "WHERE username = '"+user+"'");

        /*while(resultset.next())
        {
            if(resultset.getString("username").equals(user))
                break;
        }*/
        resultset.next();
        String pass = request.getParameter("pass");
        String repass = request.getParameter("repass");
        if( !((pass != null || !pass.equals("")) && (repass != null || !repass.equals(""))) || !pass.equals(repass)  )
            err_cont++;

        String rol = request.getParameter("rol");
        if( rol == null || rol.equals(""))
            err_cont++;
        else
            link = link.concat("&rol="+rol);

        String campus = request.getParameter("campus");
        int campus_id = 0;
        if( campus == null || campus.equals("0") || campus.equals("") )
            err_cont++;
        else
        {
            link = link.concat("&campus="+campus);
            campus_id = Integer.parseInt(campus);
        }

        String urlweb = request.getParameter("urlweb");
        if( urlweb != null && !urlweb.equals(""))
            link = link.concat("&urlweb="+urlweb);

        if( (err_cont > 0) )
        {
            response.sendRedirect(link);
            //getServletConfig().getServletContext().getRequestDispatcher(link).forward(request, response);
        }
        else
        {
            response.setContentType("text/html;charset=UTF-8");
            PrintWriter out = response.getWriter();
            out.println("username = "+user+" & url_web = "+urlweb+" & rol = "+rol+" & campus = "+campus);
            try {
                //statement.execute("UPDATE Alumno SET asdf='qwerty' WHERE username = '"+user+"'");
                String bd_campus_id = resultset.getString("campus_id");
                String bd_url_web = resultset.getString("url_web");
                String bd_rol = resultset.getString("rol");
                String bd_pass = resultset.getString("password");

                if( pass != null && !pass.equals("") && !pass.equals(bd_pass))
                    statement.execute("UPDATE Alumno SET password='"+pass+"' WHERE username='"+user+"'");

                if( ( urlweb == null && bd_url_web != null)
                    || ( urlweb != null && bd_url_web == null)
                    || ( urlweb != null && bd_url_web != null && !bd_url_web.equals(urlweb) ))
                {
                    statement.execute("UPDATE Alumno SET url_web='"+urlweb+"' WHERE username='"+user+"'");
                    session.removeAttribute("urlweb");
                    session.setAttribute("urlweb", urlweb);
                }

                if( campus != null && bd_campus_id != null && !bd_campus_id.equals(campus))
                {
                    out.println("update "+campus_id+"!="+bd_campus_id);
                    out.println(" UPDATE Alumno SET campus_id="+campus_id+" WHERE username='"+user+"' ");
                    statement.execute(" UPDATE Alumno SET campus_id="+campus_id+" WHERE username='"+user+"' ");
                    session.removeAttribute("campus");
                    session.setAttribute("campus", campus);
                }
                out.println("antes 3er if");
                if( rol != null && bd_rol != null && !bd_rol.equals(rol))
                {
                    statement.executeUpdate(" UPDATE Alumno SET rol = '" + rol + "' WHERE username = '" + user + "' ");
                    session.removeAttribute("rol");
                    session.setAttribute("rol", rol);
                }
                out.println("antes fin");
                response.sendRedirect("/Tarea1BD/register.jsp?status=reg_edit_done");

            }catch (Exception e) /*finally*/ {
                out.println("FAIL? : "+e);
                out.close();
            }
        }
    }

    // <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 {
        try {
            processRequest(request, response);
        } catch (SQLException ex) {
            Logger.getLogger(updatereg.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    /**
     * 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 {
        try {
            processRequest(request, response);
        } catch (SQLException ex) {
            Logger.getLogger(updatereg.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

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

}