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); } }