/*
 * 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 com.journaldev.servlet.session;
import model.User;
import com.journaldev.servlet.connectDB.DataConnect;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


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


        public static String nameLoginUser;

    private static final long serialVersionUID = 1L;
    private final String userID = "admin";
    private final String password = "password";

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

        // get request parameters for userID and password
        String user = request.getParameter("user");
        String pwd = request.getParameter("pwd");

                System.out.println("Cos: '" + user +"' cos: "+pwd);

                User userLoggin = validate(request.getParameter("user"), request.getParameter("pwd"));


                if(userLoggin.getName().equals(user) && userLoggin.getPassword().equals(pwd)){
                    nameLoginUser = userLoggin.getName();
            HttpSession session = request.getSession();
            session.setAttribute("user", userLoggin.getName());
            //setting session to expiry in 30 mins
            session.setMaxInactiveInterval(30*60);
            Cookie userName = new Cookie("user", user);
            userName.setMaxAge(30*60);
            response.addCookie(userName);
            response.sendRedirect("LoginSuccess.jsp");
        }else{
            RequestDispatcher rd = getServletContext().getRequestDispatcher("/login.html");
            PrintWriter out= response.getWriter();
            out.println("<font color=red>Either user name or password is wrong.</font>");
            rd.include(request, response);
        }

//      if(userID.equals(user) && password.equals(pwd)){
//          HttpSession session = request.getSession();
//          session.setAttribute("user", "Pankaj");
//          //setting session to expiry in 30 mins
//          session.setMaxInactiveInterval(30*60);
//          Cookie userName = new Cookie("user", user);
//          userName.setMaxAge(30*60);
//          response.addCookie(userName);
//          response.sendRedirect("LoginSuccess.jsp");
//      }else{
//          RequestDispatcher rd = getServletContext().getRequestDispatcher("/login.html");
//          PrintWriter out= response.getWriter();
//          out.println("<font color=red>Either user name or password is wrong.</font>");
//          rd.include(request, response);
//      }

    }

        public static User validate(String user, String password) {
        Connection con = null;
        PreparedStatement ps = null;
                User user1 = new User();
        try {
            con = DataConnect.getConnection();
            ps = con.prepareStatement("Select LOGIN, HASLO from PRACOWNICY");
            //ps.setString(1, user);
            //ps.setString(2, password);

            ResultSet rs = ps.executeQuery();

            if (rs.next()) {
                            user1.setName(rs.getString("LOGIN"));
                user1.setPassword(rs.getString("HASLO"));
                return user1;
            }
        } catch (SQLException ex) {
            System.out.println("Login error -->" + ex.getMessage());
            return user1;
        } finally {
            DataConnect.close(con);
        }
        return user1;
    }






}