protected override void Seed(MusicShopDbContext context)
{
base.Seed(context);
Account admin = new Account()
{
Login = "******", Password = "******", IsClient = false
};
Account ac1 = new Account()
{
Login = "******", Password = "******", IsClient = true
};
Account ac2 = new Account()
{
Login = "******", Password = "******", IsClient = true
};
context.Accounts.Add(admin);
context.Accounts.Add(ac1);
context.Accounts.Add(ac2);
context.SaveChanges();
Client dr4m4client = new Client()
{
Name = "Roman", Surname = "Smirnov", Email = "*****@*****.**", AccountId = ac1.Id, Phone = "+38030303003"
};
Client petroclient = new Client()
{
Name = "Petro", Surname = "Ivanov", Email = "*****@*****.**", AccountId = ac2.Id, Phone = "+3808383833"
};
context.Clients.Add(dr4m4client);
context.Clients.Add(petroclient);
context.SaveChanges();
Genre pop = new Genre()
{
Name = "Pop"
};
Genre poppunk = new Genre()
{
Name = "Pop punk"
};
Genre alrock = new Genre()
{
Name = "Alternative rock"
};
Genre hipHop = new Genre()
{
Name = "Hip-Hop"
};
Genre emorap = new Genre()
{
Name = "Emo rap"
};
Genre emotrap = new Genre()
{
Name = "Emo trap"
};
Genre lofi = new Genre()
{
Name = "Lo-fi"
};
Genre rB = new Genre()
{
Name = "R&B"
};
Genre tripHop = new Genre()
{
Name = "Trip hop"
};
context.Genres.Add(pop);
context.Genres.Add(poppunk);
context.Genres.Add(alrock);
context.Genres.Add(hipHop);
context.Genres.Add(emorap);
context.Genres.Add(emotrap);
context.Genres.Add(lofi);
context.Genres.Add(rB);
context.Genres.Add(tripHop);
context.SaveChanges();
Artist yungBlud = new Artist()
{
Name = "YUNGBLUD"
};
Artist lilpeep = new Artist()
{
Name = "Lil Peep"
};
Artist oliverTree = new Artist()
{
Name = "Oliver Tree"
};
Artist joji = new Artist()
{
Name = "Joji"
};
Artist girlInRed = new Artist()
{
Name = "Girl in Red"
};
Artist juiceWRLD = new Artist()
{
Name = "Juice WRLD"
};
Artist xXXTentacion = new Artist()
{
Name = "XXXTentacion"
};
Artist billieEilish = new Artist()
{
Name = "Billie Eilish"
};
context.Artists.Add(yungBlud);
context.Artists.Add(lilpeep);
context.Artists.Add(oliverTree);
context.Artists.Add(joji);
context.Artists.Add(girlInRed);
context.Artists.Add(juiceWRLD);
context.Artists.Add(xXXTentacion);
context.Artists.Add(billieEilish);
context.SaveChanges();
Publisher p1 = new Publisher()
{
Name = "Universal Music Group"
};
Publisher p2 = new Publisher()
{
Name = "Locomotion Recordings"
};
Publisher p3 = new Publisher()
{
Name = "AWAL"
};
Publisher p4 = new Publisher()
{
Name = "Columbia Records"
};
Publisher p5 = new Publisher()
{
Name = "Atlantic Records"
};
Publisher p6 = new Publisher()
{
Name = "88rising Music"
};
context.Publishers.Add(p1);
context.Publishers.Add(p2);
context.Publishers.Add(p3);
context.Publishers.Add(p4);
context.Publishers.Add(p5);
context.Publishers.Add(p6);
context.SaveChanges();
Deal dealHipHop = new Deal()
{
Name = "Hip-Hop", StartDate = DateTime.Now, EndDate = DateTime.Now.AddDays(7), Discount = 10
};
context.Deals.Add(dealHipHop);
Record weird = new Record()
{
ArtistId = yungBlud.Id,
PublisherId = p1.Id,
Name = "a weird! af halloween",
SellingPrice = 220,
CountSongs = 6,
CostPrice = 180,
DateOfPublishing = new System.DateTime(2020, 10, 30),
GenreId = alrock.Id
};
Record underrated = new Record()
{
ArtistId = yungBlud.Id,
PublisherId = p2.Id,
Name = "the underrated youth",
SellingPrice = 250,
CountSongs = 6,
CostPrice = 220,
DateOfPublishing = new System.DateTime(2019, 10, 18),
GenreId = alrock.Id
};
Record century = new Record()
{
ArtistId = yungBlud.Id,
PublisherId = p2.Id,
Name = "21st Century Liability",
CostPrice = 420,
SellingPrice = 500,
CountSongs = 12,
DateOfPublishing = new System.DateTime(2018, 7, 6),
GenreId = alrock.Id
};
//-----------------------------------------------
Record pt1 = new Record()
{
ArtistId = lilpeep.Id,
PublisherId = p3.Id,
Name = "Come Over When You're Sober, Pt. 1",
SellingPrice = 100,
CountSongs = 2,
CostPrice = 80,
DateOfPublishing = new System.DateTime(2017, 9, 15),
GenreId = emorap.Id
};
Record pt2 = new Record()
{
ArtistId = lilpeep.Id,
PublisherId = p4.Id,
Name = "Come Over When You're Sober, Pt. 2",
SellingPrice = 550,
CountSongs = 11,
CostPrice = 450,
Deal = dealHipHop,
DateOfPublishing = new System.DateTime(2018, 11, 9),
GenreId = hipHop.Id
};
Record crybaby = new Record()
{
ArtistId = lilpeep.Id,
PublisherId = p1.Id,
Name = "Crybaby",
SellingPrice = 550,
CountSongs = 11,
CostPrice = 480,
Deal = dealHipHop,
DateOfPublishing = new System.DateTime(2016, 6, 10),
GenreId = hipHop.Id
};
Record ee = new Record()
{
ArtistId = lilpeep.Id,
PublisherId = p4.Id,
Name = "Everybody’s everything",
SellingPrice = 670,
CountSongs = 19,
CostPrice = 600,
DateOfPublishing = new System.DateTime(2018, 7, 6),
GenreId = emorap.Id
};
Record gas = new Record()
{
ArtistId = lilpeep.Id,
PublisherId = p2.Id,
Name = "Goth Angel Sinner",
SellingPrice = 100,
CountSongs = 3,
CostPrice = 90,
DateOfPublishing = new System.DateTime(2019, 10, 31),
GenreId = emorap.Id
};
Record hellboy = new Record()
{
ArtistId = lilpeep.Id,
PublisherId = p2.Id,
Name = "Hellboy",
SellingPrice = 650,
CountSongs = 16,
CostPrice = 600,
Deal = dealHipHop,
DateOfPublishing = new System.DateTime(2015, 9, 25),
GenreId = hipHop.Id
};
//-------------------------------------
Record doyoufeelme = new Record()
{
ArtistId = oliverTree.Id,
PublisherId = p5.Id,
Name = "do you feel me?",
SellingPrice = 270,
CountSongs = 6,
CostPrice = 220,
DateOfPublishing = new System.DateTime(2019, 8, 6),
GenreId = alrock.Id
};
Record alienboy = new Record()
{
ArtistId = oliverTree.Id,
PublisherId = p5.Id,
Name = "alien boy ep",
SellingPrice = 210,
CountSongs = 6,
CostPrice = 180,
DateOfPublishing = new System.DateTime(2019, 5, 17),
GenreId = alrock.Id
};
Record ugly = new Record()
{
ArtistId = oliverTree.Id,
PublisherId = p5.Id,
Name = "Ugly Is Beautiful",
SellingPrice = 620,
CountSongs = 14,
CostPrice = 580,
DateOfPublishing = new System.DateTime(2020, 7, 17),
GenreId = alrock.Id
};
//-----------------------------------------
Record nectar = new Record()
{
ArtistId = joji.Id,
PublisherId = p6.Id,
Name = "Nectar",
SellingPrice = 850,
CountSongs = 18,
CostPrice = 800,
DateOfPublishing = new System.DateTime(2020, 9, 25),
GenreId = lofi.Id
};
Record ballads = new Record()
{
ArtistId = joji.Id,
PublisherId = p6.Id,
Name = "Ballads 1",
SellingPrice = 650,
CountSongs = 12,
CostPrice = 600,
DateOfPublishing = new System.DateTime(2018, 10, 26),
GenreId = lofi.Id
};
Record inTongues = new Record()
{
ArtistId = joji.Id,
PublisherId = p6.Id,
Name = "In Tongues",
SellingPrice = 250,
CountSongs = 6,
CostPrice = 220,
DateOfPublishing = new System.DateTime(2017, 11, 3),
GenreId = rB.Id
};
Record pinkSeason = new Record()
{
ArtistId = joji.Id,
PublisherId = p6.Id,
Name = "Pink Season",
SellingPrice = 900,
CountSongs = 35,
CostPrice = 780,
DateOfPublishing = new System.DateTime(2017, 1, 4),
GenreId = rB.Id
};
Record pinkSeasonTheProphecy = new Record()
{
ArtistId = joji.Id,
PublisherId = p6.Id,
Name = "Pink Season: The Prophecy",
SellingPrice = 200,
CountSongs = 5,
CostPrice = 180,
DateOfPublishing = new System.DateTime(2017, 5, 24),
GenreId = rB.Id
};
//------------------------------------------------
context.Records.Add(weird);
context.Records.Add(underrated);
context.Records.Add(century);
context.Records.Add(pt1);
context.Records.Add(pt2);
context.Records.Add(crybaby);
context.Records.Add(ee);
context.Records.Add(gas);
context.Records.Add(hellboy);
context.Records.Add(doyoufeelme);
context.Records.Add(alienboy);
context.Records.Add(ugly);
context.Records.Add(nectar);
context.Records.Add(ballads);
context.Records.Add(inTongues);
context.Records.Add(pinkSeason);
context.Records.Add(pinkSeasonTheProphecy);
context.SaveChanges();
//--------------------------------------
}
