public void GetVenueList_Returns_List()
        {
            bool      result = false;
            IVenueDAO test   = new VenueSqlDao(Conn);
            int       testID = GenerateTestVenue(Conn);

            List <Venue> testList = new List <Venue>(test.GetVenueList());

            foreach (Venue venue in testList)
            {
                if (venue.VenueId == testID)
                {
                    result = true;
                }
            }

            Assert.AreEqual(true, result);
        }
        public void GetVenueDetails_Returns_Data()
        {
            //Returns a list of the venue's details
            //[0] = the venue name
            //[1] = the city name
            //[2] = the state abbrevtiation
            //[3] = category
            //[4] = the description

            IVenueDAO test = new VenueSqlDao(Conn);

            int testID = JoinTestCategoryVenue(Conn);

            //List<string> testList = new List<string>();
            //test.GetVenueDetails(testID);

            Assert.AreEqual("Test Venue", test.GetVenueDetails(testID).VenueName);
            Assert.AreEqual("Test City", test.GetVenueDetails(testID).VenueCityName);
            Assert.AreEqual("XX", test.GetVenueDetails(testID).VenueStateAbbreviation);
            //Assert.AreEqual("Test Category", test.GetVenueDetails(testID).Categories);
            Assert.AreEqual("Programmers have too much fun writing things like this.", test.GetVenueDetails(testID).VenueDescription);
        }