public static Common.Album Create(Common.Album album)
{
using (var entities = new AlbumsCatalogueEntities())
{
var dbAlbum = album.ToDb();
var inserted = entities.Albums.Add(dbAlbum);
entities.SaveChanges();
return(inserted.ToCommon());
}
}
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.Album Update(Common.Album album)
{
using (var entities = new AlbumsCatalogueEntities())
{
var existing = entities.Albums.FirstOrDefault(x => x.Id == album.Id);
existing.Name = album.Name;
existing.ReleaseDate = album.ReleaseDate;
entities.SaveChanges();
return(existing.ToCommon());
}
}
public static void Delete(int id)
{
using (var entities = new AlbumsCatalogueEntities())
{
var entity = entities.Albums.FirstOrDefault(x => x.Id == id);
if (entity != null)
{
entities.Albums.Remove(entity);
}
entities.SaveChanges();
}
}
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());
}
}
