Exemple #1
0
        /// <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;
            }
        }