public void Search_Category_By_ID_Test()
        {
            CategorySqlDAL  getCategoryName = new CategorySqlDAL(ConnectionString);
            List <Category> searchTest      = getCategoryName.GetCategories(id);

            CollectionAssert.AllItemsAreNotNull(searchTest);
            Assert.AreEqual(1, searchTest.Count);
            Equals("Tragedy Is Assured", searchTest[0].category_name);
        }
        public UserInterface(string connectionString)
        {
            this.spaceDAL       = new SpaceSqlDAL(connectionString);
            this.venueDAL       = new VenueSqlDAL(connectionString);
            this.categoryDAL    = new CategorySqlDAL(connectionString);
            this.reservationDAL = new ReservationSqlDAL(connectionString);

            this.cityDAL = new CitySqlDAL(connectionString);
        }
        public void GetCategoryInfo()
        {
            //arrange
            CategorySqlDAL  categorySql  = new CategorySqlDAL(ConnectionString);
            List <Category> categoryList = categorySql.GetCategories(id);

            //assert
            Assert.IsNotNull(categoryList);
            Assert.AreEqual(categoryId, categoryList.Count);
        }