private void AddCustomer_Click(object sender, EventArgs e) { if (FirstName.Text != "" && LastName.Text != "" && Address.Text != "" && PhoneNumber.Text != "") { int result = rental.addCustomer(FirstName.Text, LastName.Text, Address.Text, PhoneNumber.Text); if (result == 1) { MessageBox.Show("customer added successfully!"); CustomersDataGridView.DataSource = rental.getCustomerData(); cleartextboxes(); } else { MessageBox.Show("Error: cannot add customer"); } } else { string message = "fields are empty"; MessageBox.Show(message); } }
public void testaddCustomer() { VideoRental rentals = new VideoRental(); int expectedflag = 0; rentals.addCustomer("steve", "roger", "brooklyn, NY", "22345542"); int flag = 1; using (SqlCommand cmd = new SqlCommand("select * from customer", rentals.myDBConnection)) { rentals.myDBConnection.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { if (rdr.GetString(1) == "steve") { flag = 0; } } } Assert.AreEqual(expectedflag, flag, "customer steve not added"); }