protected void linkSelectClick(object sender, EventArgs e) { // try{ OracleConnection conn = new OracleConnection(strConnString); conn.Open(); LinkButton btn = (LinkButton)sender; Session["user_data_id"] = btn.CommandArgument; string USER_DATA_ID = Session["user_data_id"].ToString(); string makeSQL = " select PURCHASE_IMPROT_ID, WB_SLIP_NO, CONTAINER_NO, CONTAINER_SIZE_ID, PARTY_ID, FIRST_WT_MF, SECOND_WT_MF, nvl(ITEM_WEIGHT_WB,0) AS ITEM_WEIGHT_WB, ITEM_ID, ITEM_BIN_ID, ITEM_WEIGHT, TO_CHAR(ENTRY_DATE,'dd/mm/yyyy') AS ENTRY_DATE, IS_ACTIVE from MF_PURCHASE_IMPROT where WB_SLIP_NO = '" + USER_DATA_ID + "'"; 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++) { TextPrchaseImportID.Text = dt.Rows[i]["PURCHASE_IMPROT_ID"].ToString(); TextSlipNo.Text = dt.Rows[i]["WB_SLIP_NO"].ToString(); DropDownSupplierID.Text = dt.Rows[i]["PARTY_ID"].ToString(); TextContainerNo.Text = dt.Rows[i]["CONTAINER_NO"].ToString(); DropDownContainerSizeID.Text = dt.Rows[i]["CONTAINER_SIZE_ID"].ToString(); DropDownItemID.Text = dt.Rows[i]["ITEM_ID"].ToString(); DataTable dtItemID = new DataTable(); DataSet dsi = new DataSet(); string makeItemSQL = " SELECT ITEM_BIN_ID, ITEM_BIN_NAME || ' - Capacity: ' || CAPACITY_WEIGHT || ' (KG)' AS ITEM_FULL_NAME FROM MF_ITEM_BIN WHERE IS_ACTIVE = 'Enable' AND ITEM_ID = '" + Convert.ToInt32(dt.Rows[i]["ITEM_ID"].ToString()) + "' ORDER BY ITEM_BIN_ID ASC "; dsi = ExecuteBySqlString(makeItemSQL); dtItemID = (DataTable)dsi.Tables[0]; DropDownItemBinID.DataSource = dtItemID; DropDownItemBinID.DataValueField = "ITEM_BIN_ID"; DropDownItemBinID.DataTextField = "ITEM_FULL_NAME"; DropDownItemBinID.DataBind(); DropDownItemBinID.Items.Insert(0, new ListItem("Select Item Bin ", "0")); // DropDownItemBinID.Text = dt.Rows[i]["ITEM_BIN_ID"].ToString(); TextItemWeightEx.Text = dt.Rows[i]["ITEM_WEIGHT"].ToString(); EntryDate.Text = dt.Rows[i]["ENTRY_DATE"].ToString(); TextMat1stWeightMf.Text = dt.Rows[i]["FIRST_WT_MF"].ToString(); TextMat2ndWeightMf.Text = dt.Rows[i]["SECOND_WT_MF"].ToString(); TextItemWtWb.Text = dt.Rows[i]["ITEM_WEIGHT_WB"].ToString(); CheckIsActive.Checked = Convert.ToBoolean(dt.Rows[i]["IS_ACTIVE"].ToString() == "Enable" ? true : false); string makePackSQL = " select * from MF_MATERIAL_PACKING_HISTORY where WB_SLIP_NO = '" + dt.Rows[i]["WB_SLIP_NO"].ToString() + "'"; cmdl = new OracleCommand(makePackSQL); oradata = new OracleDataAdapter(cmdl.CommandText, conn); dt = new DataTable(); oradata.Fill(dt); RowCount2 = dt.Rows.Count; for (int j = 0; j < RowCount2; j++) { if (j < 1) { DropDownPacking1.Text = dt.Rows[j]["PACKING_ID"].ToString(); TextNoOfPacking1.Text = dt.Rows[j]["NUMBER_OF_PACK"].ToString(); TextNoPerWtPacking1.Text = dt.Rows[j]["PACK_PER_WEIGHT"].ToString(); TextWtTotalPacking1.Text = dt.Rows[j]["TOTAL_WEIGHT"].ToString(); } } } conn.Close(); Display(); CheckSlipNo.Text = ""; alert_box.Visible = false; BtnAdd.Attributes.Add("aria-disabled", "false"); BtnAdd.Attributes.Add("class", "btn btn-primary disabled"); // TextSlipNo.Attributes.Add("readonly", "readonly"); // } // catch // { // Response.Redirect("~/ParameterError.aspx"); // } }
protected void linkSelectClick(object sender, EventArgs e) { // try{ OracleConnection conn = new OracleConnection(strConnString); conn.Open(); LinkButton btn = (LinkButton)sender; Session["user_data_id"] = btn.CommandArgument; int USER_DATA_ID = Convert.ToInt32(Session["user_data_id"]); string makeSQL = " select TRANSFER_ID, WB_SLIP_NO, VEHICLE_ID, ITEM_ID, ITEM_BIN_ID, FIRST_WT_MF, SECOND_WT_MF, NET_WT_MF, NET_WT_MS, VARIANCE, WB_SLIP_NO_MS, REMARKS, TO_CHAR(ENTRY_DATE,'dd/mm/yyyy') AS ENTRY_DATE, CREATE_DATE, UPDATE_DATE, C_USER_ID, U_USER_ID, IS_ACTIVE from MF_PURCHASE_TRANSFER_MASTER where TRANSFER_ID = '" + USER_DATA_ID + "'"; 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++) { 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' AND ITEM_ID = '" + Convert.ToInt32(dt.Rows[i]["ITEM_ID"].ToString()) + "' 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(); TextTransferID.Text = dt.Rows[i]["TRANSFER_ID"].ToString(); TextMfWbSlipNo.Text = dt.Rows[i]["WB_SLIP_NO"].ToString(); DropDownVehicleID.Text = dt.Rows[i]["VEHICLE_ID"].ToString(); DropDownItemID.Text = dt.Rows[i]["ITEM_ID"].ToString(); // DropDownItemBinID.Text = dt.Rows[i]["ITEM_BIN_ID"].ToString(); TextMat1stWeightMf.Text = dt.Rows[i]["FIRST_WT_MF"].ToString(); TextMat2ndWeightMf.Text = dt.Rows[i]["SECOND_WT_MF"].ToString(); TextMatWeightMf.Text = dt.Rows[i]["NET_WT_MF"].ToString(); TextMatWeightMs.Text = dt.Rows[i]["NET_WT_MS"].ToString(); TextWeightVariance.Text = decimal.Parse(dt.Rows[i]["VARIANCE"].ToString()).ToString(".00"); EntryDate.Text = dt.Rows[i]["ENTRY_DATE"].ToString(); TextRemarks.Text = dt.Rows[i]["REMARKS"].ToString(); CheckIsActive.Checked = Convert.ToBoolean(dt.Rows[i]["IS_ACTIVE"].ToString() == "Enable" ? true : false); DataTable dtSlipNoID = new DataTable(); DataSet dss = new DataSet(); string makedtSlipNoIDSQL = " SELECT * FROM MS_SALES_INTER_DIV_MASTER WHERE IS_ACTIVE = 'Enable' 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")); DropDownMsWbSlipNo.Text = dt.Rows[i]["WB_SLIP_NO_MS"].ToString(); string makeSQL1 = " select ITEM_ID, WB_SLIP_NO, FIRST_WT, SECOND_WT, ITEM_WEIGHT from MS_SALES_INTER_DIV_MASTER where WB_SLIP_NO = '" + dt.Rows[i]["WB_SLIP_NO_MS"].ToString() + "'"; cmdl = new OracleCommand(makeSQL1); oradata = new OracleDataAdapter(cmdl.CommandText, conn); dt = new DataTable(); oradata.Fill(dt); RowCount = dt.Rows.Count; for (int j = 0; j < RowCount; j++) { Text1stWeightMs.Text = dt.Rows[j]["FIRST_WT"].ToString(); Text2ndWeightMs.Text = dt.Rows[j]["SECOND_WT"].ToString(); TextMatWeightMs.Text = dt.Rows[j]["ITEM_WEIGHT"].ToString(); } } conn.Close(); Display(); PendingReceiving(); CheckSlipNo.Text = ""; alert_box.Visible = false; DropDownItemBinID.Enabled = true; DropDownMsWbSlipNo.Enabled = true; BtnAdd.Attributes.Add("aria-disabled", "false"); BtnAdd.Attributes.Add("class", "btn btn-primary disabled"); BtnUpdate.Attributes.Add("aria-disabled", "true"); BtnUpdate.Attributes.Add("class", "btn btn-success active"); BtnDelete.Attributes.Add("aria-disabled", "true"); BtnDelete.Attributes.Add("class", "btn btn-danger active"); // } // catch // { // Response.Redirect("~/ParameterError.aspx"); // } }