public async Task SetTextAsync(object obj)
{
//SqliteDatabase db = (SqliteDatabase) DatabaseService.Instance().DB;
//db.Song.Insert(new SongEntity { Name = "A", Path = "B" });
//var result = db.Song.Where(p => p.Name == "A");
//foreach (var song in result)
//{
// var dialog = new MessageDialog($"Name={song.Name}, Path={song.Path}");
// await dialog.ShowAsync();
// Console.WriteLine($"Name={song.Name}, Price={song.Path}");
//}
ISongDao songDao = DatabaseService.Instance().DB.SongDao;
songDao.Insert(new DB.model.Song {
Name = "A", Path = "XXX"
});
songDao.Insert(new DB.model.Song {
Name = "B", Path = "XXX"
});
songDao.Insert(new DB.model.Song {
Name = "C", Path = "XXX"
});
Debug.WriteLine(songDao.getAll());
Debug.WriteLine(songDao.getAll());
}
private void SaveSong(Song song, Guid parentId)
{
if (song.IsDestroyed)
{
foreach (var creator in song.Creators)
{
_creatorDao.Delete(creator.Id);
}
_songDao.Delete(song.Id);
}
if (song.IsNew)
{
song.Id = Guid.NewGuid();
song.SongbookId = parentId;
_songDao.Insert(song.ToDto());
}
else
{
_songDao.Update(song.ToDto());
}
foreach (var creator in song.Creators)
{
SaveCreator(creator, song.Id);
}
}
