public void Get_All_Spaces_Test()
        {
            SpaceSqlDAL getAllSpaces = new SpaceSqlDAL(ConnectionString);

            List <Space> spaceList = (List <Space>)getAllSpaces.GetSpaceDetails(id);

            Assert.IsNotNull(spaceList);
        }
        private void GetSpaces()
        {
            selection = Convert.ToInt32(UserInterfaceHelper.GetInteger("Enter the ID of the venue to view spaces available: "));
            Console.WriteLine();
            ListVenueSpacesHeader();
            List <Space> spaces = spaceDAL.GetSpaceDetails(selection);

            if (selection > 0 && selection <= 15)
            {
                foreach (Space item in spaces)
                {
                    string date1 = UserInterfaceHelper.ConvertIntToMonth(item.openFrom);
                    string date2 = UserInterfaceHelper.ConvertIntToMonth(item.openTo);

                    Console.WriteLine(String.Format("{0, -10} {1, -25} {2, -15} {3, -15} {4, -15} {5, -15}", item.id, item.name, date1, date2, item.dailyRate, item.maxOccupancy));
                }
            }
            else
            {
                Console.WriteLine();
                Console.WriteLine("No result, please try again!");
            }
        }