/// <summary> /// Add playlist to List_Of_Playlists in database /// </summary> public void AddPlaylistToDataBase() { if (PlaylistButtonActive) { PlaylistButtonActive = false; MovieDatabaseEntities db = new MovieDatabaseEntities(); var UserID = getCurrentUserID(); var usr = db.Users.SingleOrDefault(o => o.UserID == UserID); var i = usr.Number_Of_Playlists; usr.Number_Of_Playlists++; // Increase Number_Of_Playlists for the Current user List_Of_Playlists playlist = new List_Of_Playlists(); while (true) { var pl = db.List_Of_Playlists.SingleOrDefault(o => o.ID == i + 1 && o.UserID == usr.UserID); if (pl != null) { i++; } else { break; } } playlist.ID = i + 1; playlist.UserID = UserID; playlist.Playlist_Name = "Playlist" + playlist.ID; db.List_Of_Playlists.Add(playlist); db.SaveChanges(); createPlaylistButton(i); PlaylistButtonActive = true; } }
/// <summary> /// Add playlist to List_Of_Playlists in database /// </summary> public void AddPlaylistToDataBase() { if (PlaylistButtonActive) { PlaylistButtonActive = false; MovieDatabaseEntities db = new MovieDatabaseEntities(); var UserID = getCurrentUserID(); var usr = db.Users.SingleOrDefault(o => o.UserID == UserID); var i = usr.Number_Of_Playlists; usr.Number_Of_Playlists++; // Increase Number_Of_Playlists for the Current user List_Of_Playlists playlist = new List_Of_Playlists(); while(true) { var pl = db.List_Of_Playlists.SingleOrDefault(o => o.ID == i + 1 && o.UserID == usr.UserID); if(pl != null) { i++; } else { break; } } playlist.ID = i + 1; playlist.UserID = UserID; playlist.Playlist_Name = "Playlist" + playlist.ID; db.List_Of_Playlists.Add(playlist); db.SaveChanges(); createPlaylistButton(i); PlaylistButtonActive = true; } }