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