public void TextWbSlipNo_TextChanged(object sender, EventArgs e) { string SlipNo = TextWbSlipNo.Text; string MatchEmpIDPattern = "^([0-9]{6})$"; if (SlipNo != null) { if (Regex.IsMatch(SlipNo, MatchEmpIDPattern)) { alert_box.Visible = false; OracleConnection conn = new OracleConnection(strConnString); conn.Open(); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "select WB_SLIP_NO from MF_MATERIAL_TRANSFER_MASTER where WB_SLIP_NO = '" + Convert.ToInt32(SlipNo) + "'"; cmd.CommandType = CommandType.Text; OracleDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { CheckSlipNo.Text = "<label class='control-label'><i class='fa fa-times-circle-o'></i> Slip Number is not available</label>"; CheckSlipNo.ForeColor = System.Drawing.Color.Red; TextWbSlipNo.Focus(); BtnAdd.Attributes.Add("aria-disabled", "false"); BtnAdd.Attributes.Add("class", "btn btn-primary disabled"); } else { CheckSlipNo.Text = "<label class='control-label'><i class='fa fa fa-check'></i> Slip Number is available</label>"; CheckSlipNo.ForeColor = System.Drawing.Color.Green; BtnAdd.Attributes.Add("aria-disabled", "true"); BtnAdd.Attributes.Add("class", "btn btn-primary active"); } } else { CheckSlipNo.Text = "<label class='control-label'><i class='fa fa-hand-o-left'></i> Enter Slip Number is 6 digit only</label>"; CheckSlipNo.ForeColor = System.Drawing.Color.Red; TextWbSlipNo.Focus(); BtnAdd.Attributes.Add("aria-disabled", "false"); BtnAdd.Attributes.Add("class", "btn btn-primary disabled"); } } }
protected void BtnUpdate_Click(object sender, EventArgs e) { try { if (IS_EDIT_ACTIVE == "Enable") { OracleConnection conn = new OracleConnection(strConnString); conn.Open(); int userID = Convert.ToInt32(Session["USER_ID"]); int TransferID = Convert.ToInt32(TextTransferID.Text); int VehicleID = Convert.ToInt32(DropDownVehicleID.Text); int MaterialID = Convert.ToInt32(DropDownMaterialID.Text); string ISActive = CheckIsActive.Checked ? "Enable" : "Disable"; string MakeEntryDate = EntryDate.Text; string[] MakeEntryDateSplit = MakeEntryDate.Split('-'); String EntryDateTemp = MakeEntryDateSplit[0].Replace("/", "-"); DateTime EntryDateNewD = DateTime.ParseExact(EntryDateTemp, "dd-MM-yyyy", CultureInfo.InvariantCulture); string EntryDateNew = EntryDateNewD.ToString("dd-MM-yyyy"); double MatWeightMf = Convert.ToDouble(TextMatWeightMf.Text.Trim()); double MatWeightMs = Convert.ToDouble(TextMatWeightMs.Text.Trim()); double WeightDifference = MatWeightMf - MatWeightMs; string u_date = System.DateTime.Now.ToString("dd-MM-yyyy h:mm:ss tt"); // Transfer master update string update_user = "******"; cmdi = new OracleCommand(update_user, conn); OracleParameter[] objPrm = new OracleParameter[12]; objPrm[0] = cmdi.Parameters.Add("NoSlipID", TextWbSlipNo.Text); objPrm[1] = cmdi.Parameters.Add("NoVehicleID", VehicleID); objPrm[2] = cmdi.Parameters.Add("NoMaterialID", MaterialID); objPrm[3] = cmdi.Parameters.Add("NoMatWeightMf", MatWeightMf); objPrm[4] = cmdi.Parameters.Add("NoMatWeightMs", MatWeightMs); objPrm[5] = cmdi.Parameters.Add("NoWeightDifference", WeightDifference); objPrm[6] = cmdi.Parameters.Add("TextRemarks", TextRemarks.Text); objPrm[7] = cmdi.Parameters.Add("EntryDate", EntryDateNew); objPrm[8] = cmdi.Parameters.Add("u_date", u_date); objPrm[9] = cmdi.Parameters.Add("NoCuserID", userID); objPrm[10] = cmdi.Parameters.Add("TextIsActive", ISActive); objPrm[11] = cmdi.Parameters.Add("NoTransferID", TransferID); cmdi.ExecuteNonQuery(); cmdi.Parameters.Clear(); cmdi.Dispose(); conn.Close(); alert_box.Visible = true; alert_box.Controls.Add(new LiteralControl("Transfer Data Update successfully")); alert_box.Attributes.Add("class", "alert alert-success alert-dismissible"); clearText(); TextWbSlipNo.Focus(); Display(); DisplaySummary(); } else { Response.Redirect("~/PagePermissionError.aspx"); } } catch { Response.Redirect("~/ParameterError.aspx"); } }
// 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"); } }
public void BtnAdd_Click(object sender, EventArgs e) { try { if (IS_ADD_ACTIVE == "Enable") { OracleConnection conn = new OracleConnection(strConnString); conn.Open(); int userID = Convert.ToInt32(Session["USER_ID"]); int VehicleID = Convert.ToInt32(DropDownVehicleID.Text); int SlipNo = Convert.ToInt32(TextWbSlipNo.Text); int MaterialID = Convert.ToInt32(DropDownMaterialID.Text); string ISActive = CheckIsActive.Checked ? "Enable" : "Disable"; string MakeEntryDate = EntryDate.Text; string[] MakeEntryDateSplit = MakeEntryDate.Split('-'); String EntryDateTemp = MakeEntryDateSplit[0].Replace("/", "-"); DateTime EntryDateNewD = DateTime.ParseExact(EntryDateTemp, "dd-MM-yyyy", CultureInfo.InvariantCulture); string EntryDateNew = EntryDateNewD.ToString("dd-MM-yyyy"); string c_date = System.DateTime.Now.ToString("dd-MM-yyyy h:mm:ss tt"); double MatWeightMf = Convert.ToDouble(TextMatWeightMf.Text.Trim()); double MatWeightMs = Convert.ToDouble(TextMatWeightMs.Text.Trim()); double WeightDifference = MatWeightMf - MatWeightMs; string get_transfer_id = "select MF_MAT_TRANSFER_MASTERID_SEQ.nextval from dual"; cmdsp = new OracleCommand(get_transfer_id, conn); int newTransferID = Int16.Parse(cmdsp.ExecuteScalar().ToString()); string insert_Transfer = "insert into MF_MATERIAL_TRANSFER_MASTER (TRANSFER_ID, WB_SLIP_NO, VEHICLE_ID, MATERIAL_ID, WT_AS_PER_MF, WT_AS_PER_MS, DIFFERENCE, REMARKS, ENTRY_DATE, CREATE_DATE, C_USER_ID, IS_ACTIVE, DIVISION_ID) values ( :NoTransferID, :NoSlipID, :NoVehicleID, :NoMaterialID, :TextMatWeightMf, :TextMatWeightMs, :TextWeightDifference, :TextRemarks, TO_DATE(:EntryDate, 'DD/MM/YYYY'), TO_DATE(:c_date, 'DD-MM-YYYY HH:MI:SS AM'), :NoCuserID, :TextIsActive, 5)"; cmdi = new OracleCommand(insert_Transfer, conn); OracleParameter[] objPrm = new OracleParameter[12]; objPrm[0] = cmdi.Parameters.Add("NoTransferID", newTransferID); objPrm[1] = cmdi.Parameters.Add("NoSlipID", SlipNo); objPrm[2] = cmdi.Parameters.Add("NoVehicleID", VehicleID); objPrm[3] = cmdi.Parameters.Add("NoMaterialID", MaterialID); objPrm[4] = cmdi.Parameters.Add("TextMatWeightMf", MatWeightMf); objPrm[5] = cmdi.Parameters.Add("TextMatWeightMs", MatWeightMs); objPrm[6] = cmdi.Parameters.Add("TextWeightDifference", WeightDifference); objPrm[7] = cmdi.Parameters.Add("EntryDate", EntryDateNew); objPrm[8] = cmdi.Parameters.Add("TextRemarks", TextRemarks.Text); objPrm[9] = cmdi.Parameters.Add("c_date", c_date); objPrm[10] = cmdi.Parameters.Add("NoCuserID", userID); objPrm[11] = cmdi.Parameters.Add("TextIsActive", ISActive); cmdi.ExecuteNonQuery(); cmdi.Parameters.Clear(); cmdi.Dispose(); conn.Close(); alert_box.Visible = true; alert_box.Controls.Add(new LiteralControl("Insert New Transfer Data successfully")); alert_box.Attributes.Add("class", "alert alert-success alert-dismissible"); clearText(); TextWbSlipNo.Focus(); Display(); DisplaySummary(); } else { Response.Redirect("~/PagePermissionError.aspx"); } } catch { Response.Redirect("~/ParameterError.aspx"); } }