private string TextBoxValidation()
{
string errorMessage = string.Empty;
if (FirstNameTextBox.Text.Length > 0 && FirstNameTextBox.Text != null)
{
this.FirstName = FirstNameTextBox.Text;
}
else
{
errorMessage = "Invalid entry for first name. Please enter a valid first name";
FirstNameTextBox.Focus();
}
if (MiddleNameTextBox.Text != null)
{
this.MiddleName = MiddleNameTextBox.Text;
}
else
{
errorMessage = "Invalid entry for middle name. Please enter a valid middle name";
MiddleNameTextBox.Focus();
}
if (LastNameTextBox.Text.Length > 0 && LastNameTextBox.Text != null)
{
this.LastName = LastNameTextBox.Text;
}
else
{
errorMessage = "Invalid entry for last name. Please enter a valid last name";
LastNameTextBox.Focus();
}
if (CityTextBox.Text.Length > 0 && CityTextBox.Text != null)
{
this.City = CityTextBox.Text;
}
else
{
errorMessage = "Invalid entry for city. Please enter a valid city";
CityTextBox.Focus();
}
if (StateTextBox.Text.Length > 0 && StateTextBox.Text != null)
{
this.State = StateTextBox.Text;
}
else
{
errorMessage = "Invalid entry for state. Please enter a valid state";
StateTextBox.Focus();
}
if (CountryTextBox.Text.Length > 0 && CountryTextBox.Text != null)
{
this.Country = CountryTextBox.Text;
}
else
{
errorMessage = "Invalid entry for Country. Please enter a valid country";
CountryTextBox.Focus();
}
if (PhoneNumberTextBox.Text.Length > 0 && PhoneNumberTextBox.Text != null)
{
this.PhoneNumber = PhoneNumberTextBox.Text;
}
else
{
errorMessage = "Invalid entry for phone number. Please enter a valid phone number";
PhoneNumberTextBox.Focus();
}
if (EmailAddressTextBox.Text.Length > 0 && EmailAddressTextBox.Text != null)
{
this.EmailAddress = EmailAddressTextBox.Text;
}
else
{
errorMessage = "Invalid entry for email address. Please enter a valid email address";
EmailAddressTextBox.Focus();
}
return(errorMessage);
}
// 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();
}
}
}
}
}
