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