private void nameChangeButton_Click(object sender, EventArgs e)
{
if (CLNTextBox.Text == "")
{
MessageBox.Show("Please Fill in All Information");
}
else
{
SqlConnection con = new SqlConnection("server=localhost;database=CarDealership;Trusted_Connection=Yes;");
con.Open();
string query = "update customer set customerLN = '" + CLNTextBox.Text + "'where customerid = " + customerid;
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter da = new SqlDataAdapter();
da.InsertCommand = new SqlCommand(query, con);
da.InsertCommand.ExecuteNonQuery();
cmd.Dispose();
con.Close();
CLNTextBox.Clear();
MessageBox.Show("Last Name Changed");
}
}
private void signUpButton_Click(object sender, EventArgs e)
{
string fn = CFNTextBox.Text;
string ln = CLNTextBox.Text;
string pn = CPNTextBox.Text;
string email = CUserTextBox.Text;
string pass = CPassTextBox.Text;
if (fn == "" | ln == "" | pn == "" | email == "" | pass == "")
{
MessageBox.Show("Please fill in all information");
}
else
{
addCustomer();
}
CFNTextBox.Clear();
CLNTextBox.Clear();
CPNTextBox.Clear();
CUserTextBox.Clear();
CPassTextBox.Clear();
}
