/// <summary> /// Method for deleting song from database /// </summary> /// <param name="song"></param> /// <returns>true if deleted, false if not</returns> public bool DeleteSong(vwSong song) { try { using (AudioPlayerEntities context = new AudioPlayerEntities()) { var songToDelete = context.tblSongs.Where(x => x.SongId == song.SongId).FirstOrDefault(); context.tblSongs.Remove(songToDelete); context.SaveChanges(); return(true); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }
/// <summary> /// Method for adding song by user /// </summary> /// <param name="user">user which is adding song</param> /// <param name="song">song for adding</param> /// <returns></returns> public bool AddSong(vwUser user, vwSong song) { try { using (AudioPlayerEntities context = new AudioPlayerEntities()) { tblSong newSong = new tblSong(); newSong.SongName = song.SongName; newSong.SongAuthor = song.SongAuthor; newSong.SongDuration = song.SongDuration; newSong.UserId = user.UserId; context.tblSongs.Add(newSong); context.SaveChanges(); song.SongId = newSong.SongId; return(true); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }
public bool AddSong(tblUser user, vwSong song) { try { using (DAN_LEntities context = new DAN_LEntities()) { tblSong newSong = new tblSong(); newSong.SongName = song.SongName; newSong.Author = song.Author; newSong.Duration = song.Duration; newSong.UserID = user.UserID; context.tblSongs.Add(newSong); context.SaveChanges(); song.SongID = newSong.SongID; return(true); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(false); } }
public AddViewModel(AddView songView, vwUser user) { this.songView = songView; User = user; Song = new vwSong(); }