SHOW:
|
|
- or go back to the newest paste.
| 1 | - | public void updateAlbum(int albumID, int artistID, string title, string genre, int year, ref System.Web.UI.WebControls.FileUpload fu) |
| 1 | + | public void changeSongAlbum(int songID, int oldAlbumID, int newAlbumID) |
| 2 | {
| |
| 3 | using (var context = new ExamEntities()) | |
| 4 | {
| |
| 5 | - | Album update = context.Albums.FirstOrDefault(i => i.AlbumID == albumID); |
| 5 | + | var query = context.Songs.Where(o => o.SongID == songID); |
| 6 | - | if (title != "") |
| 6 | + | var newAlbum = context.Albums.FirstOrDefault(o => o.AlbumID == newAlbumID); |
| 7 | - | update.AlbumTitle = title; |
| 7 | + | var oldAlbum = context.Albums.FirstOrDefault(o => o.AlbumID == oldAlbumID); |
| 8 | - | if (artistID != 0) |
| 8 | + | foreach (var s in query) |
| 9 | - | update.Artist_ArtistID = artistID; |
| 9 | + | {
|
| 10 | - | if (genre != "") |
| 10 | + | s.Album.Remove(oldAlbum); |
| 11 | - | update.Genre = genre; |
| 11 | + | s.Album.Add(newAlbum); |
| 12 | - | if (year != 0) |
| 12 | + | } |
| 13 | - | update.Year = year; |
| 13 | + | |
| 14 | - | if (fu.FileBytes != null) |
| 14 | + | |
| 15 | - | update.CoverArt = fu.FileBytes; |
| 15 | + |
