public Response <AlbumDto> FindById(int id) { if (id <= 0) { return(new Response <AlbumDto>(false, "Id must be grater than 0", null)); } AlbumDto response = new AlbumDto(); try { using (musicDBEntities db = new musicDBEntities()) { Album album = db.Album.Find(id); response.Id = album.album_id; response.Name = album.name; response.Released = album.relesed; } return(new Response <AlbumDto>(true, "Element was found", response)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <AlbumDto>(false, "Somethig was wrong. Exception: " + e.Message, null)); } else { return(new Response <AlbumDto>(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, null)); } } }
public Response <int> Insert(AlbumDto newObject) { if (newObject == null) { return(new Response <int>(false, "Album cannot be null", -1)); } Album album = new Album { name = newObject.Name, relesed = newObject.Released }; try { using (musicDBEntities db = new musicDBEntities()) { db.Album.Add(album); db.SaveChanges(); } return(new Response <int>(true, "Album was inserted in DB", album.album_id)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <int>(false, "Somethig was wrong. Exception: " + e.Message, -1)); } else { return(new Response <int>(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, -1)); } } }
public Response <IEnumerable <AlbumDto> > SelectAll() { List <AlbumDto> response = new List <AlbumDto>(); try { using (musicDBEntities db = new musicDBEntities()) { List <Album> albums = db.Album.ToList(); foreach (Album album in albums) { AlbumDto aux = new AlbumDto(); aux.Id = album.album_id; aux.Name = album.name; aux.Released = album.relesed; response.Add(aux); } } return(new Response <IEnumerable <AlbumDto> >(true, response.Count + " albums found", response)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <IEnumerable <AlbumDto> >(false, "Somethig was wrong. Exception: " + e.Message, response)); } else { return(new Response <IEnumerable <AlbumDto> >(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, response)); } } }
public Response <IEnumerable <SongDto> > SelectAll() { List <SongDto> response = new List <SongDto>(); try { using (musicDBEntities db = new musicDBEntities()) { List <Song> songs = db.Song.ToList(); foreach (Song song in songs) { SongDto aux = new SongDto(song.song_id, song.title, song.genre, song.released, song.duration, song.fk_album_id.GetValueOrDefault(), song.fk_artist_id.GetValueOrDefault()); response.Add(aux); } } return(new Response <IEnumerable <SongDto> >(true, response.Count + " Songs found", response)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <IEnumerable <SongDto> >(false, "Somethig was wrong. Exception: " + e.Message, response)); } else { return(new Response <IEnumerable <SongDto> >(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, response)); } } }
public Response <int> Delete(int id) { if (id <= 0) { return(new Response <int>(false, "Id must be grater than 0", -1)); } try { using (musicDBEntities db = new musicDBEntities()) { Album albumToDelete = db.Album.Find(id); db.Album.Attach(albumToDelete); id = db.Album.Remove(albumToDelete).album_id; db.SaveChanges(); } return(new Response <int>(true, "Album was delete from DB", id)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <int>(false, "Somethig was wrong. Exception: " + e.Message, -1)); } else { return(new Response <int>(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, -1)); } } }
public Response <SongDto> FindById(int id) { if (id <= 0) { return(new Response <SongDto>(false, "Id must be grater than 0", null)); } SongDto response; try { using (musicDBEntities db = new musicDBEntities()) { Song song = db.Song.Find(id); response = new SongDto(song.song_id, song.title, song.genre, song.released, song.duration, song.fk_album_id.GetValueOrDefault(), song.fk_artist_id.GetValueOrDefault()); } return(new Response <SongDto>(true, "Song was find", response)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <SongDto>(false, "Somethig was wrong. Exception: " + e.Message, null)); } else { return(new Response <SongDto>(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, null)); } } }
public Response <int> Insert(ArtistDto newObject) { if (newObject == null) { return(new Response <int>(false, "Artist cannot be null", -1)); } Artist artist = new Artist(); artist.name = newObject.Name; try { using (musicDBEntities db = new musicDBEntities()) { db.Artist.Add(artist); db.SaveChanges(); } return(new Response <int>(true, "Artist was inserted in DB", artist.artist_id)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <int>(false, "Somethig was wrong. Exception: " + e.Message, -1)); } else { return(new Response <int>(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, -1)); } } }
public Response <ArtistDto> FindById(int id) { if (id <= 0) { return(new Response <ArtistDto>(false, "Id must be grater than 0", null)); } try { ArtistDto response = new ArtistDto(); using (musicDBEntities db = new musicDBEntities()) { Artist artist = db.Artist.Find(id); response.Id = artist.artist_id; response.Name = artist.name; } return(new Response <ArtistDto>(true, "Artist was found", response)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <ArtistDto>(false, "Somethig was wrong. Exception: " + e.Message, null)); } else { return(new Response <ArtistDto>(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, null)); } } }
public Response <IEnumerable <ArtistDto> > SelectAll() { List <ArtistDto> response = new List <ArtistDto>(); try { using (musicDBEntities db = new musicDBEntities()) { List <Artist> artists = db.Artist.ToList(); foreach (Artist artist in artists) { ArtistDto aux = new ArtistDto(); aux.Id = artist.artist_id; aux.Name = artist.name; response.Add(aux); } } return(new Response <IEnumerable <ArtistDto> >(true, response.Count + " artists found", response)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <IEnumerable <ArtistDto> >(false, "Somethig was wrong. Exception: " + e.Message, response)); } else { return(new Response <IEnumerable <ArtistDto> >(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, response)); } } }
public Response <int> Update(SongDto updatedObject) { if (updatedObject == null) { return(new Response <int>(false, "Song to update cannot be null", -1)); } try { using (musicDBEntities db = new musicDBEntities()) { Song songToUpdate = db.Song.Find(updatedObject.Id); if (songToUpdate == null) { return(new Response <int>(false, "Song to update isn't in the database", -1)); } songToUpdate.title = updatedObject.Title; songToUpdate.genre = updatedObject.Genre; songToUpdate.released = updatedObject.Released; songToUpdate.duration = updatedObject.Duration; songToUpdate.fk_album_id = updatedObject.AlbumId; songToUpdate.fk_artist_id = updatedObject.ArtistId; db.Song.Attach(songToUpdate); db.Entry(songToUpdate).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(new Response <int>(true, "Song was updated", updatedObject.Id)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <int>(false, "Somethig was wrong. Exception: " + e.Message, -1)); } else { return(new Response <int>(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, -1)); } } }
public Response <int> Update(AlbumDto updatedObject) { if (updatedObject == null) { return(new Response <int>(false, "Album to update cannot be null", -1)); } try { using (musicDBEntities db = new musicDBEntities()) { Album albumToUpdate = db.Album.Find(updatedObject.Id); if (albumToUpdate == null) { return(new Response <int>(false, "Album to update isn't in the database", -1)); } albumToUpdate.name = updatedObject.Name; albumToUpdate.relesed = updatedObject.Released; db.Album.Attach(albumToUpdate); db.Entry(albumToUpdate).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(new Response <int>(true, "Album was updated", updatedObject.Id)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <int>(false, "Somethig was wrong. Exception: " + e.Message, -1)); } else { return(new Response <int>(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, -1)); } } }
public Response <int> Insert(SongDto newObject) { if (newObject == null) { return(new Response <int>(false, "Song cannot be null", -1)); } Song song = new Song { title = newObject.Title, genre = newObject.Genre, released = newObject.Released, duration = newObject.Duration, fk_album_id = newObject.AlbumId, fk_artist_id = newObject.ArtistId }; try { using (musicDBEntities db = new musicDBEntities()) { db.Song.Add(song); db.SaveChanges(); } return(new Response <int>(true, "Song was inserted in DB", song.song_id)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <int>(false, "Somethig was wrong. Exception: " + e.Message, -1)); } else { return(new Response <int>(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, -1)); } } }
/// <summary> /// gets the songs of an specific album. Songs are sort by title. Results are paginated /// </summary> /// <param name="albumId">Id of specific album</param> /// <param name="page">page number of results</param> /// <returns> Response object of IEnumerable<SongDto> </SongDto></returns> public Response <IEnumerable <SongDto> > SelectSongsByAlbum(int albumId, int page = 0) { if (albumId <= 0) { return(new Response <IEnumerable <SongDto> >(false, "Id of album must be greater than 0", null)); } try { List <SongDto> response = new List <SongDto>(); using (musicDBEntities db = new musicDBEntities()) { List <Song> albumSongs = db.Song.Where(s => s.fk_album_id == albumId).OrderBy(pet => pet.title).Skip(page * elementsPerPage).Take(elementsPerPage).ToList(); foreach (Song song in albumSongs) { SongDto aux = new SongDto(song.song_id, song.title, song.genre, song.released, song.duration, song.fk_album_id.GetValueOrDefault(), song.fk_artist_id.GetValueOrDefault()); response.Add(aux); } } return(new Response <IEnumerable <SongDto> >(true, response.Count + " songs in page " + page, response)); } catch (Exception e) { if (e.InnerException == null) { return(new Response <IEnumerable <SongDto> >(false, "Somethig was wrong. Exception: " + e.Message, null)); } else { return(new Response <IEnumerable <SongDto> >(false, "Somethig was wrong. Exception: " + e.InnerException.InnerException.Message, null)); } } }