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"); }