public SongCollection GetSong(int songID)
        {
            SongCollection song = new SongCollection();

            using (_connection)
            {
                SqlCommand cmd = new SqlCommand("spGetSong", _connection);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@SongID", songID);
                _connection.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                if (reader.Read())
                {
                    song.SongID   = songID;
                    song.Title    = reader.GetString(0);
                    song.ArtistID = reader.GetInt32(1);
                    song.Price    = reader.GetInt32(2);
                }
            }
            return(song);
        }
        public List <SongCollection> GetAllSongs()
        {
            List <SongCollection> allSongs = new List <SongCollection>();

            using (_connection)
            {
                SqlCommand cmd = new SqlCommand("spGetAllSongs", _connection);
                cmd.CommandType = CommandType.StoredProcedure;
                _connection.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    SongCollection song = new SongCollection();
                    song.SongID   = reader.GetInt32(0);
                    song.Title    = reader.GetString(1);
                    song.ArtistID = reader.GetInt32(2);
                    song.Price    = reader.GetInt32(3);
                    allSongs.Add(song);
                }
            }
            return(allSongs);
        }
        public List <SongCollection> SearchByPerformer(int artistID, string zoekterm = "")
        {
            List <SongCollection> songs = new List <SongCollection>();

            using (_connection)
            {
                SqlCommand cmd = new SqlCommand("spSearchByPerformer", _connection);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@ArtistID", artistID);
                cmd.Parameters.AddWithValue("@Zoekterm", zoekterm);
                _connection.Open();
                SqlDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    SongCollection song = new SongCollection();
                    song.SongID   = reader.GetInt32(0);
                    song.Title    = reader.GetString(1);
                    song.ArtistID = reader.GetInt32(2);
                    song.Price    = reader.GetInt32(3);
                    songs.Add(song);
                }
            }
            return(songs);
        }