private void btncancel_Click(object sender, EventArgs e) { this.Close(); CustomerListForm clf = new CustomerListForm(); clf.Show(); clf.Focus(); }
private void BtnSave_Click_1(object sender, EventArgs e) { var updatequery = from x in ctx.Customers where x.CustomerID == cusobj.CustomerID select x; var updatecus = updatequery.First(); updatecus.Name = txtCustName.Text; updatecus.DOB = dtDOB.Value; if (optFemale.Checked) { updatecus.Gender = "F"; } else { updatecus.Gender = "M"; } updatecus.NRIC = txtNRIC.Text; updatecus.Address = txtAddress.Text; updatecus.PostalCode = txtPostalCode.Text; updatecus.Phoneno = txtPhoneNo.Text; updatecus.Email = txtEmail.Text; updatecus.Remarks = txtRemarks.Text.Trim(); // no empty values for required fields bool acceptData = true; int count = 0; lblvalidate.Text = ""; if (txtCustName.Text == "") { lblvalidate.Text = "Fill in the Name."; acceptData = false; count = count + 1; txtCustName.Focus(); } if (txtPhoneNo.Text == "") { lblvalidate.Text = "Fill in the Mobile No."; count = count + 1; acceptData = false; txtPhoneNo.Focus(); } if (this.txtEmail.Text == "") { lblvalidate.Text = "Fill in the Email."; count = count + 1; acceptData = false; txtEmail.Focus(); } else { //email validation string email = txtEmail.Text; string strRegex = @"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}" + @"\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\" + @".)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$"; Regex re = new Regex(strRegex); if (re.IsMatch(email) == false) { lblvalidate.Text = "Invalid email address"; acceptData = false; txtEmail.Focus(); } } //length validation txtCustName.MaxLength = 30; if (txtCustName.Text.Length > 30) { MessageBox.Show("Customer name cannot be more than 30 characters!!!"); count = count + 1; acceptData = false; txtCustName.Focus(); } txtNRIC.MaxLength = 9; if (txtNRIC.Text.Length > 9) { MessageBox.Show("NRIC should be 9 characters!!!"); count = count + 1; acceptData = false; txtNRIC.Focus(); } else if (txtNRIC.Text.Length < 9) { MessageBox.Show("NRIC should be 9 characters!!!"); count = count + 1; acceptData = false; txtNRIC.Focus(); } txtAddress.MaxLength = 255; if (txtAddress.Text.Length > 255) { MessageBox.Show("Address cannot be more than 255 characters!!!"); count = count + 1; acceptData = false; txtAddress.Focus(); } txtPostalCode.MaxLength = 6; if (txtPostalCode.Text.Length > 6) { MessageBox.Show("Postal Code should be 6 characters"); count = count + 1; acceptData = false; txtPostalCode.Focus(); } else if (txtPostalCode.Text.Length < 6) { MessageBox.Show("Postal Code should be 6 characters"); count = count + 1; acceptData = false; txtPostalCode.Focus(); } txtPhoneNo.MaxLength = 8; if (txtPhoneNo.Text.Length > 8) { MessageBox.Show("Phone no digits should be 8."); count = count + 1; acceptData = false; txtPhoneNo.Focus(); } else if (txtPhoneNo.Text.Length < 8) { MessageBox.Show("Phone no digits should be 8."); count = count + 1; acceptData = false; txtPhoneNo.Focus(); } txtEmail.MaxLength = 50; if (txtEmail.Text.Length > 50) { MessageBox.Show("Email address cannot be more than 50 characters!!!."); count = count + 1; acceptData = false; txtEmail.Focus(); } txtRemarks.MaxLength = 255; if (txtRemarks.Text.Length > 255) { MessageBox.Show("Remarks cannot be more than 255 characters!!!x."); count = count + 1; acceptData = false; txtRemarks.Focus(); } if (count > 1) { lblvalidate.Text = "Required fields cannot be empty."; } if ((acceptData == true) && (cusctrl.NewCustomerValidation(cusobj))) { MessageBox.Show("All data are validated."); ctx.SaveChanges(); MessageBox.Show("Update Successfully"); CustomerListForm clf = new CustomerListForm(); clf.Show(); clf.Focus(); clf.TopMost = false; this.Close(); } else { MessageBox.Show("Data validation Error."); } }