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 dtCategoryID = new DataTable();
DataSet ds = new DataSet();
string makeDepartmentSQL = " SELECT ITEM_CATEGORY_ID, ITEM_CAT_QR_PRI_CODE || ' - ' || ITEM_CATEGORY_NAME AS ITEM_CATEGORY_NAME_CODE FROM IT_ASSET_ITEM_CATEGORIES WHERE IS_ACTIVE = 'Enable' ORDER BY ITEM_CATEGORY_ID ASC";
ds = ExecuteBySqlStringCatType(makeDepartmentSQL);
dtCategoryID = (DataTable)ds.Tables[0];
DropDownCategoryID.DataSource = dtCategoryID;
DropDownCategoryID.DataValueField = "ITEM_CATEGORY_ID";
DropDownCategoryID.DataTextField = "ITEM_CATEGORY_NAME_CODE";
DropDownCategoryID.DataBind();
DropDownCategoryID.Items.Insert(0, new ListItem("Select Categorey", "0"));
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 dtCatID = new DataTable();
DataSet dc = new DataSet();
string makeDropDownCatSQL = " SELECT * FROM MF_CATEGORY WHERE IS_ACTIVE = 'Enable' ORDER BY CATEGORY_ID ASC";
dc = ExecuteBySqlString(makeDropDownCatSQL);
dtCatID = (DataTable)dc.Tables[0];
DropDownCategoryID.DataSource = dtCatID;
DropDownCategoryID.DataValueField = "CATEGORY_ID";
DropDownCategoryID.DataTextField = "CATEGORY_NAME";
DropDownCategoryID.DataBind();
DropDownCategoryID.Items.Insert(0, new ListItem("Select Category", "0"));
DataTable dtInID = new DataTable();
DataSet dcn = new DataSet();
string makeDropDownInSQL = " SELECT NATURE_ITEM_ID, NATURE_NAME || '-' || SHORT_CODE AS NATURE_NAME FROM NRC_INVENTORY_NATURE_ITEM WHERE IS_ACTIVE = 'Enable' ORDER BY NATURE_ITEM_ID ASC";
dcn = ExecuteBySqlString(makeDropDownInSQL);
dtInID = (DataTable)dcn.Tables[0];
DropDownInNatureID.DataSource = dtInID;
DropDownInNatureID.DataValueField = "NATURE_ITEM_ID";
DropDownInNatureID.DataTextField = "NATURE_NAME";
DropDownInNatureID.DataBind();
DropDownInNatureID.Items.Insert(0, new ListItem("Select Inventory Nature", "0"));
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");
DropDownCategoryID.Focus();
Display();
alert_box.Visible = false;
}
IsLoad = false;
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}