C# (CSharp) VideoOnRentShop VideoRental Exemples

Exemple #1

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