public static void Initialize(ApplicationDbContext context)
{
context.Database.EnsureCreated();
if (context.People.Any())
{
return;
}
var projects = new Project[]
{
new Project {
Title = "Project #1", Description = "Very long description", LastEditDate = DateTime.Parse("2007-09-01")
},
new Project {
Title = "Project #2", Description = "long description", LastEditDate = DateTime.Parse("2012-11-05")
},
new Project {
Title = "Project #3", Description = "description", LastEditDate = DateTime.Parse("2015-06-23")
}
};
foreach (Project p in projects)
{
context.Projects.Add(p);
}
context.SaveChanges();
var people = new Person[]
{
new Person {
FirstName = "Jan", LastName = "Kowalski", Email = "*****@*****.**"
},
new Person {
FirstName = "Emil", LastName = "Nowak", Email = "*****@*****.**"
},
new Person {
FirstName = "Artur", LastName = "Król", Email = "*****@*****.**"
}
};
foreach (Person p in people)
{
context.People.Add(p);
}
context.SaveChanges();
var severities = new Severity[]
{
new Severity {
SeverityName = "Minor"
},
new Severity {
SeverityName = "Major"
}
};
foreach (Severity s in severities)
{
context.Severities.Add(s);
}
context.SaveChanges();
var statuses = new Status[]
{
new Status {
StatusName = "Open"
},
new Status {
StatusName = "In progress"
},
new Status {
StatusName = "Closed"
}
};
foreach (Status s in statuses)
{
context.Statuses.Add(s);
}
context.SaveChanges();
var issues = new Issue[]
{
new Issue {
Title = "Problem #1", Description = "Very very long description",
AuthorId = people.Single(i => i.LastName == "Nowak").PersonId,
ProjectId = projects.Single(i => i.Title == "Project #1").ProjectId,
SeverityId = severities.Single(i => i.SeverityName == "Minor").SeverityId,
StatusId = statuses.Single(i => i.StatusName == "Open").StatusId
}
};
foreach (Issue i in issues)
{
context.Issues.Add(i);
}
context.SaveChanges();
var projectMembers = new ProjectMember[]
{
new ProjectMember {
ProjectId = projects.Single(i => i.Title == "Project #1").ProjectId,
PersonId = people.Single(i => i.LastName == "Nowak").PersonId
},
new ProjectMember {
ProjectId = projects.Single(i => i.Title == "Project #1").ProjectId,
PersonId = people.Single(i => i.LastName == "Kowalski").PersonId
}
};
foreach (ProjectMember p in projectMembers)
{
context.ProjectMembers.Add(p);
}
context.SaveChanges();
var assignees = new Assignee[]
{
new Assignee {
IssueId = issues.Single(i => i.Title == "Problem #1").IssueId,
PersonId = people.Single(i => i.LastName == "Kowalski").PersonId
},
new Assignee {
IssueId = issues.Single(i => i.Title == "Problem #1").IssueId,
PersonId = people.Single(i => i.LastName == "Nowak").PersonId
}
};
foreach (Assignee a in assignees)
{
context.Assignees.Add(a);
}
context.SaveChanges();
}