protected void Page_Load(object sender, EventArgs e) { if (Session["USER_NAME"] != null) { string requestedFile = Path.GetFileName(Request.Path); OracleConnection conn = new OracleConnection(strConnString); conn.Open(); string makeSQL = " SELECT NUPP.IS_PAGE_ACTIVE, NUPP.IS_ADD_ACTIVE, NUPP.IS_EDIT_ACTIVE, NUPP.IS_DELETE_ACTIVE, NUPP.IS_VIEW_ACTIVE FROM NRC_USER_PAGE_PERMISSION NUPP LEFT JOIN NRC_USER_PAGES NUP ON NUP.USER_PAGE_ID = NUPP.USER_PAGE_ID WHERE NUPP.USER_ID = '" + Session["USER_ID"] + "' AND NUP.IS_ACTIVE = 'Enable' AND NUP.PAGE_URL = '" + requestedFile + "' "; cmdl = new OracleCommand(makeSQL); oradata = new OracleDataAdapter(cmdl.CommandText, conn); dt = new DataTable(); oradata.Fill(dt); RowCount = dt.Rows.Count; for (int i = 0; i < RowCount; i++) { IS_PAGE_ACTIVE = dt.Rows[i]["IS_PAGE_ACTIVE"].ToString(); IS_ADD_ACTIVE = dt.Rows[i]["IS_ADD_ACTIVE"].ToString(); IS_EDIT_ACTIVE = dt.Rows[i]["IS_EDIT_ACTIVE"].ToString(); IS_DELETE_ACTIVE = dt.Rows[i]["IS_DELETE_ACTIVE"].ToString(); IS_VIEW_ACTIVE = dt.Rows[i]["IS_VIEW_ACTIVE"].ToString(); } if (IS_PAGE_ACTIVE == "Enable") { // lb1.Text = "<b><font color=Brown>" + "WELLCOME :: " + "</font>" + "<b><font color=red>" + Session["USER_NAME"] + " User ID:" + Session["USER_ID"] + "</font>"; if (!IsPostBack) { DataTable dtEmployeeID = new DataTable(); DataSet dse = new DataSet(); string makeEmployeeSQL = " SELECT EMP_ID, EMP_FNAME || ' ' ||EMP_LNAME AS EMP_NAME FROM HR_EMPLOYEES WHERE IS_ACTIVE = 'Enable' ORDER BY EMP_ID ASC"; dse = ExecuteBySqlStringUserType(makeEmployeeSQL); dtEmployeeID = (DataTable)dse.Tables[0]; DropDownEmployeeID.DataSource = dtEmployeeID; DropDownEmployeeID.DataValueField = "EMP_ID"; DropDownEmployeeID.DataTextField = "EMP_NAME"; DropDownEmployeeID.DataBind(); DropDownEmployeeID.Items.Insert(0, new ListItem("Select Employee", "0")); DataTable dtUserRoleID = new DataTable(); DataSet ds = new DataSet(); string makeRoleSQL = " SELECT USER_ROLE_ID, USER_ROLE_SHORT_NAME || ' - ' ||USER_ROLE_NAME AS USER_ROLE_SNAME FROM NRC_USER_ROLE WHERE IS_ACTIVE = 'Enable' "; ds = ExecuteBySqlStringUserType(makeRoleSQL); dtUserRoleID = (DataTable)ds.Tables[0]; DropDownUserRoleID.DataSource = dtUserRoleID; DropDownUserRoleID.DataValueField = "USER_ROLE_ID"; DropDownUserRoleID.DataTextField = "USER_ROLE_SNAME"; DropDownUserRoleID.DataBind(); DropDownUserRoleID.Items.Insert(0, new ListItem("Select User Role", "0")); Display(); TextPassword.TextMode = TextBoxMode.Password; TextPasswordConfirm.Text = ""; ChangeOpen.Visible = false; alert_box.Visible = false; BtnUpdate.Attributes.Add("aria-disabled", "false"); BtnUpdate.Attributes.Add("class", "btn btn-success disabled"); BtnDelete.Attributes.Add("aria-disabled", "false"); BtnDelete.Attributes.Add("class", "btn btn-danger disabled"); } IsLoad = false; } else { Response.Redirect("~/PagePermissionError.aspx"); } } else { Response.Redirect("~/Default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["USER_NAME"] != null) { string requestedFile = Path.GetFileName(Request.Path); OracleConnection conn = new OracleConnection(strConnString); conn.Open(); string makeSQL = " SELECT NUPP.IS_PAGE_ACTIVE, NUPP.IS_ADD_ACTIVE, NUPP.IS_EDIT_ACTIVE, NUPP.IS_DELETE_ACTIVE, NUPP.IS_VIEW_ACTIVE, NUPP.IS_REPORT_ACTIVE, NUPP.IS_PRINT_ACTIVE FROM NRC_USER_PAGE_PERMISSION NUPP LEFT JOIN NRC_USER_PAGES NUP ON NUP.USER_PAGE_ID = NUPP.USER_PAGE_ID WHERE NUPP.USER_ID = '" + Session["USER_ID"] + "' AND NUP.IS_ACTIVE = 'Enable' AND NUP.PAGE_URL = '" + requestedFile + "' "; cmdl = new OracleCommand(makeSQL); oradata = new OracleDataAdapter(cmdl.CommandText, conn); dt = new DataTable(); oradata.Fill(dt); RowCount = dt.Rows.Count; for (int i = 0; i < RowCount; i++) { IS_PAGE_ACTIVE = dt.Rows[i]["IS_PAGE_ACTIVE"].ToString(); IS_ADD_ACTIVE = dt.Rows[i]["IS_ADD_ACTIVE"].ToString(); IS_EDIT_ACTIVE = dt.Rows[i]["IS_EDIT_ACTIVE"].ToString(); IS_DELETE_ACTIVE = dt.Rows[i]["IS_DELETE_ACTIVE"].ToString(); IS_VIEW_ACTIVE = dt.Rows[i]["IS_VIEW_ACTIVE"].ToString(); IS_REPORT_ACTIVE = dt.Rows[i]["IS_REPORT_ACTIVE"].ToString(); IS_PRINT_ACTIVE = dt.Rows[i]["IS_PRINT_ACTIVE"].ToString(); } if (IS_PAGE_ACTIVE == "Enable") { if (!IsPostBack) { DataTable dtEmployeeID = new DataTable(); DataSet dse = new DataSet(); string makeEmployeeSQL = " SELECT EMP_ID, EMP_FNAME || ' ' ||EMP_LNAME AS EMP_NAME FROM HR_EMPLOYEES WHERE IS_ACTIVE = 'Enable' ORDER BY EMP_ID ASC"; dse = ExecuteBySqlString(makeEmployeeSQL); dtEmployeeID = (DataTable)dse.Tables[0]; DropDownEmployeeID.DataSource = dtEmployeeID; DropDownEmployeeID.DataValueField = "EMP_ID"; DropDownEmployeeID.DataTextField = "EMP_NAME"; DropDownEmployeeID.DataBind(); DropDownEmployeeID.Items.Insert(0, new ListItem("Select Petty Cash Holder", "0")); DataTable dtClaimID = new DataTable(); DataSet dsc = new DataSet(); string makeClaimSQL = " SELECT * FROM WP_PURCHASE_CLAIM WHERE IS_ACTIVE = 'Enable' AND IS_CHECK = 'Incomplete' ORDER BY CLAIM_NO ASC"; dsc = ExecuteBySqlString(makeClaimSQL); dtClaimID = (DataTable)dsc.Tables[0]; DropDownClaimID.DataSource = dtClaimID; DropDownClaimID.DataValueField = "CLAIM_NO"; DropDownClaimID.DataTextField = "CLAIM_NO"; DropDownClaimID.DataBind(); DropDownClaimID.Items.Insert(0, new ListItem("Select Claim ID ", "0")); DataTable dtPaymentTypeID = new DataTable(); DataSet ds = new DataSet(); string makeRoleSQL = " SELECT PAYMENT_TYPE_ID, PAYMENT_TYPE_NAME FROM NRC_PAYMENT_TYPE WHERE IS_ACTIVE = 'Enable' ORDER BY PAYMENT_TYPE_ID ASC "; ds = ExecuteBySqlString(makeRoleSQL); dtPaymentTypeID = (DataTable)ds.Tables[0]; DropDownPaymentTypeID.DataSource = dtPaymentTypeID; DropDownPaymentTypeID.DataValueField = "PAYMENT_TYPE_ID"; DropDownPaymentTypeID.DataTextField = "PAYMENT_TYPE_NAME"; DropDownPaymentTypeID.DataBind(); // DropDownPaymentTypeID.Items.Insert(0, new ListItem("Select User Role", "0")); TextClaimNo.Enabled = false; DropDownEmployeeID.Enabled = false; TextMonthYear4.Enabled = false; EntryDate.Enabled = false; DropDownPaymentTypeID.Enabled = false; DropDownSlipNo.Enabled = false; TextTotalAmount.Enabled = false; // CheckIsActive.Enabled = false; QueryCmo.Visible = false; BtnUpdate.Attributes.Add("aria-disabled", "false"); BtnUpdate.Attributes.Add("class", "btn btn-success disabled"); Display(); alert_box.Visible = false; } IsLoad = false; } else { Response.Redirect("~/PagePermissionError.aspx"); } } else { Response.Redirect("~/Default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["USER_NAME"] != null) { string requestedFile = Path.GetFileName(Request.Path); OracleConnection conn = new OracleConnection(strConnString); conn.Open(); string makeSQL = " SELECT NUPP.IS_PAGE_ACTIVE, NUPP.IS_ADD_ACTIVE, NUPP.IS_EDIT_ACTIVE, NUPP.IS_DELETE_ACTIVE, NUPP.IS_VIEW_ACTIVE FROM NRC_USER_PAGE_PERMISSION NUPP LEFT JOIN NRC_USER_PAGES NUP ON NUP.USER_PAGE_ID = NUPP.USER_PAGE_ID WHERE NUPP.USER_ID = '" + Session["USER_ID"] + "' AND NUP.IS_ACTIVE = 'Enable' AND NUP.PAGE_URL = '" + requestedFile + "' "; cmdl = new OracleCommand(makeSQL); oradata = new OracleDataAdapter(cmdl.CommandText, conn); dt = new DataTable(); oradata.Fill(dt); RowCount = dt.Rows.Count; for (int i = 0; i < RowCount; i++) { IS_PAGE_ACTIVE = dt.Rows[i]["IS_PAGE_ACTIVE"].ToString(); IS_ADD_ACTIVE = dt.Rows[i]["IS_ADD_ACTIVE"].ToString(); IS_EDIT_ACTIVE = dt.Rows[i]["IS_EDIT_ACTIVE"].ToString(); IS_DELETE_ACTIVE = dt.Rows[i]["IS_DELETE_ACTIVE"].ToString(); IS_VIEW_ACTIVE = dt.Rows[i]["IS_VIEW_ACTIVE"].ToString(); } if (IS_PAGE_ACTIVE == "Enable") { if (!IsPostBack) { DataTable dtEmpID = new DataTable(); DataSet ds = new DataSet(); string makeEmpSQL = " SELECT EMP_ID, EMP_ID || ' - ' || EMP_FNAME || ' ' || EMP_LNAME AS EMP_NAME from HR_EMPLOYEES WHERE IS_ACTIVE = 'Enable' ORDER BY EMP_ID ASC"; ds = ExecuteBySqlString(makeEmpSQL); dtEmpID = (DataTable)ds.Tables[0]; DropDownEmployeeID.DataSource = dtEmpID; DropDownEmployeeID.DataValueField = "EMP_ID"; DropDownEmployeeID.DataTextField = "EMP_NAME"; DropDownEmployeeID.DataBind(); DropDownEmployeeID.Items.Insert(0, new ListItem("Select Employee", "0")); DataTable dtItemID = new DataTable(); DataSet di = new DataSet(); string makeItemSQL = " SELECT IAEI.EMP_ITEMS_ID, AI.ITEM_NAME || ' - ' || AI.ITEM_TYPE || ' ' || AI.ITEM_BRAND AS ITEM_NAME_ALL from IT_ASSET_EMP_ITEMS IAEI LEFT JOIN IT_ASSET_ITEMS AI ON AI.ITEM_ID = IAEI.ITEM_ID LEFT JOIN IT_ASSET_ITEM_CATEGORIES AIC ON AIC.ITEM_CATEGORY_ID = AI.ITEM_CATEGORY_ID WHERE AI.IS_ACTIVE = 'Enable' AND (AIC.ITEM_CAT_QR_PRI_CODE = 'CPU' OR AIC.ITEM_CAT_QR_PRI_CODE = 'ITD') ORDER BY AI.ITEM_ID ASC"; di = ExecuteBySqlString(makeItemSQL); dtItemID = (DataTable)di.Tables[0]; DropDownItemID.DataSource = dtItemID; DropDownItemID.DataValueField = "EMP_ITEMS_ID"; DropDownItemID.DataTextField = "ITEM_NAME_ALL"; DropDownItemID.DataBind(); DropDownItemID.Items.Insert(0, new ListItem("Select Item", "0")); DataTable dtItemExpID = new DataTable(); DataSet die = new DataSet(); string makeItemExpSQL = " SELECT AIE.ITEM_EXP_ID, AIE.ITEM_EXP_NAME from IT_ASSET_ITEM_EXPIRES AIE LEFT JOIN IT_ASSET_ITEM_CATEGORIES AIC ON AIC.ITEM_CATEGORY_ID = AIE.ITEM_CATEGORY_ID WHERE AIE.IS_ACTIVE = 'Enable' ORDER BY AIE.ITEM_EXP_ID ASC"; die = ExecuteBySqlString(makeItemExpSQL); dtItemExpID = (DataTable)die.Tables[0]; DropDownItemExpID.DataSource = dtItemExpID; DropDownItemExpID.DataValueField = "ITEM_EXP_ID"; DropDownItemExpID.DataTextField = "ITEM_EXP_NAME"; DropDownItemExpID.DataBind(); DropDownItemExpID.Items.Insert(0, new ListItem("Select Item Expire", "0")); DataTable dtDepartmentID = new DataTable(); DataSet dep = new DataSet(); string makeDepartmentSQL = " SELECT * FROM HR_EMP_DEPARTMENTS WHERE IS_ACTIVE = 'Enable' ORDER BY DEPARTMENT_ID ASC"; dep = ExecuteBySqlString(makeDepartmentSQL); dtDepartmentID = (DataTable)dep.Tables[0]; DropDownDepartmentID.DataSource = dtDepartmentID; DropDownDepartmentID.DataValueField = "DEPARTMENT_ID"; DropDownDepartmentID.DataTextField = "DEPARTMENT_NAME"; DropDownDepartmentID.DataBind(); DropDownDepartmentID.Items.Insert(0, new ListItem("Select Department", "0")); DataTable dtDivisionID = new DataTable(); DataSet dsd = new DataSet(); string makeDivisionSQL = " SELECT * FROM HR_EMP_DIVISIONS WHERE IS_ACTIVE = 'Enable' ORDER BY DIVISION_ID ASC"; dsd = ExecuteBySqlString(makeDivisionSQL); dtDivisionID = (DataTable)dsd.Tables[0]; DropDownDivisionID.DataSource = dtDivisionID; DropDownDivisionID.DataValueField = "DIVISION_ID"; DropDownDivisionID.DataTextField = "DIVISION_NAME"; DropDownDivisionID.DataBind(); DropDownDivisionID.Items.Insert(0, new ListItem("Select Division", "0")); DataTable dtLocationID = new DataTable(); DataSet dsl = new DataSet(); string makeLocationSQL = " SELECT * FROM HR_EMP_LOCATIONS WHERE IS_ACTIVE = 'Enable' ORDER BY LOCATION_ID ASC"; dsl = ExecuteBySqlString(makeLocationSQL); dtLocationID = (DataTable)dsl.Tables[0]; DropDownLocationID.DataSource = dtLocationID; DropDownLocationID.DataValueField = "LOCATION_ID"; DropDownLocationID.DataTextField = "LOCATION_NAME"; DropDownLocationID.DataBind(); DropDownLocationID.Items.Insert(0, new ListItem("Select Location", "0")); DataTable dtPlacementID = new DataTable(); DataSet depl = new DataSet(); string makePlacementSQL = " SELECT * FROM IT_ASSET_ITEMS_PLACEMENT WHERE IS_ACTIVE = 'Enable' ORDER BY PLACEMENT_ID ASC"; depl = ExecuteBySqlString(makePlacementSQL); dtPlacementID = (DataTable)depl.Tables[0]; DropDownPlacementID.DataSource = dtPlacementID; DropDownPlacementID.DataValueField = "PLACEMENT_ID"; DropDownPlacementID.DataTextField = "PLACEMENT_NAME"; DropDownPlacementID.DataBind(); DropDownPlacementID.Items.Insert(0, new ListItem("Select Placement", "0")); // Display(); DropDownItemID.Attributes.Add("disabled", "disabled"); // TextQrImage.Visible = false; alert_box.Visible = false; ExpDept.Visible = false; } IsLoad = false; } else { Response.Redirect("~/PagePermissionError.aspx"); } } else { Response.Redirect("~/Default.aspx"); } }