public void RemovePlaylist(Playlist ipl)
{
using (var db = new SQLiteConnection(Tables.DBPath))
{
if (ipl != null)
{
var p = new Library.TableModels.Playlist();
p.ID = ipl.ID;
p.Path = ipl.Path;
db.Delete(p);
}
}
}
public void Save(Bridge.Playlist playlist, List <TrackViewModel> lst)
{
using (var db = new SQLiteConnection(Tables.DBPath))
{
try
{
if (!string.IsNullOrEmpty(playlist.ID)) //already a member in DB
{
playlist.Write(TranslateList(lst)); //save to given path
//Now check if the given path was the original path or
//a different one
//if (db.Table<Library.TableModels.Playlist>().Where(c => c.ID == playlist.ID).First().Path != playlist.Path)
//{
//delete old playlist, since new one is already saved
string f = db.Table <Library.TableModels.Playlist>().Where(c => c.ID == playlist.ID).First().Path;
//if (File.Exists(f)) File.Delete(f);
var p = new Library.TableModels.Playlist();
p.ID = playlist.ID;
p.Path = playlist.Path;
p.Name = playlist.Name;
db.Update(p);
//}
}
else //not a member in DB means its a new playlist
{
playlist.ID = Guid.NewGuid().ToString();
playlist.Write(TranslateList(lst));
var p = new Library.TableModels.Playlist();
p.ID = playlist.ID;
p.Path = playlist.Path;
p.Name = playlist.Name;
db.Insert(p);
}
}
catch (Exception e)
{
}
}
}