public void Save()
{
context.SaveChanges();
}
public static async void EnsurePopulated(IApplicationBuilder app)
{
SemaFlagsDBContext context = app.ApplicationServices.GetRequiredService <SemaFlagsDBContext>();
UserManager <User> userManager = app.ApplicationServices.GetRequiredService <UserManager <User> >();
context.Boards.RemoveRange(context.Boards);
context.Groups.RemoveRange(context.Groups);
context.Nodes.RemoveRange(context.Nodes);
//context.UserBoardAffiliations.RemoveRange(context.UserBoardAffiliations);
context.SaveChanges();
User user = await userManager.FindByNameAsync("Ania");
User user1 = await userManager.FindByNameAsync("Tomek");
User user2 = await userManager.FindByNameAsync("Michal");
User user3 = await userManager.FindByNameAsync("Jacek");
if (user == null)
{
user = new Models.User {
UserName = "******", Email = "*****@*****.**", Name = "Ania R"
};
await userManager.CreateAsync(user, "aniaPass");
}
if (user1 == null)
{
user1 = new Models.User {
UserName = "******", Email = "*****@*****.**", Name = "Tomek H"
};
await userManager.CreateAsync(user1, "tomekPass");
}
if (user2 == null)
{
user2 = new Models.User {
UserName = "******", Email = "*****@*****.**", Name = "Michał S"
};
try
{
IdentityResult a = await userManager.CreateAsync(user2, "michalPass");
}
catch (Exception ex) {
Console.WriteLine(ex.Message);
}
}
if (user3 == null)
{
user3 = new Models.User {
UserName = "******", Email = "*****@*****.**", Name = "Jacek W"
};
await userManager.CreateAsync(user3, "jacekPass");
}
Board board1 = null;
Board board2 = null;
if (!context.Boards.Any())
{
board1 = new Board {
Name = "Rauta", Description = "Integration Environment"
};
board2 = new Board {
Name = "Nordic"
};
context.Boards.AddRange(
board1,
board2
);
context.SaveChanges();
}
Group group1 = null;
Group group2 = null;
Group group3 = null;
Group group4 = null;
if (!context.Groups.Any())
{
group1 = new Group {
BoardId = board1.Id, Name = "Dev", Description = "Development machines"
};
group2 = new Group {
BoardId = board1.Id, Name = "QA", Description = "QA machines"
};
group3 = new Group {
BoardId = board2.Id, Name = "Dev", Description = "Development machines"
};
group4 = new Group {
BoardId = board2.Id, Name = "QA", Description = "QA machines"
};
context.Groups.AddRange(
group1, group2, group3, group4
);
context.SaveChanges();
}
if (!context.Nodes.Any())
{
context.Nodes.AddRange(
new Node {
GroupId = group1.Id, Name = "Finnish POS", Description = "F555P001", AssignedUserId = user.Id
},
new Node {
GroupId = group1.Id, Name = "Finnish BS", Description = "F555S001", AssignedUserId = user2.Id
},
new Node {
GroupId = group1.Id, Name = "Swedish POS", Description = "H555P001"
},
new Node {
GroupId = group1.Id, Name = "Swedish BS", Description = "H555S001"
},
new Node {
GroupId = group1.Id, Name = "Latvian POS", Description = "L555P001", AssignedUserId = user.Id
},
new Node {
GroupId = group1.Id, Name = "Latvian BS", Description = "L555S001", AssignedUserId = user1.Id
},
new Node {
GroupId = group1.Id, Name = "Estonian POS", Description = "V555P001"
},
new Node {
GroupId = group1.Id, Name = "Estonian BS", Description = "V555S001"
},
new Node {
GroupId = group2.Id, Name = "Finnish POS", Description = "F550P001"
},
new Node {
GroupId = group2.Id, Name = "Finnish BS", Description = "F550S001"
},
new Node {
GroupId = group2.Id, Name = "Swedish POS", Description = "H550P001"
},
new Node {
GroupId = group2.Id, Name = "Swedish BS", Description = "H550S001"
},
new Node {
GroupId = group2.Id, Name = "Latvian POS", Description = "L550P001", AssignedUserId = user2.Id
},
new Node {
GroupId = group2.Id, Name = "Latvian BS", Description = "L550S001"
},
new Node {
GroupId = group2.Id, Name = "Estonian POS", Description = "V550P001"
},
new Node {
GroupId = group2.Id, Name = "Estonian BS", Description = "V550S001"
}
);
context.SaveChanges();
}
if (!context.UserBoardAffiliations.Any())
{
context.UserBoardAffiliations.AddRange(
new UserBoardAffiliation {
userId = user.Id, boardId = board1.Id, isAdmin = true
},
new UserBoardAffiliation {
userId = user.Id, boardId = board2.Id
},
new UserBoardAffiliation {
userId = user1.Id, boardId = board1.Id
},
new UserBoardAffiliation {
userId = user1.Id, boardId = board2.Id, isAdmin = true
},
new UserBoardAffiliation {
userId = user2.Id, boardId = board1.Id
},
new UserBoardAffiliation {
userId = user3.Id, boardId = board1.Id
}
);
context.SaveChanges();
}
}