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