public void CreateSong(SongDTO songDTO) { if (songDTO == null) { throw new ArgumentNullException("Song service - CreateSong(...) songDTO cannot be null"); } SongReview review; var song = Mapper.Map <Song>(songDTO); using (var uow = UnitOfWorkProvider.Create()) { song.Album = GetSongAlbum(songDTO.AlbumID); song.Creator = clientRepository.GetByID(songDTO.CreatorID); if (songDTO.ReviewIDs != null) { foreach (int ID in songDTO.ReviewIDs) { review = GetSongReview(ID); song.Reviews.Add(review); } } songRepository.Insert(song); uow.Commit(); } }
public void create() { SongDTO sDTO = new SongDTO(name, trackNo, duration, songtext, album); SongDAO sDAO = new SongDAO(); sDAO.insertSong(sDTO); }
public IActionResult Delete(int id) { try { var songToDelete = _context.Songs.Where(s => s.Id == id).FirstOrDefault(); if (songToDelete != null) { SongDTO copyOfSong = new SongDTO { Id = songToDelete.Id, Album = songToDelete.Album, Artist = songToDelete.Artist, Title = songToDelete.Title, ReleaseDate = songToDelete.ReleaseDate, Likes = songToDelete.Likes }; _context.Remove(songToDelete); _context.SaveChanges(); return(StatusCode(200, copyOfSong)); } else { return(StatusCode(400)); } } catch { return(StatusCode(500)); } }
public void GetAllSongs() { using (var context = new MusicAppDb()) { context.Songs.ToList().Select(x => SongDTO.FromEntity(x)).ToList().ForEach(x => Console.WriteLine(x.NameAndDuration)); } }
public async Task <IActionResult> PutSong(int id, SongDTO song) { if (ModelState.IsValid) { if (id != song.Id) { return(BadRequest()); } try { await this._songService.UpdateAsync(id, song); } catch (DbUpdateConcurrencyException) { if (!await SongExistsAsync(id)) { return(NotFound()); } else { return(BadRequest()); } } return(NoContent()); } else { return(BadRequest()); } }
public ArtistController() { services = new GoogleDriveServices(HttpContext.Current.Server.MapPath("~/")); dto = new ArtistDTO(HttpContext.Current.Request.Url); albumDto = new AlbumDTO(HttpContext.Current.Request.Url); songDto = new SongDTO(HttpContext.Current.Request.Url); }
public IActionResult Get(int id) { //Song ThatOneSong = _context.Songs.Where(song => song.Id == id).FirstOrDefault(); SongDTO ThatOneSong = songDTOs.Where(song => song.Id == id).FirstOrDefault(); return(Ok(ThatOneSong)); }
public MusicGameController() { Uri uri = HttpContext.Current.Request.Url; dto = new ScoreDTO(uri); songDto = new SongDTO(uri); }
public IActionResult AddLike(int id) { try { Song song = _context.Songs.Where(s => s.Id == id).FirstOrDefault(); if (song == null) { return(BadRequest()); } else { song.Likes += 1; _context.Update(song); _context.SaveChanges(); SongDTO returnVal = new SongDTO() { Id = song.Id, Title = song.Title, Album = song.Album, Artist = song.Artist, ReleaseDate = song.ReleaseDate, Likes = song.Likes }; return(StatusCode(200, returnVal)); } } catch { return(StatusCode(500)); } }
public void AddSong(SongDTO song) { using (SqlConnection connection = new SqlConnection("Data Source=(LocalDB)\\v11.0;AttachDbFilename=D:\\Git\\Gramophone.Web\\App_Data\\GramophoneDB.mdf;Integrated Security=True")) { connection.Open(); using (SqlCommand cmd = connection.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_AddNewSong"; cmd.Connection = connection; cmd.Parameters.AddWithValue("@SongTitle", song.SongTitle); cmd.Parameters.AddWithValue("@Singer1ID", song.Singer1); cmd.Parameters.AddWithValue("@Singer2ID", song.Singer2); cmd.Parameters.AddWithValue("@Singer3ID", song.Singer3); cmd.Parameters.AddWithValue("@ComposerID", song.Composer); cmd.Parameters.AddWithValue("@DirectorID", song.Director); cmd.Parameters.AddWithValue("@MusicianID", song.Musician); cmd.Parameters.AddWithValue("@AlbumID", song.Album); cmd.Parameters.AddWithValue("@Year", song.Year); cmd.Parameters.AddWithValue("@Lyrics", DBNull.Value); cmd.Parameters.AddWithValue("@Image", DBNull.Value); cmd.Parameters.AddWithValue("@YouTubeURL", song.YouTubeURL); cmd.ExecuteNonQuery(); } connection.Close(); } }
public Boolean updateSongAlbumArtist(SongDTO dto) { Boolean check = false; using (sqlConnection = new SqlConnection(connectionString)) { try { sqlConnection.Open(); command = new SqlCommand("UPDATE Song_Album_Artist SET albumID = @albumID, artistID = @artistID " + "WHERE songID= @id", sqlConnection); command.Parameters.AddWithValue("@id", dto.ID); command.Parameters.AddWithValue("@albumID", dto.Album.Id); command.Parameters.AddWithValue("@artistID", dto.Artis.Id); check = command.ExecuteNonQuery() > 0; } catch (Exception e) { Console.WriteLine(e.StackTrace); } finally { closeConnect(); } } return(check); }
public IActionResult Put(int id, [FromBody] SongDTO UpdatedSongDTO) { SongDTO songDTOToUpdate = songDTOs.Where(song => song.Id == id).FirstOrDefault(); try { songDTOToUpdate.Album = UpdatedSongDTO.Album; songDTOToUpdate.Artist = UpdatedSongDTO.Artist; songDTOToUpdate.Title = UpdatedSongDTO.Title; songDTOToUpdate.ReleaseDate = UpdatedSongDTO.ReleaseDate; Song songToUpdate = DTOToSong(songDTOToUpdate); if (UpdatedSongDTO.LikesSong) { songDTOToUpdate.LikesSong = false; songToUpdate.Likes++; } songDTOToUpdate.DisplayLikes = songToUpdate.Likes; _context.Update(songToUpdate); _context.SaveChanges(); songDTOs = SongsConverter(_context.Songs.ToList()); return(Ok(songDTOToUpdate)); } catch (Exception ex) { Console.WriteLine($"Something went wrong: {ex}"); return(StatusCode(400, "Bad Request, Object Not found")); } }
public Boolean updateSongs(SongDTO dto) { Boolean check = false; using (sqlConnection = new SqlConnection(connectionString)) { try { sqlConnection.Open(); command = new SqlCommand("UPDATE Songs SET title = @title, lyrics = @lyrics, dateRelease = @dateRelease, " + "linkDownLoad = @linkDownLoad " + "WHERE ID = @id", sqlConnection); command.Parameters.AddWithValue("@id", dto.ID); command.Parameters.AddWithValue("@title", dto.Title); command.Parameters.AddWithValue("@lyrics", dto.Lyrics); command.Parameters.AddWithValue("@dateRelease", dto.DateRelease); command.Parameters.AddWithValue("@linkDownLoad", dto.LinkDownLoad); check = command.ExecuteNonQuery() > 0; } catch (Exception e) { Console.WriteLine(e.StackTrace); } finally { closeConnect(); } } return(check); }
public List <SongDTO> loadAllSongs() { int songID; string title, lyrics, dateRelease, linkOpen, linkDownLoad, image; ArtistDTO artis; int artisID; string artisName; AlbumDTO album; int albumID; string albumName; SongDTO song = null; List <SongDTO> result = new List <SongDTO>(); using (sqlConnection = new SqlConnection(connectionString)) { try { sqlConnection.Open(); using (command = new SqlCommand("" + "Select Songs.ID, Songs.title,Songs.lyrics,Songs.dateRelease,Songs.linkOpen,Songs.linkDownLoad,Songs.image,Artists.ID,Artists.name,Albums.ID,Albums.name " + "From Songs, Artists, Albums, Song_Album_Artist " + "Where Song_Album_Artist.albumID = Albums.ID AND Song_Album_Artist.songID = Songs.ID AND Song_Album_Artist.artistID = Artists.ID", sqlConnection)) using (reader = command.ExecuteReader()) { while (reader.Read()) { //songs songID = reader.GetInt32(0); title = reader.GetString(1); lyrics = reader.GetString(2); dateRelease = reader.GetDateTime(3).ToString("yyyy-MM-dd"); linkOpen = reader.GetString(4); linkDownLoad = reader.GetString(5); image = reader.GetString(6); //artis artisID = reader.GetInt32(7); artisName = reader.GetString(8); artis = new ArtistDTO(artisID, artisName); //album albumID = reader.GetInt32(9); albumName = reader.GetString(10); album = new AlbumDTO(albumID, albumName); song = new SongDTO(songID, title, lyrics, dateRelease, linkOpen, linkDownLoad, image, artis, album); result.Add(song); } } } catch (Exception e) { Console.WriteLine(e.StackTrace); } finally { closeConnect(); } } return(result); }
public Boolean addSongArtistAndAlbum(SongDTO dto) { Boolean check = false; using (sqlConnection = new SqlConnection(connectionString)) { try { sqlConnection.Open(); using (command = new SqlCommand("Insert into " + "Song_Album_Artist(songID,albumID,artistID) " + "Values (@songID, @albumID, @artistID)", sqlConnection)) { command.Parameters.AddWithValue("@songID", dto.ID); command.Parameters.AddWithValue("@albumID", dto.Album.Id); command.Parameters.AddWithValue("@artistID", dto.Artis.Id); check = command.ExecuteNonQuery() > 0; } } catch (Exception e) { Console.WriteLine(e.StackTrace); } finally { closeConnect(); } } return(check); }
public Boolean addSong(SongDTO dto, int time) { Boolean check = false; using (sqlConnection = new SqlConnection(connectionString)) { try { sqlConnection.Open(); using (command = new SqlCommand("Insert into " + " Songs(ID,title,lyrics,dateRelease,linkOpen,linkDownLoad,image,time) " + " Values (@ID, @title, @lyrics, @dateRelease, @linkOpen, @linkDownLoad,@image,@time)", sqlConnection)) { command.Parameters.AddWithValue("@ID", dto.ID); command.Parameters.AddWithValue("@title", dto.Title); command.Parameters.AddWithValue("@lyrics", dto.Lyrics); command.Parameters.AddWithValue("@dateRelease", dto.DateRelease); command.Parameters.AddWithValue("@linkOpen", dto.LinkOpen); command.Parameters.AddWithValue("@linkDownLoad", dto.LinkDownLoad); command.Parameters.AddWithValue("@image", dto.Image); command.Parameters.AddWithValue("@time", time); check = command.ExecuteNonQuery() > 0; } } catch (Exception e) { Console.WriteLine(e.StackTrace); } finally { closeConnect(); } } return(check); }
public ActionResult InfoSong(int idPerformer, int?idSong, string sort = "ascName") { SongDTO songDto = SongServices.GetById(idSong); var song = _mapper.Map <SongDTO, SongViewModel>(songDto); ViewBag.Sort = sort; return(View(song)); }
public async Task <OperationResult <SongDTO> > Save(SongDTO songDTO) { var song = mapper.Map <Song>(songDTO); // Validation for songs could be added here, return a non-success if something was wrong await songRepository.Save(song); return(OperationResult <SongDTO> .CreateSuccessResult(mapper.Map <SongDTO>(song))); }
public ActionResult SaveAccords(int idSong, string strAccords) { string[] arrAccords = strAccords.Split(','); SongDTO updateSong = Services.SaveAccords(arrAccords, idSong); var song = _mapper.Map <SongDTO, SongViewModel>(updateSong); return(View("InfoSong", song)); }
public void updateMetaDataLabels(SongDTO song) { Album.Content = song.songTag.getAlbum(); Artist.Content = song.songTag.getArtist(); this.durationLabel.Content = song.songTag.getDuration().ToString(@"mm\:ss"); //metadataLabels.Thumbnail.Image = songDTO.songTag.getThumbnail(); this.titleLabel.Content = song.songTag.getTitle(); setTimeLabel(new TimeSpan(0)); }
public UsersController() { services = new GoogleDriveServices(HttpContext.Current.Server.MapPath("~/")); Uri uri = HttpContext.Current.Request.Url; dto = new UserInfoDTO(uri); playlistDto = new PlaylistDTO(uri); songDto = new SongDTO(uri); }
public SongController() { services = new GoogleDriveServices(HttpContext.Current.Server.MapPath("~/")); Uri uri = HttpContext.Current.Request.Url; dto = new SongDTO(uri); commentDto = new CommentDTO(uri); rankingSongDto = new RankingSongDTO(uri); }
public void updateSongMetadataInformation(SongDTO song) { this.albumLabel.Content = song.songTag.Album; this.artistLabel.Content = song.songTag.Artist; this.durationLabel.Content = song.songTag.Duration.ToString(@"mm\:ss"); this.thumbnailImage.Source = song.songTag.ThumbnailSource; this.titleLabel.Content = song.songTag.Title; setTimeLabel(new TimeSpan(0)); }
public List <SongDTO> getSongsOfPlayList(int playListID) { int songID, time; string title, lyrics, dateRelease, linkOpen, linkDownLoad, image; ArtistDTO artis; int artisID; string artisName; SongDTO song = null; List <SongDTO> result = new List <SongDTO>(); using (sqlConnection = new SqlConnection(connectionString)) { try { sqlConnection.Open(); using (command = new SqlCommand("" + "Select distinct Songs.ID, Songs.title,Songs.lyrics,Songs.dateRelease,Songs.linkOpen,Songs.linkDownLoad,Songs.image,Songs.time,Artists.ID,Artists.name " + "From Songs, Playlist_Songs, Playlists, Artists, Song_Album_Artist " + "Where Songs.ID = Playlist_Songs.songID AND Playlist_Songs.PlaylistID = Playlists.ID " + "AND Songs.ID = Song_Album_Artist.songID AND Song_Album_Artist.artistID = Artists.ID " + "AND Playlists.ID = @playListID", sqlConnection)) command.Parameters.AddWithValue("@playListID", playListID); using (reader = command.ExecuteReader()) { while (reader.Read()) { //songs songID = reader.GetInt32(0); title = reader.GetString(1); lyrics = reader.GetString(2); dateRelease = reader.GetDateTime(3).ToString("yyyy-MM-dd"); linkOpen = reader.GetString(4); linkDownLoad = reader.GetString(5); image = reader.GetString(6); time = reader.GetInt32(7); //artis artisID = reader.GetInt32(8); artisName = reader.GetString(9); artis = new ArtistDTO(artisID, artisName); song = new SongDTO(songID, title, lyrics, dateRelease, linkOpen, linkDownLoad, image, time, artis); result.Add(song); } } } catch (Exception e) { Console.WriteLine(e.StackTrace); } finally { closeConnect(); } } return(result); }
public Song Post(SongDTO value) { Song model = new Song() { Name = value.Name, Style = value.Style }; return(ISongRepository.Create(model)); }
public Song(SongDTO SongDTO) { SongId = SongDTO.SongId; Title = SongDTO.Title; Artist = SongDTO.Artist; Released = SongDTO.Released; Genre = SongDTO.Genre; MP3FilePath = SongDTO.MP3FilePath; SongBanner = SongDTO.SongBanner; }
public async Task <IActionResult> Save([FromBody] SongDTO songDTO) { var operationResult = await songService.Save(songDTO); if (!operationResult.IsSuccess) { return(NotFound(operationResult.Message)); } return(Ok(operationResult.Result)); }
public IActionResult Post([FromBody] SongDTO songDTOToAdd) { Song songToAdd = DTOToSong(songDTOToAdd); _context.Songs.Add(songToAdd); _context.SaveChanges(); songDTOs = SongsConverter(_context.Songs.ToList()); return(Created("api/MusicController", songDTOToAdd)); }
public void Post(SongDTO value) { Song model = new Song() { title = value.title, artist = value.artist, link = value.link }; iSongRepository.Create(model); }
public IActionResult Delete(int id) { SongDTO songDTOToDelete = songDTOs.Where(song => song.Id == id).FirstOrDefault(); Song songToDelete = DTOToSong(songDTOToDelete); _context.Remove(songToDelete); _context.SaveChanges(); songDTOs = SongsConverter(_context.Songs.ToList()); return(Ok(songDTOToDelete)); }