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