public bool MoverAscensorAbajo(Pisos piso) { PictureBox PisoParada = NivelEdificio(piso); if (AscensorPictureBox.Location.Y >= PisoParada.Location.Y) { ImagenPersona ImagenInterna = Lista.Find(x => x.PisoDireccion == piso) ?? new ImagenPersona(); PointAscensor.Y = PisoParada.Location.Y; AscensorPictureBox.Location = PointAscensor; MoverAscensor = false; if (ImagenInterna.Id > 0) { StateTextBox.AppendText($"Salieron {ListaSalida.Where(x => x.PisoDireccion == piso).ToList().Count() } personas del elevador{Environment.NewLine}"); EliminarControles(ListaSalida.Where(x => x.PisoDireccion == piso).ToList()); } Lista.Remove(Lista.Find(x => x.PisoDireccion == piso)); PisoActual = piso; ListaSalida.RemoveAll(x => x.PisoDireccion == piso); ListaSalida.RemoveAll(x => x.PisoDireccion == Pisos.SinPiso); CambiarLabel("Esperando que seleccione un piso", Color.White, Color.Green); CantidadPersonasLabel.Text = ListaSalida.Count(x => x.Peso > 0).ToString(); PesoElevadorLabel.Text = ListaSalida.Sum(x => x.Peso).ToString(); return(true); } return(false); }
private void addLot() { SqlConnection con = new SqlConnection("server=localhost;database=CarDealership;Trusted_Connection=Yes;"); string streetName = StreetNameTextBox.Text; string streetNum = StreetNumTextBox.Text; string state = StateTextBox.Text; string city = CityTextBox.Text; string zipcode = ZipcodeTextBox.Text; if (streetName == "" || streetNum == "" || state == "" || city == "" || zipcode == "") { MessageBox.Show("Please Fill in All Information"); } else { con.Open(); string query = "INSERT INTO lot values('" + streetNum + "','" + streetName + "','" + state + "','" + city + "','" + zipcode + "')"; SqlCommand cmd = new SqlCommand(query, con); SqlDataAdapter da = new SqlDataAdapter(); da.InsertCommand = new SqlCommand(query, con); da.InsertCommand.ExecuteNonQuery(); MessageBox.Show("Lot Added"); cmd.Dispose(); con.Close(); StreetNameTextBox.Clear(); StreetNumTextBox.Clear(); StateTextBox.Clear(); CityTextBox.Clear(); ZipcodeTextBox.Clear(); } }
public void TextBoxValueChanged(object sender, EventArgs e) { StateTextBox tb = sender as StateTextBox; if (tb != null && tb.oldText != tb.Text) { _repository.SaveDirtyFlag(_view.SelectedContactIndex); } }
private void SubmitButton_Click(object sender, EventArgs e) { try { string gender; if (FemaleradioButton1.Checked) { gender = FemaleradioButton1.Text; } else { gender = MaleradioButton2.Text; } Address addr = new Address(StreetTextBox.Text, CityTextBox.Text, StateTextBox.Text, ZipTextBox.Text); CreditCard cc = new CreditCard(int.Parse(CardNumbertextBox1.Text), int.Parse(PintextBox1.Text), DateTime.Parse(ExpirationDatedateTimePicker1.Text)); Customer cust1 = new Customer(FirstNameTextBox.Text, LastNameTextBox.Text, gender, addr, PhoneNumberTextBox.Text, int.Parse(IDNumberTextBox.Text), cc); foreach (Person p in TravelAgency.people) { if (cust1.isEqual(p)) { throw new DuplicateDataExcception("Sorry! This Customer already exists!"); } } string s = " "; if (FirstNameTextBox.Text == s || LastNameTextBox.Text == s) { throw new InvalidName("Invalid Name"); } if (PhoneNumberTextBox.Text == s) { throw new InvalidPhoneNumber("Invalid PhoneNumber"); } if (StreetTextBox.Text == s || CityTextBox.Text == s || StateTextBox.Text == s || ZipTextBox.Text == s) { throw new InvalidAddress("Invalid Address"); } if (IDNumberTextBox.Text == s) { throw new InvalidDataException("Invalid ID"); } if (CardNumbertextBox1.Text == s || PintextBox1.Text == s) { throw new InvalidDataException("invalid card"); } if (!FemaleradioButton1.Checked && !MaleradioButton2.Checked) { throw new InvalidDataException("Invalid Gender"); } TravelAgency.people.Add(cust1); MessageBox.Show("Customer " + FirstNameTextBox.Text + " " + LastNameTextBox.Text + " was added"); FirstNameTextBox.Clear(); LastNameTextBox.Clear(); PhoneNumberTextBox.Clear(); StreetTextBox.Clear(); CityTextBox.Clear(); StateTextBox.Clear(); ZipTextBox.Clear(); IDNumberTextBox.Clear(); FemaleradioButton1.Checked = false; MaleradioButton2.Checked = false; PintextBox1.Clear(); ExpirationDatedateTimePicker1.ResetText(); CardNumbertextBox1.Clear(); } catch (InvalidName) { MessageBox.Show("Invalid Name"); } catch (InvalidPhoneNumber) { MessageBox.Show("Invalid phone Number"); } catch (DuplicateDataExcception ex) { MessageBox.Show(ex.Message); } catch (OverflowException oe) { MessageBox.Show(oe.Message); } catch (Exception q) { MessageBox.Show(q.Message); } }
private void OnTimer_Tick(object sender, EventArgs e) { if (Lista.Sum(x => x.Peso) <= 0) { OnTimer.Stop(); } if (CapturarGente) { PesoTotalAcumulado = ListaSalida.Sum(x => x.Peso); PersonaGlobal = ObtenerImagenPorPisoControles(PisoActual) ?? new ImagenPersona(); if (PesoTotalAcumulado + PersonaGlobal.Peso >= PesoTotal) { StateTextBox.AppendText($"La persona que intento ingresar tenia {PersonaGlobal.Peso} sobrepasando el limite con {(PesoTotalAcumulado + PersonaGlobal.Peso) - PesoTotal} {Environment.NewLine}"); CambiarLabel("Ascensor Lleno.", Color.White, Color.Red); CapturarGente = false; MoverAscensor = true; ListaBotones.ForEach(x => x.Enabled = true); ObtenerButton(PisoActual).Enabled = false; } else { PersonaGlobal.PisoDireccion = AquePiso; if (PersonaGlobal.Id != 0) { if (!ListaSalida.Exists(x => x.Id == PersonaGlobal.Id)) { ListaSalida.Add(PersonaGlobal); } } else { ListaSalida.Add(new ImagenPersona() { PisoDireccion = AquePiso, Peso = 0 }); } StateTextBox.AppendText($"Peso Agregado {PersonaGlobal.Peso} {Environment.NewLine}"); CantidadPersonasLabel.Text = ListaSalida.Count(x => x.Peso > 0).ToString(); PesoElevadorLabel.Text = ListaSalida.Sum(x => x.Peso).ToString(); CapturarGente = false; MoverPersonas = true; MoverAscensor = false; CambiarLabel("Esperando que seleccione un piso", Color.White, Color.Green); } } if (MoverPersonas) { AnimarImagen(PersonaGlobal.PictureBox); if (MoverPersonaHorizontal(PersonaGlobal.PictureBox, 25)) { AsignarPosicionPersona(PersonaGlobal.PictureBox); if (PesoTotalAcumulado <= PesoTotal) { CapturarGente = false; MoverPersonas = false; if (ListaSalida.Count(x => x.PisoOrigen == PisoActual) == Lista.Count(x => x.PisoOrigen == PisoActual)) { MoverPersonas = false; MoverAscensor = true; } else { ListaBotones.ForEach(x => x.Enabled = true); ObtenerButton(PisoActual).Enabled = false; } CambiarLabel("Esperando que seleccione un piso", Color.White, Color.Green); } else { MoverPersonas = false; MoverAscensor = true; } } else { CambiarLabel("Persona en movimiento", Color.Black, Color.Yellow); } } if (MoverAscensor) { if ((int)PisoActual <= (int)AquePiso) { Pisos ppp; if (ListaSalida.Count == 0) { ppp = AquePiso; } else { ppp = ListaSalida.FirstOrDefault().PisoDireccion; } if (!MoverAscensorArriba(ppp)) { MoverPersonaVertical(ListaSalida, DecrementoEnY); MoverAscensorVertical(DecrementoEnY); CambiarLabel("Ascensor en movimiento, no presione nada", Color.White, Color.Red); } else { ListaBotones.ForEach(x => x.Enabled = true); ObtenerButton(PisoActual).Enabled = false; CambiarLabel("Esperando que seleccione un piso", Color.White, Color.Green); } } else { Pisos ppp; if (ListaSalida.Count == 0) { ppp = AquePiso; } else { ppp = ListaSalida.FirstOrDefault().PisoDireccion; } if (!MoverAscensorAbajo(ppp)) { MoverPersonaVertical(ListaSalida, DecrementoEnY); MoverAscensorVertical(DecrementoEnY); CambiarLabel("Ascensor en movimiento, no presione nada", Color.White, Color.Red); } else { ListaBotones.ForEach(x => x.Enabled = true); ObtenerButton(PisoActual).Enabled = false; CambiarLabel("Esperando que seleccione un piso", Color.White, Color.Green); } } } Invalidate(); }
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); }
public void SubmitButton_Click(object sender, EventArgs e) { try { string gender; if (FemaleradioButton1.Checked) { gender = FemaleradioButton1.Text; } else { gender = MaleradioButton2.Text; } Passport pass = new Passport(FirstNameTextBox.Text, LastNameTextBox.Text, CountryOfBirthTextBox.Text, NationalityTextBoox.Text); Address adr = new Address(StreetTextBox.Text, CityTextBox.Text, StateTextBox.Text, ZipTextBox.Text); Person adam1 = new Passenger(int.Parse(IDNumberTextBox.Text), FirstNameTextBox.Text, LastNameTextBox.Text, gender, PhoneNumberTextBox.Text, adr, pass); foreach (Person p in TravelAgency.people) { if (adam1.isEqual(p)) { throw new DuplicateDataExcception("Sorry! This Passenger already exists"); } } string s = " "; if (FirstNameTextBox.Text == s || LastNameTextBox.Text == s) { throw new InvalidName("Invalid Name"); } if (PhoneNumberTextBox.Text == s) { throw new InvalidPhoneNumber("Invalid PhoneNumber"); } if (StreetTextBox.Text == s || CityTextBox.Text == s || StateTextBox.Text == s || ZipTextBox.Text == s) { throw new InvalidAddress("Invalid Address"); } if (CountryOfBirthTextBox.Text == s) { throw new InvalidDataException("Invalid Country of Birth"); } if (NationalityTextBoox.Text == s) { throw new InvalidDataException("Invalid Nationality"); } if (IDNumberTextBox.Text == s) { throw new InvalidDataException("Invalid ID"); } if (PassportNumberTextBox.Text == s) { throw new InvalidDataException("Invalid Passport Number"); } if (!FemaleradioButton1.Checked && !MaleradioButton2.Checked) { throw new InvalidDataException("Invalid Gender"); } TravelAgency.people.Add(adam1); MessageBox.Show("Passenger " + FirstNameTextBox.Text + " " + LastNameTextBox.Text + " was added"); IDNumberTextBox.Clear(); FirstNameTextBox.Clear(); LastNameTextBox.Clear(); PhoneNumberTextBox.Clear(); StreetTextBox.Clear(); CityTextBox.Clear(); StateTextBox.Clear(); ZipTextBox.Clear(); CountryOfBirthTextBox.Clear(); NationalityTextBoox.Clear(); FemaleradioButton1.Checked = false; MaleradioButton2.Checked = false; PassportTextBox.Clear(); } catch (InvalidName) { MessageBox.Show("Invalid Name"); } catch (InvalidPhoneNumber) { MessageBox.Show("invalid Phone Number"); } catch (DuplicateDataExcception ex) { MessageBox.Show(ex.Message); } catch (OverflowException oe) { MessageBox.Show(oe.Message); } catch (Exception q) { MessageBox.Show(q.Message); } }
private void InitializeDataBindings() { ChkSendHomeAddress.DataBindings.Clear(); HomeAddressStreetTextBox.DataBindings.Clear(); HomeAddressZipCodeTextBox.DataBindings.Clear(); HomeAddressCityTextBox.DataBindings.Clear(); HomeAddressSubCityTextBox.DataBindings.Clear(); ChkSendBoxAddress.DataBindings.Clear(); BoxZipCodeTextBox.DataBindings.Clear(); BoxCityTextBox.DataBindings.Clear(); BoxNumberTextBox.DataBindings.Clear(); CountryTextBox.DataBindings.Clear(); StateTextBox.DataBindings.Clear(); ApplyGcdDataStreetButton.DataBindings.Clear(); ApplyGcdDataZipCodeButton.DataBindings.Clear(); ApplyGcdDataCityButton.DataBindings.Clear(); ApplyGcdDataCountryButton.DataBindings.Clear(); if (_address?.HomeAddress == null) { return; } HomeAddress homeAddress = _address.HomeAddress; PostOfficeBox box = _address.PostOfficeBox; ChkSendHomeAddress.SetCheckedDataBinding(_address, nameof(_address.HasHomeAddress)); SetHasHomeAddressEnabledBinding(HomeAddressStreetTextBox) .SetTextDataBinding(homeAddress, nameof(homeAddress.Street)); SetHasHomeAddressEnabledBinding(HomeAddressZipCodeTextBox) .SetTextDataBinding(homeAddress, nameof(homeAddress.ZipCode)); SetHasHomeAddressEnabledBinding(HomeAddressCityTextBox) .SetTextDataBinding(homeAddress, nameof(homeAddress.City)); SetHasHomeAddressEnabledBinding(HomeAddressSubCityTextBox) .SetTextDataBinding(homeAddress, nameof(homeAddress.SubCity)); ChkSendBoxAddress.SetCheckedDataBinding(_address, nameof(_address.HasPostOfficeBox)); SetHasPostOfficeBoxEnabledBinding(BoxZipCodeTextBox) .SetTextDataBinding(box, nameof(box.ZipCode)); SetHasPostOfficeBoxEnabledBinding(BoxCityTextBox) .SetTextDataBinding(box, nameof(box.City)); SetHasPostOfficeBoxEnabledBinding(BoxNumberTextBox) .SetTextDataBinding(box, nameof(box.Number)); CountryTextBox.SetTextDataBinding(_address, nameof(_address.Country)); StateTextBox.SetTextDataBinding(_address, nameof(_address.State)); SetHasHomeAddressEnabledBinding(ApplyGcdDataStreetButton); SetHasHomeAddressEnabledBinding(ApplyGcdDataZipCodeButton); SetHasHomeAddressEnabledBinding(ApplyGcdDataCityButton); }
/// <summary> /// Enter a value into the 'State' field /// </summary> /// <param name="state">The value to enter</param> public void EnterState(string state) { StateTextBox.Clear(); StateTextBox.SendKeys(state); }
private void SubmitButton_Click(object sender, EventArgs e) { try //throw this exception if this passenger already exists { string gender; if (FemaleradioButton1.Checked) { gender = FemaleradioButton1.Text; } else { gender = MaleradioButton2.Text; } Address addr = new Address(StreetTextBox.Text, CityTextBox.Text, StateTextBox.Text, ZipTextBox.Text); TravelAgent trav1 = new TravelAgent(FirstNameTextBox.Text, LastNameTextBox.Text, gender, addr, PhoneNumberTextBox.Text, int.Parse(IDNumberTextBox.Text), double.Parse(EarningstextBox1.Text), SsnTextBox.Text); trav1.countofEmployees++; foreach (Person p in TravelAgency.people) { if (trav1.isEqual(p)) { throw new DuplicateDataExcception("Sorry! This Passenger already exists!"); } } string s = " "; if (FirstNameTextBox.Text == s || LastNameTextBox.Text == s) { throw new InvalidName("Invalid Name"); } if (PhoneNumberTextBox.Text == s) { throw new InvalidPhoneNumber("Invalid PhoneNumber"); } if (StreetTextBox.Text == s || CityTextBox.Text == s || StateTextBox.Text == s || ZipTextBox.Text == s) { throw new InvalidAddress("Invalid Address"); } if (IDNumberTextBox.Text == s) { throw new InvalidDataException("Invalid ID"); } if (SsnTextBox.Text == s) { throw new InvalidDataException("Invalid Passport Number"); } if (!FemaleradioButton1.Checked && !MaleradioButton2.Checked) { throw new InvalidDataException("Invalid Gender"); } TravelAgency.people.Add(trav1); MessageBox.Show("Travel Agent " + FirstNameTextBox.Text + " " + LastNameTextBox.Text + " was added"); FirstNameTextBox.Clear(); LastNameTextBox.Clear(); PhoneNumberTextBox.Clear(); StreetTextBox.Clear(); SsnTextBox.Clear(); CityTextBox.Clear(); StateTextBox.Clear(); ZipTextBox.Clear(); FemaleradioButton1.Checked = false; MaleradioButton2.Checked = false; IDNumberTextBox.Clear(); EarningstextBox1.Clear(); } catch (InvalidName) { MessageBox.Show("Invalid Name"); } catch (InvalidPhoneNumber) { MessageBox.Show("Invalid phone Number"); } catch (DuplicateDataExcception ex) { MessageBox.Show(ex.Message); } catch (OverflowException oe) { MessageBox.Show(oe.Message); } catch (FormatException f) { MessageBox.Show(f.Message); } catch (Exception q) { MessageBox.Show(q.Message); } }
// 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(); } } } } }