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(); } }
private void SaveButton_Click(object sender, EventArgs e) { if (FirstNameTextBox.Text == "" || LastNameTextBox.Text == "" || EmailTextBox.Text == "" || CityTextBox.Text == "" || StreetNameTextBox.Text == "" || ZipCodeTextBox.Text == "") { WarningLabel.DissapearAfterSeconds(2); FirstNameTextBox.FlickerIfEmpty(); LastNameTextBox.FlickerIfEmpty(); EmailTextBox.FlickerIfEmpty(); CityTextBox.FlickerIfEmpty(); StreetNameTextBox.FlickerIfEmpty(); ZipCodeTextBox.FlickerIfEmpty(); } else { //DAL.Instance.CreatePlace(NameTextBox.Text, LuxeCheckBox.Checked, DescriptionTextBox.Text, image); //Place place = (Place)PlacesComboBox.SelectedItem; if (FirstNameTextBox.Text != customer.FirstName) { customer.FirstName = FirstNameTextBox.Text; } if (LastNameTextBox.Text != customer.LastName) { customer.LastName = LastNameTextBox.Text; } if (EmailTextBox.Text != customer.Email) { customer.Email = EmailTextBox.Text; } if (CityTextBox.Text != customer.City) { customer.City = CityTextBox.Text; } if (StreetNameTextBox.Text != customer.Street) { customer.Street = StreetNameTextBox.Text; } if (ZipCodeTextBox.Text != customer.ZipCode) { customer.ZipCode = ZipCodeTextBox.Text; } if (DateOfBirthPicker.Value != customer.DateOfBirth) { customer.DateOfBirth = DateOfBirthPicker.Value; } this.Close(); } }