protected void lbuLogin_Click(object sender, EventArgs e)
{
int count = DatabaseManager.ExecuteInt("SELECT count(*) FROM PS_PERSON WHERE PS_CITIZEN_ID = '" + tbUsername.Text + "'");
if(count == 0) {
Label12X.Text = "ไม่พบผู้ใช้งาน!";
} else {
if(DatabaseManager.ValidateUser(tbUsername.Text, tbPassword.Text)) {
PersonnelSystem ps = new PersonnelSystem();
ps.LoginPerson = DatabaseManager.GetPerson(tbUsername.Text);
Session["PersonnelSystem"] = ps;
if (DatabaseManager.ExecuteInt("SELECT COUNT(*) FROM LEV_CLAIM WHERE PS_CITIZEN_ID = '" + ps.LoginPerson.CitizenID + "' AND YEAR = " + Util.BudgetYear()) == 0) {
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand("INSERT INTO LEV_CLAIM (LEAVE_CLAIM_ID, PS_CITIZEN_ID, YEAR, SICK_NOW, SICK_REQ, BUSINESS_NOW, BUSINESS_REQ, GB_NOW, GB_REQ, REST_NOW, REST_REQ, REST_SAVE, REST_SAVE_FIX, REST_THIS, REST_THIS_FIX, REST_MAX, HGB_NOW, HGB_REQ, ORDAIN_NOW, ORDAIN_REQ, HUJ_NOW, HUJ_REQ, SICK_MAX, BUSINESS_MAX, HUJ_MAX, ORDAIN_MAX) VALUES (SEQ_LEV_CLAIM_ID.NEXTVAL, :PS_CITIZEN_ID, :YEAR, :SICK_NOW, :SICK_REQ, :BUSINESS_NOW, :BUSINESS_REQ, :GB_NOW, :GB_REQ, :REST_NOW, :REST_REQ, :REST_SAVE, :REST_SAVE_FIX, :REST_THIS, :REST_THIS_FIX, :REST_MAX, :HGB_NOW, :HGB_REQ, :ORDAIN_NOW, :ORDAIN_REQ, :HUJ_NOW, :HUJ_REQ, :SICK_MAX, :BUSINESS_MAX, :HUJ_MAX, :ORDAIN_MAX)", con)) {
com.Parameters.AddWithValue("PS_CITIZEN_ID", ps.LoginPerson.CitizenID);
com.Parameters.AddWithValue("YEAR", Util.BudgetYear());
int v1 = 0;
int v2 = 10;
int v60 = 60;
int v45 = 45;
int v120 = 120;
com.Parameters.AddWithValue("SICK_NOW", v1);
com.Parameters.AddWithValue("SICK_REQ", v1);
com.Parameters.AddWithValue("BUSINESS_NOW", v1);
com.Parameters.AddWithValue("BUSINESS_REQ", v1);
com.Parameters.AddWithValue("GB_NOW", v1);
com.Parameters.AddWithValue("GB_REQ", v1);
com.Parameters.AddWithValue("REST_NOW", v1);
com.Parameters.AddWithValue("REST_REQ", v1);
com.Parameters.AddWithValue("REST_SAVE", v1);
com.Parameters.AddWithValue("REST_SAVE_FIX", v1);
com.Parameters.AddWithValue("REST_THIS", v2);
com.Parameters.AddWithValue("REST_THIS_FIX", v2);
com.Parameters.AddWithValue("REST_MAX", v2);
com.Parameters.AddWithValue("HGB_NOW", v1);
com.Parameters.AddWithValue("HGB_REQ", v1);
com.Parameters.AddWithValue("ORDAIN_NOW", v1);
com.Parameters.AddWithValue("ORDAIN_REQ", v1);
com.Parameters.AddWithValue("HUJ_NOW", v1);
com.Parameters.AddWithValue("HUJ_REQ", v1);
com.Parameters.AddWithValue("SICK_MAX", v60);
com.Parameters.AddWithValue("BUSINESS_MAX", v45);
com.Parameters.AddWithValue("HUJ_MAX", v120);
com.Parameters.AddWithValue("ORDAIN_MAX", v120);
com.ExecuteNonQuery();
}
}
}
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand("SELECT LEAVE_ID FROM LEV_DATA WHERE CURRENT_DATE >= FROM_DATE AND LEAVE_TYPE_ID IN(2,4,6,7) AND LEAVE_STATUS_ID = 1", con)) {
using(OracleDataReader reader = com.ExecuteReader()) {
while(reader.Read()) {
int leaveID = reader.GetInt32(0);
LeaveData leaveData = new LeaveData();
leaveData.Load(leaveID);
leaveData.ExecuteCancelBySystem();
}
}
}
using (OracleCommand com = new OracleCommand("SELECT LEAVE_ID FROM LEV_DATA WHERE LEAVE_STATUS_ID = 1 AND TRUNC(CURRENT_DATE - REQ_DATE, 0) >= 3", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
int leaveID = reader.GetInt32(0);
LeaveData leaveData = new LeaveData();
leaveData.Load(leaveID);
leaveData.ExecuteCancelBySystem();
}
}
}
/*using (OracleCommand com = new OracleCommand("SELECT LEAVE_ID FROM LEV_DATA WHERE CURRENT_DATE >= FROM_DATE AND LEAVE_TYPE_ID IN(2,4,6,7) AND LEAVE_STATUS_ID = 4", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
int leaveID = reader.GetInt32(0);
LeaveData leaveData = new LeaveData();
leaveData.Load(leaveID);
leaveData.ExecuteCancelOfCancelBySystem();
}
}
}
using (OracleCommand com = new OracleCommand("SELECT LEAVE_ID FROM LEV_DATA WHERE LEAVE_STATUS_ID = 4 AND TRUNC(CURRENT_DATE - CANCEL_DATE, 0) >= 3", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read()) {
int leaveID = reader.GetInt32(0);
LeaveData leaveData = new LeaveData();
leaveData.Load(leaveID);
leaveData.ExecuteCancelOfCancelBySystem();
}
}
}*/
//-------------
/*using (OracleCommand com = new OracleCommand("UPDATE LEV_DATA SET LEAVE_STATUS_ID = 10 WHERE LEAVE_ID = (SELECT LEAVE_ID FROM LEV_DATA WHERE CURRENT_DATE >= FROM_DATE AND LEAVE_TYPE_ID IN(2,4,6,7) AND LEAVE_STATUS_ID IN(1,2))", con)) {
com.ExecuteNonQuery();
}
using (OracleCommand com = new OracleCommand("UPDATE LEV_DATA SET LEAVE_STATUS_ID = 10 WHERE LEAVE_ID = (SELECT LEAVE_ID FROM LEV_DATA WHERE LEAVE_STATUS_ID IN(1,2) AND TRUNC(CURRENT_DATE - REQ_DATE, 0) >= 3)", con)) {
com.ExecuteNonQuery();
}*/
}
Response.Redirect("Default.aspx");
} else {
Label12X.Text = "รหัสผ่านไม่ถูกต้อง!";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack) {
if(Request.QueryString["ID"] != null && Request.QueryString["Password"] != null && Request.QueryString["Action"] != null) {
if (DatabaseManager.ValidateUser(Request.QueryString["ID"], Request.QueryString["Password"])) {
PersonnelSystem ps = new PersonnelSystem();
ps.LoginPerson = DatabaseManager.GetPerson(Request.QueryString["ID"].ToString());
Session["PersonnelSystem"] = ps;
if(Request.QueryString["Action"] == "1") {
Response.Redirect("ChangePassword.aspx");
} else {
Response.Redirect("Default.aspx");
}
} else {
Label12X.Text = "รหัสผ่านไม่ถูกต้อง!";
}
}
}
Session.Remove("PersonnelSystem");
}
