private void metroButton6_Click(object sender, EventArgs e)
        {
            //get the data from texbox
            p.sPID       = int.Parse(sPID.Text);
            p.sProgramme = sProgramme.Text;



            bool success = p.Update(p);

            if (success == true)
            {
                //Upload Successfully
                MessageBox.Show(" Successfully Updated");
            }
            else
            {
                //faild to update
                MessageBox.Show("ERROR ");
            }
            DataTable dtp = p.Select();

            metroGrid2.DataSource = dtp;



            Clear2();
        }
Пример #2
0
        protected void dgUpdate_Programme(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            Label        lblTempID            = (Label)e.Item.Cells[0].FindControl("txtID");
            TextBox      txtTempProgrammeCode = (TextBox)e.Item.Cells[0].FindControl("txtProgrammeID");
            DropDownList txtTempFacultyID     = (DropDownList)e.Item.Cells[1].FindControl("ddlFacultyName");
            TextBox      txtTempProgrammeName = (TextBox)e.Item.Cells[2].FindControl("txtProgrammeName");

            Regex codeRegex = new Regex(@"[A-Z]{3}$");
            Match checkCode = codeRegex.Match(txtTempProgrammeCode.Text);

            //Validation for programme (No digit allowed and only up to 50 characters)
            Regex progRegex = new Regex(@"[a-zA-Z() ]{1,50}$");
            Match checkProg = progRegex.Match(txtTempProgrammeName.Text);

            if (lblTempID.Text.Trim() == "" || txtTempProgrammeCode.Text.Trim() == "" || txtTempFacultyID.Text.Trim() == "" || txtTempProgrammeName.Text.Trim() == "")
            {
                ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type='text/javascript'>swal('Error!', 'Please fill in the programme information first!', 'error')</script>'");
            }
            else if (!checkCode.Success)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type='text/javascript'>swal('Error!', 'The programme code must have 3 upppercase characters', 'error')</script>'");
            }
            else if (!checkProg.Success)
            {
                ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type='text/javascript'>swal('Error!', 'Programme name can only consist characters or ().', 'error')</script>'");
            }
            else
            {
                Programme programme = new Programme();
                if (programme.Update(lblTempID.Text, txtTempProgrammeCode.Text, txtTempFacultyID.Text, txtTempProgrammeName.Text) == false)
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type='text/javascript'>swal('Error!', 'This code is existed already, try another programme code!', 'error')</script>'");
                }
                else
                {
                    ClientScript.RegisterStartupScript(this.GetType(), "Success", "<script type='text/javascript'>swal({title: 'Updated!', text: 'This " + txtTempProgrammeName.Text + " (" + txtTempProgrammeCode.Text + ") programme is updated successfully', type : 'success', confirmButtonText : 'OK'}, function (isConfirm) { if (isConfirm) { window.location.href = 'cpProgramme.aspx'; }});</script>'");
                }
            }
        }