private void AddCustomerButton_Click(object sender, EventArgs e) { try { // If any of the fields is empty if (main.isEmpty(CustomerIDBox.Text) || main.isEmpty(DriversLicenseBox.Text) || main.isEmpty(NameBox.Text) || main.isEmpty(PhoneNumberBox.Text) || main.isEmpty(AddressBox.Text) || main.isEmpty(CityBox.Text) || main.isEmpty(ProvinceBox.Text) || main.isEmpty(PostalCodeBox.Text)) { MessageBox.Show("Please fill in all fields"); return; } string command = "INSERT INTO Customer VALUES('" + CustomerIDBox.Text + "','" + DriversLicenseBox.Text.ToUpper() + "','" + text.ToTitleCase(NameBox.Text) + "','" + PhoneNumberBox.Text + "','" + text.ToTitleCase(AddressBox.Text) + "','" + text.ToTitleCase(CityBox.Text) + "','" + text.ToTitleCase(ProvinceBox.Text) + "','" + PostalCodeBox.Text.ToUpper() + "')"; datab.insert(command); main.CustomersDGV_LoadAll(datab); this.Close(); } catch (Exception e2) { // MessageBox.Show("VIN already exists in the system", "VIN Error"); MessageBox.Show(e2.ToString(), "Error"); } }
private void SubmitChangesButton_Click(object sender, EventArgs e) { /* Compare the corresponding input text to the value of the cell selected. If they are different update. If not, dont do anything*/ try { // converts the string into something "System.Globalization" can manipulate? TextInfo text = CultureInfo.CurrentCulture.TextInfo; // Ensure the input text is not empty and different from the original value if (CustomerIDBox.Text != this.getCustomerIDValue() && !main.isEmpty(CustomerIDBox.Text)) { string updatecID = "UPDATE Customer SET cID = '" + CustomerIDBox.Text + "' WHERE cID = '" + this.getCustomerIDValue() + "'"; datab.insert(updatecID); } if (DriversLicenseBox.Text != this.getDriverLicenseValue() && !main.isEmpty(DriversLicenseBox.Text)) { string updateDriversLicense = "UPDATE Customer SET driverLicense = '" + DriversLicenseBox.Text + "' WHERE driverLicense = '" + this.getDriverLicenseValue() + "' AND cID ='" + getCustomerIDValue() + "'"; datab.insert(updateDriversLicense); } if (NameBox.Text != this.getNameValue() && !main.isEmpty(NameBox.Text)) { string updateName = "UPDATE Customer SET name = '" + NameBox.Text + "' WHERE name = '" + this.getNameValue() + "' AND cID ='" + getCustomerIDValue() + "'"; datab.insert(updateName); } if (PhoneNumberBox.Text != this.getPhoneNumberValue() && !main.isEmpty(PhoneNumberBox.Text)) { string updatePhoneNumber = "UPDATE Customer SET phoneNumber = '" + PhoneNumberBox.Text + "' WHERE phoneNumber = '" + this.getPhoneNumberValue() + "' AND cID ='" + getCustomerIDValue() + "'"; datab.insert(updatePhoneNumber); } if (AddressBox.Text != this.getAddressValue() && !main.isEmpty(AddressBox.Text)) { string updateAddress = "UPDATE Customer SET address1 = '" + AddressBox.Text + "' WHERE address1 = '" + this.getAddressValue() + "' AND cID ='" + getCustomerIDValue() + "'"; datab.insert(updateAddress); } if (CityBox.Text != this.getCityValue() && !main.isEmpty(CityBox.Text)) { string updateCity = "UPDATE Customer SET city = '" + CityBox.Text + "' WHERE city = '" + this.getCityValue() + "' AND cID ='" + getCustomerIDValue() + "'"; datab.insert(updateCity); } if (ProvinceBox.Text != this.getProvinceValue() && !main.isEmpty(ProvinceBox.Text)) { string updateProvince = "UPDATE Customer SET province = '" + ProvinceBox.Text + "' WHERE province = '" + this.getProvinceValue() + "' AND cID ='" + getCustomerIDValue() + "'"; datab.insert(updateProvince); } if (PostalCodeBox.Text != this.getPostalCodeValue() && !main.isEmpty(PostalCodeBox.Text)) { string updatePostalCode = "UPDATE Customer SET postCode = '" + PostalCodeBox.Text + "' WHERE postCode = '" + this.getPostalCodeValue() + "' AND cID ='" + getCustomerIDValue() + "'"; datab.insert(updatePostalCode); } main.CustomersDGV_LoadAll(datab); this.Close(); } catch (Exception e2) { MessageBox.Show(e2.ToString(), "Error"); } }