public static PlaylistMusique Create(PlaylistMusique playlistMusique)
{
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = new SqlCommand(CREATE, connection);
command.Parameters.AddWithValue("@id_musique", playlistMusique.Id_musique);
command.Parameters.AddWithValue("@id_playlist", playlistMusique.Id_Playlist);
command.ExecuteScalar();
}
return(playlistMusique);
}
public static PlaylistMusique Get(int id_musique, int id_playlist)
{
PlaylistMusique playlistMusique = null;
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = new SqlCommand(GET, connection);
command.Parameters.AddWithValue("@id_musique", id_musique);
command.Parameters.AddWithValue("@id_playlist", id_playlist);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
playlistMusique = new PlaylistMusique(reader.GetInt32(0), reader.GetInt32(1));
}
}
return(playlistMusique);
}