package hospital.Controller.Actions.Logon;

import org.apache.struts.action.*;
import org.hibernate.Transaction;

import javax.servlet.http.*;
import java.sql.*;
import java.util.ArrayList;

import hospital.Controller.ActionForms.*;
import hospital.Model.*;

public class LoginAction extends Action {
    private String userName = "";
    private String password = "";
    private String userID = "";
    private String realName = "";
    private String isCorrect = "0";

    public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) {
        HttpSession session = request.getSession();
        try {
            //初始化頁面的所有參數
            initPageParameters(form, request);
            checkUser(session);
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        returnPageParameters(request);
        if (isCorrect.equals("1")) {
            return mapping.findForward("frame");
        } else {
            return mapping.findForward("error");
        }
    }

    private void setPropertyToOrginate() {
        userName = "";
        password = "";
        userID = "";
        realName = "";
        isCorrect = "0";
    }

    private void initPageParameters(ActionForm form, HttpServletRequest request) {
        setPropertyToOrginate();
        LoginActionForm loginActionForm = (LoginActionForm) form;
        userName = loginActionForm.getUserName();
        password = loginActionForm.getPassword();
    }

    private void checkUser(HttpSession session) throws SQLException {
        Sys用戶表DAO Sys用戶表Obj=new Sys用戶表DAO();
        Transaction tx=Sys用戶表Obj.getSession().beginTransaction();
        ArrayList userList=(ArrayList)Sys用戶表Obj.findUserByUserName_Password(userName, password);
        tx.commit();
        Sys用戶表Obj.getSession().close();
        
        //String sql = "select 用戶編號,真實姓名 from sys用戶表 where 用戶名稱=" + "'" + this.userName + "' and " + "用戶密碼=" + "'" + this.password + "'";
        
        if (userList.size()!=0) {
        	Sys用戶表 singleUser=(Sys用戶表)userList.get(0);
            session.setAttribute("userID", userID);
            userID = String.valueOf(singleUser.get用戶編號());
            realName = singleUser.get真實姓名();
            isCorrect = "1";
        } else {
            isCorrect = "-1";
        }
    }

    private void returnPageParameters(HttpServletRequest request) {
        request.setAttribute("userID", userID);
        request.setAttribute("realName", realName);
    }
}