public PlaylistSongTable() : base("PlaylistSong")
{
PlaylistTable playlistTable = new PlaylistTable();
SongTable songTable = new SongTable();
PlaylistId = new SqlColumn("PlaylistId", EType.Int, playlistTable.TableName, playlistTable.Id.Name, true);
SongId = new SqlColumn("SongId", EType.Int, songTable.TableName, songTable.Id.Name, true);
PosInPlaylist = new SqlColumn("PosInPlaylist", EType.Int);
}
public static void DeletePlaylist(PlaylistItem playlist)
{
PlaylistTable table = new PlaylistTable();
using (SqliteConnection con = CreateConnection())
{
con.Open();
DeleteRow(con, table, table.Id, playlist.Id);
}
}
private static void CreatePlaylistTable(SqliteConnection con, bool force = false)
{
PlaylistTable playlistTable = new PlaylistTable();
CreateTable(con, playlistTable, force);
if (IsEmpty(con, playlistTable))
{
InsertRow(con, playlistTable, new PlaylistItem("All Music", true));
}
}
public void AddPlaylist(string name)
{
PlaylistTable table = new PlaylistTable(name);
DatabaseManager.Current.AddPlaylist(table);
PlaylistModel playlistModel = new PlaylistModel(table);
Playlists.Add(playlistModel);
playlistLookupDictionary.Add(playlistModel.PlaylistId, playlistModel);
}
