// public virtual void Select(bool directed, bool forward){}
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 dtID = new DataTable();
DataSet ds = new DataSet();
string makeVehicleSQL = " SELECT * FROM MF_VEHICLE WHERE IS_ACTIVE = 'Enable' ORDER BY VEHICLE_NO ASC";
ds = ExecuteBySqlString(makeVehicleSQL);
dtID = (DataTable)ds.Tables[0];
DropDownVehicleID.DataSource = dtID;
DropDownVehicleID.DataValueField = "VEHICLE_ID";
DropDownVehicleID.DataTextField = "VEHICLE_NO";
DropDownVehicleID.DataBind();
DropDownVehicleID.Items.Insert(0, new ListItem("Select Vehicle Number ", "0"));
DataTable dtMaterialID = new DataTable();
DataSet dsi = new DataSet();
string makeMaterialSQL = " SELECT MATERIAL_ID, MATERIAL_NAME || ' - ' || MATERIAL_CODE AS MATERIAL_FULL_NAME FROM MF_MATERIAL WHERE IS_ACTIVE = 'Enable' ORDER BY MATERIAL_ID ASC";
dsi = ExecuteBySqlString(makeMaterialSQL);
dtMaterialID = (DataTable)dsi.Tables[0];
DropDownMaterialID.DataSource = dtMaterialID;
DropDownMaterialID.DataValueField = "MATERIAL_ID";
DropDownMaterialID.DataTextField = "MATERIAL_FULL_NAME";
DropDownMaterialID.DataBind();
DropDownMaterialID.Items.Insert(0, new ListItem("Select Material", "0"));
DropDownMaterialID1.DataSource = dtMaterialID;
DropDownMaterialID1.DataValueField = "MATERIAL_ID";
DropDownMaterialID1.DataTextField = "MATERIAL_FULL_NAME";
DropDownMaterialID1.DataBind();
DropDownMaterialID1.Items.Insert(0, new ListItem("Select Material", "0"));
// TextWbSlipNo.Focus();
// Page.SetFocus(TextWbSlipNo);
// TextWbSlipNo.Select();
// this.ActiveControl = TextWbSlipNo;
TextWbSlipNo.Focus();
TextWbSlipNo.Attributes.Add("onfocus", "this.select(); this.onfocus = null;");
// TextWbSlipNo.Attributes.Add("onfocus", "selectText();");
Display();
DisplaySummary();
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, 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 dtID = new DataTable();
DataSet ds = new DataSet();
string makeVehicleSQL = " SELECT * FROM MF_VEHICLE WHERE IS_ACTIVE = 'Enable' ORDER BY VEHICLE_NO ASC";
ds = ExecuteBySqlString(makeVehicleSQL);
dtID = (DataTable)ds.Tables[0];
DropDownVehicleID.DataSource = dtID;
DropDownVehicleID.DataValueField = "VEHICLE_ID";
DropDownVehicleID.DataTextField = "VEHICLE_NO";
DropDownVehicleID.DataBind();
DropDownVehicleID.Items.Insert(0, new ListItem("Select Vehicle Number ", "0"));
DataTable dtSlipNoID = new DataTable();
DataSet dss = new DataSet();
string makedtSlipNoIDSQL = " SELECT * FROM MS_SALES_INTER_DIV_MASTER WHERE IS_ACTIVE = 'Enable' AND IS_MF_RECEIVED_STATUS IS NULL AND INTER_DIVISION_ID = '5' ORDER BY WB_SLIP_NO DESC";
dss = ExecuteBySqlString(makedtSlipNoIDSQL);
dtSlipNoID = (DataTable)dss.Tables[0];
DropDownMsWbSlipNo.DataSource = dtSlipNoID;
DropDownMsWbSlipNo.DataValueField = "WB_SLIP_NO";
DropDownMsWbSlipNo.DataTextField = "WB_SLIP_NO";
DropDownMsWbSlipNo.DataBind();
DropDownMsWbSlipNo.Items.Insert(0, new ListItem("Select MS Weight Slip No", "0"));
DataTable dtItemID = new DataTable();
DataSet dsi = new DataSet();
string makeItemSQL = " SELECT ITEM_ID, ITEM_NAME || ' - ' || ITEM_CODE AS ITEM_FULL_NAME FROM MF_ITEM WHERE IS_ACTIVE = 'Enable' AND IS_TRANSFER_ACTIVE = 'Enable' ORDER BY ITEM_ID ASC";
dsi = ExecuteBySqlString(makeItemSQL);
dtItemID = (DataTable)dsi.Tables[0];
DropDownItemID.DataSource = dtItemID;
DropDownItemID.DataValueField = "ITEM_ID";
DropDownItemID.DataTextField = "ITEM_FULL_NAME";
DropDownItemID.DataBind();
DropDownItemID.Items.Insert(0, new ListItem("Select Item", "0"));
DropDownItemID1.DataSource = dtItemID;
DropDownItemID1.DataValueField = "ITEM_ID";
DropDownItemID1.DataTextField = "ITEM_FULL_NAME";
DropDownItemID1.DataBind();
DropDownItemID1.Items.Insert(0, new ListItem("Select Item", "0"));
/* DataTable dtItemBinID = new DataTable();
* DataSet dsb = new DataSet();
* string makeItemBinSQL = " SELECT ITEM_BIN_ID, ITEM_BIN_NAME || ' - Capacity: ' || CAPACITY_WEIGHT || ' (KG)' AS ITEM_FULL_NAME FROM MF_ITEM_BIN WHERE IS_ACTIVE = 'Enable' ORDER BY ITEM_BIN_ID ASC";
* dsb = ExecuteBySqlString(makeItemBinSQL);
* dtItemBinID = (DataTable)dsb.Tables[0];
* DropDownItemBinID.DataSource = dtItemBinID;
* DropDownItemBinID.DataValueField = "ITEM_BIN_ID";
* DropDownItemBinID.DataTextField = "ITEM_FULL_NAME";
* DropDownItemBinID.DataBind();
* DropDownItemBinID.Items.Insert(0, new ListItem("Select Item Bin", "0")); */
DropDownMsWbSlipNo.Focus();
Text1stWeightMs.Attributes.Add("readonly", "readonly");
Text2ndWeightMs.Attributes.Add("readonly", "readonly");
TextMatWeightMs.Attributes.Add("readonly", "readonly");
TextMatWeightMf.Attributes.Add("readonly", "readonly");
TextWeightVariance.Enabled = false;
DropDownItemBinID.Enabled = false;
DropDownItemID.Enabled = 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");
Display();
DisplaySummary();
PendingReceiving();
alert_box.Visible = false;
}
IsLoad = false;
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
