private void ReadSelectID()
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT CITIZEN_ID,(SELECT UNIV_NAME_TH FROM REF_UNIV WHERE REF_UNIV.UNIV_ID = UOC_STAFF.UNIV_ID) UNIV_NAME,(SELECT FULLNAME FROM REF_PREFIX_NAME WHERE UOC_STAFF.PREFIX_NAME = REF_PREFIX_NAME.PREFIX_NAME_ID) PREFIX_NAME,STF_FNAME,STF_LNAME,(SELECT GENDER_NAME FROM REF_GENDER WHERE REF_GENDER.GENDER_ID = UOC_STAFF.GENDER_ID) GENDER_NAME,BIRTHDAY,HOMEADD,MOO,STREET,(SELECT PROVINCE_NAME_TH FROM REF_PROVINCE WHERE REF_PROVINCE.PROVINCE_ID = UOC_STAFF.PROVINCE_ID) PROVINCE_NAME,(SELECT DISTRICT_NAME_TH FROM REF_DISTRICT WHERE REF_DISTRICT.DISTRICT_ID = UOC_STAFF.DISTRICT_ID) DISTRICT_NAME,(SELECT SUB_DISTRICT_NAME_TH FROM REF_SUB_DISTRICT WHERE REF_SUB_DISTRICT.SUB_DISTRICT_ID = UOC_STAFF.SUB_DISTRICT_ID) SUB_DISTRICT_NAME,TELEPHONE,ZIPCODE,(SELECT NATION_NAME_ENG FROM REF_NATION WHERE REF_NATION.NATION_ID = UOC_STAFF.NATION_ID) NATION_NAME,(SELECT STAFFTYPE_NAME FROM REF_STAFFTYPE WHERE REF_STAFFTYPE.STAFFTYPE_ID = UOC_STAFF.STAFFTYPE_ID) STAFFTYPE_NAME,(SELECT TIME_CONTACT_NAME FROM REF_TIME_CONTACT WHERE REF_TIME_CONTACT.TIME_CONTACT_ID = UOC_STAFF.TIME_CONTACT_ID) TIME_CONTACT_NAME,(SELECT BUDGET_NAME FROM REF_BUDGET WHERE REF_BUDGET.BUDGET_ID = UOC_STAFF.BUDGET_ID) BUDGET_NAME,(SELECT SUBSTAFFTYPE_NAME FROM REF_SUBSTAFFTYPE WHERE REF_SUBSTAFFTYPE.SUBSTAFFTYPE_ID = UOC_STAFF.SUBSTAFFTYPE_ID) SUBSTAFFTYPE_NAME,(SELECT ADMIN_NAME FROM REF_ADMIN WHERE REF_ADMIN.ADMIN_ID = UOC_STAFF.ADMIN_POSITION_ID) ADMIN_POSITION_NAME,(SELECT POSITION_NAME_TH FROM REF_POSITION WHERE REF_POSITION.POSITION_ID = UOC_STAFF.POSITION_ID) POSITION_NAME,POSITION_WORK,(SELECT FAC_NAME FROM REF_FAC WHERE REF_FAC.FAC_ID = UOC_STAFF.DEPARTMENT_ID) DEPARTMENT_NAME,DATE_INWORK,DATE_START_THIS_U,SPECIAL_NAME,(SELECT ISCED_NAME FROM REF_ISCED WHERE REF_ISCED.ISCED_ID = UOC_STAFF.TEACH_ISCED_ID) TEACH_ISCED_NAME,(SELECT LEV_NAME_TH FROM REF_LEV WHERE REF_LEV.LEV_ID = UOC_STAFF.GRAD_LEV_ID) GRAD_LEV_NAME,GRAD_CURR,(SELECT ISCED_NAME FROM REF_ISCED WHERE REF_ISCED.ISCED_ID = UOC_STAFF.GRAD_ISCED_ID) GRAD_ISCED_NAME,(SELECT PROGRAM_NAME FROM REF_PROGRAM WHERE REF_PROGRAM.PROGRAM_ID_NEW = UOC_STAFF.GRAD_PROG) GRAD_PROG,GRAD_UNIV,(SELECT NATION_NAME_ENG FROM REF_NATION WHERE REF_NATION.NATION_ID = UOC_STAFF.GRAD_COUNTRY_ID) GRAD_COUNTRY_NAME,(SELECT DEFORM_NAME FROM REF_DEFORM WHERE REF_DEFORM.DEFORM_ID = UOC_STAFF.DEFORM_ID) DEFORM_NAME,SIT_NO,SALARY,POSITION_SALARY,(SELECT RELIGION_NAME_TH FROM REF_RELIGION WHERE REF_RELIGION.RELIGION_ID = UOC_STAFF.RELIGION_ID) RELIGION_NAME_TH,(SELECT MOVEMENT_TYPE_NAME FROM REF_MOVEMENT_TYPE WHERE REF_MOVEMENT_TYPE.MOVEMENT_TYPE_ID = UOC_STAFF.MOVEMENT_TYPE_ID) MOVEMENT_TYPE_NAME,MOVEMENT_DATE,DECORATION,RESULT1,PERCENT_SALARY1,RESULT2,PERCENT_SALARY2 FROM UOC_STAFF WHERE UOC_ID = '" + loginPerson.UOC_ID + "'", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
int i = 0;
lbCitizenID.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbUniv.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbPrefixName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbLastName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbGender.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbBirthday.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd/MM/yyyy"); ++i;
lbHomeAdd.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
}
}
}
}
}
protected void btn1_Click(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF LoginPerson = ps.LoginPerson;
if (FileUpload1.HasFile)
{
FileInfo fi = new FileInfo(FileUpload1.FileName);
string fname = RandomFileName() + fi.Extension;
FileUpload1.SaveAs(Server.MapPath("~/Upload/PersonImage/" + fname));
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("INSERT INTO PS_PERSON_IMAGE (ID, CITIZEN_ID, URL, PRESENT) VALUES (PS_PERSON_IMAGE_SEQ.NEXTVAL, :CITIZEN_ID, :URL, :PRESENT)", con))
{
com.Parameters.AddWithValue("CITIZEN_ID", LoginPerson.CITIZEN_ID);
com.Parameters.AddWithValue("URL", fname);
int v1 = 0;
com.Parameters.AddWithValue("PRESENT", v1);
com.ExecuteNonQuery();
}
}
}
Page.Response.Redirect(Page.Request.Url.ToString(), true);
}
protected void lbuBack_Click(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
int count = 0;
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand("SELECT COUNT(LEAVE_ID) FROM LEV_LEAVE WHERE CMD_HIGH_ID = '" + loginPerson.CITIZEN_ID + "' AND LEV_LEAVE.STATE_ID = 3", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read())
{
count = int.Parse(reader.GetValue(0).ToString());
}
}
}
}
if (count == 0)
{
error_area.InnerHtml = "ไม่มีรายการที่ท่านต้องอนุมัติ";
}
else
{
error_area.InnerHtml = "กรุณาเลือกรายการที่ต้องอนุมัติ";
}
//error_area.Attributes["class"] = "alert alert_info";
error_area.Attributes["class"] = null;
error_area.InnerHtml = "";
MultiView1.ActiveViewIndex = 0;
}
private void fBack()
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
int count = 0;
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand("SELECT COUNT(LEAVE_ID) FROM LEV_LEAVE WHERE CMD_LOW_ID = '" + loginPerson.CITIZEN_ID + "' AND LEV_LEAVE.STATE_ID = 1", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read())
{
count = int.Parse(reader.GetValue(0).ToString());
}
}
}
}
if (count == 0)
{
error_area.InnerHtml = "ไม่มีรายการที่ท่านต้องลงความเห็น";
}
else
{
error_area.InnerHtml = "กรุณาเลือกรายการที่ต้องการลงความเห็น";
}
//error_area.Attributes["class"] = "alert alert_info";
error_area.Attributes["class"] = null;
error_area.InnerHtml = "";
MultiView1.ActiveViewIndex = 0;
}
protected void lbuUpdatePerson_Click(object sender, EventArgs e)
{
if (tbZipcode.Text.Length != 5)
{
MultiView1.ActiveViewIndex = 0;
ScriptManager.GetCurrent(this.Page).SetFocus(this.tbZipcode);
ChangeNotification("danger", "กรุณากรอกรหัสไปรษณีย์ให้ครบ 5 หลัก");
return;
}
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
PS_PERSON person = new PS_PERSON();
person.HOMEADD = tbHomeAdd.Text;
person.MOO = tbMoo.Text;
person.STREET = tbStreet.Text;
person.SUB_DISTRICT_ID = ddlSubDistrict.SelectedValue;
person.DISTRICT_ID = ddlDistrict.SelectedValue;
person.PROVINCE_ID = ddlProvince.SelectedValue;
person.TELEPHONE = tbTelephone.Text;
person.ZIPCODE = tbZipcode.Text;
person.NATION_ID = ddlNation.SelectedValue;
person.UOC_ID = loginPerson.UOC_ID;
person.UPDATE_PERSON_USER();
INSERT_REQUEST();
MultiView1.ActiveViewIndex = 3;
btnSelectView0.Visible = false;
btnSelectView1.Visible = false;
btnSelectView2.Visible = false;
btnUpdatePerson.Visible = false;
}
protected void BindData()
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING);
OracleDataAdapter sda = new OracleDataAdapter("SELECT (SELECT STF_FNAME || ' ' || STF_LNAME FROM UOC_STAFF WHERE UOC_STAFF.UOC_ID = TB_PROJECT.UOC_ID) NAME, (SELECT CATEGORY_NAME FROM TB_PROJECT_CATEGORY WHERE TB_PROJECT_CATEGORY.CATEGORY_ID = TB_PROJECT.CATEGORY_ID) CATEGORY_ID, PROJECT_NAME, ADDRESS_PROJECT, PRO_ID FROM TB_PROJECT ORDER BY UOC_ID ASC", con);
DataTable dt = new DataTable();
sda.Fill(dt);
myRepeater.DataSource = dt;
myRepeater.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
loginPerson = ps.LoginPerson;
LoadCalendar(Table1, DateTime.Today);
LoadCalendar(Table2, DateTime.Today.AddMonths(1));
if (!IsPostBack)
{
LoadAbsentLate();
}
}
private void ReadSelectID()
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT HOMEADD,MOO,STREET,PROVINCE_ID,DISTRICT_ID,SUB_DISTRICT_ID,TELEPHONE,ZIPCODE,NATION_ID,SPECIAL_NAME,TEACH_ISCED_ID,UNIV_ID,PREFIX_NAME,STF_FNAME,STF_LNAME FROM UOC_STAFF WHERE CITIZEN_ID = '" + loginPerson.CITIZEN_ID + "'", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
int i = 0;
tbHomeAdd.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbMoo.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbStreet.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
ddlProvince.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
ddlDistrict.Items.Clear();
string s1 = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
DatabaseManager.BindDropDown(ddlDistrict, "SELECT * FROM REF_DISTRICT WHERE PROVINCE_ID = " + ddlProvince.SelectedValue, "DISTRICT_NAME_TH", "DISTRICT_ID", "--กรุณาเลือกอำเภอ--");
ddlDistrict.SelectedValue = s1;
ddlSubDistrict.Items.Clear();
string s2 = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
DatabaseManager.BindDropDown(ddlSubDistrict, "SELECT * FROM REF_SUB_DISTRICT WHERE DISTRICT_ID = " + ddlDistrict.SelectedValue, "SUB_DISTRICT_NAME_TH", "SUB_DISTRICT_ID", "--กรุณาเลือกตำบล--");
ddlSubDistrict.SelectedValue = s2;
tbTelephone.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbZipcode.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
ddlNation.SelectedValue = reader.IsDBNull(i) ? null : reader.GetString(i); ++i;
lbSpecialName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbTeachISCED.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
//
ddlUniv.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
ddlPrefixName.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbLastName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
}
}
}
}
}
//private List<DateTime> datetimeList;
protected void Page_Load(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
pp = ps.LoginPerson;
//datetimeList = DatabaseManager.GetLeaveDateTimeFromToDate(pp.CitizenID);
LoadCalendar(Panel1, DateTime.Today);
if (!IsPostBack)
{
DateTime dt = DateTime.Today;
ddlMonth.SelectedValue = "" + dt.Month;
tbYear.Text = "" + (dt.Year + 543);
}
}
protected void Page_Load(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
loginPerson = ps.LoginPerson;
FuncGVFinish();
FuncGVProcessing();
FuncGVHistory();
FuncGVCH();
FuncLeaveClaim();
if (!IsPostBack)
{
lbuVS1.CssClass = "ps-tab-selected";
}
}
protected void Page_Load(object sender, EventArgs e)
{
loginPerson = PersonnelSystem.GetPersonnelSystem(this).LoginPerson;
if (!IsPostBack)
{
//Session["LeaveReportTable"] = null;
for (int i = 2500; i < 2600; ++i)
{
DropDownList1.Items.Add(new System.Web.UI.WebControls.ListItem("" + i, "" + i));
}
//DateTime dt = Util.ODTT();
/*if (dt.Month >= 10) {
* DropDownList1.SelectedValue = "" + (dt.Year + 1);
* } else {
* DropDownList1.SelectedValue = "" + dt.Year;
* }*/
DropDownList1.SelectedValue = "" + (Util.BudgetYear() + 543);
ddlView.Items.Add(new ListItem("แสดงทั้งหมด", "1"));
ddlView.Items.Add(new ListItem("แสดงเฉพาะภายในวิทยาเขต", "2"));
ddlView.Items.Add(new ListItem("แสดงเฉพาะภายใน สำนัก / สถาบัน / คณะ", "3"));
ddlView.Items.Add(new ListItem("แสดงเฉพาะภายใน กอง / สำนักงานเลขา / ภาควิชา", "4"));
ddlView.Items.Add(new ListItem("แสดงเฉพาะภายใน งาน / ฝ่าย", "5"));
ddlView.Items.Add(new ListItem("แสดงเฉพาะตนเอง", "6"));
ddlSelfView.Items.Add(new ListItem("แสดงการลาทั้งหมด", "1"));
ddlSelfView.Items.Add(new ListItem("แสดงตามรหัสการลา", "2"));
/* trSelfView.Style.Add("display", "none");
* trSelfViewLeaveID.Style.Add("display", "none");*/
}
/*if(Session["LeaveReportTable"] != null) {
* Table tb = (Table)Session["LeaveReportTable"];
* Panel1.Controls.Clear();
* Panel1.Controls.Add(tb);
* }*/
}
protected void Page_Load(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
if (!IsPostBack)
{
if (loginPerson.IsLoginFirst())
{
TitleDivNamePassOld.Visible = false;
divPassOld.Visible = false;
tbPasswordOld.Visible = false;
}
if (loginPerson.IsLoginSecond())
{
tbPasswordOld.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
loginPerson = ps.LoginPerson;
if (!IsPostBack)
{
if (MultiView1.ActiveViewIndex == 0)
{
btnSelectView0.CssClass = "btn btn-info";
btnSelectView1.CssClass = "btn btn-primary";
btnSelectView2.CssClass = "btn btn-primary";
}
BindDDL();
ReadSelectID();
BindLabel();
}
}
protected void Page_Load(object sender, EventArgs e)
{
UOC_STAFF ps = PersonnelSystem.GetPersonnelSystem(this).LoginPerson;
if (!IsPostBack)
{
SQLCampus();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) {
con.Open();
using (OracleCommand com = new OracleCommand("SELECT BOSS_NODE_ID, BOSS_NODE_NAME FROM TB_BOSS_NODE", con)) {
using (OracleDataReader reader = com.ExecuteReader()) {
while (reader.Read())
{
ddlHighNode.Items.Add(new ListItem(reader.GetInt32(0) + " | " + reader.GetString(1), reader.GetInt32(0) + ""));
}
}
}
}
}
BindTable();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
GridView1.DataSource = DatabaseManager.CreateSQLDataSource("SELECT * FROM LEV_CLAIM WHERE PS_CITIZEN_ID = '" + loginPerson.UOC_ID + "'");
GridView1.DataBind();
/*using(OleDbConnection con = new OleDbConnection(DatabaseManager.CONNECTION_STRING)) {
* con.Open();
* using(OleDbCommand com = new OleDbCommand("SELECT * FROM LEV_CLAIM WHERE PS_CITIZEN_ID = '" + loginPerson.CitizenID + "' AND YEAR = EXTRACT(YEAR FROM CURRENT_DATE)", con)) {
* using(OleDbDataReader reader = com.ExecuteReader()) {
* while(reader.Read()) {
* //lbKij.Text = reader.GetValue(9).ToString() + "/" + reader.GetValue(10).ToString();
* lbRest.Text = reader.GetValue(11).ToString() + "/" + reader.GetValue(12).ToString();
* //lbOrdain.Text = reader.GetValue(13).ToString() + "/" + reader.GetValue(14).ToString();
* }
* }
* }
* }*/
}
}
private void ReadSelectID()
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT CITIZEN_ID,(SELECT UNIV_NAME_TH FROM REF_UNIV WHERE REF_UNIV.UNIV_ID = UOC_STAFF.UNIV_ID) UNIV_NAME,(SELECT FULLNAME FROM REF_PREFIX_NAME WHERE UOC_STAFF.PREFIX_NAME = REF_PREFIX_NAME.PREFIX_NAME_ID) PREFIX_NAME,STF_FNAME,STF_LNAME,(SELECT GENDER_NAME FROM REF_GENDER WHERE REF_GENDER.GENDER_ID = UOC_STAFF.GENDER_ID) GENDER_NAME,BIRTHDAY,HOMEADD,MOO,STREET,(SELECT PROVINCE_NAME_TH FROM REF_PROVINCE WHERE REF_PROVINCE.PROVINCE_ID = UOC_STAFF.PROVINCE_ID) PROVINCE_NAME,(SELECT DISTRICT_NAME_TH FROM REF_DISTRICT WHERE REF_DISTRICT.DISTRICT_ID = UOC_STAFF.DISTRICT_ID) DISTRICT_NAME,(SELECT SUB_DISTRICT_NAME_TH FROM REF_SUB_DISTRICT WHERE REF_SUB_DISTRICT.SUB_DISTRICT_ID = UOC_STAFF.SUB_DISTRICT_ID) SUB_DISTRICT_NAME,TELEPHONE,ZIPCODE,(SELECT NATION_NAME_ENG FROM REF_NATION WHERE REF_NATION.NATION_ID = UOC_STAFF.NATION_ID) NATION_NAME,(SELECT STAFFTYPE_NAME FROM REF_STAFFTYPE WHERE REF_STAFFTYPE.STAFFTYPE_ID = UOC_STAFF.STAFFTYPE_ID) STAFFTYPE_NAME,(SELECT TIME_CONTACT_NAME FROM REF_TIME_CONTACT WHERE REF_TIME_CONTACT.TIME_CONTACT_ID = UOC_STAFF.TIME_CONTACT_ID) TIME_CONTACT_NAME,(SELECT BUDGET_NAME FROM REF_BUDGET WHERE REF_BUDGET.BUDGET_ID = UOC_STAFF.BUDGET_ID) BUDGET_NAME,(SELECT SUBSTAFFTYPE_NAME FROM REF_SUBSTAFFTYPE WHERE REF_SUBSTAFFTYPE.SUBSTAFFTYPE_ID = UOC_STAFF.SUBSTAFFTYPE_ID) SUBSTAFFTYPE_NAME,(SELECT ADMIN_NAME FROM REF_ADMIN WHERE REF_ADMIN.ADMIN_ID = UOC_STAFF.ADMIN_POSITION_ID) ADMIN_POSITION_NAME,(SELECT POSITION_NAME_TH FROM REF_POSITION WHERE REF_POSITION.POSITION_ID = UOC_STAFF.POSITION_ID) POSITION_NAME,POSITION_WORK,(SELECT FAC_NAME FROM REF_FAC WHERE REF_FAC.FAC_ID = UOC_STAFF.DEPARTMENT_ID) DEPARTMENT_NAME,DATE_INWORK,DATE_START_THIS_U,SPECIAL_NAME,(SELECT ISCED_NAME FROM REF_ISCED WHERE REF_ISCED.ISCED_ID = UOC_STAFF.TEACH_ISCED_ID) TEACH_ISCED_NAME,(SELECT LEV_NAME_TH FROM REF_LEV WHERE REF_LEV.LEV_ID = UOC_STAFF.GRAD_LEV_ID) GRAD_LEV_NAME,GRAD_CURR,(SELECT ISCED_NAME FROM REF_ISCED WHERE REF_ISCED.ISCED_ID = UOC_STAFF.GRAD_ISCED_ID) GRAD_ISCED_NAME,(SELECT PROGRAM_NAME FROM REF_PROGRAM WHERE REF_PROGRAM.PROGRAM_ID_NEW = UOC_STAFF.GRAD_PROG) GRAD_PROG,GRAD_UNIV,(SELECT NATION_NAME_ENG FROM REF_NATION WHERE REF_NATION.NATION_ID = UOC_STAFF.GRAD_COUNTRY_ID) GRAD_COUNTRY_NAME,(SELECT DEFORM_NAME FROM REF_DEFORM WHERE REF_DEFORM.DEFORM_ID = UOC_STAFF.DEFORM_ID) DEFORM_NAME,SIT_NO,SALARY,POSITION_SALARY,(SELECT RELIGION_NAME_TH FROM REF_RELIGION WHERE REF_RELIGION.RELIGION_ID = UOC_STAFF.RELIGION_ID) RELIGION_NAME_TH,(SELECT MOVEMENT_TYPE_NAME FROM REF_MOVEMENT_TYPE WHERE REF_MOVEMENT_TYPE.MOVEMENT_TYPE_ID = UOC_STAFF.MOVEMENT_TYPE_ID) MOVEMENT_TYPE_NAME,MOVEMENT_DATE,DECORATION,RESULT1,PERCENT_SALARY1,RESULT2,PERCENT_SALARY2 FROM UOC_STAFF WHERE UOC_ID = '" + loginPerson.UOC_ID + "'", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
int i = 0;
lbCitizenID.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbUniv.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbPrefixName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbLastName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbGender.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbBirthday.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd/MM/yyyy"); ++i;
lbHomeAdd.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbMoo.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbStreet.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbProvince.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbDistrict.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbSubDistrict.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbTelephone.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbZipcode.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbNation.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbStaffType.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbTimeContact.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbBudget.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbSubStafftype.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbAdminPosition.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbPosition.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbPositionWork.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbDepartment.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbDateInwork.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd/MM/yyyy"); ++i;
lbDateStartThisU.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd/MM/yyyy"); ++i;
lbSpecialName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbTeachISCED.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbGradLev.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbGradCURR.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbGradISCED.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbGradProg.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbGradUniv.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbGradCountry.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbDeform.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbSitNo.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbSalary.Text = reader.IsDBNull(i) ? "" : reader.GetInt32(i).ToString(); ++i;
lbPositionSalary.Text = reader.IsDBNull(i) ? "" : reader.GetInt32(i).ToString(); ++i;
lbReligion.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbMovementType.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbMovementDate.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd/MM/yyyy"); ++i;
lbDecoration.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbResult1.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbPercentSalary1.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbResult2.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbPercentSalary2.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
}
}
}
}
}
protected void btnUpdateProject_Click(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
string[] validFileTypes = { "pdf" };
string ext = System.IO.Path.GetExtension(FUdocument.PostedFile.FileName);
bool isValidFile = false;
for (int i = 0; i < validFileTypes.Length; i++)
{
if (ext == "." + validFileTypes[i])
{
isValidFile = true;
break;
}
}
if (!isValidFile)
{
ScriptManager.GetCurrent(this.Page).SetFocus(this.FUdocument);
ChangeNotification("danger", "กรุณาแนบไฟล์นามสกุล " + string.Join(",", validFileTypes) + " เท่านั้น");
return;
}
else if (FUdocument.PostedFile.ContentLength > 26214400)
{
ScriptManager.GetCurrent(this.Page).SetFocus(this.FUdocument);
ChangeNotification("danger", "กรุณาแนบไฟล์ไม่เกิน 25 MB");
return;
}
else
{
ChangeNotification("", "");
}
if (tbStartDate.Text != "" && tbEndDate.Text != "")
{
DateTime dtEndDate = DateTime.Parse(tbEndDate.Text);
DateTime dtStartDate = DateTime.Parse(tbStartDate.Text);
int totalDay = (int)(dtEndDate - dtStartDate).TotalDays + 1;
if (totalDay <= 0)
{
notification.Attributes["class"] = "alert alert_danger";
notification.InnerHtml = "";
notification.InnerHtml += "<div> <img src='Image/Small/red_alert.png' /> วันที่เริ่มโครงการ - วันที่สิ้นสุดโครงการ : วันที่ไม่ถูกต้อง !</div>";
ScriptManager.GetCurrent(this.Page).SetFocus(this.tbStartDate);
return;
}
else
{
notification.Attributes["class"] = "none";
notification.InnerHtml = "";
}
}
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
PROJECT p = new PROJECT();
p.Load(int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
p.CATEGORY_ID = Convert.ToInt32(ddlCategory.SelectedValue);
p.PROJECT_NAME = tbProjectName.Text;
p.ADDRESS_PROJECT = tbAddressProject.Text;
p.START_DATE = DateTime.Parse(tbStartDate.Text);
p.END_DATE = DateTime.Parse(tbEndDate.Text);
p.EXPENSES = Convert.ToInt32(tbExpenses.Text);
p.FUNDING = tbFunding.Text;
p.CERTIFICATE = tbCertificate.Text;
p.SUMMARIZE_PROJECT = tbSummarizeProject.Text;
p.RESULT_TEACHING = tbResultTeaching.Text;
p.RESULT_ACADEMIC = tbResultAcademic.Text;
p.DIFFICULTY_PROJECT = tbDifficultyProject.Text;
p.RESULT_PROJECT = tbResultProject.Text;
p.RESULT_RESEARCHING = tbResultResearching.Text;
p.RESULT_OTHER = tbResultOther.Text;
p.COUNSEL = tbCounsel.Text;
p.COUNTRY_ID = Convert.ToInt32(ddlCountry.SelectedValue);
p.SUB_COUNTRY_ID = Convert.ToInt32(ddlSubCountry.SelectedValue);
if (FUdocument.HasFile)
{
string CountBase = DatabaseManager.ExecuteString("select count(*) from tb_project where pro_id = '" + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + "'");
FileInfo fi = new FileInfo(FUdocument.FileName);
string imgFile = "UID=" + p.UOC_ID + "&count=" + CountBase + fi.Extension;
FUdocument.SaveAs(Server.MapPath("Upload/Project/PDF/" + imgFile));
p.IMG_FILE = imgFile;
}
p.PRO_ID = int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()));
p.UPDATE_PROJECT();
Notsuccess.Visible = false;
success.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
int count = DatabaseManager.GetLeaveRequiredCountByCommander(loginPerson.CITIZEN_ID);
/* using (OleDbConnection con = new OleDbConnection(DatabaseManager.CONNECTION_STRING)) {
* con.Open();
* using (OleDbCommand com = new OleDbCommand("SELECT COUNT(LEAVE_ID) FROM LEV_LEAVE WHERE CMD_HIGH_ID = '" + loginPerson.CitizenID + "' AND LEV_LEAVE.STATE_ID = 2", con)) {
* using (OleDbDataReader reader = com.ExecuteReader()) {
* while (reader.Read()) {
* count = int.Parse(reader.GetValue(0).ToString());
* }
* }
* }
* }*/
if (count == 0)
{
error_area.InnerHtml = "ไม่มีรายการที่ท่านต้องอนุมัติ";
}
else
{
error_area.InnerHtml = "กรุณาเลือกรายการที่ต้องการอนุมัติ";
}
error_area.Attributes["class"] = null;
error_area.InnerHtml = "";
if (count > 0)
{
SqlDataSource sds = DatabaseManager.CreateSQLDataSource("SELECT LEV_DATA.LEAVE_ID รหัสการลา, (SELECT PS_FN_TH || ' ' || PS_LN_TH FROM PS_PERSON WHERE PS_CITIZEN_ID = LEV_DATA.PS_ID) ชื่อผู้ลา, (SELECT LEAVE_TYPE_NAME FROM LEV_TYPE WHERE LEV_TYPE.LEAVE_TYPE_ID = LEV_DATA.LEAVE_TYPE_ID) ประเภทการลา, REQ_DATE วันที่ข้อมูล, (SELECT LEAVE_STATUS_NAME FROM LEV_STATUS WHERE LEAVE_STATUS_ID = LEV_DATA.LEAVE_STATUS_ID) สถานะ FROM LEV_DATA, LEV_BOSS_DATA WHERE LEAVE_STATUS_ID IN(1,4) AND LEV_DATA.LEAVE_ID = LEV_BOSS_DATA.LEAVE_ID AND LEV_DATA.BOSS_STATE = LEV_BOSS_DATA.STATE AND LEV_BOSS_DATA.CITIZEN_ID = '" + loginPerson.CITIZEN_ID + "'");
GridView1.DataSource = sds;
GridView1.DataBind();
Util.NormalizeGridViewDate(GridView1, 3);
TableHeaderCell newHeader = new TableHeaderCell();
newHeader.Text = "เลือก";
GridView1.HeaderRow.Cells.Add(newHeader);
GridView1.HeaderRow.Cells[0].Text = "<img src='Image/Small/ID.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[0].Text;
GridView1.HeaderRow.Cells[1].Text = "<img src='Image/Small/person2.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[1].Text;
GridView1.HeaderRow.Cells[2].Text = "<img src='Image/Small/list.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[2].Text;
GridView1.HeaderRow.Cells[3].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[3].Text;
GridView1.HeaderRow.Cells[4].Text = "<img src='Image/Small/question.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[4].Text;
GridView1.HeaderRow.Cells[5].Text = "<img src='Image/Small/pointer.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[5].Text;
for (int i = 0; i < GridView1.Rows.Count; ++i)
{
string id = GridView1.Rows[i].Cells[0].Text;
LinkButton lbu = new LinkButton();
lbu.Text = "<img src='Image/Small/next.png'></img>";
lbu.CssClass = "ps-button";
lbu.Click += (e2, e3) => {
LeaveData leaveData = new LeaveData();
leaveData.Load(int.Parse(id));
Session["LeaveData"] = leaveData;
trPSBirthDate.Visible = false;
trPSWorkInDate.Visible = false;
trWifeName.Visible = false;
trGBDate.Visible = false;
trOrdained.Visible = false;
trTempleName.Visible = false;
trTempleLocation.Visible = false;
trOrdainDate.Visible = false;
trHujed.Visible = false;
trReason.Visible = false;
trContact.Visible = false;
trPhone.Visible = false;
trRestSave.Visible = false;
trRestLeft.Visible = false;
trRestTotal.Visible = false;
trStatistic.Visible = false;
//trCLOldComment.Visible = false;
//trCLOldDate.Visible = false;
//trCHOldComment.Visible = false;
//trCHOldDate.Visible = false;
trCancelReason.Visible = false;
if (leaveData.LeaveTypeID == 1)
{
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 2)
{
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 3)
{
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 4)
{
trRestSave.Visible = true;
trRestLeft.Visible = true;
trRestTotal.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 5)
{
trWifeName.Visible = true;
trGBDate.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 6)
{
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trOrdained.Visible = true;
trTempleName.Visible = true;
trTempleLocation.Visible = true;
trOrdainDate.Visible = true;
}
else if (leaveData.LeaveTypeID == 7)
{
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trHujed.Visible = true;
}
if (leaveData.LeaveStatusID == 2)
{
}
else if (leaveData.LeaveStatusID == 4)
{
//trCLOldComment.Visible = true;
//trCLOldDate.Visible = true;
//trCHOldComment.Visible = true;
//trCHOldDate.Visible = true;
trCancelReason.Visible = true;
}
lbLeaveID.Text = leaveData.LeaveID.ToString();
lbLeaveTypeName.Text = leaveData.LeaveTypeName;
lbReqDate.Text = leaveData.RequestDate.Value.ToLongDateString();
lbPSName.Text = leaveData.Person.FirstName + " " + leaveData.Person.LastName;
lbPSPos.Text = leaveData.Person.PositionWorkName;
lbPSAPos.Text = leaveData.Person.AdminPositionName;
if (Util.IsBlank(leaveData.Person.WorkDivisionID))
{
lbPSDept.Text = leaveData.Person.DivisionName;
}
else
{
lbPSDept.Text = leaveData.Person.WorkDivisionName;
}
//if (leaveData.PS_BirthDate.HasValue) {
lbPSBirthDate.Text = leaveData.Person.BIRTHDAY.Value.ToLongDateString();
//} else {
// lbPSBirthDate.Text = "-";
//}
//if (leaveData.PS_WorkInDate.HasValue) {
lbPSWorkInDate.Text = leaveData.Person.DATE_INWORK.Value.ToLongDateString();
//} else {
// lbPSWorkInDate.Text = "-";
// }
lbRestSave.Text = leaveData.RestSave + " วัน";
lbRestLeft.Text = leaveData.RestLeft + " วัน";
lbRestTotal.Text = leaveData.RestTotal + " วัน";
lbWifeName.Text = leaveData.WifeFirstName + " " + leaveData.WifeLastName;
if (leaveData.GiveBirthDate.HasValue)
{
lbGBDate.Text = leaveData.GiveBirthDate.Value.ToLongDateString();
}
else
{
lbGBDate.Text = "-";
}
lbOrdained.Text = leaveData.Ordained == 1 ? "เคย" : "ไม่เคย";
lbTempleName.Text = leaveData.TempleName;
lbTempleLocation.Text = leaveData.TempleLocation;
if (leaveData.OrdainDate.HasValue)
{
lbOrdainDate.Text = leaveData.OrdainDate.Value.ToLongDateString();
}
else
{
lbOrdainDate.Text = "-";
}
lbHujed.Text = leaveData.Hujed == 1 ? "เคย" : "ไม่เคย";
if (leaveData.FromDate.HasValue)
{
lbFTTDate.Text = leaveData.FromDate.Value.ToLongDateString() + " ถึง " + leaveData.ToDate.Value.ToLongDateString() + " รวม " + leaveData.TotalDay + " วัน";
}
else
{
lbFTTDate.Text = "ไม่เคยลา";
}
lbStatistic.Text = "ลามาแล้ว " + leaveData.CountPast + " วัน / ลาครั้งนี้ " + leaveData.CountNow + " วัน / รวม " + leaveData.CountTotal + " วัน";
lbReason.Text = leaveData.Reason;
lbContact.Text = leaveData.Contact;
lbPhone.Text = leaveData.Telephone;
if (leaveData.LastFromDate.HasValue)
{
lbLastFTTDate.Text = leaveData.LastFromDate.Value.ToLongDateString() + " ถึง " + leaveData.LastToDate.Value.ToLongDateString() + " รวม " + leaveData.LastTotalDay + " วัน";
}
else
{
lbLastFTTDate.Text = "ไม่เคยลา";
}
if (leaveData.DocterCertificationFileName != "")
{
divDrCer.InnerHtml = "<a href='Upload/Drcer/" + leaveData.DocterCertificationFileName + "'><img src='Upload/DrCer/" + leaveData.DocterCertificationFileName + "' style='width: 200px;' /></a>";
}
/*lbCLComment.Text = "";
* for (int j = 0; j < leaveData.LeaveBossDataList.Count; j++) {
* if(!leaveData.LeaveBossDataList[j].Allow.HasValue) {
* continue;
* }
* LeaveBossData leaveBossData = leaveData.LeaveBossDataList[j];
* lbCLComment.Text += "<div style='color: #808080'>" + leaveBossData.Person.FirstNameAndLastName + " / " + leaveBossData.AllowDate.Value.ToLongDateString() + "</div><div style='margin-bottom: 10px;'> - " + leaveBossData.Comment + "</div>";
* }*/
{
TableRow row = new TableRow();
TableCell cell2;
Image image;
tbBoss.Rows.Add(row);
for (int j = 0; j < leaveData.BossStateMax; j++)
{
LeaveBossData leaveBossData = leaveData.LeaveBossDataList[j];
cell2 = new TableCell();
cell2.Style.Add("vertical-align", "top");
Table tb = new Table();
tb.CssClass = "ps-table-1";
tb.Style.Add("text-align", "left");
{
TableRow tr;
TableCell cell3;
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.ColumnSpan = 2;
cell3.Style.Add("text-align", "center");
image = new Image();
image.CssClass = "ps-ms-main-drop-profile-pic";
string imagePath = DatabaseManager.GetPersonImageFileName(leaveBossData.CitizenID);
if (imagePath != "")
{
image.Attributes["src"] = "Upload/PersonImage/" + imagePath;
cell3.Controls.Add(image);
}
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ชื่อ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.FirstNameAndLastName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ตำแหน่ง";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.PositionWorkName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ระดับ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.AdminPositionName;// + "<br />" + leaveBossData.Person.AdminPositionNameExtra();
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "การอนุมัติ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
if (leaveData.LeaveStatusID == 1)
{
if (leaveBossData.Allow.HasValue)
{
cell3.Text = "<div style='color: #808080;'>" + leaveBossData.AllowDate.Value.ToLongDateString() + "</div>";
if (leaveBossData.Allow.Value == 1)
{
cell3.Text += "<div style='color: green'>อนุญาต</div>";
}
else
{
cell3.Text += "<div style='color: red'>ไม่อนุญาต</div>";
}
cell3.Text += "<div style='color: #000000;'>" + leaveBossData.Comment + "</div>";
}
}
else if (leaveData.LeaveStatusID == 4)
{
if (leaveBossData.CancelAllow.HasValue)
{
cell3.Text = "<div style='color: #808080;'>" + leaveBossData.CancelAllowDate.Value.ToLongDateString() + "</div>";
if (leaveBossData.CancelAllow.Value == 1)
{
cell3.Text += "<div style='color: green'>อนุญาต</div>";
}
else
{
cell3.Text += "<div style='color: red'>ไม่อนุญาต</div>";
}
cell3.Text += "<div style='color: #000000;'>" + leaveBossData.CancelComment + "</div>";
}
}
tr.Cells.Add(cell3);
}
cell2.Controls.Add(tb);
row.Cells.Add(cell2);
}
}
lbCancelReason.Text = leaveData.CancelReason;
/*if (leaveData.LeaveStatusID >= 1 && leaveData.LeaveStatusID <= 4) {
* if(leaveData.CL_ID == null) {
* lbCLComment.Text = "-";
* lbCLDate.Text = "-";
* } else {
* lbCLComment.Text = leaveData.CL_Comment;
* lbCLDate.Text = leaveData.CL_Date.Value.ToLongDateString();
* }
*
* } else if (leaveData.LeaveStatusID >= 5 && leaveData.LeaveStatusID <= 8) {
* if(leaveData.CL_ID == null) {
* lbCLOldComment.Text = "-";
* lbCLOldDate.Text = "-";
* lbCHOldComment.Text = leaveData.CH_Comment;
* lbCHOldDate.Text = leaveData.CH_Date.Value.ToLongDateString();
* lbCancelReason.Text = leaveData.CancelReason;
* lbCLComment.Text = "-";
* lbCLDate.Text = "-";
* } else {
* lbCLOldComment.Text = leaveData.CL_Comment;
* lbCLOldDate.Text = leaveData.CL_Date.Value.ToLongDateString();
* lbCHOldComment.Text = leaveData.CH_Comment;
* lbCHOldDate.Text = leaveData.CH_Date.Value.ToLongDateString();
* lbCancelReason.Text = leaveData.CancelReason;
* lbCLComment.Text = leaveData.CL_CancelComment;
* lbCLDate.Text = leaveData.CL_CancelDate.Value.ToLongDateString();
* }
*
* }*/
MultiView1.ActiveViewIndex = 1;
error_area.Attributes["class"] = null;
error_area.InnerHtml = "";
};
TableCell cell = new TableCell();
cell.Controls.Add(lbu);
GridView1.Rows[i].Cells.Add(cell);
}
lbNoData.Visible = false;
}
else
{
lbNoData.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
/*if (!IsPostBack) {
* ChangeNotification("info", "กรุณากรอกข้อมูล");
* }*/
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
//------
{
SqlDataSource sds = DatabaseManager.CreateSQLDataSource("SELECT LEAVE_ID รหัสการลา, (SELECT LEAVE_TYPE_NAME FROM LEV_TYPE WHERE LEV_TYPE.LEAVE_TYPE_ID = LEV_DATA.LEAVE_TYPE_ID) ประเภทการลา, REQ_DATE วันที่ข้อมูล, FROM_DATE จากวันที่, TO_DATE ถึงวันที่, TOTAL_DAY รวมวัน FROM LEV_DATA WHERE LEAVE_STATUS_ID = 1 AND PS_ID = '" + loginPerson.CITIZEN_ID + "' ORDER BY LEAVE_ID DESC");
gvLeaveProgress.DataSource = sds;
gvLeaveProgress.DataBind();
if (gvLeaveProgress.Rows.Count > 0)
{
lbLeaveProgress.Visible = false;
TableHeaderCell headerCell = new TableHeaderCell();
headerCell.Text = "เลือก";
gvLeaveProgress.HeaderRow.Cells.Add(headerCell);
gvLeaveProgress.HeaderRow.Cells[0].Text = "<img src='Image/Small/ID.png' class='icon_left'/>" + gvLeaveProgress.HeaderRow.Cells[0].Text;
gvLeaveProgress.HeaderRow.Cells[1].Text = "<img src='Image/Small/list.png' class='icon_left'/>" + gvLeaveProgress.HeaderRow.Cells[1].Text;
gvLeaveProgress.HeaderRow.Cells[2].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvLeaveProgress.HeaderRow.Cells[2].Text;
gvLeaveProgress.HeaderRow.Cells[3].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvLeaveProgress.HeaderRow.Cells[3].Text;
gvLeaveProgress.HeaderRow.Cells[4].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvLeaveProgress.HeaderRow.Cells[4].Text;
gvLeaveProgress.HeaderRow.Cells[6].Text = "<img src='Image/Small/pointer.png' class='icon_left'/>" + gvLeaveProgress.HeaderRow.Cells[6].Text;
for (int i = 0; i < gvLeaveProgress.Rows.Count; ++i)
{
string ID = gvLeaveProgress.Rows[i].Cells[0].Text;
TableCell cell = new TableCell();
LinkButton btn = new LinkButton();
btn.CssClass = "ps-button";
btn.Text = "<img src='Image/Small/next.png'></img>";
btn.Click += (e2, e3) => {
lbuCancelFinish.Visible = false;
lbuCancelProgressFinish.Visible = true;
trCancelReason.Visible = false;
LeaveData leaveData = new LeaveData();
leaveData.Load(int.Parse(ID));
trPSBirthDate.Visible = false;
trPSWorkInDate.Visible = false;
trWifeName.Visible = false;
trGBDate.Visible = false;
trOrdained.Visible = false;
trTempleName.Visible = false;
trTempleLocation.Visible = false;
trOrdainDate.Visible = false;
trHujed.Visible = false;
trReason.Visible = false;
trContact.Visible = false;
trPhone.Visible = false;
trRestSave.Visible = false;
trRestLeft.Visible = false;
trRestTotal.Visible = false;
trStatistic.Visible = false;
if (leaveData.LeaveTypeID == 1)
{
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 2)
{
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 3)
{
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 4)
{
trRestSave.Visible = true;
trRestLeft.Visible = true;
trRestTotal.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 5)
{
trWifeName.Visible = true;
trGBDate.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 6)
{
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trOrdained.Visible = true;
trTempleName.Visible = true;
trTempleLocation.Visible = true;
trOrdainDate.Visible = true;
}
else if (leaveData.LeaveTypeID == 7)
{
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trHujed.Visible = true;
}
lbLeaveID.Text = leaveData.LeaveID.ToString();
lbLeaveTypeName.Text = leaveData.LeaveTypeName;
lbReqDate.Text = leaveData.RequestDate.Value.ToLongDateString();
lbPSName.Text = leaveData.Person.FirstName + " " + leaveData.Person.LastName;
lbPSPos.Text = leaveData.Person.PositionWorkName;
lbPSAPos.Text = leaveData.Person.AdminPositionName;
if (Util.IsBlank(leaveData.Person.WorkDivisionID))
{
lbPSDept.Text = leaveData.Person.DivisionName;
}
else
{
lbPSDept.Text = leaveData.Person.WorkDivisionName;
}
lbPSBirthDate.Text = leaveData.Person.BIRTHDAY.Value.ToLongDateString();
lbPSWorkInDate.Text = leaveData.Person.DATE_INWORK.Value.ToLongDateString();
lbRestSave.Text = leaveData.RestSave + " วัน";
lbRestLeft.Text = leaveData.RestLeft + " วัน";
lbRestTotal.Text = leaveData.RestTotal + " วัน";
lbWifeName.Text = leaveData.WifeFirstName + " " + leaveData.WifeLastName;
if (leaveData.GiveBirthDate.HasValue)
{
lbGBDate.Text = leaveData.GiveBirthDate.Value.ToLongDateString();
}
else
{
lbGBDate.Text = "-";
}
lbOrdained.Text = leaveData.Ordained == 1 ? "เคย" : "ไม่เคย";
lbTempleName.Text = leaveData.TempleName;
lbTempleLocation.Text = leaveData.TempleLocation;
if (leaveData.OrdainDate.HasValue)
{
lbOrdainDate.Text = leaveData.OrdainDate.Value.ToLongDateString();
}
else
{
lbOrdainDate.Text = "-";
}
lbHujed.Text = leaveData.Hujed == 1 ? "เคย" : "ไม่เคย";
if (leaveData.FromDate.HasValue)
{
lbFTTDate.Text = leaveData.FromDate.Value.ToLongDateString() + " ถึง " + leaveData.ToDate.Value.ToLongDateString() + " รวม " + leaveData.TotalDay + " วัน";
}
else
{
lbFTTDate.Text = "ไม่เคยลา";
}
lbStatistic.Text = "ลามาแล้ว " + leaveData.CountPast + " วัน / ลาครั้งนี้ " + leaveData.CountNow + " วัน / รวม " + leaveData.CountTotal + " วัน";
lbReason.Text = leaveData.Reason;
lbContact.Text = leaveData.Contact;
lbPhone.Text = leaveData.Telephone;
if (leaveData.LastFromDate.HasValue)
{
lbLastFTTDate.Text = leaveData.LastFromDate.Value.ToLongDateString() + " ถึง " + leaveData.LastToDate.Value.ToLongDateString() + " รวม " + leaveData.LastTotalDay + " วัน";
}
else
{
lbLastFTTDate.Text = "ไม่เคยลา";
}
if (leaveData.DocterCertificationFileName != "")
{
divDrCer.InnerHtml = "<a href='Upload/Drcer/" + leaveData.DocterCertificationFileName + "'><img src='Upload/DrCer/" + leaveData.DocterCertificationFileName + "' style='width: 200px;' /></a>";
}
{
TableRow row = new TableRow();
TableCell cell2;
Image image;
tbBoss.Rows.Add(row);
for (int j = 0; j < leaveData.BossStateMax; j++)
{
LeaveBossData leaveBossData = leaveData.LeaveBossDataList[j];
cell2 = new TableCell();
cell2.Style.Add("vertical-align", "top");
Table tb = new Table();
tb.CssClass = "ps-table-1";
tb.Style.Add("text-align", "left");
{
TableRow tr;
TableCell cell3;
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.ColumnSpan = 2;
cell3.Style.Add("text-align", "center");
image = new Image();
image.CssClass = "ps-ms-main-drop-profile-pic";
string imagePath = DatabaseManager.GetPersonImageFileName(leaveBossData.CitizenID);
if (imagePath != "")
{
image.Attributes["src"] = "Upload/PersonImage/" + imagePath;
cell3.Controls.Add(image);
}
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ชื่อ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.FirstNameAndLastName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ตำแหน่ง";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.PositionWorkName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ระดับ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.AdminPositionName;// + "<br />" + leaveBossData.Person.AdminPositionNameExtra();
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "การอนุมัติ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
if (leaveBossData.Allow.HasValue)
{
cell3.Text = "<div style='color: #808080;'>" + leaveBossData.AllowDate.Value.ToLongDateString() + "</div>";
if (leaveBossData.Allow.Value == 1)
{
cell3.Text += "<div style='color: green'>อนุญาต</div>";
}
else
{
cell3.Text += "<div style='color: red'>ไม่อนุญาต</div>";
}
cell3.Text += "<div style='color: #000000;'>" + leaveBossData.Comment + "</div>";
}
tr.Cells.Add(cell3);
}
cell2.Controls.Add(tb);
row.Cells.Add(cell2);
}
}
Session["LeaveData"] = leaveData;
MV1.ActiveViewIndex = 1;
//Response.Redirect("ViewLeaveForm.aspx?Form=1&LeaveID=" + ID);
};
cell.Controls.Add(btn);
gvLeaveProgress.Rows[i].Cells.Add(cell);
}
Util.NormalizeGridViewDate(gvLeaveProgress, 2);
Util.NormalizeGridViewDate(gvLeaveProgress, 3);
Util.NormalizeGridViewDate(gvLeaveProgress, 4);
}
else
{
lbLeaveProgress.Visible = true;
}
}
//--------
{
SqlDataSource sds = DatabaseManager.CreateSQLDataSource("SELECT LEAVE_ID รหัสการลา, (SELECT LEAVE_TYPE_NAME FROM LEV_TYPE WHERE LEV_TYPE.LEAVE_TYPE_ID = LEV_DATA.LEAVE_TYPE_ID) ประเภทการลา, REQ_DATE วันที่ข้อมูล, FROM_DATE จากวันที่, TO_DATE ถึงวันที่, TOTAL_DAY รวมวัน FROM LEV_DATA WHERE LEAVE_STATUS_ID = 3 AND PS_ID = '" + loginPerson.CITIZEN_ID + "' AND V_ALLOW = 1 AND CEIL(FROM_DATE - CURRENT_DATE) >= 3 ORDER BY LEAVE_ID DESC");
gvLeave.DataSource = sds;
gvLeave.DataBind();
if (gvLeave.Rows.Count > 0)
{
lbLeave.Visible = false;
TableHeaderCell headerCell = new TableHeaderCell();
headerCell.Text = "เลือก";
gvLeave.HeaderRow.Cells.Add(headerCell);
gvLeave.HeaderRow.Cells[0].Text = "<img src='Image/Small/ID.png' class='icon_left'/>" + gvLeave.HeaderRow.Cells[0].Text;
gvLeave.HeaderRow.Cells[1].Text = "<img src='Image/Small/list.png' class='icon_left'/>" + gvLeave.HeaderRow.Cells[1].Text;
gvLeave.HeaderRow.Cells[2].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvLeave.HeaderRow.Cells[2].Text;
gvLeave.HeaderRow.Cells[3].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvLeave.HeaderRow.Cells[3].Text;
gvLeave.HeaderRow.Cells[4].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + gvLeave.HeaderRow.Cells[4].Text;
gvLeave.HeaderRow.Cells[6].Text = "<img src='Image/Small/pointer.png' class='icon_left'/>" + gvLeave.HeaderRow.Cells[6].Text;
for (int i = 0; i < gvLeave.Rows.Count; ++i)
{
string ID = gvLeave.Rows[i].Cells[0].Text;
TableCell cell = new TableCell();
LinkButton btn = new LinkButton();
btn.CssClass = "ps-button";
btn.Text = "<img src='Image/Small/next.png'></img>";
btn.Click += (e2, e3) => {
lbuCancelFinish.Visible = true;
lbuCancelProgressFinish.Visible = false;
trCancelReason.Visible = true;
LeaveData leaveData = new LeaveData();
leaveData.Load(int.Parse(ID));
trPSBirthDate.Visible = false;
trPSWorkInDate.Visible = false;
trWifeName.Visible = false;
trGBDate.Visible = false;
trOrdained.Visible = false;
trTempleName.Visible = false;
trTempleLocation.Visible = false;
trOrdainDate.Visible = false;
trHujed.Visible = false;
trReason.Visible = false;
trContact.Visible = false;
trPhone.Visible = false;
trRestSave.Visible = false;
trRestLeft.Visible = false;
trRestTotal.Visible = false;
trStatistic.Visible = false;
if (leaveData.LeaveTypeID == 1)
{
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 2)
{
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 3)
{
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 4)
{
trRestSave.Visible = true;
trRestLeft.Visible = true;
trRestTotal.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 5)
{
trWifeName.Visible = true;
trGBDate.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 6)
{
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trOrdained.Visible = true;
trTempleName.Visible = true;
trTempleLocation.Visible = true;
trOrdainDate.Visible = true;
}
else if (leaveData.LeaveTypeID == 7)
{
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trHujed.Visible = true;
}
lbLeaveID.Text = leaveData.LeaveID.ToString();
lbLeaveTypeName.Text = leaveData.LeaveTypeName;
lbReqDate.Text = leaveData.RequestDate.Value.ToLongDateString();
lbPSName.Text = leaveData.Person.FirstName + " " + leaveData.Person.LastName;
lbPSPos.Text = leaveData.Person.PositionWorkName;
lbPSAPos.Text = leaveData.Person.AdminPositionName;
if (Util.IsBlank(leaveData.Person.WorkDivisionID))
{
lbPSDept.Text = leaveData.Person.DivisionName;
}
else
{
lbPSDept.Text = leaveData.Person.WorkDivisionName;
}
lbPSBirthDate.Text = leaveData.Person.BIRTHDAY.Value.ToLongDateString();
lbPSWorkInDate.Text = leaveData.Person.DATE_INWORK.Value.ToLongDateString();
lbRestSave.Text = leaveData.RestSave + " วัน";
lbRestLeft.Text = leaveData.RestLeft + " วัน";
lbRestTotal.Text = leaveData.RestTotal + " วัน";
lbWifeName.Text = leaveData.WifeFirstName + " " + leaveData.WifeLastName;
if (leaveData.GiveBirthDate.HasValue)
{
lbGBDate.Text = leaveData.GiveBirthDate.Value.ToLongDateString();
}
else
{
lbGBDate.Text = "-";
}
lbOrdained.Text = leaveData.Ordained == 1 ? "เคย" : "ไม่เคย";
lbTempleName.Text = leaveData.TempleName;
lbTempleLocation.Text = leaveData.TempleLocation;
if (leaveData.OrdainDate.HasValue)
{
lbOrdainDate.Text = leaveData.OrdainDate.Value.ToLongDateString();
}
else
{
lbOrdainDate.Text = "-";
}
lbHujed.Text = leaveData.Hujed == 1 ? "เคย" : "ไม่เคย";
if (leaveData.FromDate.HasValue)
{
lbFTTDate.Text = leaveData.FromDate.Value.ToLongDateString() + " ถึง " + leaveData.ToDate.Value.ToLongDateString() + " รวม " + leaveData.TotalDay + " วัน";
}
else
{
lbFTTDate.Text = "ไม่เคยลา";
}
lbStatistic.Text = "ลามาแล้ว " + leaveData.CountPast + " วัน / ลาครั้งนี้ " + leaveData.CountNow + " วัน / รวม " + leaveData.CountTotal + " วัน";
lbReason.Text = leaveData.Reason;
lbContact.Text = leaveData.Contact;
lbPhone.Text = leaveData.Telephone;
if (leaveData.LastFromDate.HasValue)
{
lbLastFTTDate.Text = leaveData.LastFromDate.Value.ToLongDateString() + " ถึง " + leaveData.LastToDate.Value.ToLongDateString() + " รวม " + leaveData.LastTotalDay + " วัน";
}
else
{
lbLastFTTDate.Text = "ไม่เคยลา";
}
if (leaveData.DocterCertificationFileName != "")
{
divDrCer.InnerHtml = "<a href='Upload/Drcer/" + leaveData.DocterCertificationFileName + "'><img src='Upload/DrCer/" + leaveData.DocterCertificationFileName + "' style='width: 200px;' /></a>";
}
{
TableRow row = new TableRow();
TableCell cell2;
Image image;
tbBoss.Rows.Add(row);
for (int j = 0; j < leaveData.BossStateMax; j++)
{
LeaveBossData leaveBossData = leaveData.LeaveBossDataList[j];
cell2 = new TableCell();
cell2.Style.Add("vertical-align", "top");
Table tb = new Table();
tb.CssClass = "ps-table-1";
tb.Style.Add("text-align", "left");
{
TableRow tr;
TableCell cell3;
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.ColumnSpan = 2;
cell3.Style.Add("text-align", "center");
image = new Image();
image.CssClass = "ps-ms-main-drop-profile-pic";
string imagePath = DatabaseManager.GetPersonImageFileName(leaveBossData.CitizenID);
if (imagePath != "")
{
image.Attributes["src"] = "Upload/PersonImage/" + imagePath;
cell3.Controls.Add(image);
}
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ชื่อ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.FirstNameAndLastName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ตำแหน่ง";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.PositionWorkName;
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "ระดับ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
cell3.Text = leaveBossData.Person.AdminPositionName;// + "<br />" + leaveBossData.Person.AdminPositionNameExtra();
tr.Cells.Add(cell3);
tr = new TableRow();
tb.Rows.Add(tr);
cell3 = new TableCell();
cell3.Text = "การอนุมัติ";
tr.Cells.Add(cell3);
cell3 = new TableCell();
if (leaveBossData.Allow.HasValue)
{
cell3.Text = "<div style='color: #808080;'>" + leaveBossData.AllowDate.Value.ToLongDateString() + "</div>";
if (leaveBossData.Allow.Value == 1)
{
cell3.Text += "<div style='color: green'>อนุญาต</div>";
}
else
{
cell3.Text += "<div style='color: red'>ไม่อนุญาต</div>";
}
cell3.Text += "<div style='color: #000000;'>" + leaveBossData.Comment + "</div>";
}
tr.Cells.Add(cell3);
}
cell2.Controls.Add(tb);
row.Cells.Add(cell2);
}
}
Session["LeaveData"] = leaveData;
MV1.ActiveViewIndex = 1;
//Response.Redirect("ViewLeaveForm.aspx?Form=1&LeaveID=" + ID);
};
cell.Controls.Add(btn);
gvLeave.Rows[i].Cells.Add(cell);
}
Util.NormalizeGridViewDate(gvLeave, 2);
Util.NormalizeGridViewDate(gvLeave, 3);
Util.NormalizeGridViewDate(gvLeave, 4);
}
else
{
lbLeave.Visible = true;
}
}
}
protected void btnChangePassword_Click(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
if (loginPerson.IsLoginFirst())
{
Label12X.Text = "";
if (tbPasswordNew.Text == "")
{
Label12X.Text = "กรุณากรอกรหัสผ่านใหม่";
Label12X.ForeColor = System.Drawing.Color.Red;
return;
}
if (tbPasswordNewAgain.Text == "")
{
Label12X.Text = "กรุณากรอกรหัสผ่านใหม่อีกครั้ง";
Label12X.ForeColor = System.Drawing.Color.Red;
return;
}
if (tbPasswordNew.Text == "" || tbPasswordNewAgain.Text == "")
{
Label12X.Text = "กรุณากรอกรหัสผ่านใหม่ให้ครบถ้วน";
Label12X.ForeColor = System.Drawing.Color.Red;
return;
}
if (tbPasswordNew.Text != tbPasswordNewAgain.Text)
{
Label12X.Text = "รหัสผ่านไม่ตรงกัน";
Label12X.ForeColor = System.Drawing.Color.Red;
return;
}
string source = tbPasswordNew.Text;
using (MD5 md5Hash = MD5.Create())
{
string hash = GetMd5Hash(md5Hash, source);
DatabaseManager.ExecuteNonQuery("UPDATE UOC_STAFF SET PASSWORD = '******', ST_LOGIN_ID = 1 WHERE CITIZEN_ID = '" + loginPerson.CITIZEN_ID + "'");
Label12X.Text = "ตั้งรหัสผ่านสำเร็จ";
Label12X.ForeColor = System.Drawing.Color.Green;
}
}
if (loginPerson.IsLoginSecond())
{
Label12X.Text = "";
if (tbPasswordNew.Text == "")
{
Label12X.Text = "กรุณากรอกรหัสผ่านใหม่";
Label12X.ForeColor = System.Drawing.Color.Red;
return;
}
if (tbPasswordNewAgain.Text == "")
{
Label12X.Text = "กรุณากรอกรหัสผ่านใหม่อีกครั้ง";
Label12X.ForeColor = System.Drawing.Color.Red;
return;
}
if (tbPasswordOld.Text == tbPasswordNew.Text)
{
Label12X.Text = "รหัสผ่านใหม่ไม่สามารถซ้ำรหัสผ่านเก่า";
Label12X.ForeColor = System.Drawing.Color.Red;
return;
}
if (tbPasswordNew.Text != tbPasswordNewAgain.Text)
{
Label12X.Text = "รหัสผ่านใหม่กับรหัสผ่านใหม่อีกครั้งไม่ตรงกัน";
Label12X.ForeColor = System.Drawing.Color.Red;
return;
}
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT PASSWORD FROM UOC_STAFF WHERE CITIZEN_ID ='" + loginPerson.CITIZEN_ID + "'", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
string source = tbPasswordNew.Text;
string CheckOld = tbPasswordOld.Text;
while (reader.Read())
{
using (MD5 md5Hash = MD5.Create())
{
string hash = GetMd5Hash(md5Hash, source);
string hashOld = GetMd5Hash(md5Hash, CheckOld);
if (!reader.IsDBNull(0))
{
if (hashOld != reader.GetString(0))
{
Label12X.Text = "รหัสผ่านเก่าไม่ถูกต้อง";
Label12X.ForeColor = System.Drawing.Color.Red;
return;
}
DatabaseManager.ExecuteNonQuery("UPDATE UOC_STAFF SET PASSWORD = '******' WHERE CITIZEN_ID = '" + loginPerson.CITIZEN_ID + "'");
Label12X.Text = "เปลี่ยนรหัสผ่านสำเร็จ";
Label12X.ForeColor = System.Drawing.Color.Green;
}
}
}
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
int count = 0;// DatabaseManager.GetLeaveRequiredCountByCommanderLow(loginPerson.CitizenID); ;
/*using (OleDbConnection con = new OleDbConnection(DatabaseManager.CONNECTION_STRING)) {
* con.Open();
* using (OleDbCommand com = new OleDbCommand("SELECT COUNT(LEV_MAIN.LEAVE_ID) FROM LEV_MAIN, LEV_FORM1 WHERE LEV_MAIN.LEAVE_ID = LEV_FORM1.LEAVE_ID AND CMD_LOW_ID = '" + loginPerson.CitizenID + "' AND LEAVE_STATE = 1", con)) {
* using (OleDbDataReader reader = com.ExecuteReader()) {
* while (reader.Read()) {
* count = int.Parse(reader.GetValue(0).ToString());
* }
* }
* }
* }*/
if (count == 0)
{
error_area.InnerHtml = "ไม่มีรายการที่ท่านต้องลงความเห็น";
}
else
{
error_area.InnerHtml = "กรุณาเลือกรายการที่ต้องการลงความเห็น";
}
//error_area.Attributes["class"] = "alert alert_info";
error_area.Attributes["class"] = null;
error_area.InnerHtml = "";
if (count > 0)
{
SqlDataSource sds = DatabaseManager.CreateSQLDataSource("SELECT LEAVE_ID รหัสการลา, (SELECT PS_FN_TH || ' ' || PS_LN_TH FROM PS_PERSON WHERE PS_CITIZEN_ID = LEV_DATA.PS_ID) ชื่อผู้ลา, (SELECT LEAVE_TYPE_NAME FROM LEV_TYPE WHERE LEV_TYPE.LEAVE_TYPE_ID = LEV_DATA.LEAVE_TYPE_ID) ประเภทการลา, REQ_DATE วันที่ข้อมูล, (SELECT LEAVE_STATUS_NAME FROM LEV_STATUS WHERE LEAVE_STATUS_ID = LEV_DATA.LEAVE_STATUS_ID) สถานะ FROM LEV_DATA WHERE LEAVE_STATUS_ID in(1,5) AND CL_ID = '" + loginPerson.CITIZEN_ID + "'");
GridView1.DataSource = sds;
GridView1.DataBind();
Util.NormalizeGridViewDate(GridView1, 3);
TableHeaderCell newHeader = new TableHeaderCell();
newHeader.Text = "เลือก";
GridView1.HeaderRow.Cells.Add(newHeader);
GridView1.HeaderRow.Cells[0].Text = "<img src='Image/Small/ID.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[0].Text;
GridView1.HeaderRow.Cells[1].Text = "<img src='Image/Small/person2.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[1].Text;
GridView1.HeaderRow.Cells[2].Text = "<img src='Image/Small/list.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[2].Text;
GridView1.HeaderRow.Cells[3].Text = "<img src='Image/Small/calendar.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[3].Text;
GridView1.HeaderRow.Cells[4].Text = "<img src='Image/Small/question.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[4].Text;
GridView1.HeaderRow.Cells[5].Text = "<img src='Image/Small/pointer.png' class='icon_left'/>" + GridView1.HeaderRow.Cells[5].Text;
for (int i = 0; i < GridView1.Rows.Count; ++i)
{
if (GridView1.Rows[i].Cells[4].Text == "1")
{
GridView1.Rows[i].Cells[4].Text = "ขอลา";
}
if (GridView1.Rows[i].Cells[4].Text == "5")
{
GridView1.Rows[i].Cells[4].Text = "ยกเลิกลา";
}
string id = GridView1.Rows[i].Cells[0].Text;
LinkButton lbu = new LinkButton();
lbu.Text = "<img src='Image/Small/next.png'></img>";
lbu.CssClass = "ps-button";
lbu.Click += (e2, e3) => {
LeaveData leaveData = new LeaveData();
leaveData.Load(int.Parse(id));
Session["LeaveData"] = leaveData;
trPSBirthDate.Visible = false;
trPSWorkInDate.Visible = false;
trWifeName.Visible = false;
trGBDate.Visible = false;
trOrdained.Visible = false;
trTempleName.Visible = false;
trTempleLocation.Visible = false;
trOrdainDate.Visible = false;
trHujed.Visible = false;
trReason.Visible = false;
trContact.Visible = false;
trPhone.Visible = false;
trRestSave.Visible = false;
trRestLeft.Visible = false;
trRestTotal.Visible = false;
trStatistic.Visible = false;
trOldComment.Visible = false;
trOldDate.Visible = false;
trCancelReason.Visible = false;
if (leaveData.LeaveTypeID == 1)
{
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 2)
{
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 3)
{
trStatistic.Visible = true;
trReason.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 4)
{
trRestSave.Visible = true;
trRestLeft.Visible = true;
trRestTotal.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 5)
{
trWifeName.Visible = true;
trGBDate.Visible = true;
trContact.Visible = true;
trPhone.Visible = true;
}
else if (leaveData.LeaveTypeID == 6)
{
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trOrdained.Visible = true;
trTempleName.Visible = true;
trTempleLocation.Visible = true;
trOrdainDate.Visible = true;
}
else if (leaveData.LeaveTypeID == 7)
{
trPSBirthDate.Visible = true;
trPSWorkInDate.Visible = true;
trHujed.Visible = true;
}
if (leaveData.LeaveStatusID == 1)
{
}
else if (leaveData.LeaveStatusID == 5)
{
trOldComment.Visible = true;
trOldDate.Visible = true;
trCancelReason.Visible = true;
}
lbLeaveID.Text = leaveData.LeaveID.ToString();
lbLeaveTypeName.Text = leaveData.LeaveTypeName;
lbReqDate.Text = leaveData.RequestDate.Value.ToLongDateString();
/* lbPSName.Text = leaveData.PS_Title + leaveData.PS_FirstName + " " + leaveData.PS_LastName;
* lbPSPos.Text = leaveData.PS_Position;
* lbPSAPos.Text = leaveData.PS_AdminPosition;
* lbPSDept.Text = leaveData.PS_Department;
*
* if (leaveData.PS_BirthDate.HasValue) {
* lbPSBirthDate.Text = leaveData.PS_BirthDate.Value.ToLongDateString();
* } else {
* lbPSBirthDate.Text = "-";
* }
* if (leaveData.PS_WorkInDate.HasValue) {
* lbPSWorkInDate.Text = leaveData.PS_WorkInDate.Value.ToLongDateString();
* } else {
* lbPSWorkInDate.Text = "-";
* }*/
lbRestSave.Text = leaveData.RestSave + " วัน";
lbRestLeft.Text = leaveData.RestLeft + " วัน";
lbRestTotal.Text = leaveData.RestTotal + " วัน";
lbWifeName.Text = leaveData.WifeFirstName + " " + leaveData.WifeLastName;
if (leaveData.GiveBirthDate.HasValue)
{
lbGBDate.Text = leaveData.GiveBirthDate.Value.ToLongDateString();
}
else
{
lbGBDate.Text = "-";
}
lbOrdained.Text = leaveData.Ordained == 1 ? "เคย" : "ไม่เคย";
lbTempleName.Text = leaveData.TempleName;
lbTempleLocation.Text = leaveData.TempleLocation;
if (leaveData.OrdainDate.HasValue)
{
lbOrdainDate.Text = leaveData.OrdainDate.Value.ToLongDateString();
}
else
{
lbOrdainDate.Text = "-";
}
lbHujed.Text = leaveData.Hujed == 1 ? "เคย" : "ไม่เคย";
if (leaveData.FromDate.HasValue)
{
lbFTTDate.Text = leaveData.FromDate.Value.ToLongDateString() + " ถึง " + leaveData.ToDate.Value.ToLongDateString() + " รวม " + leaveData.TotalDay + " วัน";
}
else
{
lbFTTDate.Text = "ไม่เคยลา";
}
lbStatistic.Text = "ลามาแล้ว " + leaveData.CountPast + " วัน / ลาครั้งนี้ " + leaveData.CountNow + " วัน / รวม " + leaveData.CountTotal + " วัน";
lbReason.Text = leaveData.Reason;
lbContact.Text = leaveData.Contact;
lbPhone.Text = leaveData.Telephone;
if (leaveData.LastFromDate.HasValue)
{
lbLastFTTDate.Text = leaveData.LastFromDate.Value.ToLongDateString() + " ถึง " + leaveData.LastToDate.Value.ToLongDateString() + " รวม " + leaveData.LastTotalDay + " วัน";
}
else
{
lbLastFTTDate.Text = "ไม่เคยลา";
}
/* if(leaveData.LeaveStatusID >= 5 && leaveData.LeaveStatusID <= 8) {
* lbOldComment.Text = leaveData.CL_Comment;
* lbOldDate.Text = leaveData.CL_Date.Value.ToLongDateString();
* lbCancelReason.Text = leaveData.CancelReason;
* }*/
if (leaveData.DocterCertificationFileName != "")
{
divDrCer.InnerHtml = "<a href='Upload/Drcer/" + leaveData.DocterCertificationFileName + "'><img src='Upload/DrCer/" + leaveData.DocterCertificationFileName + "' style='width: 200px;' /></a>";
}
MultiView1.ActiveViewIndex = 1;
error_area.Attributes["class"] = null;
error_area.InnerHtml = "";
};
TableCell cell = new TableCell();
cell.Controls.Add(lbu);
GridView1.Rows[i].Cells.Add(cell);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SessionTimeOut.Text = Session.Timeout.ToString() + " นาที";
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
UOC_STAFF loginPerson = ps.LoginPerson;
if (!IsPostBack)
{
lbName.Text = loginPerson.FullName;
lbStaffType.Text = loginPerson.STAFFTYPE_NAME;
lbPosition.Text = loginPerson.POSITION_NAME;
lbPositionRank.Text = loginPerson.ADMIN_POSITION_NAME;
lbDepartment.Text = loginPerson.DEPARTMENT_NAME;
string name = loginPerson.FullName;
profile_name.InnerText = name;
if (loginPerson.ST_LOGIN_ID == 0)
{
menu1.Visible = false;
}
if (loginPerson.PERSON_ROLE_ID == 99)
{
MenuPublic.Visible = true;
MenuPublic2.Visible = true;
MenuRolePerson.Visible = false;
MenuRoleInsig.Visible = false;
MenuRoleSalary.Visible = false;
MenuRoleLeave.Visible = false;
MenuRoleAdmin.Visible = true;
}
else if (loginPerson.PERSON_ROLE_ID == 1)
{
MenuPublic.Visible = true;
MenuPublic2.Visible = true;
MenuRolePerson.Visible = false;
MenuRoleInsig.Visible = false;
MenuRoleSalary.Visible = false;
MenuRoleLeave.Visible = false;
MenuRoleAdmin.Visible = false;
}
else if (loginPerson.PERSON_ROLE_ID == 2)
{
MenuPublic.Visible = true;
MenuPublic2.Visible = true;
MenuRolePerson.Visible = true;
MenuRoleInsig.Visible = false;
MenuRoleSalary.Visible = false;
MenuRoleLeave.Visible = false;
MenuRoleAdmin.Visible = false;
}
else if (loginPerson.PERSON_ROLE_ID == 3)
{
MenuPublic.Visible = true;
MenuPublic2.Visible = true;
MenuRolePerson.Visible = false;
MenuRoleInsig.Visible = true;
MenuRoleSalary.Visible = false;
MenuRoleLeave.Visible = false;
MenuRoleAdmin.Visible = false;
}
else if (loginPerson.PERSON_ROLE_ID == 4)
{
MenuPublic.Visible = true;
MenuPublic2.Visible = true;
MenuRolePerson.Visible = false;
MenuRoleInsig.Visible = false;
MenuRoleSalary.Visible = true;
MenuRoleLeave.Visible = false;
MenuRoleAdmin.Visible = false;
}
else if (loginPerson.PERSON_ROLE_ID == 5)
{
MenuPublic.Visible = true;
MenuPublic2.Visible = true;
MenuRolePerson.Visible = false;
MenuRoleInsig.Visible = false;
MenuRoleSalary.Visible = false;
MenuRoleLeave.Visible = true;
MenuRoleAdmin.Visible = false;
}
}
//Declare
int countRequestID = 0;
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT URL FROM PS_PERSON_IMAGE WHERE CITIZEN_ID = '" + loginPerson.CITIZEN_ID + "' AND PRESENT = 1", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
string fileName;
fileName = reader.GetValue(0).ToString();
string personImageFileName = DatabaseManager.GetPersonImageFileName(loginPerson.CITIZEN_ID);
if (personImageFileName != "")
{
profile_pic.Src = "Upload/PersonImage/" + personImageFileName;
profile_pic2.Src = "Upload/PersonImage/" + personImageFileName;
}
else
{
profile_pic.Src = "Image/Small/person2.png";
}
}
}
}
if (loginPerson.PERSON_ROLE_ID == 2)
{
//Count
using (OracleCommand com = new OracleCommand("SELECT COUNT(STATUS_ID) FROM TB_REQUEST WHERE STATUS_ID = 0", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
countRequestID = reader.GetInt32(0);
IntCountRequest.Text = "คุณมีรายการที่ต้องอนุมัติ" + reader.GetInt32(0).ToString() + "รายการ";
}
}
}
noti_request_none.Visible = false;
noti_request_approve.Visible = false;
int count = countRequestID;
if (countRequestID == 0)
{
noti_request_none.Visible = true;
}
else
{
noti_request_approve.Visible = true;
}
if (count > 0)
{
noti_alert.InnerText = "" + count;
noti_alert.Attributes["class"] = "ps-ms-main-hd-noti-alert";
}
}
else
{
NotiAllsee.Visible = true;
NotiManageRequest.Visible = false;
}
}
}
