public GenreDto deleteGenreById(int genreId)
{
using (PlayListsProjectEntities context = new PlayListsProjectEntities())
{
var genreFound = context.Genre.Where(x => x.IdGenre == genreId);
Genre genreToDelete = new Genre
{
IdGenre = genreId
};
if (genreFound.Count() > 0)
{
context.Genre.Attach(genreToDelete);
context.Genre.Remove(genreToDelete);
}
else
{
return(new GenreDto());
}
context.SaveChanges();
return(new GenreDto
{
IdGenre = genreToDelete.IdGenre,
Name = genreToDelete.Name
});
}
}
public GenreDto getGenreById(int id)
{
using (PlayListsProjectEntities context = new PlayListsProjectEntities())
{
return(context.Genre.Where(x => x.IdGenre == id).Select(y => new GenreDto
{
IdGenre = y.IdGenre,
Name = y.Name
}).First());
}
}
public IList <GenreDto> getAllGenres()
{
using (PlayListsProjectEntities context = new PlayListsProjectEntities())
{
return(context.Genre.Select(x => new GenreDto
{
IdGenre = x.IdGenre,
Name = x.Name
}).ToList());
}
}
public IList <ArtistDto> getAllArtists()
{
using (PlayListsProjectEntities context = new PlayListsProjectEntities()) {
return(context.Artist.Select(x => new ArtistDto {
IdArtist = x.IdArtist,
LastName = x.LastName,
Name = x.Name,
Nationality = x.Nationality
}).ToList());
}
}
public IList <SongDto> getAllSongs()
{
using (PlayListsProjectEntities context = new PlayListsProjectEntities())
{
return(context.Song.Select(x => new SongDto {
IdGenre = x.IdGenre,
IdSong = x.IdSong,
Length = x.Length,
Name = x.Name
}).ToList());
}
}
public GenreDto createOrUpdateGenre(GenreDto newGenre)
{
using (PlayListsProjectEntities context = new PlayListsProjectEntities())
{
GenreDto genreToReturn = new GenreDto();
if (newGenre.IdGenre == null)//create
{
var createGenre = new Genre
{
Name = newGenre.Name
};
context.Genre.Add(createGenre);
genreToReturn.IdGenre = createGenre.IdGenre;
genreToReturn.Name = createGenre.Name;
}
else //update
{
var genreFound = context.Genre.Where(x => x.IdGenre == newGenre.IdGenre).Count();
if (genreFound > 0)
{
var updateGenre = new Genre
{
IdGenre = newGenre.IdGenre.Value,
Name = newGenre.Name
};
context.Genre.Attach(updateGenre);
context.Entry(updateGenre).State = System.Data.Entity.EntityState.Modified;
genreToReturn.IdGenre = updateGenre.IdGenre;
genreToReturn.Name = updateGenre.Name;
}
else
{
return(new GenreDto());
}
}
context.SaveChanges();
return(genreToReturn);
}
}
