AAAAAAAAAAA

package servlethtml;
import java.io.*;
import java.sql.*;

import java.net.URLDecoder;
import java.net.URLEncoder;
import java.nio.charset.StandardCharsets;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Enumeration;
import java.util.Random;

import javax.servlet.*;
import javax.servlet.http.*;

import org.apache.catalina.tribes.membership.Membership;

import connection.JDBCConnection;
import data.Admin;
import data.ContrFin;
import data.ContrInf;
import data.Course;
import data.Degree;
import data.Globals;
import data.Member;
import data.Participates_In;
import data.Project;
import data.Teacher;
import database.Main;
import database.Procedure;


/**@author Myrsini Gkolemi
 *
 * */


public class PageServlet extends HttpServlet
{


	public PageServlet() {
		super();
	}
	/**
	 * @serial Warning
	 */
	private static final long serialVersionUID = 1L;
	private Procedure proc;

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

		            response.setCharacterEncoding("UTF-8");



	}

	@Override
	 protected void doGet(HttpServletRequest request, HttpServletResponse response)
		      throws ServletException, IOException{



		   processRequest(request,response);

		   response.setContentType("text/html");

		   PrintWriter out = response.getWriter();


		   RequestDispatcher rd = request.getRequestDispatcher("/index.html");
		   rd.forward(request, response);


		   System.out.println(request.getParameter("birthday"));

		   ArrayList<String> confirm_buttons = new ArrayList<String>();

		   for(int i = 1; i<5 ; i++)
		   {
			   if( i == 1)
			   {
				   confirm_buttons.add(request.getParameter("confirm_1a"));
				   confirm_buttons.add(request.getParameter("confirm_1e"));
			   }
			   else
			   confirm_buttons.add(request.getParameter("confirm_"+ i));
		   }
		   try
		   {

			   if(confirm_buttons.get(0)!=null && !confirm_buttons.get(0).isEmpty() &&
				 request.getParameter("modify")!=null )
				   changeAdminEmploy(request, response);
			   else if(confirm_buttons.get(0)!=null && !confirm_buttons.get(0).isEmpty())
				   actionAdmin(request, response);
			   else if(confirm_buttons.get(1)!=null && !confirm_buttons.get(1).isEmpty() &&
					   request.getParameter("modify")!=null )
				   changeEduEmploy(request, response);
			    else if(confirm_buttons.get(1)!=null && !confirm_buttons.get(1).isEmpty())
				   actionEdu(request,response);
			   else if(confirm_buttons.get(2)!=null && !confirm_buttons.get(2).isEmpty())
				   modifyWages(request, response);
			   else if(confirm_buttons.get(3)!=null && !confirm_buttons.get(3).isEmpty())
				   layOffEmploy(request, response);
			   else if(confirm_buttons.get(4)!=null && !confirm_buttons.get(4).isEmpty())
				   promoteEmploy(request, response);

		   }
		   catch(SQLException e)
		   {
			   e.printStackTrace();
		   }



	    }



		private Admin  actionAdmin(HttpServletRequest request, HttpServletResponse response) throws UnsupportedEncodingException, SQLException
		{
			// Basic information

			int id = 1+ proc.getLatestId("Admin_Stuff", "id_Stuff");

			String firstname = new String(request.getParameter("firstname").getBytes("ISO-8859-1"),"UTF-8");
			String fathername = new String(request.getParameter("fathername").getBytes("ISO-8859-1"),"UTF-8");
			String lastname = new String(request.getParameter("lastname").getBytes("ISO-8859-1"),"UTF-8");
			String amka = new String(request.getParameter("amka").getBytes("ISO-8859-1"),"UTF-8");
			String afm = new String(request.getParameter("afm").getBytes("ISO-8859-1"),"UTF-8");
			String birthday = new String(request.getParameter("birthday").getBytes("ISO-8859-1"),"UTF-8");
			String gend = new String(request.getParameter("gender").getBytes("ISO-8859-1"),"UTF-8");
			String address = new String(request.getParameter("address").getBytes("ISO-8859-1"),"UTF-8");
			String telephone = new String(request.getParameter("telephone").getBytes("ISO-8859-1"),"UTF-8");
			String bank = new String(request.getParameter("bank").getBytes("ISO-8859-1"),"UTF-8");
			String iban = new String(request.getParameter("iban").getBytes("ISO-8859-1"),"UTF-8");
			String department = new String(request.getParameter("department").getBytes("ISO-8859-1"),"UTF-8");
			String position = new String(request.getParameter("position").getBytes("ISO-8859-1"),"UTF-8");
			String duties = new String(request.getParameter("duty").getBytes("ISO-8859-1"),"UTF-8");
			// Family information

			char gender = gend.charAt(0);

			System.out.println("GENDER:" + gender);
			System.out.println("BIRTHDAY:" + birthday);

			//	Family information
			boolean married_check = false;
			char married ='\0';
			if(request.getParameter("married")!= null)	married_check = true;

			if(married_check == true) married = '1';
			else 					  married = '0';


			String dependants =  new String(request.getParameter("count_dependants").getBytes("ISO-8859-1"),"UTF-8");
			int num_dependants = Math.max(Integer.parseInt(dependants),0);

			System.out.println(num_dependants);
			ArrayList<Member> dep_members = new ArrayList<Member>();
			if(num_dependants!= 0)
				dep_members.addAll((parseMembers(request, num_dependants,id)));

			for(Member m:dep_members)
				System.out.println(m.toString());

			//	Degrees
			String degrees = new String(request.getParameter("count_titles").getBytes("ISO-8859-1"),"UTF-8");
			int num_degrees = Math.max(Integer.parseInt(degrees),0);
			System.out.println(num_degrees);

			ArrayList<Degree> Degrees = new ArrayList<Degree>();
			if(num_degrees!= 0)
			{
				System.out.println("NUM OF DEGREES:" + num_degrees);
				Degrees.addAll((parseDegree(request, num_degrees,id)));
				System.out.println("DEGREES SIZE:" + Degrees.size());
			}

			//	Contract



			ContrFin contractFinite = null;
			ContrInf contractInfinite = null;


			if(request.getParameter("temporary") != null)
				contractFinite = contractParseFin(request,id);
			else
				contractInfinite = contractParseInf(request,id);



			//	Insertions  JUMP

			Admin administrator = new Admin(id,firstname,lastname, fathername, gender, birthday,amka,afm,department
					,married,address,bank,iban,'0',position,duties,telephone);


			String administratorInsert = administrator.insertToTable();

			if(request.getParameter("modify")==null)
			{
				Statement stmt =  this.proc.getConnection().con.createStatement();
				stmt.executeUpdate(administratorInsert);
			}
			// Insert Contract ---------------

			if(contractFinite != null)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(contractFinite.insertToTable());
			}
			else if(contractInfinite != null)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(contractInfinite.insertToTable());
			}

			//-------------------------------------

			//Insert Dependant Members ------------
			ArrayList<String> dep_statements = new ArrayList<String>();
			for(Member m: dep_members)
				dep_statements.add(m.insertToTable());

			for(String s: dep_statements)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(s);
			}

			//-------------------------------------

			//Insert Titles -----------------------
			ArrayList<String> degree_statements = new ArrayList<String>();
			for(Degree d: Degrees)
				degree_statements.add(d.insertToTable());

			for(String d: degree_statements)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(d);
			}

			//-------------------------------------
			return administrator;
		}





		private Teacher  actionEdu(HttpServletRequest request, HttpServletResponse response) throws UnsupportedEncodingException, SQLException
		{
			// Basic information
			int id = 1+ proc.getLatestId("Teaching_Stuff", "ID_Stuff");

			String firstname = new String(request.getParameter("firstname").getBytes("ISO-8859-1"),"UTF-8");
			String fathername = new String(request.getParameter("fathername").getBytes("ISO-8859-1"),"UTF-8");
			String lastname = new String(request.getParameter("lastname").getBytes("ISO-8859-1"),"UTF-8");
			String amka = new String(request.getParameter("amka").getBytes("ISO-8859-1"),"UTF-8");
			String afm = new String(request.getParameter("afm").getBytes("ISO-8859-1"),"UTF-8");
			String birthday = new String(request.getParameter("birthday").getBytes("ISO-8859-1"),"UTF-8");
			String gend = new String(request.getParameter("gender").getBytes("ISO-8859-1"),"UTF-8");
			String address = new String(request.getParameter("address").getBytes("ISO-8859-1"),"UTF-8");
			String telephone = new String(request.getParameter("telephone").getBytes("ISO-8859-1"),"UTF-8");
			String bank = new String(request.getParameter("bank").getBytes("ISO-8859-1"),"UTF-8");
			String iban = new String(request.getParameter("iban").getBytes("ISO-8859-1"),"UTF-8");
			String department = new String(request.getParameter("department").getBytes("ISO-8859-1"),"UTF-8");
			String position = new String(request.getParameter("position").getBytes("ISO-8859-1"),"UTF-8");

			char gender = gend.charAt(0);

			System.out.println("BIRTHDAY:" + birthday);

			//	Family information
			boolean married_check = false;
			char married ='\0';
			if(request.getParameter("married")!= null)	married_check = true;

			if(married_check == true) married = '1';
			else 					  married = '0';


			String dependants =  new String(request.getParameter("count_dependants").getBytes("ISO-8859-1"),"UTF-8");
			int num_dependants = Math.max(Integer.parseInt(dependants),0);

			System.out.println(num_dependants);
			ArrayList<Member> dep_members = new ArrayList<Member>();
			if(num_dependants!= 0)
				dep_members.addAll((parseMembers(request, num_dependants,id)));

			for(Member m:dep_members)
				System.out.println(m.toString());

			//	Degrees
			String degrees = new String(request.getParameter("count_titles").getBytes("ISO-8859-1"),"UTF-8");
			int num_degrees = Math.max(Integer.parseInt(degrees),0);
			System.out.println(num_degrees);

			ArrayList<Degree> Degrees = new ArrayList<Degree>();
			if(num_degrees!= 0)
				Degrees.addAll((parseDegree(request, num_dependants,id)));

			//	Projects
			String project =  new String(request.getParameter("count_projects").getBytes("ISO-8859-1"),"UTF-8");
			int num_projects = Math.max(Integer.parseInt(project),0);
			System.out.println("Project Number:" + num_projects);
			ArrayList<Project> projects = new ArrayList<Project>();
			if(num_projects!= 0)
				projects.addAll(parseProjects(request,num_projects));


			//	Project Relation
			ArrayList<Participates_In> participants = parseParticipants(request,projects,num_projects,id);


			//	Lessons

			String lessons =  new String(request.getParameter("count_lessons").getBytes("ISO-8859-1"),"UTF-8");
			int num_lessons = Math.max(Integer.parseInt(lessons),0);
			System.out.println(num_lessons);
			ArrayList<Course> courses = new ArrayList<Course>();
			if(num_lessons!= 0)
				courses.addAll(parseLessons(request,num_lessons,id));


			//	Contract
			ContrFin contractFinite = null;
			ContrInf contractInfinite = null;

			if(request.getParameter("modify")==null)
			{
				if(request.getParameter("temporary") != null)
					contractFinite = contractParseFin(request,id);
				else
					contractInfinite = contractParseInf(request,id);
			}

			//	Insertions  JUMP

			Teacher teacher = new Teacher(id,firstname,lastname, fathername, gender, birthday,amka,afm,department
					,married,address,bank,iban,'0',position,telephone);



			String educatorInsert = teacher.insertToTable();

			if(request.getParameter("modify")==null)
			{
				System.out.println("Not modifying");
				Statement stmt =  this.proc.getConnection().con.createStatement();
				stmt.executeUpdate(educatorInsert);
			}

			// Insert Contract ---------------

			if(contractFinite != null)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(contractFinite.insertToTable());
			}
			else if(contractInfinite != null)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(contractInfinite.insertToTable());
			}

			//-------------------------------------

			//Insert Dependant Members ------------
			ArrayList<String> dep_statements = new ArrayList<String>();
			for(Member m: dep_members)
				dep_statements.add(m.insertToTable());

			for(String s: dep_statements)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(s);
			}

			//-------------------------------------

			//Insert Titles -----------------------
			ArrayList<String> degree_statements = new ArrayList<String>();
			for(Degree d: Degrees)
				degree_statements.add(d.insertToTable());

			for(String d: degree_statements)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(d);
			}

			//-------------------------------------

			//Insert Projects ---------------------
			ArrayList<String> project_statements = new ArrayList<String>();
			for(Project p: projects)
				project_statements.add(p.insertToTable());

			for(String p : project_statements)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(p);
			}

			ArrayList<String> participants_statements = new ArrayList<String>();
			for(Participates_In p: participants)
				participants_statements.add(p.insertToTable());

			for(String p : participants_statements)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(p);
			}

			//Insert Lessons-----------------------

			ArrayList<String> lesson_statements = new ArrayList<String>();
			for(Course c: courses)
				lesson_statements.add(c.insertToTable());

			for(String c : lesson_statements)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(c);
			}

			//-------------------------------------
			return teacher;
		}



		/* The user is not allowed to change the contract *JUMP*
		 * */



		private void changeEduEmploy(HttpServletRequest request, HttpServletResponse response) throws SQLException, UnsupportedEncodingException
		{
			System.out.println("INSIDE EDU CHANGE ");

			String id_string = null;

			id_string = new String(request.getParameter("employee_id").getBytes("ISO-8859-1"),"UTF-8");


			int id = Integer.parseInt(id_string);

			Teacher old = proc.getTeacher(id);
			Teacher updated = this.actionEdu(request, response);
			old.updateTeacher(updated);
			String teacherUpdate = old.updateToTable();
			//aaa
			Statement stmt =  this.proc.getConnection().con.createStatement();
			stmt.executeUpdate(teacherUpdate);

		}

		private void changeAdminEmploy(HttpServletRequest request, HttpServletResponse response) throws SQLException, UnsupportedEncodingException
		{
			System.out.println("INSIDE ADMIN CHANGE ");

			String id_string = null;

			id_string = new String(request.getParameter("employee_id").getBytes("ISO-8859-1"),"UTF-8");


			int id = Integer.parseInt(id_string);

			Admin old = proc.getAdmin(id);
			Admin updated = this.actionAdmin(request, response);
			old.updateAdmin(updated);
			String adminUpdate = old.updateToTable();
			Statement stmt =  this.proc.getConnection().con.createStatement();
			stmt.executeUpdate(adminUpdate);

		}

		ArrayList<Degree> parseDegree(HttpServletRequest request,int num,int emp_id) throws UnsupportedEncodingException, SQLException
		{

			String[] title = request.getParameterValues("title_d");
			String[] unis = request.getParameterValues("university");
			String[] yeargrads = request.getParameterValues("graduation");
			String[] gradeunis = request.getParameterValues("grade");

			int year[] = new int[num];
			float grade[] = new float[num];

			for(int i=0; i<num ; i++)
			{
				year[i] = Integer.parseInt(yeargrads[i]);
				grade[i] = Float.parseFloat(gradeunis[i]);

			}

			ArrayList<String> titles = new ArrayList<String>();
			ArrayList<String> universities = new ArrayList<String>();


			for(int i=0 ;i<num ; i++)
			{
				titles.add(new String(title[i].getBytes("ISO-8859-1"),"UTF-8"));
				universities.add(new String(unis[i].getBytes("ISO-8859-1"),"UTF-8"));
			}


			ArrayList<Degree> degrees = new ArrayList<Degree>();
			int id = 1 +proc.getLatestId("Participates_In", "id_Project");

			for(int i=0 ; i<num ; i++)
				degrees.add(new Degree(id,titles.get(i) , year[i], grade[i], universities.get(i),
						emp_id));


			return degrees;


		}



		ContrFin contractParseFin(HttpServletRequest request, int emp_id) throws UnsupportedEncodingException, SQLException
		{
			String dateBegin = new String(request.getParameter("date_emp").getBytes("ISO-8859-1"),"UTF-8");
			String dateEnd	=  new String(request.getParameter("date_leave").getBytes("ISO-8859-1"),"UTF-8");
			String daysOff	= new String(request.getParameter("daysoff").getBytes("ISO-8859-1"),"UTF-8");
			String hoursWe = new String(request.getParameter("weekhours").getBytes("ISO-8859-1"),"UTF-8");

			int hoursWeek = Integer.parseInt(hoursWe);
			int daysLeave = Integer.parseInt(daysOff);

			int id = 1+ proc.getLatestId("Contract_Fin","id_Contract");

			return new ContrFin(id,dateBegin,hoursWeek,daysLeave,'0',dateEnd,emp_id);

		}

		ContrInf contractParseInf(HttpServletRequest request, int emp_id) throws UnsupportedEncodingException, SQLException
		{
			String dateBegin = new String(request.getParameter("date_emp").getBytes("ISO-8859-1"),"UTF-8");
			String daysOff	= new String(request.getParameter("daysoff").getBytes("ISO-8859-1"),"UTF-8");
			String hoursWe = new String(request.getParameter("weekhours").getBytes("ISO-8859-1"),"UTF-8");


			int hoursWeek = Integer.parseInt(hoursWe);
			int daysLeave = Integer.parseInt(daysOff);

			int id = 1+ proc.getLatestId("Contract_Inf","id_Contract");

			return new ContrInf(id,dateBegin,hoursWeek,daysLeave,'0',emp_id);



		}

		ArrayList<Project> parseProjects(HttpServletRequest request, int num) throws UnsupportedEncodingException, SQLException
		{
			String[] p_name = request.getParameterValues("project_field");

			ArrayList<String> projectName = new ArrayList<String>();

			for(int i=0; i< num ; i++)
			{
				projectName.add(new String(p_name[i].getBytes("ISO-8859-1"),"UTF-8"));

			}

			//TO-DO RETURN
			int id = 1 + proc.getLatestId("Project", "id_Project");
			ArrayList<Project> projects = new ArrayList<Project>();
			for(int i=0; i< num ; i++)
				projects.add(new Project(id,projectName.get(i)));



			return projects;

		}


		ArrayList<Participates_In> parseParticipants(HttpServletRequest request,ArrayList<Project> projects, int id_emp, int id) throws UnsupportedEncodingException
		{
			String[] p_begin = request.getParameterValues("project_begin");
			String[] p_end = request.getParameterValues("project_end");

			ArrayList<String> projectBegin = new ArrayList<String>();
			ArrayList<String> projectEnd = new ArrayList<String>();

			for(int i = 0 ; i < projects.size() ; i++)
			{
				projectBegin.add(new String(p_begin[i].getBytes("ISO-8859-1"),"UTF-8"));
				projectEnd.add(new String(p_end[i].getBytes("ISO-8859-1"),"UTF-8"));
			}

			ArrayList<Participates_In> participants = new ArrayList<Participates_In>();

			for(int i = 0 ; i < projects.size()  ; i++)
			{
				participants.add(new Participates_In(projects.get(i).getId(),projectBegin.get(i),projectEnd.get(i),id_emp));
			}

			return participants;

		}


		ArrayList<Course> parseLessons(HttpServletRequest request, int num,int emp_id) throws UnsupportedEncodingException, SQLException
		{
			String[] l_name = request.getParameterValues("lesson_field");

			ArrayList<String> lessonNames = new ArrayList<String>();
			for(int i=0; i< num ; i++)
			{
				lessonNames.add(new String(l_name[i].getBytes("ISO-8859-1"),"UTF-8"));

			}

			int id = 1 + proc.getLatestId("Course", "id_Course");
			ArrayList<Course> courses = new ArrayList<Course>();
			for(int i=0; i< num ; i++)
				courses.add(new Course(id,lessonNames.get(i),emp_id));



			return courses;
			//TO-DO RETURN


		}



		ArrayList<Member> parseMembers(HttpServletRequest request, int num, int emp_id) throws UnsupportedEncodingException, SQLException
		{
			ArrayList<Member> members = new ArrayList<Member>();

			String[] d_lastname = request.getParameterValues("d_lastname");
			String[] d_firstname = request.getParameterValues("d_firstname");
			String[] d_birthday = request.getParameterValues("d_birthday");
			String[] d_gender = request.getParameterValues("d_gender");
			String[] d_amka = request.getParameterValues("d_amka");
			String[] d_relationship = request.getParameterValues("d_relationship");

			for(int i=0; i< num ; i++)
				System.out.println("LN:" +d_lastname[i]+ " " + "FN:" + d_firstname[i] + d_lastname.length);

			ArrayList<String> lastname = new ArrayList<String>();
			ArrayList<String> firstname = new ArrayList<String>();
			ArrayList<String> birthdate = new ArrayList<String>();
			ArrayList<String> gender = new ArrayList<String>();
			ArrayList<String> amka = new ArrayList<String>();
			ArrayList<String> relationship = new ArrayList<String>();



			for(int i=0 ;i<num ; i++)
			{
				lastname.add(new String(d_lastname[i].getBytes("ISO-8859-1"),"UTF-8"));
				firstname.add(new String(d_firstname[i].getBytes("ISO-8859-1"),"UTF-8"));
				birthdate.add(new String(d_birthday[i].getBytes("ISO-8859-1"),"UTF-8"));
				gender.add(new String(d_gender[i].getBytes("ISO-8859-1"),"UTF-8"));
				amka.add(new String(d_amka[i].getBytes("ISO-8859-1"),"UTF-8"));
				relationship.add(new String(d_relationship[i].getBytes("ISO-8859-1"),"UTF-8"));
			}


			char[] relation = new char[num];
			char[] gen = new char[num];

			for(int i=0 ;i<num ; i++)
			{
				gen[i] = gender.get(i).charAt(0);
				relation[i] = relationship.get(i).charAt(0);

			}

			for(int i=0 ;i<num ; i++)
			{
				switch(relation[i])
				{
					case 'σ' :
						relation[i] = 's';
						break;
					case 'π' :
						relation[i] = 'c';
						break;
				}

			}

			int id = 1+ proc.getLatestId("Family_Member", "id_Member");


			for(int i=0; i<num; i++)
			{
				members.add(new Member(id + i, firstname.get(i),lastname.get(i), relation[i], gen[i],birthdate.get(i),
						amka.get(i),emp_id));
			}

			//TO-DO RETURN
			return members;
		}



		private void modifyWages(HttpServletRequest request, HttpServletResponse response) throws UnsupportedEncodingException, SQLException {

			String change_wage_admin = new String(request.getParameter("change_wage_admin").getBytes("ISO-8859-1"),"UTF-8");

			String change_wage_edu = new String(request.getParameter("change_wage_edu").getBytes("ISO-8859-1"),"UTF-8");

			String change_allowance_lib = new String(request.getParameter("change_allowance_lib").getBytes("ISO-8859-1"),"UTF-8");

			String change_allowance_res = new String(request.getParameter("change_allowance_res").getBytes("ISO-8859-1"),"UTF-8");



			float wageAdmin = -1.0f;
			float wageEdu = -1.0f;
			float allowanceLib = -1.0f;
			float allowanceRes = -1.0f;



			if(change_wage_admin!=null && !change_wage_admin.isEmpty())
				wageAdmin = Float.parseFloat(change_wage_admin);
			if(change_wage_edu!=null && !change_wage_edu.isEmpty())
				wageEdu = Float.parseFloat(change_wage_edu);
			if(change_allowance_lib!=null && !change_allowance_lib.isEmpty())
				allowanceLib = Float.parseFloat(change_allowance_lib);
			if(change_allowance_res!=null && !change_allowance_res.isEmpty())
				allowanceRes = Float.parseFloat(change_allowance_res);

			// change GValues fields
			Globals g = proc.getGlobals();
			Globals newGlobals = new Globals(wageAdmin, wageEdu,allowanceLib ,allowanceRes);
			g.updateGlobals(newGlobals);
			String updateGlobals =g.updateToTable();

			Statement stmt =  this.proc.getConnection().con.createStatement();
			stmt.executeUpdate(updateGlobals);


		}


		private void layOffEmploy(HttpServletRequest request, HttpServletResponse response) throws UnsupportedEncodingException, SQLException {

			String idEmploy = new String(request.getParameter("id").getBytes("ISO-8859-1"),"UTF-8");
			if(idEmploy!=null && !idEmploy.isEmpty())
				System.out.println("ID: " + idEmploy);
			int id = Integer.parseInt(idEmploy);
			proc.terminateContract(id);
		}


		private void promoteEmploy(HttpServletRequest request, HttpServletResponse response) throws UnsupportedEncodingException, SQLException {


			String idEmploy = new String(request.getParameter("id").getBytes("ISO-8859-1"),"UTF-8");
			if(idEmploy!=null && !idEmploy.isEmpty())
				System.out.println("ID: " + idEmploy);
			// find current active contract and terminate
			int id = Integer.parseInt(idEmploy);
			ContrFin contractFinite = null;
			ContrInf contractInfinite = null;

			if(request.getParameter("modify")==null)
			{
				if(request.getParameter("temporary") != null)
					contractFinite = contractParseFin(request,id);
				else
					contractInfinite = contractParseInf(request,id);
			}

			// Insert Contract ---------------

			if(contractFinite != null)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(contractFinite.insertToTable());
			}
			else if(contractInfinite != null)
			{
				Statement statement =  this.proc.getConnection().con.createStatement();

				statement.executeUpdate(contractInfinite.insertToTable());
			}



		}



		public void init(ServletConfig config) throws ServletException {
			//this.connection = new JDBCConnection();
			this.proc = Main.proc;
		}






}