package com.wgh.action;

import javax.servlet.http.*;

import org.apache.struts.action.*;

import com.wgh.actionForm.QuestionsForm;
import com.wgh.actionForm.TaoTiForm;
import com.wgh.core.ChStr;
import com.wgh.dao.LessonDAO;
import com.wgh.dao.QuestionsDAO;
import com.wgh.dao.TaoTiDAO;

public class Questions extends Action {
	private QuestionsDAO questionsDAO = null;
	private LessonDAO lessonDAO=null;
	private TaoTiDAO taoTiDAO=null;

	public Questions() {
		this.questionsDAO = new QuestionsDAO();
		this.lessonDAO=new LessonDAO();
		this.taoTiDAO=new TaoTiDAO();
	}
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String action = request.getParameter("action");
		System.out.println("獲取的查詢字符串：" + action);
		if ("questionsQuery".equals(action)) {
			return questionsQuery(mapping, form, request, response);
		}else if("questionsAddQuery".equals(action)){
			return questionsAddQuery(mapping,form,request,response);			
		} else if ("questionsAdd".equals(action)) {
			return questionsAdd(mapping, form, request, response);
		} else if ("questionsDel".equals(action)) {
			return questionsDel(mapping, form, request, response);
		}else if("questionsModifyQuery".equals(action)){
			return questionsModifyQuery(mapping,form,request,response);
		}else if("questionsModify".equals(action)){
			return questionsModify(mapping,form,request,response);
		}else if("queryTaoTi".equals(action)){
			return queryTaoTi(mapping,form,request,response);
		}else{
			request.setAttribute("error", "操作失敗！");
			return mapping.findForward("error");
		}
	}

	// 查詢考試題目信息
	private ActionForward questionsQuery(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		request.setAttribute("questionsQuery", questionsDAO.query(0));
		return mapping.findForward("questionsQuery");
	}

	// 添加考試題目
	private ActionForward questionsAdd(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		QuestionsForm questionsForm = (QuestionsForm) form;
		int ret = questionsDAO.insert(questionsForm);
		if (ret == 1) {
			return mapping.findForward("questionsAdd");
		} else if (ret == 2) {
			request.setAttribute("error", "該考試題目已經添加！");
			return mapping.findForward("error");
		} else {
			request.setAttribute("error", "添加考試題目失敗！");
			return mapping.findForward("error");
		}
	}
	// 添加考試題目時查詢
	private ActionForward questionsAddQuery(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		request.setAttribute("lessonList",lessonDAO.query(-1));	//全部包括套題的課程列表
		return mapping.findForward("questionsAddQuery");
	}
	
	//根據課程查詢套題ajax
	private ActionForward queryTaoTi(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		request.setAttribute("taoTiList",taoTiDAO.queryTaoTi(Integer.parseInt(request.getParameter("id"))));	//查詢指定課程的套題列表
		return mapping.findForward("queryTaoTi");
	}	
	// 修改考試題目時的查詢
	private ActionForward questionsModifyQuery(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		QuestionsForm questionsForm=(QuestionsForm)((questionsDAO.query(Integer.parseInt(request.getParameter("id")))).get(0));
		request.setAttribute("questionsModifyQuery", questionsForm);
		return mapping.findForward("questionsModifyQuery");
	}
	//修改考試題目
	private ActionForward questionsModify(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		QuestionsForm questionsForm = (QuestionsForm) form;
		int ret = questionsDAO.update(questionsForm);
		if (ret == 0) {
			request.setAttribute("error", "修改考試題目失敗！");
			return mapping.findForward("error");
		} else {
			return mapping.findForward("questionsModify");
		}
	}	
	// 刪除考試題目
	private ActionForward questionsDel(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		QuestionsForm questionsForm = (QuestionsForm) form;
		int ret = questionsDAO.delete(questionsForm);
		if (ret == 0) {
			request.setAttribute("error", "刪除考試題目失敗！");
			return mapping.findForward("error");
		} else {
			return mapping.findForward("questionsDel");
		}
	}
}