/*
 * 作者:劉云云
 * 時間:2007年11月12日
 * 功能:會員信息管理-＞舊會員卡升級。
 */
package com.mole.struts.action;

import java.util.ArrayList;

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

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.MerchantCardUpdateDAO;
import com.mole.struts.form.MerchantCardUpdateForm;

/**
 * MyEclipse Struts Creation date: 11-12-2007
 * 
 * XDoclet definition:
 * 
 * @struts.action path="/merchantCardUp" name="merchantCardUpForm"
 *                scope="request" validate="true"
 * @struts.action-forward name="merchantCardUp" path="/MerchantCardUp.jsp"
 */
public class MerchantCardUpdateAction 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 = (String) request.getParameter("action");
		if (action != null) {
			MerchantCardUpdateForm mForm = (MerchantCardUpdateForm) form;
			MerchantCardUpdateDAO dao = new MerchantCardUpdateDAO();
			String sql = "SELECT ID FROM Customer WHERE LoginName='"
					+ mForm.getUser() + "'";
			ArrayList<Object[]> al = dao.executeQuery(sql);
			if (al.size() != 0) {
				String storeID = (String) request.getSession().getAttribute(
						"store");
				Object[] obj = al.get(0);
				int customerID = (Integer) obj[0];
				sql = "INSERT INTO [Score]([StoreID],[CustomerID],[Score]) VALUES('"
						+ storeID
						+ "',"
						+ customerID
						+ ","
						+ mForm.getScore()
						+ ")";
				dao.executeUpdate(sql);
				request.setAttribute("result", "true");
			} else {
				request.setAttribute("result", "false");
			}
		}
		return mapping.findForward("goMerchantCardUpdate");
	}
}