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 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 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' ORDER BY USER_ROLE_ID ASC "; 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")); DataTable dtUserPageID = new DataTable(); DataSet dsp = new DataSet(); string makePageSQL = " SELECT USER_PAGE_ID, PAGE_NAME || ' - ' ||PAGE_URL AS USER_PAGE_NAME FROM NRC_USER_PAGES WHERE IS_ACTIVE = 'Enable' ORDER BY USER_PAGE_ID ASC"; dsp = ExecuteBySqlStringPages(makePageSQL); dtUserPageID = (DataTable)dsp.Tables[0]; DropDownUserPageID.DataSource = dtUserPageID; DropDownUserPageID.DataValueField = "USER_PAGE_ID"; DropDownUserPageID.DataTextField = "USER_PAGE_NAME"; DropDownUserPageID.DataBind(); Display(); alert_box.Visible = false; } IsLoad = false; } else { Response.Redirect("~/PagePermissionError.aspx"); } } else { Response.Redirect("~/Default.aspx"); } }