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 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(); } if (IS_PAGE_ACTIVE == "Enable") { if (!IsPostBack) { DataTable dtCustomerID = new DataTable(); DataSet ds = new DataSet(); string makeCustomerSQL = " SELECT PP.PARTY_ID, PP.PARTY_NAME FROM PF_PURCHASE_JW PPJ LEFT JOIN PF_PARTY PP ON PP.PARTY_ID = PPJ.PARTY_ID WHERE PP.IS_ACTIVE = 'Enable' GROUP BY PP.PARTY_ID, PP.PARTY_NAME ORDER BY PP.PARTY_NAME ASC"; ds = ExecuteBySqlStringEmpType(makeCustomerSQL); dtCustomerID = (DataTable)ds.Tables[0]; DropDownCustomerID.DataSource = dtCustomerID; DropDownCustomerID.DataValueField = "PARTY_ID"; DropDownCustomerID.DataTextField = "PARTY_NAME"; DropDownCustomerID.DataBind(); DropDownCustomerID.Items.Insert(0, new ListItem("Select Customer", "0")); DataTable dtItemID = new DataTable(); DataSet dsi = new DataSet(); string makeDropDownItemSQL = " SELECT * FROM PF_ITEM WHERE IS_ACTIVE = 'Enable' ORDER BY ITEM_ID ASC"; dsi = ExecuteBySqlStringEmpType(makeDropDownItemSQL); dtItemID = (DataTable)dsi.Tables[0]; DropDownItemID.DataSource = dtItemID; DropDownItemID.DataValueField = "ITEM_ID"; DropDownItemID.DataTextField = "ITEM_NAME"; DropDownItemID.DataBind(); DropDownItemID.Items.Insert(0, new ListItem("Select Item", "0")); DropDownItemID1.DataSource = dtItemID; DropDownItemID1.DataValueField = "ITEM_ID"; DropDownItemID1.DataTextField = "ITEM_NAME"; DropDownItemID1.DataBind(); DropDownItemID1.Items.Insert(0, new ListItem("All Item", "0")); DataTable dtSubItemID = new DataTable(); DataSet dss = new DataSet(); string makeDropDownSubItemSQL = " SELECT * FROM PF_SUB_ITEM WHERE IS_ACTIVE = 'Enable' ORDER BY SUB_ITEM_ID ASC"; dss = ExecuteBySqlStringEmpType(makeDropDownSubItemSQL); dtSubItemID = (DataTable)dss.Tables[0]; DropDownSubItemID.DataSource = dtSubItemID; DropDownSubItemID.DataValueField = "SUB_ITEM_ID"; DropDownSubItemID.DataTextField = "SUB_ITEM_NAME"; DropDownSubItemID.DataBind(); DropDownSubItemID.Items.Insert(0, new ListItem("Select Sub Item", "0")); DataTable dtPgeID = new DataTable(); DataSet dsp = new DataSet(); string makeDropDownPgeSQL = " SELECT * FROM NRC_VAT WHERE IS_ACTIVE = 'Enable' ORDER BY VAT_ID ASC"; dsp = ExecuteBySqlStringEmpType(makeDropDownPgeSQL); dtPgeID = (DataTable)dsp.Tables[0]; DropDownVatID.DataSource = dtPgeID; DropDownVatID.DataValueField = "VAT_ID"; DropDownVatID.DataTextField = "VAT_PERCENT"; DropDownVatID.DataBind(); // DropDownVatID.Items.Insert(0, new ListItem("Select Garbage Est. of Prod.", "0")); DropDownCustomerID.Attributes.Add("disabled", "disabled"); // TextItemWeight.Attributes.Add("disabled", "disabled"); TextInvoiceNo.Focus(); 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 dtItemID = new DataTable(); DataSet dsi = new DataSet(); string makeItemSQL = " SELECT ITEM_ID, ITEM_CODE || ' : ' || ITEM_NAME AS ITEM_FULL_NAME FROM MF_ITEM WHERE IS_ACTIVE = 'Enable' AND IS_SALES_ACTIVE = 'Enable' ORDER BY ITEM_ID ASC"; dsi = ExecuteBySqlString(makeItemSQL); dtItemID = (DataTable)dsi.Tables[0]; DropDownGradeID.DataSource = dtItemID; DropDownGradeID.DataValueField = "ITEM_ID"; DropDownGradeID.DataTextField = "ITEM_FULL_NAME"; DropDownGradeID.DataBind(); DropDownGradeID.Items.Insert(0, new ListItem("Select Grade", "0")); DataTable dtGradeTempID = new DataTable(); DataSet dsg = new DataSet(); string makeGradeTempSQL = " SELECT MPG.GRADE_ID, MPG.GRADE_ID || ' - ' || MI.ITEM_NAME AS ITEM_FULL_NAME FROM MF_PRODUCTION_GRADE MPG LEFT JOIN MF_ITEM MI ON MI.ITEM_ID = MPG.ITEM_ID WHERE MPG.IS_ACTIVE = 'Enable' ORDER BY MPG.GRADE_ID DESC"; dsg = ExecuteBySqlString(makeGradeTempSQL); dtGradeTempID = (DataTable)dsg.Tables[0]; DropDownGradeTempID.DataSource = dtGradeTempID; DropDownGradeTempID.DataValueField = "GRADE_ID"; DropDownGradeTempID.DataTextField = "ITEM_FULL_NAME"; DropDownGradeTempID.DataBind(); DropDownGradeTempID.Items.Insert(0, new ListItem("Select Grade Template", "0")); DataTable dtSupplierID = new DataTable(); DataSet ds = new DataSet(); string makeSupplierSQL = " SELECT PARTY_ID, PARTY_ID || ' - ' || PARTY_NAME || ' - ' || PARTY_VAT_NO AS PARTY_NAME FROM MF_PARTY WHERE IS_ACTIVE = 'Enable' AND IS_PRODUCTION_ACTIVE = 'Enable' ORDER BY PARTY_NAME ASC"; ds = ExecuteBySqlString(makeSupplierSQL); dtSupplierID = (DataTable)ds.Tables[0]; DropDownCustomerID.DataSource = dtSupplierID; DropDownCustomerID.DataValueField = "PARTY_ID"; DropDownCustomerID.DataTextField = "PARTY_NAME"; DropDownCustomerID.DataBind(); DropDownCustomerID.Items.Insert(0, new ListItem("Select Customer", "0")); TextGradeID.Enabled = false; string get_batch_id = " select LAST_NUMBER from all_sequences where sequence_name = 'MF_PRODUCTION_GRADEID_SEQ'"; cmdu = new OracleCommand(get_batch_id, conn); int GradeID = Convert.ToInt32(cmdu.ExecuteScalar()); GradeID = GradeID + 1; TextGradeID.Text = String.Concat("GD-", GradeID.ToString().PadLeft(4, '0')); string USER_DATA_ID = ""; ItemDisplay(USER_DATA_ID, new EventArgs()); Display(); alert_box.Visible = false; } IsLoad = false; } else { Response.Redirect("~/PagePermissionError.aspx"); } } else { Response.Redirect("~/Default.aspx"); } }