private bool ValidateForm() { if (!Regex.Match(FirstNameTextBox.Text, @"^\D{1,30}$").Success) { MessageBox.Show("First name must consist of at least 1 character and not exceed 30 characters!"); FirstNameTextBox.Focus(); return(false); } if (!Regex.Match(LastNameTextBox.Text, @"^\D{1,30}$").Success) { MessageBox.Show("Last name must consist of at least 1 character and not exceed 30 characters!"); LastNameTextBox.Focus(); return(false); } if (!Regex.Match(AddressTextBox.Text, @"^(Вул\.\s\D{1,40}\,\s\d{1,3})$").Success) { MessageBox.Show("Address must consist of at least 1 character and not exceed 50 characters!"); AddressTextBox.Focus(); return(false); } if (!Regex.Match(PhoneNumberTextBox.Text, @"^\d{10}$").Success) { MessageBox.Show("Phone number must consist of 10 digits!"); PhoneNumberTextBox.Focus(); return(false); } return(true); }
private bool ValidateForm() { if (!Regex.Match(TitleTextBox.Text, @"^\D{1,50}$").Success) { MessageBox.Show("Title must consist of at least 1 character and not exceed 50 characters!"); TitleTextBox.Focus(); return(false); } if (!Regex.Match(ContactTextBox.Text, @"^\D{1,50}$").Success) { MessageBox.Show("Contact person must consist of at least 1 character and not exceed 50 characters!"); ContactTextBox.Focus(); return(false); } if (!Regex.Match(PhoneTextBox.Text, @"^\d{10}$").Success) { MessageBox.Show("Phone number must consist of 10 digits!"); PhoneTextBox.Focus(); return(false); } if (!Regex.Match(AddressTextBox.Text, @"^(Вул\.\s\D{1,40}\,\s\d{1,3})$").Success) { MessageBox.Show("Address must consist of at least 1 character and not exceed 50 characters!"); AddressTextBox.Focus(); return(false); } return(true); }
private void UpdateButton_Click(object sender, RoutedEventArgs e) { if (NameBox.Text == "" || BloodgroupBox.Text == "" || AddressBox.Text == "" || PhonenumberBox.Text == "" || CurrentcityBox.Text == "") { MessageBox.Show("Please fill up all the fields", "Error", MessageBoxButton.OK, MessageBoxImage.Error); NameTextBox.Focus(); } if (!Regex.Match(NameBox.Text, @"^([A-Z][a-z]+||[A-Z][a-z]+\s[A-Z][a-z]+||[A-Z][a-z]+\s[A-Z][a-z]+\s[A-Z][a-z]+)$").Success) { MessageBox.Show("Invalid Name", "Message", MessageBoxButton.OK, MessageBoxImage.Error); BloodgroupBox.Focus(); PhonenumberTextBox.Focus(); } else if (!Regex.Match(PhonenumberBox.Text, @"^\d{10}||\d{11}$").Success) { MessageBox.Show("Invalid Phone Number", "Message", MessageBoxButton.OK, MessageBoxImage.Error); AddressTextBox.Focus(); } else if ( !Regex.Match(AddressBox.Text, @"^([A-Z][a-z]+||\d{3}-[A-Z][a-z]+||[A-Z][a-z]+\s[A-Z][a-z]+,[A-Z][a-z]+,[A-Z][a-z]+)$").Success) { MessageBox.Show("Invalid Address", "Message", MessageBoxButton.OK, MessageBoxImage.Error); CurrentcityTextBox.Focus(); } else if (!Regex.Match(CurrentcityBox.Text, @"^[A-Z][a-z]+$").Success) { MessageBox.Show("Invalid Current City Name", "Message", MessageBoxButton.OK, MessageBoxImage.Error); } else if (Activate()) { Conn = DatabaseConnection.GetConnection(); if (Conn.State.ToString() == "Closed") { Conn.Open(); } string query = string.Format("update information set Name='" + NameBox.Text + "',Bloodgroup='" + BloodgroupBox.SelectionBoxItem + "',Phonenumber='" + PhonenumberBox.Text + "',Address='" + AddressBox.Text + "', Currentcity='" + CurrentcityBox.Text + "' wehre Id='" + IdComboBox.SelectionBoxItem + "'"); var cmd = new SqlCommand(query, Conn); cmd.ExecuteNonQuery(); MessageBox.Show("Data is Updated!!"); Conn.Close(); } }
private void SaveButton_Click(object sender, RoutedEventArgs e) { if (Name1TextBox.Text == "" || BloodgroupComboBox.Text == "" || AddressTextBox.Text == "" || PhonenumberTextBox.Text == "" || CurrentcityTextBox.Text == "") { MessageBox.Show("Please fill up all the fields", "Error", MessageBoxButton.OK, MessageBoxImage.Error); NameTextBox.Focus(); } else if (!Regex.Match(Name1TextBox.Text, @"^([A-Z][a-z]+||[A-Z][a-z]+\s[A-Z][a-z]+||[A-Z][a-z]+\s[A-Z][a-z]+\s[A-Z][a-z]+)$").Success) { MessageBox.Show("Invalid Name", "Message", MessageBoxButton.OK, MessageBoxImage.Error); BloodgroupBox.Focus(); PhonenumberTextBox.Focus(); } else if (!Regex.Match(PhonenumberTextBox.Text, @"^\d{10}||\d{11}$").Success) { MessageBox.Show("Invalid Phone Number", "Message", MessageBoxButton.OK, MessageBoxImage.Error); AddressTextBox.Focus(); } else if ( !Regex.Match(AddressTextBox.Text, @"^([A-Z][a-z]+||\d{3}-[A-Z][a-z]+\s[A-Z][a-z]+,[A-Z][a-z]+,[A-Z][a-z]+)$").Success) { MessageBox.Show("Invalid Address", "Message", MessageBoxButton.OK, MessageBoxImage.Error); CurrentcityTextBox.Focus(); } else if (!Regex.Match(CurrentcityTextBox.Text, @"^[A-Z][a-z]+$").Success) { MessageBox.Show("Invalid Current City Name", "Message", MessageBoxButton.OK, MessageBoxImage.Error); } else if (Activate()) { Conn = DatabaseConnection.GetConnection(); if (Conn.State.ToString() == "Closed") { Conn.Open(); } string query = string.Format("insert into information values('{0}','{1}','{2}','{3}','{4}','{5}')", IdTextBox.Text, Name1TextBox.Text, BloodgroupComboBox.SelectionBoxItem, PhonenumberTextBox.Text, AddressTextBox.Text, CurrentcityTextBox.Text); var cmd = new SqlCommand(query, Conn); cmd.ExecuteNonQuery(); MessageBox.Show("Data is Inserted!!"); Conn.Close(); } }
private bool UpdateClient() { try { InvoicerDataSetTableAdapters.ClientTableAdapter objClient = new InvoicerDataSetTableAdapters.ClientTableAdapter(); if (this.NameTextBox.Text == "") { MessageBox.Show("Please enter Customer Name"); NameTextBox.Focus(); return(false); } else if (AddressTextBox.Text == "") { MessageBox.Show("Please enter Customer Address"); AddressTextBox.Focus(); return(false); } else if (CityTextBox.Text == "") { MessageBox.Show("Please enter Customer City"); CityTextBox.Focus(); return(false); } string ClientName = this.NameTextBox.Text != "" ? NameTextBox.Text : null; string Address = this.AddressTextBox.Text != "" ? AddressTextBox.Text : null; string City = this.CityTextBox.Text != "" ? CityTextBox.Text : null; string State = this.StateTextBox.Text != "" ? StateTextBox.Text : null; string Zip = this.ZipTextBox.Text != "" ? ZipTextBox.Text : null; string TINNO = this.txtTINNo.Text != "" ? txtTINNo.Text : null; //string OrderNo = this.txtRefNo.Text != "" ? txtRefNo.Text : null; string DCNO = this.txtDCNo.Text != "" ? txtDCNo.Text : null; string VendorCode = this.txtVendorCode.Text != "" ? txtVendorCode.Text : null; string GSTIN = this.txtGSTIN.Text != "" ? this.txtGSTIN.Text : null; string StateCode = this.txtStateCode.Text != "" ? this.txtStateCode.Text : null; if (txtClientID.Text == "") { objClient.Insert(ClientName, Address, City, State, Zip, DCNO, VendorCode, TINNO, GSTIN, StateCode); } else { objClient.UpdateClient(ClientName, Address, City, State, Zip, DCNO, VendorCode, TINNO, GSTIN, StateCode, Convert.ToInt32(txtClientID.Text.ToString())); } return(true); } catch (Exception excLocal) { throw excLocal; } }
private void FocusFirstEmptyLoginCredential() { if (Address == string.Empty) { AddressTextBox.Focus(); } else if (Port == string.Empty) { PortTextBox.Focus(); } else if (Username == string.Empty) { UsernameTextBox.Focus(); } else { PasswordBox.Focus(); } }
private bool ValidateForm() { if (!Regex.Match(FirstNameTextBox.Text, @"^\D{1,30}$").Success) { MessageBox.Show("First name must consist of at least 1 character and not exceed 30 characters!"); FirstNameTextBox.Focus(); return(false); } if (!Regex.Match(LastNameTextBox.Text, @"^\D{1,30}$").Success) { MessageBox.Show("Last name must consist of at least 1 character and not exceed 30 characters!"); LastNameTextBox.Focus(); return(false); } if (!Regex.Match(PhoneNumberTextBox.Text, @"^\d{10}$").Success) { MessageBox.Show("Phone number must consist of 10 digits!"); PhoneNumberTextBox.Focus(); return(false); } if (!Regex.Match(ExperienceTextBox.Text, @"^[0-9]+$").Success) { MessageBox.Show("Invalid work experience number! It must contain only digits"); ExperienceTextBox.Focus(); return(false); } if (!Regex.Match(AddressTextBox.Text, @"^(Вул\.\s\D{1,40}\,\s\d{1,3})$").Success) { MessageBox.Show("Address must consist of at least 1 character and not exceed 50 characters!"); AddressTextBox.Focus(); return(false); } if (RoleComboBox.SelectedItem == null) { MessageBox.Show("Please select role"); return(false); } if (MarketComboBox.SelectedItem == null) { MessageBox.Show("Please select market"); return(false); } if (CityComboBox.SelectedItem == null) { MessageBox.Show("Please select city"); return(false); } if (!Regex.Match(LoginTextBox.Text, @"^\D{6,20}$").Success) { MessageBox.Show("Login must consist of at least 6 character and not exceed 20 characters!"); LoginTextBox.Focus(); return(false); } if (!Regex.Match(PasswordTextBox.Text, @"^\D{6,20}$").Success) { MessageBox.Show("Login must consist of at least 6 character and not exceed 20 characters!"); PasswordTextBox.Focus(); return(false); } return(true); }
private bool IsFormValidate() { if (FullNameTextBox.Text.Trim() == "") { MessageBox.Show("Full Name is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); FullNameTextBox.Clear(); FullNameTextBox.Focus(); return(false); } if (FatherNameTextBox.Text.Trim() == "") { MessageBox.Show("Father Name is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); FatherNameTextBox.Clear(); FatherNameTextBox.Focus(); return(false); } if (MotherNameTextBox.Text.Trim() == "") { MessageBox.Show("Mother Name is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); MotherNameTextBox.Clear(); MotherNameTextBox.Focus(); return(false); } if (AddressTextBox.Text.Trim() == "") { MessageBox.Show("Address is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); AddressTextBox.Clear(); AddressTextBox.Focus(); return(false); } if (EmailTextBox.Text.Trim() == "") { MessageBox.Show("Email Name is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); EmailTextBox.Clear(); EmailTextBox.Focus(); return(false); } if (MobileTextBox.Text.Trim() == "") { MessageBox.Show("Mobile number is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); MobileTextBox.Clear(); MobileTextBox.Focus(); return(false); } if (BloodGroupTextBox.Text.Trim() == "") { MessageBox.Show("Blood Group is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); BloodGroupTextBox.Clear(); BloodGroupTextBox.Focus(); return(false); } if (GenderComboBox.SelectedIndex == -1) { MessageBox.Show("Gender is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } if (BranchComboBox.SelectedIndex == -1) { MessageBox.Show("Branch is required", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } return(true); }
public FtpDialog() { InitializeComponent(); AddressTextBox.Focus(); }
// save button clicked private void SaveButton_Click(object sender, EventArgs e) { if (FirstNameTextBox.Text == "" || FirstNameTextBox.ForeColor == Color.Red) { MessageBox.Show("Make sure you filled out <First Name> field and entered only letters (a-z, A-Z)", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error); FirstNameTextBox.Focus(); } else if (LastNameTextBox.Text == "" || LastNameTextBox.ForeColor == Color.Red) { MessageBox.Show("Make sure you filled out <Last Name> field and entered only letters (a-z, A-Z)", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error); LastNameTextBox.Focus(); } else if (PhoneTextBox.Text == "" || PhoneTextBox.ForeColor == Color.Red) { MessageBox.Show("Make sure you filled out <Phone Number> field and input is in correct format (XXXXXXXXXX or XXX XXX XXXX or XXX-XXX-XXXX)", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error); PhoneTextBox.Focus(); } else if (EmailTextBox.Text == "" || EmailTextBox.ForeColor == Color.Red) { MessageBox.Show("Make sure you filled out <Email> field and provided valid Email", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error); EmailTextBox.Focus(); } else if (CityTextBox.Text == "" || CityTextBox.ForeColor == Color.Red) { MessageBox.Show("Make sure you filled out <City> field and provided valid input", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error); CityTextBox.Focus(); } else if (StateTextBox.Text == "" || StateTextBox.ForeColor == Color.Red) { MessageBox.Show("Make sure you filled out <State> field and provided valid input", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error); StateTextBox.Focus(); } else if (ZipTextBox.Text == "" || ZipTextBox.ForeColor == Color.Red) { MessageBox.Show("Make sure you filled out <Zip> field and input is in valid format (XXXXX)", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error); ZipTextBox.Focus(); } else if (AddressTextBox.Text == "" || AddressTextBox.ForeColor == Color.Red) { MessageBox.Show("Make sure you filled out <Address> field and provided valid input", "Invalid Input Provided", MessageBoxButtons.OK, MessageBoxIcon.Error); AddressTextBox.Focus(); } else { string cmdText = "select count(*) from Customers where FirstName = @firstName and LastName = @lastName and Email = @email and Phone = @phone and Address = @address and City = @city and State = @state and Zip = @zip"; scmd = new SqlCommand(cmdText, connection); connection.Open(); scmd.Parameters.AddWithValue("@firstName", FirstNameTextBox.Text); scmd.Parameters.AddWithValue("@lastName", LastNameTextBox.Text); scmd.Parameters.AddWithValue("@email", EmailTextBox.Text); scmd.Parameters.AddWithValue("@phone", PhoneTextBox.Text); scmd.Parameters.AddWithValue("@address", AddressTextBox.Text); scmd.Parameters.AddWithValue("@city", CityTextBox.Text); scmd.Parameters.AddWithValue("@state", StateTextBox.Text); scmd.Parameters.AddWithValue("@zip", ZipTextBox.Text); int exists = (int)scmd.ExecuteScalar(); // check if entered isnb is unique connection.Close(); // if user clicks new customer button, add new customer mode is on if (addNewCustomerMode) { if (exists > 0) { MessageBox.Show("Customer Already Exists", "Addition of existing Customer", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { DialogResult save = MessageBox.Show("Do you want to save the Customer?", "Add New Customer", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (save == DialogResult.Yes) { scmd = new SqlCommand("SET IDENTITY_INSERT Customers OFF; insert into Customers(FirstName, LastName, Email, Phone, Address, City, State, Zip) Values(@firstName, @lastName, @email, @phone, @address, @city, @state, @zip)", connection); connection.Open(); scmd.Parameters.AddWithValue("@firstName", FirstNameTextBox.Text); scmd.Parameters.AddWithValue("@lastName", LastNameTextBox.Text); scmd.Parameters.AddWithValue("@email", EmailTextBox.Text); scmd.Parameters.AddWithValue("@phone", PhoneTextBox.Text); scmd.Parameters.AddWithValue("@address", AddressTextBox.Text); scmd.Parameters.AddWithValue("@state", CityTextBox.Text); scmd.Parameters.AddWithValue("@city", CityTextBox.Text); scmd.Parameters.AddWithValue("@zip", ZipTextBox.Text); scmd.ExecuteNonQuery(); connection.Close(); MessageBox.Show("The Customer Was Added Successfully."); DisplayCustomers(); // refresh combobox values ResetAll(); CustomerComboBox.Enabled = true; } } } // if user chooses customer from combobox, update customer mode is on if (updateCustomerMode) { if (exists > 0) { MessageBox.Show("You haven't modified anything.", "Nothing to update", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { DialogResult save = MessageBox.Show("Do you want to update the Customer?", "Update Existing Customer", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (save == DialogResult.Yes) { cmdText = "update Customers set FirstName = @firstName, LastName = @lastName, Email = @email, Phone = @phone, Address = @address, City = @city, State = @state, Zip = @zip where ID = @customerID"; scmd = new SqlCommand(cmdText, connection); connection.Open(); scmd.Parameters.AddWithValue("@customerID", customerID); scmd.Parameters.AddWithValue("@firstName", FirstNameTextBox.Text); scmd.Parameters.AddWithValue("@lastName", LastNameTextBox.Text); scmd.Parameters.AddWithValue("@email", EmailTextBox.Text); scmd.Parameters.AddWithValue("@phone", PhoneTextBox.Text); scmd.Parameters.AddWithValue("@address", AddressTextBox.Text); scmd.Parameters.AddWithValue("@city", CityTextBox.Text); scmd.Parameters.AddWithValue("@state", StateTextBox.Text); scmd.Parameters.AddWithValue("@zip", ZipTextBox.Text); scmd.ExecuteNonQuery(); connection.Close(); MessageBox.Show("The Customer Was Updated Successfully."); DisplayCustomers(); // refresh combobox values ResetAll(); } } } } }
private void ShowError(object sender, ErrorEvent e) { MessageBox.Show(e.Value, "Błąd", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK); AddressTextBox.Focus(); }