public static int deleteSongEntry(MyPianoSong pianoSong)
{
if (pianoSong.songID <= 0)
{
throw new Exception("Unable to delete song, no song ID provided");
}
try
{
var newQuery = (from p in context.PianoSongs
where p.PianoSongID == pianoSong.songID
select p);
PianoSong ps = newQuery.FirstOrDefault();
Song s = ps.Song;
Artist a = ps.Artist;
Book b = ps.Book;
context.PianoSongs.Remove(ps);
context.SaveChanges();
return(ps.PianoSongID);
}
catch (Exception ex)
{
#if (DEBUG)
Logger.LogError(ex, showDialog: true);
#else
Logger.LogError(ex);
#endif
return(-1);
}
}
public static int addSongEntry(MyPianoSong pianoSong)
{
try
{
Song s = new Song();
Artist a = new Artist();
Book b = new Book();
PianoSong pSong = new PianoSong();
s.SongName = pianoSong.SongTitle;
a.ArtistName = pianoSong.SongArtist;
b.BookName = pianoSong.SongBook;
pSong.Song = s;
pSong.Artist = a;
pSong.Book = b;
pSong.PageNumber = pianoSong.PageNum;
context.PianoSongs.Add(pSong);
context.SaveChanges();
return(pSong.PianoSongID);
}
catch (Exception ex)
{
#if (DEBUG)
Logger.LogError(ex, showDialog: true);
#else
Logger.LogError(ex);
#endif
return(-1);
}
}
