public static Song SongToDb(this Common.Song song)
{
return(new Song()
{
Id = song.Id,
Artist = song.Artist,
Name = song.Name,
Genre = (int)song.Genre,
AlbumId = song.AlbumId
});
}
public static Common.Song Create(Common.Song song)
{
using (var entities = new AlbumsCatalogueEntities())
{
var songToDb = song.SongToDb();
var newSong = entities.Songs.Add(songToDb);
var songToCommon = newSong.ToCommon();
entities.SaveChanges();
return(songToCommon);
}
}
public static Common.Song Update(Common.Song song)
{
using (var entities = new AlbumsCatalogueEntities())
{
var existing = entities.Songs.FirstOrDefault(x => x.Id == song.Id);
if (existing == null)
{
return(null);
}
existing.Name = song.Name;
existing.Genre = (int)song.Genre;
existing.Artist = song.Artist;
entities.SaveChanges();
return(existing.ToCommon());
}
}
