/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.mole.struts.action;

import java.util.ArrayList;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import com.mole.struts.dao.DBConnector;

/**
 * MyEclipse Struts Creation date: 11-18-2007 Creator: Li Bin XDoclet
 * definition:
 * 
 * @struts.action validate="true"
 * @struts.action-forward name="merchantCardLoose" path="/merchantCardLoose.jsp"
 */
public class MerchantCardLooseAction extends Action {
	/*
	 * Generated Methods
	 */

	/**
	 * Method execute
	 * 
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {

		String action = request.getParameter("action");
		DBConnector dbc = new DBConnector();
		if (action != null && action.equals("login")) {
			ArrayList<Object[]> list = null;
			String loginName = request.getParameter("loginName");
			String password = request.getParameter("password");
			String sql = "select ID from Card where CustomerID=(select ID from Customer where LoginName='"
					+ loginName + "' and Password='" + password + "')";
			try {
				list = dbc.executeQuery(sql);
			} catch (Exception e) {
				e.printStackTrace();
			}
			if (list.size() == 0) {
				HttpSession session = request.getSession();
				session.setAttribute("title", "錯誤信息");
				session.setAttribute("message", "用戶名或密碼錯誤，請重新登陸！");
				session.setAttribute("returnUrl", "merchantCardLoose.do");
				return mapping.findForward("goMessage");
			} else {
				String temp = ((Object[]) list.get(0))[0].toString();
				request.setAttribute("OldCardID", temp);
			}
		}
		if (action != null && action.equals("loose")) {
			String oldCardID = request.getParameter("oldCardID");
			String newCardID = request.getParameter("newCardID");
			try {
				dbc.executeStoredProcedure("sp_RegrantCard(?,?)", oldCardID,
						newCardID);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return mapping.findForward("goMerchantCardLoose");
	}
}