public static void InsertCourse(Module myModule)
{
using (var context = new AllocationContext())
{
context.Modules.Add(myModule);
context.SaveChanges();
}
}
public static void Initialize(AllocationContext context)
{
context.Database.EnsureCreated();
if (context.Users.Any())
{
return;
}
var users = new User[]
{
new User {
FirstName = "Carson", LastName = "Alexander"
},
new User {
FirstName = "Meredith", LastName = "Alonso"
},
new User {
FirstName = "Arturo", LastName = "Anand"
},
new User {
FirstName = "Gytis", LastName = "Barzdukas"
},
new User {
FirstName = "Peggy", LastName = "Justice"
},
new User {
FirstName = "Laura", LastName = "Norman"
},
new User {
FirstName = "Nino", LastName = "Olivetto"
},
/*new Student{FirstMidName="Meredith",LastName="Alonso",EnrollmentDate=DateTime.Parse("2002-09-01")},
* new Student{FirstMidName="Arturo",LastName="Anand",EnrollmentDate=DateTime.Parse("2003-09-01")},
* new Student{FirstMidName="Gytis",LastName="Barzdukas",EnrollmentDate=DateTime.Parse("2002-09-01")},
* new Student{FirstMidName="Yan",LastName="Li",EnrollmentDate=DateTime.Parse("2002-09-01")},
* new Student{FirstMidName="Peggy",LastName="Justice",EnrollmentDate=DateTime.Parse("2001-09-01")},
* new Student{FirstMidName="Laura",LastName="Norman",EnrollmentDate=DateTime.Parse("2003-09-01")},
* new Student{FirstMidName="Nino",LastName="Olivetto",EnrollmentDate=DateTime.Parse("2005-09-01")}*/
};
foreach (User u in users)
{
context.Users.Add(u);
}
context.SaveChanges();
var Modules = new Module[]
{
new Module {
ModuleID = 1050, Name = "Chemistry"
},
new Module {
ModuleID = 4022, Name = "Microeconomics"
},
new Module {
ModuleID = 4041, Name = "Macroeconomics"
},
new Module {
ModuleID = 1045, Name = "Calculus"
},
new Module {
ModuleID = 3141, Name = "Trigonometry"
},
new Module {
ModuleID = 2021, Name = "Composition"
},
new Module {
ModuleID = 2042, Name = "Literature"
}
};
foreach (Module c in Modules)
{
context.Modules.Add(c);
}
context.SaveChanges();
var Moduleusers = new ModuleUser[]
{
new ModuleUser {
UserID = 1, ModuleID = 4022
},
new ModuleUser {
UserID = 1, ModuleID = 4041
},
new ModuleUser {
UserID = 2, ModuleID = 1045
},
new ModuleUser {
UserID = 2, ModuleID = 3141
},
new ModuleUser {
UserID = 2, ModuleID = 2021
},
new ModuleUser {
UserID = 3, ModuleID = 1050
},
new ModuleUser {
UserID = 4, ModuleID = 1050
},
new ModuleUser {
UserID = 4, ModuleID = 4022
},
new ModuleUser {
UserID = 5, ModuleID = 4041
},
new ModuleUser {
UserID = 6, ModuleID = 1045
},
new ModuleUser {
UserID = 7, ModuleID = 3141
},
};
ModuleUser ModuleUser = new ModuleUser();
ModuleUser.UserID = 1;
ModuleUser.ModuleID = 1050;
context.ModuleUsers.Add(ModuleUser);
foreach (ModuleUser c in Moduleusers)
{
context.ModuleUsers.Add(c);
}
context.SaveChanges();
var skills = new Skill[]
{
new Skill(1, "Java"),
new Skill(2, "C"),
new Skill(3, "C++"),
new Skill(4, "ARM Assembly"),
new Skill(5, "Go"),
};
foreach (Skill c in skills)
{
context.Skills.Add(c);
}
context.SaveChanges();
}
