public static async Task Initialize(IServiceProvider serviceProvider, string testUserPw)
{
using (var context = new IssueTrackerContext(
serviceProvider.GetRequiredService <DbContextOptions <IssueTrackerContext> >()))
{
var user1 = await EnsureUser(serviceProvider, testUserPw, "*****@*****.**");
var user2 = await EnsureUser(serviceProvider, testUserPw, "*****@*****.**");
var user3 = await EnsureUser(serviceProvider, testUserPw, "*****@*****.**");
SeedDB(context, user1, user2, user3);
}
}
public static void Initialize(IssueTrackerContext context)
{
context.Database.EnsureCreated();
if (context.UserTasks.Any())
{
return; // DB has been seeded
}
var UserTasks = new UserTask[]
{
new UserTask {
Type = TaskType.BUG, Name = "This is bug 1"
},
new UserTask {
Type = TaskType.BUG, Name = "This is bug 2"
},
new UserTask {
Type = TaskType.TASK, Name = "This is task 1"
},
new UserTask {
Type = TaskType.TASK, Name = "This is task 1"
}
};
foreach (UserTask task in UserTasks)
{
context.UserTasks.Add(task);
}
context.SaveChanges();
var Dashboards = new Dashboard[]
{
new Dashboard {
Name = "Dashboard1"
},
new Dashboard {
Name = "Dashboard2"
}
};
foreach (Dashboard dashboard in Dashboards)
{
context.Dashboards.Add(dashboard);
}
context.SaveChanges();
}
public IndexModel(IssueTracker.Data.IssueTrackerContext context)
{
_context = context;
}
public SqlIssueTrackerRepo(IssueTrackerContext context)
{
_context = context;
}
public DeleteModel(IssueTracker.Data.IssueTrackerContext context)
{
_context = context;
}
public static void SeedDB(IssueTrackerContext context, string user1, string user2, string user3)
{
if (context.Ticket.Any())
{
return; // DB has been seeded
}
context.Statuses.AddRange(
new Status
{
Name = "OPEN"
},
new Status
{
Name = "ON PROGRESS"
},
new Status
{
Name = "DONE"
},
new Status
{
Name = "CLOSED"
}
);
context.Categories.AddRange(
new Category
{
Name = "Backend"
},
new Category
{
Name = "FrontEnd"
},
new Category
{
Name = "Database"
},
new Category
{
Name = "Project"
}
);
context.Ticket.AddRange(
new Ticket
{
Name = "Help: No API Found for Testing Class",
Description = "Only for testing purpose.",
StatusId = 3,
CategoryId = 1,
AssigneeId = user1,
CreatorId = user2,
CreatedDate = new DateTime(2020, 8, 1),
},
new Ticket
{
Name = "Help: Layout error when using testing module",
Description = "Only for testing purpose.",
StatusId = 2,
CategoryId = 2,
AssigneeId = user2,
CreatorId = user1,
CreatedDate = new DateTime(2020, 8, 2),
},
new Ticket
{
Name = "Help: Database conflict need to drop all of them",
Description = "Only for testing purpose.",
StatusId = 4,
CategoryId = 3,
AssigneeId = user3,
CreatorId = user2,
CreatedDate = new DateTime(2020, 8, 3),
},
new Ticket
{
Name = "Help: Issues in Flowchart",
Description = "Only for testing purpose.",
StatusId = 1,
CategoryId = 4,
AssigneeId = user2,
CreatorId = user3,
CreatedDate = new DateTime(2020, 8, 4),
},
new Ticket
{
Name = "Help: Cannot Install Windows Media Player",
Description = "Only for testing purpose.",
StatusId = 1,
CategoryId = 2,
AssigneeId = user1,
CreatorId = user3,
CreatedDate = new DateTime(2020, 8, 5),
}
);
context.SaveChanges();
}
public EditModel(IssueTracker.Data.IssueTrackerContext context)
{
_context = context;
}
