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();
}
}
}
}
}
