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();
}