public static void Initialize(CodeMatchContext context) { context.Database.EnsureCreated(); if (context.Users.Any()) { return; // DB has been seeded } context.Permissions.AddRange( new Permission { Name = "permission 1" }, new Permission { Name = "permission 2" } ); context.SaveChanges(); context.Roles.AddRange( new Role { Name = "Maker" }, new Role { Name = "Company" } ); context.SaveChanges(); context.RolePermissions.AddRange(new RolePermission { Permission = context.Permissions.FirstOrDefault(), Role = context.Roles.FirstOrDefault() }); context.SaveChanges(); context.Companies.AddRange(new Company { Location = "location company" }); context.SaveChanges(); context.Makers.AddRange(new Maker { Dob = new DateTime(1998, 3, 12), Experience = "none", Firstname = "te", Lastname = "st", LinkedIn = "www.link.com", }); context.SaveChanges(); context.Users.AddRange(new User { Role = context.Roles.FirstOrDefault(), Biography = "biobio", Email = "*****@*****.**", Password = "******", Phonenumber = "123456789", MakerID = 1 }, new User { Biography = "user 2 biography", Email = "*****@*****.**", Password = "******", Phonenumber = "987654321", Role = context.Roles.SingleOrDefault(r => r.RoleID == 2), CompanyID = 1 }); context.SaveChanges(); context.Assignments.AddRange(new Assignment { Status = "...", Location = "assignment location", Company = context.Companies.FirstOrDefault(), Description = "This is the description of the assignment" }); context.SaveChanges(); context.Applications.AddRange(new Application { IsAccepted = true, Assignment = context.Assignments.FirstOrDefault(), Maker = context.Makers.FirstOrDefault() }); context.SaveChanges(); context.Reviews.AddRange(new Review { Assignment = context.Assignments.FirstOrDefault(), Description = "very good", Receiver = context.Users.Where(r => r.Email == "*****@*****.**").Single(), Sender = context.Users.Where(r => r.Email == "*****@*****.**").Single() }); context.SaveChanges(); context.Tags.AddRange(new Tag { Name = "front" }, new Tag { Name = "back" }); context.SaveChanges(); context.MakerTags.AddRange(new MakerTag { Maker = context.Makers.FirstOrDefault(), Tag = context.Tags.Single(r => r.Name == "front") }); context.SaveChanges(); context.CompanyTags.AddRange(new CompanyTag { Company = context.Companies.FirstOrDefault(), Tag = context.Tags.Single(r => r.Name == "back") }); context.SaveChanges(); }
public static void Initialize(CodeMatchContext context) { context.Database.EnsureCreated(); if (context.Users.Any()) { return; // DB has been seeded } context.Permissions.AddRange( new Permission { Name = "update_maker_profile" }, new Permission { Name = "update_company_profile" }, new Permission { Name = "read_maker_profile" }, new Permission { Name = "read_company_profile" }, new Permission { Name = "not_admin" }, new Permission { Name = "can_click_admin_link" }, new Permission { Name = "can_click_assignments_link" }, new Permission { Name = "can_click_notifications_link" } ); context.SaveChanges(); context.Roles.AddRange( new Role { Name = "Maker" }, new Role { Name = "Company" }, new Role { Name = "Admin" } ); context.SaveChanges(); context.RolePermissions.AddRange( new RolePermission { RoleID = 1, PermissionID = 1 }, new RolePermission { RoleID = 1, PermissionID = 3 }, new RolePermission { RoleID = 2, PermissionID = 2 }, new RolePermission { RoleID = 2, PermissionID = 4 }, new RolePermission { RoleID = 2, PermissionID = 5 }, new RolePermission { RoleID = 1, PermissionID = 5 } , new RolePermission { RoleID = 1, PermissionID = 7 }, new RolePermission { RoleID = 3, PermissionID = 6 }, new RolePermission { RoleID = 1, PermissionID = 8 }, new RolePermission { RoleID = 2, PermissionID = 8 } ); context.SaveChanges(); context.Companies.AddRange(new Company { StreetAdress = "Schoolstraat", PostalCode = 2260, Name = "Kwb Heultje" }, new Company { StreetAdress = "Biezenveld 34", PostalCode = 2460, Name = "Geko bvba" }, new Company { StreetAdress = "Gasthuisstraat 102", PostalCode = 2300, Name = "MusicMaestro" } ); context.SaveChanges(); context.Makers.AddRange( new Maker { Dob = new DateTime(1998, 3, 12), Experience = "Ik ben een 3de jaars IT-student. Ik ben ervaren in C# en Angular", Firstname = "Brecht", Lastname = "Snoeck", LinkedIn = "www.linkedin.com/in/brecht-snoeck-564715142/", Nickname = "Brekke" }, new Maker { Dob = new DateTime(1998, 05, 11), Experience = "C#, Angular", Firstname = "Bosz", Lastname = "Srisan", LinkedIn = "www.linkedin.com/in/boszsrisan", Nickname = "Bozie", } ); context.SaveChanges(); context.Users.AddRange(new User { RoleID = 1, Biography = "Hallo ik ben Brecht Snoeck. Ik ben geboren op 4 juli 1997. Ik houd van sport en IT.", Email = "*****@*****.**", Password = "******", Phonenumber = "123456789", MakerID = 1 }, new User { Biography = "Wij zijn Kwb Heultje en vertegenwoordigen kleine zelfstandigen.", Email = "*****@*****.**", Password = "******", Phonenumber = "987654321", RoleID = 2, CompanyID = 1 }, new User { Biography = "administrator", Email = "*****@*****.**", Password = "******", Phonenumber = "987654321", RoleID = 3, }, new User { Biography = "ITF student", Email = "*****@*****.**", Password = "******", Phonenumber = "0483476363", RoleID = 1, MakerID = 2 }, new User { Biography = "Plastic bedrijf", Email = "*****@*****.**", Password = "******", Phonenumber = "0483473626", RoleID = 2, CompanyID = 2 }, new User { Biography = "Mensen gepasioneerd door muziek!", Email = "*****@*****.**", Password = "******", Phonenumber = "014856478", RoleID = 2, CompanyID = 3 }, new User { Email = "*****@*****.**", Password = "******", Phonenumber = "0897635267", RoleID = 3, } ); context.SaveChanges(); context.Assignments.AddRange( new Assignment { Status = "Initial", StreetAdress = "Schoolstraat", PostalCode = 2260, Company = context.Companies.FirstOrDefault(), Description = "Webdesign", Name = "De bakkerij website" }, new Assignment { Status = "InProgress", StreetAdress = "Schoolstraat", PostalCode = 2260, Company = context.Companies.FirstOrDefault(), Description = "Datamodeling", Name = "Het bakkerij datamodel" }, new Assignment { Status = "Completed", StreetAdress = "Schoolstraat", PostalCode = 2260, Company = context.Companies.FirstOrDefault(), Description = "Backend .NET", Name = "De online bakkerij database" }, new Assignment { Status = "Initial", StreetAdress = "Schoolstraat", PostalCode = 2260, Company = context.Companies.FirstOrDefault(), Description = "Hallo, ik ben slager Jan. Ik ben op zoek naar iemand die voor mijn prestigieuze slagerij een website kan maken! Ik ben op zoek naar een vriendelijke student/freelancer" + "die me hierbij kan helpen", Name = "De slager website" }, new Assignment { Status = "Initial", StreetAdress = "Schoolstraat", PostalCode = 2260, Company = context.Companies.FirstOrDefault(), Description = "Hallo, ik ben directeur Bart. Ik ben op zoek naar iemand die voor mijn prestigieuze school een website kan maken! Ik ben op zoek naar een vriendelijke student/freelancer" + "die me hierbij kan helpen", Name = "De school website" }, new Assignment { Status = "InProgress", StreetAdress = "Gasthuisstraat 102", PostalCode = 2300, Company = context.Companies.SingleOrDefault(x => x.CompanyID == 3), Description = "Hey, wij binnen MusicMaestro zoeken een gedreven persoon met IT-kennis die het ziet zitten om een website voor ons te bouwen." + "Hierbij staat een goede vergoeding vast!", Name = "Website voor een muziekwinkel" } ); context.SaveChanges(); context.Applications.AddRange( new Application { IsAccepted = true, Assignment = context.Assignments.Where(r => r.Name == "Het bakkerij datamodel").Single(), Maker = context.Makers.FirstOrDefault() }, new Application { IsAccepted = true, Assignment = context.Assignments.Where(r => r.Name == "De bakkerij website").Single(), Maker = context.Makers.FirstOrDefault() }, new Application { IsAccepted = true, Assignment = context.Assignments.Where(r => r.Name == "Het bakkerij datamodel").Single(), Maker = context.Makers.SingleOrDefault(m => m.MakerID == 2) }, new Application { IsAccepted = true, Assignment = context.Assignments.Where(r => r.Name == "De online bakkerij database").Single(), Maker = context.Makers.FirstOrDefault() }, new Application { IsAccepted = true, Assignment = context.Assignments.Where(r => r.Name == "Website voor een muziekwinkel").Single(), Maker = context.Makers.SingleOrDefault(r => r.MakerID == 2) } ); context.SaveChanges(); context.Reviews.AddRange(new Review { Assignment = context.Assignments.FirstOrDefault(), Description = "very good", Sender = context.Users.Where(r => r.Email == "*****@*****.**").Single() }); context.SaveChanges(); context.Tags.AddRange(new Tag { Name = "Front-end" }, new Tag { Name = "Back-end" }, new Tag { Name = "English" }, new Tag { Name = "French" }, new Tag { Name = "Dutch" }, new Tag { Name = "Design" }, new Tag { Name = "Datamodeling" }, new Tag { Name = "Teamwork" }, new Tag { Name = "C#" }, new Tag { Name = "Javascript" }, new Tag { Name = "node.js" }, new Tag { Name = "HTML" }, new Tag { Name = "CSS" }, new Tag { Name = "Sql" }, new Tag { Name = ".NET" } ); context.SaveChanges(); context.MakerTags.AddRange(new MakerTag { MakerID = 1, TagID = 1 }, new MakerTag { MakerID = 2, TagID = 12 }, new MakerTag { MakerID = 2, TagID = 13 }, new MakerTag { MakerID = 2, TagID = 6 }, new MakerTag { MakerID = 2, TagID = 5 } ); context.SaveChanges(); context.CompanyTags.AddRange(new CompanyTag { CompanyID = 1, TagID = 2 } ); context.SaveChanges(); context.Notification.AddRange( new Notification { Sender = context.Users.FirstOrDefault(), Receiver = context.Users.Single(u => u.Email == "*****@*****.**"), ApplicationID = 2, Read = false }, new Notification { Sender = context.Users.FirstOrDefault(), Receiver = context.Users.Single(u => u.Email == "*****@*****.**"), ApplicationID = 1, Read = false }, new Notification { Sender = context.Users.Single(u => u.Email == "*****@*****.**"), Receiver = context.Users.FirstOrDefault(), ApplicationID = 1, Read = false }, new Notification { Sender = context.Users.Single(u => u.Email == "*****@*****.**"), Receiver = context.Users.FirstOrDefault(), ReviewID = 1, Read = false }, new Notification { Sender = context.Users.Single(u => u.Email == "*****@*****.**"), Receiver = context.Users.FirstOrDefault(), AssignmentID = 3, Read = false } ); context.SaveChanges(); context.AssignmentTags.AddRange( new AssignmentTag { AssignmentID = 1, TagID = 12 }, new AssignmentTag { AssignmentID = 1, TagID = 13 }, new AssignmentTag { AssignmentID = 1, TagID = 6 }, new AssignmentTag { AssignmentID = 2, TagID = 14 }, new AssignmentTag { AssignmentID = 2, TagID = 7 }, new AssignmentTag { AssignmentID = 2, TagID = 2 }, new AssignmentTag { AssignmentID = 3, TagID = 15 }, new AssignmentTag { AssignmentID = 4, TagID = 13 }, new AssignmentTag { AssignmentID = 4, TagID = 6 }, new AssignmentTag { AssignmentID = 5, TagID = 6 }, new AssignmentTag { AssignmentID = 5, TagID = 13 }, new AssignmentTag { AssignmentID = 6, TagID = 13 }, new AssignmentTag { AssignmentID = 6, TagID = 6 }, new AssignmentTag { AssignmentID = 6, TagID = 12 }, new AssignmentTag { AssignmentID = 6, TagID = 5 } ); context.SaveChanges(); }