/**
 *  Title  hrms
 *  @author: dzc
 *  Company: hust
 *  Copyright: Copyright (c) 2005
 *  @version 1.0
 *  Date  :   2006-04
 *  Filename:Assess.java
 **/

package hrms.action;

import hrms.database.DBConnect;
import hrms.util.*;

import java.sql.*;
import java.util.*;

import hrms.util.*;

public class Assess {

	public String EmployeeID, Position, GetType, Duty, Department, English,
			Computer, Remark;

	public java.sql.Date GetDate, StartDate, EndDate;

	public int AssessNO;

	public Assess() {
	};

	public String getEmployeeID() {
		return EmployeeID;
	}

	public void setEmployeeID(String s) {
		this.EmployeeID = s;
	}

	public String getPosition() {
		return Position;
	}

	public void setPosition(String s) {
		this.Position = s;
	}

	public String getGetType() {
		return GetType;
	}

	public void setGetType(String s) {
		this.GetType = s;
	}

	public String getDuty() {
		return Duty;
	}

	public void setDuty(String s) {
		this.Duty = s;
	}

	public String getDepartment() {
		return Department;
	}

	public void setDepartment(String s) {
		this.Department = s;
	}

	public String getEnglish() {
		return English;
	}

	public void setEnglish(String s) {
		this.English = s;
	}

	public String getComputer() {
		return Computer;
	}

	public void setComputer(String s) {
		this.Computer = s;
	}

	public String getRemark() {
		return Remark;
	}

	public void setRemark(String s) {
		this.Remark = s;
	}

	public void setAssessNO(int i) {
		this.AssessNO = i;
	}

	public String getAssessNO() {
		return DataConvert.IntToStr(AssessNO);
	}

	public String getGetDate() {
		if (this.GetDate != null)
			return DataConvert.sqlDateToStr(GetDate);
		else
			return "";
	}

	public void setGetDate(String str) {
		if (str != null)
			this.GetDate = DataConvert.StrTosqlDate(str);
		else
			this.GetDate = null;
	}

	public String getStartDate() {
		if (this.StartDate != null)
			return DataConvert.sqlDateToStr(StartDate);
		else
			return "";
	}

	public void setStartDate(String str) {
		if (str != null)
			this.StartDate = DataConvert.StrTosqlDate(str);
		else
			this.StartDate = null;
	}

	public String getEndDate() {
		if (this.EndDate != null)
			return DataConvert.sqlDateToStr(EndDate);
		else
			return "";
	}

	public void setEndDate(String str) {
		if (str != null)
			this.EndDate = DataConvert.StrTosqlDate(str);
		else
			this.EndDate = null;
	}

	/*
	 * Find Assess by NO
	 */
	public static Assess FindByNO(String _AssessNO) {
		DBConnect dbc = null;
		Assess assess = new Assess();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM assess WHERE AssessNO=?");
			dbc.setString(1, _AssessNO);
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) {
				assess.setAssessNO(rs.getInt("AssessNO"));
				assess.setEmployeeID(rs.getString("EmployeeID"));
				assess.setPosition(rs.getString("Position"));
				assess.setGetDate(rs.getString("GetDate"));
				assess.setGetType(rs.getString("GetType"));
				assess.setDuty(rs.getString("Duty"));
				assess.setStartDate(rs.getString("StartDate"));
				assess.setEndDate(rs.getString("EndDate"));
				assess.setDepartment(rs.getString("Department"));
				assess.setEnglish(rs.getString("English"));
				assess.setComputer(rs.getString("Computer"));
				assess.setRemark(rs.getString("Remark"));
			} else {
				assess = null;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
				assess = null;
			}
		}
		return assess;

	}

	/*
	 * Add Assess
	 */
	public static String Add(String _EmployeeID, String _Position,
			String _GetDate, String _GetType, String _Duty, String _StartDate,
			String _EndDate, String _Department, String _English,
			String _Computer, String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("INSERT INTO assess (EmployeeID,Position,GetDate,GetType,"
							+ "Duty,StartDate,EndDate,Department,English,Computer,Remark) VALUES (?,?,?,?,?,?,?,?,?,?,?)");
			dbc.setString(1, _EmployeeID);
			dbc.setString(2, _Position);
			dbc.setDate(3, DataConvert.StrTosqlDate(_GetDate));
			dbc.setString(4, _GetType);
			dbc.setString(5, _Duty);
			dbc.setDate(6, DataConvert.StrTosqlDate(_StartDate));
			dbc.setDate(7, DataConvert.StrTosqlDate(_EndDate));
			dbc.setString(8, _Department);
			dbc.setString(9, _English);
			dbc.setString(10, _Computer);
			dbc.setString(11, _Remark);
			dbc.executeUpdate();
			dbc.close();
			return "1";

		} catch (Exception e) {
			System.err.println(e);
			return e.toString();
		}

	}

	/*
	 * Modify Assess
	 */

	public static String Modify(String _AssessNO,String _EmployeeID,String _Position,
			String _GetDate, String _GetType, String _Duty, String _StartDate,
			String _EndDate, String _Department, String _English,
			String _Computer,String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("UPDATE assess SET EmployeeID=?,Position=?,GetDate=?,GetType=?,Duty=?,"
							+ "StartDate=?,EndDate=?,Department=?,English=?,Computer=?,Remark=? WHERE AssessNO=?");
			dbc.setString(1, _EmployeeID);
			dbc.setString(2, _Position);
			dbc.setDate(3, DataConvert.StrTosqlDate(_GetDate));
			dbc.setString(4, _GetType);
			dbc.setString(5, _Duty);
			dbc.setDate(6, DataConvert.StrTosqlDate(_StartDate));
			dbc.setDate(7, DataConvert.StrTosqlDate(_EndDate));
			dbc.setString(8, _Department);
			dbc.setString(9, _English);
			dbc.setString(10, _Computer);
			dbc.setString(11, _Remark);
			dbc.setInt(12, DataConvert.StrToInt(_AssessNO));
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * Delete Assess
	 */
	public static String Delete(String _AssessNO) {
		try {
			DBConnect dbc = new DBConnect();
			dbc.prepareStatement("DELETE FROM assess WHERE AssessNO=?");
			dbc.setInt(1, DataConvert.StrToInt(_AssessNO));
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * search Assess by EmployeeID
	 */
	public static Vector SearchByID(String _EmployeeID) {
		DBConnect dbc = null;
		Vector AssessVector = new Vector();
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("SELECT * FROM assess WHERE EmployeeID=? ORDER BY GetDate ASC");
			dbc.setString(1, _EmployeeID);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Assess assess = new Assess();
				assess.setAssessNO(rs.getInt("AssessNO"));
				assess.setEmployeeID(rs.getString("EmployeeID"));
				assess.setPosition(rs.getString("Position"));
				assess.setGetDate(rs.getString("GetDate"));
				assess.setGetType(rs.getString("GetType"));
				assess.setDuty(rs.getString("Duty"));
				assess.setStartDate(rs.getString("StartDate"));
				assess.setEndDate(rs.getString("EndDate"));
				assess.setDepartment(rs.getString("Department"));
				assess.setEnglish(rs.getString("English"));
				assess.setComputer(rs.getString("Computer"));
				assess.setRemark(rs.getString("Remark"));
				AssessVector.add(assess);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return AssessVector;

	}

	/*
	 * List All Assess
	 */
	public static Vector ListAll() {
		DBConnect dbc = null;
		Vector AssessVector = new Vector();

		String strSQL = "SELECT * FROM assess ORDER BY EmployeeID,GetDate ASC";

		try {
			dbc = new DBConnect();
			dbc.prepareStatement(strSQL);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Assess assess = new Assess();
				assess.setAssessNO(rs.getInt("AssessNO"));
				assess.setEmployeeID(rs.getString("EmployeeID"));
				assess.setPosition(rs.getString("Position"));
				assess.setGetDate(rs.getString("GetDate"));
				assess.setGetType(rs.getString("GetType"));
				assess.setDuty(rs.getString("Duty"));
				assess.setStartDate(rs.getString("StartDate"));
				assess.setEndDate(rs.getString("EndDate"));
				assess.setDepartment(rs.getString("Department"));
				assess.setEnglish(rs.getString("English"));
				assess.setComputer(rs.getString("Computer"));
				assess.setRemark(rs.getString("Remark"));
				AssessVector.add(assess);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return AssessVector;

	}

	
}