public PlaylistSongs AddSongToPlaylist(PlaylistSongs playlistSongs)
        {
            if (playlistSongs.songID != 0 & playlistSongs.playlistID != 0)
            {
                SqlCommand cmd = new SqlCommand(@"INSERT INTO[dbo].[Playlist_Songs] (SongID, PlaylistID) values (@SongID, @PlaylistID)", con);
                cmd.Parameters.AddWithValue("@SongID", playlistSongs.songID);
                cmd.Parameters.AddWithValue("@PlaylistID", playlistSongs.playlistID);
                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();

                return(playlistSongs);
            }
            else
            {
                return(playlistSongs);
            }
        }
예제 #2
0
        public IActionResult Add(int selectedPlaylist, int selectedSong)
        {
            PlaylistSongs playlistSongs = new PlaylistSongs();

            try
            {
                playlistSongs.playlistID = selectedPlaylist;
                playlistSongs.songID     = selectedSong;
                playlistContainer.AddSongPlaylist(playlistSongs);
                ViewBag.SuccesOrNot = "Song saved to playlist!";
            }
            catch
            {
                ViewBag.SuccesOrNot = "ERROR! Song did not save to playlist";
            }

            return(Customer());
        }
예제 #3
0
        private async void OpenSongMenu(Song obj)
        {
            var choice = await pageDialogService.DisplayActionSheetAsync("Options", "Close", "", new string[] {
                "Remove from Playlist",
                "Go to Band Page"
            });

            if (choice.Equals("Remove from Playlist"))
            {
                var remove = await pageDialogService.DisplayAlertAsync("", "Do you really want to remove this song from the playlist?", "OK", "CANCEL");

                if (remove)
                {
                    if (await Singleton.Instance.webService.RemoveSongFromPlaylist(playlist.PlId.ToString(), obj.SongId.ToString()))
                    {
                        PlaylistSongs.Remove(obj);
                    }
                }
            }
        }
        public async Task <ActionResult <PlaylistSongs> > PostPlaylistSongs(PlaylistSongs playlistSongs)
        {
            var user = await userManager.FindByNameAsync(User.Identity.Name);

            if (user == null)
            {
                return(Unauthorized(new Response {
                    Status = "Fail", Message = "I don't know how you could possibly get this error message but you managed to do it"
                }));
            }
            var playlist = await _context.Playlist.Where(x => x.Id == playlistSongs.PlaylistId).FirstOrDefaultAsync();

            if (playlist.UserID != user.Id)
            {
                return(Unauthorized(new Response {
                    Status = "Fail", Message = "You do not own this playlist"
                }));
            }
            _context.PlaylistSongs.Add(playlistSongs);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetPlaylistSongs", new { id = playlistSongs.Id }, playlistSongs));
        }
예제 #5
0
        public void SeedSong()
        {
            if (!musicContext.Songs.Any())
            {
                Artist artist = new Artist
                {
                    Name = "Plini",
                };

                Album album1 = new Album
                {
                    Name            = "Other Things",
                    Songs           = new List <Song>(),
                    ArtistId        = 1,
                    DateTimeCreated = DateTime.Parse("2020-9-19-11:35")
                };
                Song song1 = new Song
                {
                    Name            = "Selenium Forest",
                    Length          = 6.05,
                    AlbumId         = 1,
                    DateTimeCreated = DateTime.Parse("2020-9-19-11:35")
                };
                Song song2 = new Song
                {
                    Name            = "Electric Sunrise",
                    Length          = 5.50,
                    AlbumId         = 1,
                    DateTimeCreated = DateTime.Parse("2020-9-19-1:35")
                };
                Playlist playlist1 = new Playlist
                {
                    Name   = "Plini is good",
                    Public = true,
                };
                PlaylistSongs playlistSongs1 = new PlaylistSongs
                {
                    SongId     = 1,
                    PlaylistId = 1,
                };
                PlaylistSongs playlistSongs2 = new PlaylistSongs
                {
                    SongId     = 2,
                    PlaylistId = 1,
                };

                musicContext.Artists.Add(artist);
                musicContext.SaveChanges();
                musicContext.Albums.Add(album1);
                musicContext.SaveChanges();
                musicContext.Songs.Add(song1);
                musicContext.Songs.Add(song2);
                musicContext.SaveChanges();
                musicContext.Playlist.Add(playlist1);
                musicContext.SaveChanges();
                musicContext.PlaylistSongs.Add(playlistSongs1);
                musicContext.SaveChanges();
                musicContext.PlaylistSongs.Add(playlistSongs2);
                musicContext.SaveChanges();
            }
        }