package ocs;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.PreparedStatement ;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Enumeration;

@SuppressWarnings("serial")
public class login extends HttpServlet {
	
	// init
	public void init() {
	// on récupère les paramètres d'initialisation de la servlet
		ServletConfig config = getServletConfig();
	}
	
	 // GET
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	     throws IOException, ServletException {
		getServletContext().getRequestDispatcher("/WEB-INF/view/login.jsp").forward(request, response);
	     
	}
	
	   // POST
	public void doPost(HttpServletRequest request, HttpServletResponse response)
	       throws IOException, ServletException {
		// Arguments of post : 
		String student_id = request.getParameter("student_id");
		String birthdate = request.getParameter("birthdate");
	     try  {
	    	 System.out.println(student_id);
	    	 Connection conn = Singleton.getInstance() ;
		     PreparedStatement prepare = conn.prepareStatement("SELECT * FROM ocs_student WHERE (student_id=?);");

		     
		     prepare.setString(1, student_id);
		     ResultSet result = prepare.executeQuery();
		     
		     System.out.println(prepare.toString());
		     System.out.println(result.toString());
	
		     if(result.next()){
		    	 String dob = (String)result.getObject(6) ;
		    	 if((dob.substring(0, 4).equals(birthdate.substring(4,8)))  
		    			 && (dob.substring(5,7).equals(birthdate.substring(2,4))) 
		    			 && (dob.substring(8,10).equals(birthdate.substring(0,2)))) {
		    		 //OK
		    			request.setAttribute("title", "It Works");
		    			request.setAttribute("text", "Logged in ");
		    			getServletContext().getRequestDispatcher("/WEB-INF/view/test.jsp").forward(request, response);
		    		 
		    	 }else{
		    			request.setAttribute("title", "Wrong login");
		    			request.setAttribute("text", "Sorry, your student ID or your birthdate is wrong ! ");
		    			getServletContext().getRequestDispatcher("/WEB-INF/view/error.jsp").forward(request, response);
		    	 }
		     }
	     }catch(SQLException e) {
	    	 e.printStackTrace();
	     }
	     
	}
}