private static void AddRelationships()
{
using (var db = new MusicStoreDbContext())
{
var albums = db.Albums.ToList();
var artists = db.Artists.ToList();
var songs = db.Songs.ToList();
albums[0].Artists.Add(artists[0]);
albums[0].Artists.Add(artists[1]);
songs[0].Artist = artists[0];
songs[1].Artist = artists[1];
songs[2].Artist = artists[1];
songs[0].Album = albums[0];
songs[1].Album = albums[0];
songs[2].Album = albums[0];
db.SaveChanges();
}
Console.WriteLine("Relationships are successfully added!");
}
public VenueEFRepository(MusicStoreDbContext db)
{
_db = db;
}
public MusicianEFRepository(MusicStoreDbContext db)
{
_db = db;
}
private static void UpdateSong(int id)
{
using (var db = new MusicStoreDbContext())
{
var song = db.Songs.First(x => x.Id == id);
song.Year = 190;
MusicStoreClient.Update(id, song);
}
}
private static void UpdateArtist(int id)
{
using (var db = new MusicStoreDbContext())
{
var artist = db.Artists.First(x => x.Id == id);
artist.Country = "Brazil";
MusicStoreClient.Update(id, artist);
}
}
private static void UpdateAlbum(int id)
{
using (var db = new MusicStoreDbContext())
{
var album = db.Albums.First(x => x.Id == id);
album.Year = 2;
MusicStoreClient.Update(id, album);
}
}
public static ShoppingCart GetCart(MusicStoreDbContext db, string cartId) => new ShoppingCart(db, cartId);
public static ShoppingCart GetCart(MusicStoreDbContext db, HttpContext context) => GetCart(db, GetCartId(context));
public ShoppingCart(MusicStoreDbContext db, string id)
{
this._db = db;
this._shoppingCartId = id;
}
