package com.logistic.servlet;

import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.logistic.data.DataConnect;
import java.sql.Statement;
import java.sql.ResultSet;
import com.logistic.business.EmployeeManager;

public class EmployeeInfoUpdate extends HttpServlet {

	
	private static final long serialVersionUID = -2305260907601477327L; 
	HttpSession session=null;
	DataConnect dc=new DataConnect();
	Statement stat=null;
	ResultSet rs=null;
	String id=null;
	String name=null;
	String sex=null;
	int    age=0;
	int    flag=0;
	String idencard=null;
	String birthdate=null;
	String diploma=null;
	String joindate=null;
	String address=null;
	String phone=null;
	String mobile=null;
	String department=null;
	String job=null;
	RequestDispatcher requestdispatcher;

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

		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html; charset=gb2312");
		session=request.getSession();
		
/*--------------從頁面employeeinfosave.jsp獲取員工信息，并判斷是否合法。如果合法插入員工信息-----------*/
		 id=(String)request.getParameter("eid");						//員工編號
		 name=(String)request.getParameter("employeename");				//員工姓名
		 sex=(String)request.getParameter("employeesex");				//員工性別
		 age=Integer.valueOf(request.getParameter("employeeage"));  	//員工年齡
		 idencard=(String)request.getParameter("employeeidcard");   	//員工身份證號碼
		 birthdate=(String)request.getParameter("birthdate");			//員工出生日期
		 diploma=(String)request.getParameter("diploma");				//員工的學歷編號
		 joindate=(String)request.getParameter("joindate");				//員工加入公司時間
		 address=(String)request.getParameter("homeaddress");			//員工的家庭住址
		 phone=(String)request.getParameter("fixphone");				//員工家中電話號碼	
		 mobile=(String)request.getParameter("mobile");					//員工移動電話號碼	
		 department=(String)request.getParameter("department");     	//員工所屬部門編號
		 job=(String)request.getParameter("jobs");						//員工所從事的職務編號
		
		 
         if(id==null||name==null||sex==null||(age<18)||(idencard.length()<18)||(mobile.length()<11)){
	    	  
	    	session.setAttribute("errors","員工信息填寫有誤，請確認!");
	    	requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
			requestdispatcher.forward(request, response);   	  
	     }else{
			
		  try{
				EmployeeManager em=new EmployeeManager();
				flag=-10;
				flag=em.ModifyEmployee(id, name, sex, age, idencard, birthdate, diploma, joindate, address, phone, mobile, department, job);
				if(flag>0){					
						requestdispatcher=request.getRequestDispatcher("/viewpage/showpage/employeeinfolist.jsp");
						requestdispatcher.forward(request, response);
				}else{
						session.setAttribute("errors", "職員信息修改失敗!");
						requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
						requestdispatcher.forward(request, response);
				}
			}catch(Exception ex){flag=-1;ex.printStackTrace();}finally{dc.close();}
	    }		 
	}
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {

			doPost(request,response);
    }

}