Exemplo n.º 1
0
 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);
     }
 }
Exemplo n.º 2
0
        // 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");
        }