private void AddCustomer_Click(object sender, EventArgs e) { if (FirstName.Text != "" && LastName.Text != "" && Address.Text != "" && PhoneNumber.Text != "") { int result = rental.addNewCustomer(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); } }
// test function of add customer button and add new customer button. // add address from customer option. public void testaddCustomer() { VideoRental rent = new VideoRental(); int expectedflag = 0; rent.addNewCustomer("Roger", "Federer", "1455 bleecher street, NY", "344564"); int flag = 1; using (MySqlCommand cmd = new MySqlCommand("select * from customer", rent.conn)) { rent.conn.Open(); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { if (rdr.GetString("FirstName") == "Roger") { flag = 0; } } } Assert.AreEqual(expectedflag, flag, "customer roger not addded"); }