public static void Seed(this HomeDBContext dbContext)
{
dbContext.Database.EnsureDeleted();
dbContext.Database.EnsureCreated();
dbContext.Set <UserEntity>().AddRange(
new UserEntity()
{
UniqueId = Guid.Parse("c68a3404-0591-4184-b137-a54600d43b68"), Username = "******", Password = "******", Token = "acf/Twq4NphhnEaAn3SH6Q==", Active = true, Deleted = false
},
new UserEntity()
{
UniqueId = Guid.Parse("57c62076-1c3f-42ec-858d-a54600d43b6a"), Username = "******", Password = "******", Token = "acf/Twq4NphhnEaAn3SH6Q==", Active = true, Deleted = false
},
new UserEntity()
{
UniqueId = Guid.Parse("50979184-6419-44ef-b5fd-a87100f3049a"), Username = "******", Password = "******", Token = "acf/Twq4NphhnEaAn3SH6Q==", Active = true, Deleted = false
},
new UserEntity()
{
UniqueId = Guid.Parse("13e15f30-09ee-4db4-b636-aadf00e0c6c8"), Username = "******", Password = "******", Token = "acf/Twq4NphhnEaAn3SH6Q==", Active = true, Deleted = false
},
new UserEntity()
{
UniqueId = Guid.Parse("9cb95e6b-6257-4289-b629-a97300971965"), Username = "******", Password = "******", Token = "acf/Twq4NphhnEaAn3SH6Q==", Active = true, Deleted = false
}
);
dbContext.SaveChanges();
}
public UsersRepository(HomeDBContext dbContext)
{
_dbContext = dbContext;
_userEntity = _dbContext.Set <UserEntity>();
}
public ArtistRepository(HomeDBContext dbContext)
{
_dbContext = dbContext;
_artistEntity = _dbContext.Set <ArtistEntity>();
}
public static void Seed(this HomeDBContext dbContext)
{
dbContext.Database.EnsureDeleted();
dbContext.Database.EnsureCreated();
dbContext.Set <ContactsEntity>().AddRange(
new ContactsEntity()
{
FirstName = "Firstname1", LastName = "Lastname1", Email = "*****@*****.**", Phone = "111-0000"
},
new ContactsEntity()
{
FirstName = "Firstname2", LastName = "Lastname2", Email = "*****@*****.**", Phone = "222-0000"
},
new ContactsEntity()
{
FirstName = "Firstname3", LastName = "Lastname3", Email = "*****@*****.**", Phone = "333-0000"
}
);
dbContext.Set <RatingTypeEntity>().AddRange(
new RatingTypeEntity()
{
UniqueId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3b1"), Name = "Star 1", Value = 1
},
new RatingTypeEntity()
{
UniqueId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3b2"), Name = "Star 2", Value = 2
},
new RatingTypeEntity()
{
UniqueId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3b3"), Name = "Star 3", Value = 3
},
new RatingTypeEntity()
{
UniqueId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3b4"), Name = "Star 4", Value = 4
},
new RatingTypeEntity()
{
UniqueId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3b5"), Name = "Star 5", Value = 5
}
);
dbContext.Set <MusicTypeEntity>().AddRange(
new MusicTypeEntity()
{
UniqueId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3c1"), Name = "Pop"
},
new MusicTypeEntity()
{
UniqueId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3c2"), Name = "Rock and Roll"
}
);
dbContext.Set <ArtistEntity>().AddRange(
new ArtistEntity()
{
UniqueId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3a1"), Name = "Backstreet Boys"
},
new ArtistEntity()
{
UniqueId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3a2"), Name = "The Beatles"
},
new ArtistEntity()
{
UniqueId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3a3"), Name = "Elvis Presley"
}
);
dbContext.Set <AlbumPriceEntity>().AddRange(
new AlbumPriceEntity()
{
UniqueId = Guid.Parse("1a178d0e-6602-4375-a088-ab8d00facaa1"), Price = (decimal)11.29
},
new AlbumPriceEntity()
{
UniqueId = Guid.Parse("1a178d0e-6602-4375-a088-ab8d00facaa2"), Price = (decimal)12.29
},
new AlbumPriceEntity()
{
UniqueId = Guid.Parse("1a178d0e-6602-4375-a088-ab8d00facaa3"), Price = (decimal)13.29
}
);
dbContext.Set <SongPriceEntity>().AddRange(
new SongPriceEntity()
{
UniqueId = Guid.Parse("1b178d0e-6602-4375-a088-ab8d00facbb1"), Price = (decimal)1.29
},
new SongPriceEntity()
{
UniqueId = Guid.Parse("1b178d0e-6602-4375-a088-ab8d00facbb2"), Price = (decimal)1.30
},
new SongPriceEntity()
{
UniqueId = Guid.Parse("1b178d0e-6602-4375-a088-ab8d00facbb3"), Price = (decimal)1.31
},
new SongPriceEntity()
{
UniqueId = Guid.Parse("1b178d0e-6602-4375-a088-ab8d00facbb4"), Price = (decimal)1.32
}
);
dbContext.SaveChanges();
dbContext.Set <AlbumEntity>().Add(new AlbumEntity
{
UniqueId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00facdd1"),
Name = "DNA",
Review = @"There's one question the Backsteet Boys can't seem to escape: Do they still consider themselves a boy band? The five-piece, most of whom are now over 40 and married with children, have come to embrace the term. ""At this point, 'boys' has come to mean more, like, 'friends'."" Kevin Richardson told...",
Released = DateTime.Parse("2019-01-25"),
CopyRightInfo = "© 2018 K-Bahn, LLC & RCA Records, a division of Sony Music Entertainment",
CoverPath = "Uploads/Pictures/Albums/Covers/DNA.png",
MusicTypeId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3c1"),
ArtistId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3a1"),
AlbumPriceId = Guid.Parse("1a178d0e-6602-4375-a088-ab8d00facaa1")
});
dbContext.SaveChanges();
dbContext.Set <SongEntity>().AddRange(
new SongEntity()
{
UniqueId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00facad1"), AlbumId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00facdd1"), SongPriceId = Guid.Parse("1b178d0e-6602-4375-a088-ab8d00facbb1"), Number = 1, Name = "Don't Go Breaking My Heart", Time = new TimeSpan(00, 03, 36), Popularity = 70
},
new SongEntity()
{
UniqueId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00facad2"), AlbumId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00facdd1"), SongPriceId = Guid.Parse("1b178d0e-6602-4375-a088-ab8d00facbb1"), Number = 2, Name = "Nobody Else", Time = new TimeSpan(00, 03, 38), Popularity = 20
},
new SongEntity()
{
UniqueId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00facad3"), AlbumId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00facdd1"), SongPriceId = Guid.Parse("1b178d0e-6602-4375-a088-ab8d00facbb1"), Number = 3, Name = "Breathe", Time = new TimeSpan(00, 03, 06), Popularity = 30
},
new SongEntity()
{
UniqueId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00facad4"), AlbumId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00facdd1"), SongPriceId = Guid.Parse("1b178d0e-6602-4375-a088-ab8d00facbb1"), Number = 4, Name = "New Love", Time = new TimeSpan(00, 03, 00), Popularity = 25
}
);
dbContext.SaveChanges();
dbContext.Set <AlbumRatingEntity>().AddRange(
new AlbumRatingEntity()
{
UniqueId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00fabbb1"), AlbumId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00facdd1"), RatingTypeId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3b4")
},
new AlbumRatingEntity()
{
UniqueId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00fabbb2"), AlbumId = Guid.Parse("0f078d0e-6602-4375-a088-ab8d00facdd1"), RatingTypeId = Guid.Parse("5befa4aa-06fd-4390-a2f5-a54600d4e3b5")
}
);
dbContext.SaveChanges();
}
public ContactsRepository(HomeDBContext dbContext)
{
_dbContext = dbContext;
_contactsEntity = _dbContext.Set <ContactsEntity>();
}
public EmployeesRepository(HomeDBContext dbContext)
{
_dbContext = dbContext;
_employeesEntity = _dbContext.Set <EmployeeEntity>();
}
public VersionHistoryRepository(HomeDBContext dbContext)
{
_dbContext = dbContext;
_versionHistoryEntity = _dbContext.Set <VersionHistoryEntity>();
}
public SongRepository(HomeDBContext dbContext)
{
_dbContext = dbContext;
_songEntity = _dbContext.Set <SongEntity>();
}
public async Task<HashSet<AlbumEntity>> GetAlbumsAsync()
{
if (_albumEntity != null)
{
var response = new HashSet<AlbumEntity>();
foreach (var album in _albumEntity.AsNoTracking().ToHashSet())
{
album.Artist = await _dbContext.Set<ArtistEntity>().Where(x => x.UniqueId == album.ArtistId).SingleOrDefaultAsync();
album.Artist.Album = null;
album.MusicType = await _dbContext.Set<MusicTypeEntity>().Where(x => x.UniqueId == album.MusicTypeId).SingleOrDefaultAsync();
album.MusicType.Album = null;
album.AlbumPrice = await _dbContext.Set<AlbumPriceEntity>().Where(x => x.UniqueId == album.AlbumPriceId).SingleOrDefaultAsync();
album.AlbumPrice.Album = null;
album.Song = _dbContext.Set<SongEntity>().Where(x => x.Album.UniqueId == album.UniqueId).ToHashSet();
foreach (var song in album.Song)
{
song.Album = null;
song.SongPrice = await _dbContext.Set<SongPriceEntity>().Where(x => x.UniqueId == song.SongPriceId).SingleOrDefaultAsync();
if (song.SongPrice != null)
song.SongPrice.Song = null;
}
album.AlbumRating = _dbContext.Set<AlbumRatingEntity>().Where(x => x.AlbumId == album.UniqueId).ToHashSet();
foreach (var albumRating in album.AlbumRating)
{
albumRating.Album = null;
albumRating.RatingType = await _dbContext.Set<RatingTypeEntity>().Where(x => x.UniqueId == albumRating.RatingTypeId).SingleOrDefaultAsync();
if (albumRating.RatingType != null)
albumRating.RatingType.AlbumRating = null;
}
response.Add(album);
}
return response;
}
return null;
}
public AlbumRepository(HomeDBContext dbContext)
{
_dbContext = dbContext;
_albumEntity = _dbContext.Set<AlbumEntity>();
}
public MusicTypeRepository(HomeDBContext dbContext)
{
_dbContext = dbContext;
_musicTypeEntity = _dbContext.Set <MusicTypeEntity>();
}
public RatingTypeRepository(HomeDBContext dbContext)
{
_dbContext = dbContext;
_ratingTypeEntities = _dbContext.Set <RatingTypeEntity>();
}
public AlbumRatingRepository(HomeDBContext dbContext)
{
_dbContext = dbContext;
_albumRatingEntities = _dbContext.Set <AlbumRatingEntity>();
}
