public static Playlist Sons_from_base(int id)
{
Object temp;
Playlist pl = new Playlist();
try
{
MySqlCommand commandlogin = new MySqlCommand("SELECT * FROM `playlist` WHERE `user_id` LIKE (@id)", cn);
commandlogin.Parameters.Add("@id", id);
commandlogin.ExecuteNonQuery();
using (var reader = commandlogin.ExecuteReader())
{
while (reader.Read())
{
pl.Add(reader[2].ToString(), reader[3].ToString());
}
}
return pl;
}
catch (MySqlException)
{
return null;
}
finally
{
cn.Close();
}
}
public User(Library userLibrary, string userName, Playlist userPlaylist)
{
this.userName = userName;
library = userLibrary;
playlist = userPlaylist;
}
public User(string userName)
{
this.userName = userName;
library = new Library();
playlist = new Playlist();
}
