package imis_elec;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;



public class ElecDev_Type extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public ElecDev_Type() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		this.doPost(request, response);
	}

	
	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {


		String pattern = request.getParameter("pattern");

		if(pattern.equals("insert")) {
			this.insert(request, response);
		}
		else if(pattern.equals("search")) {
			this.search(request, response);
		}else if(pattern.equals("getElecDev_Type")) {
			this.getElecInfo(request, response);
		}else if(pattern.equals("modify")) {
			this.modify(request, response);
		}else if(pattern.equals("delete")) {
			this.delete(request, response); 
		}else if(pattern.equals("newPage")) {
			//新建頁面(跳轉到添加信息頁面)
			this.newPage(request,response);
		}
	}
	
	
	/**
	 *
	 * 這個方法向表“ElecDev_Type”中插入數據
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	
	public void insert(HttpServletRequest request, HttpServletResponse response) 
	throws ServletException, IOException{
	
	boolean flag = false;
	String url = "../imis_elec/fail.jsp";
	
	ElecDev_TypeTO elecDev_Type = new ElecDev_TypeTO();
	elecDev_Type.setElecDevTypeName(request.getParameter("ElecDevTypeName").trim());
	//elecDev_Type.setReMark(Integer.parseInt(request.getParameter("ReMark").trim()));
	elecDev_Type.setReMark(0);
	
	
	
	
	ElecDev_TypeDAOImpl elecDev_ChkDAO = (ElecDev_TypeDAOImpl) DAOFactory.getInstance().getElecDev_TypeDAO();
	try {
		if(elecDev_ChkDAO.getElecDevTypeName(request.getParameter("ElecDevTypeName").trim())!= null)
		{
			request.setAttribute("ElecDevTypeName", "該設備類型名稱已存在");
			url = "../imis_elec/elecDev_Type_insert.jsp";
		}
		else
		{
			flag = elecDev_ChkDAO.insertElecDev_Type(elecDev_Type);
		}
		
		
	} catch (Exception e) {
		e.printStackTrace();
	}			
	
	if(flag == true) {
		request.setAttribute("success", "您已成功插入信息！");
		request.getRequestDispatcher("../imis_elec/successful.jsp").forward(request, response);
	} else {
		request.setAttribute("fail", "您的插入失敗了！");
		request.getRequestDispatcher(url).forward(request, response);
	}
	}
	
	/**
	 *
	 * 這個方法向表“ElecDev_Type”中得到信息,這個方法會被修改和刪除頁面調用，根據參數“page”來判斷
	 * 是哪個頁面。
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */	
	public void getElecInfo(HttpServletRequest request, HttpServletResponse response) 
		throws ServletException, IOException{
		ElecDev_TypeTO elecDev_TypeTO = null;
		int  elecDevTypeNo=-1;
		String ElecDevTypeName=null;
		if (request.getParameter("ElecDevTypeNo") != null)
		{
			  elecDevTypeNo  = Integer.parseInt(request.getParameter("ElecDevTypeNo").trim());
		}
		if (request.getParameter("ElecDevTypeName") != null)
		{
			ElecDevTypeName = request.getParameter("ElecDevTypeName").trim();
		}
		ElecDev_TypeDAOImpl elecDev_TypeDAO = (ElecDev_TypeDAOImpl) DAOFactory.getInstance().getElecDev_TypeDAO();
		
		try {
				if(elecDevTypeNo==-1)
				{
					elecDev_TypeTO = elecDev_TypeDAO.getElecDev_Type(ElecDevTypeName);
				}
				else
				{	
					elecDev_TypeTO = elecDev_TypeDAO.getElecDev_Type(elecDevTypeNo);
				}
				} catch (Exception e) {
			e.printStackTrace();
		}			
		
		if(elecDev_TypeTO != null) {
			request.setAttribute("ElecDev_Type", elecDev_TypeTO);
		} else {
			request.setAttribute("ElecDevTypeUnexisted", "用電設備類型名稱 " +
					"不存在！");
		}
		
		if(request.getParameter("page").equals("modify")) {
			request.getRequestDispatcher("../imis_elec/elecDev_Type_modify.jsp").forward(request, response);
		} else if(request.getParameter("page").equals("delete")) {
			request.getRequestDispatcher("../imis_elec/elecDev_Type_delete.jsp").forward(request, response);
		}
	}
	
	/**
	 *
	 * 這個方法向表“ElecDev_Rep”中修改數據
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */	
	public void modify(HttpServletRequest request, HttpServletResponse response) 
		throws ServletException, IOException{
				
		boolean flag = false;
		String url = "../imis_elec/fail.jsp";
		
		
		ElecDev_TypeTO elecDev_Type = new ElecDev_TypeTO();
		
		elecDev_Type.setElecDevTypeNo(Integer.parseInt(request.getParameter("ElecDevTypeNo").trim()));
		elecDev_Type.setElecDevTypeName(request.getParameter("ElecDevTypeName").trim());
		elecDev_Type.setReMark(0);
		
		
		ElecDev_TypeDAOImpl elecDev_TypeDAO = (ElecDev_TypeDAOImpl) DAOFactory.getInstance().getElecDev_TypeDAO();
		try {
			if(elecDev_TypeDAO.getElecDevTypeName(request.getParameter("ElecDevTypeName").trim())!= null)
			{
				request.setAttribute("ElecDevTypeName", "該設備類型名稱已存在");
				url = "../imis_elec/elecDev_Type_modify.jsp";
				request.setAttribute("ElecDev_Type", request.getSession().getAttribute("ElecDev_Type"));
				request.getSession().removeAttribute("ElecDev_Type");
			}
			else{
				flag = elecDev_TypeDAO.updateElecDev_Type(elecDev_Type);
			}
			
			
		} catch (Exception e) {
			e.printStackTrace();
		}			
		
		if(flag == true) {
			request.setAttribute("success", "您已成功修改信息！");
			request.getRequestDispatcher("../imis_elec/successful.jsp").forward(request, response);
		} else {
			request.setAttribute("fail", "您的修改失敗了！");
			request.getRequestDispatcher(url).forward(request, response);
		}
	}
	

	/**
	 *
	 * 這個方法向表“ElecDev_Type”中刪除數據
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */	
	public void delete(HttpServletRequest request, HttpServletResponse response) 
		throws ServletException, IOException{
				
		boolean flag = false;
		
		int  elecDevTypeNo = Integer.parseInt(request.getParameter("ElecDevTypeNo").trim());
		
		ElecDev_TypeDAOImpl elecDev_TypeDAO = (ElecDev_TypeDAOImpl) DAOFactory.getInstance().getElecDev_TypeDAO();
		try {
			flag = elecDev_TypeDAO.deleteElecDev_Type(elecDevTypeNo);
		} catch (Exception e) {
			e.printStackTrace();
		}			
		
		if(flag == true) {
			request.setAttribute("success", "您已成功刪除信息！");
			request.getRequestDispatcher("../imis_elec/successful.jsp").forward(request, response);
		} else {
			request.setAttribute("fail", "您的刪除失敗了！");
			request.getRequestDispatcher("../imis_elec/fail.jsp").forward(request, response);
		}

	}
	
	/**
	 *
	 * 這個方法向表“ElecDev_Type”中查找數據
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */	
	public void search(HttpServletRequest request, HttpServletResponse response) 
	throws ServletException, IOException{
	
	ArrayList list = new ArrayList();
	
	ElecDev_TypeTO elecDev_type = new ElecDev_TypeTO();
	if(!request.getParameter("ElecDevTypeNo").equals("")){
		elecDev_type.setElecDevTypeNo(Integer.parseInt(request.getParameter("ElecDevTypeNo").trim()));
	}
	else{
		elecDev_type.setElecDevTypeNo(-1);
	}
	if(!request.getParameter("ReMark").equals("")){
		elecDev_type.setReMark(Integer.parseInt(request.getParameter("ReMark").trim()));
	}
	else{
		elecDev_type.setReMark(-1);
	}
	elecDev_type.setElecDevTypeName(request.getParameter("ElecDevTypeName").trim());
	
	
	
	
	ElecDev_TypeDAOImpl elecDev_TypeDAO = (ElecDev_TypeDAOImpl) DAOFactory.getInstance().getElecDev_TypeDAO();
	try {
		list = elecDev_TypeDAO.searchElecDev_Type(elecDev_type);
		
	} catch (Exception e) {
		e.printStackTrace();
	}			
	
	request.getSession().setAttribute("ElecDev_TypeList", list);
	request.getRequestDispatcher("../imis_elec/elecDev_Type_bysearch.jsp").forward(request, response);
	}
	
	private void newPage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		//新建頁面(跳轉到添加信息頁面)
		request.getRequestDispatcher("../imis_elec/elecDev_Type_insert.jsp").forward(request, response);
	}

	

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}