public DeleteModel(ProjectManagementApp.Models.WebAppContext context)
 {
     _context = context;
 }
示例#2
0
 public DetailsModel(ProjectManagementApp.Models.WebAppContext context, ILogger <DetailsModel> log)
 {
     _context = context;
     _log     = log;
 }
 public IndexModel(ProjectManagementApp.Models.WebAppContext context)
 {
     _context = context;
 }
示例#4
0
        public static void Initialize(IServiceProvider serviceProvider)
        {
            using (var context = new WebAppContext(
                       serviceProvider.GetRequiredService <
                           DbContextOptions <WebAppContext> >()))
            {
                // context.Database.EnsureCreated();

                // Look for any Members
                if (context.Members.Any())
                {
                    return;   // DB has been seeded
                }

                context.Members.AddRange(
                    new Member {
                    FirstName = "Joe", LastName = "Blow"
                },
                    new Member {
                    FirstName = "Dawn", LastName = "Spring"
                },
                    new Member {
                    FirstName = "Donald", LastName = "Draper"
                },
                    new Member {
                    FirstName = "Kashion", LastName = "Smith"
                },
                    new Member {
                    FirstName = "Braley", LastName = "Hand"
                },
                    new Member {
                    FirstName = "Hope", LastName = "Stokes"
                },
                    new Member {
                    FirstName = "Dan", LastName = "Quant"
                },
                    new Member {
                    FirstName = "Mary", LastName = "Ramirez"
                },
                    new Member {
                    FirstName = "Stephanie", LastName = "Andrews"
                },
                    new Member {
                    FirstName = "Peggy", LastName = "Olson"
                },
                    new Member {
                    FirstName = "Gary", LastName = "Mulberg"
                },
                    new Member {
                    FirstName = "Sallye", LastName = "Hand"
                },
                    new Member {
                    FirstName = "Gavin", LastName = "Beck"
                },
                    new Member {
                    FirstName = "Kim", LastName = "McGill"
                },
                    new Member {
                    FirstName = "Hollie", LastName = "Hawkins"
                },
                    new Member {
                    FirstName = "Roger", LastName = "Sterling"
                },
                    new Member {
                    FirstName = "Charles", LastName = "Ritchie"
                },
                    new Member {
                    FirstName = "Bobby", LastName = "Lee"
                },
                    new Member {
                    FirstName = "Denise", LastName = "Rayford"
                }
                    );
                context.SaveChanges();


                context.Projects.AddRange(
                    new Project {
                    ProjectName = "2019 Golden Nail Awards", DueDate = DateTime.Parse("2019-04-18"), ProjectDes = "The 2019 Golden Nail Awards honoring art supporters in the Texas Panhandle will be held on April 25th at the Derrick Event Center in Downtown Amarillo."
                },
                    new Project {
                    ProjectName = "CIDM 4372 Group Project", DueDate = DateTime.Parse("2019-02-22"), ProjectDes = "This project requires 6 task members to clean, analyze, and present data from a file."
                },
                    new Project {
                    ProjectName = "Present 2022 TTIA Bid", DueDate = DateTime.Parse("2019-06-01"), ProjectDes = "Sales team needs to work to gather requirements for the conference and get offers from partners."
                },
                    new Project {
                    ProjectName = "Task 2", DueDate = DateTime.Parse("2018-07-06"), ProjectDes = "This is task 2"
                },
                    new Project {
                    ProjectName = "Task 3", DueDate = DateTime.Parse("2020-10-05"), ProjectDes = "This is task 3"
                },
                    new Project {
                    ProjectName = "Task 4", DueDate = DateTime.Parse("2019-06-05"), ProjectDes = "This is task 4"
                },
                    new Project {
                    ProjectName = "Task 5", DueDate = DateTime.Parse("2018-10-15"), ProjectDes = "This is task 5"
                },
                    new Project {
                    ProjectName = "Task 6", DueDate = DateTime.Parse("2019-05-05"), ProjectDes = "This is task 6"
                },
                    new Project {
                    ProjectName = "Task 7", DueDate = DateTime.Parse("2019-11-19"), ProjectDes = "This is task 7"
                },
                    new Project {
                    ProjectName = "Task 8", DueDate = DateTime.Parse("2019-12-20"), ProjectDes = "This is task 8"
                },
                    new Project {
                    ProjectName = "Task 9", DueDate = DateTime.Parse("2019-09-08"), ProjectDes = "This is task 9"
                },
                    new Project {
                    ProjectName = "Task 10", DueDate = DateTime.Parse("2019-01-22"), ProjectDes = "This is task 10"
                },
                    new Project {
                    ProjectName = "Task 11", DueDate = DateTime.Parse("2020-02-13"), ProjectDes = "This is task 11"
                },
                    new Project {
                    ProjectName = "Task 12", DueDate = DateTime.Parse("2020-03-15"), ProjectDes = "This is task 12"
                },
                    new Project {
                    ProjectName = "Task 13", DueDate = DateTime.Parse("2021-04-18"), ProjectDes = "This is task 13"
                },
                    new Project {
                    ProjectName = "Task 14", DueDate = DateTime.Parse("2019-05-25"), ProjectDes = "This is task 14"
                },
                    new Project {
                    ProjectName = "Task 15", DueDate = DateTime.Parse("2019-10-13"), ProjectDes = "This is task 15"
                },
                    new Project {
                    ProjectName = "Task 16", DueDate = DateTime.Parse("2023-01-01"), ProjectDes = "This is task 16"
                },
                    new Project {
                    ProjectName = "Task 17", DueDate = DateTime.Parse("2050-01-01"), ProjectDes = "This is task 17"
                }
                    );

                context.SaveChanges();

                context.ProjectMembers.AddRange(
                    new ProjectMember {
                    ProjectID = 1, MemberID = 1, MemberRole = Role.Manager, AssignmentDes = "Define roles for other team members and head planning meetings"
                },
                    new ProjectMember {
                    ProjectID = 1, MemberID = 2, MemberRole = Role.Researcher, AssignmentDes = "Send out RFPs and present to team"
                },
                    new ProjectMember {
                    ProjectID = 1, MemberID = 3, MemberRole = Role.Specialist, AssignmentDes = "Keep track of and create budget for event."
                },
                    new ProjectMember {
                    ProjectID = 1, MemberID = 4, MemberRole = Role.Task_Worker, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 2, MemberID = 5, MemberRole = Role.Manager, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 2, MemberID = 6, MemberRole = Role.Task_Worker, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 2, MemberID = 2, MemberRole = Role.Task_Worker, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 2, MemberID = 1, MemberRole = Role.Task_Worker, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 2, MemberID = 7, MemberRole = Role.Task_Worker, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 2, MemberID = 8, MemberRole = Role.Task_Worker, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 3, MemberID = 9, MemberRole = Role.Manager, AssignmentDes = "Presents bid to TTIA board"
                },
                    new ProjectMember {
                    ProjectID = 3, MemberID = 10, MemberRole = Role.Specialist, AssignmentDes = "Ensures that all servicing promises are met"
                },
                    new ProjectMember {
                    ProjectID = 3, MemberID = 11, MemberRole = Role.Researcher, AssignmentDes = "Gather requirements for conference and send out RFPs"
                },
                    new ProjectMember {
                    ProjectID = 7, MemberID = 12, MemberRole = Role.Task_Worker, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 7, MemberID = 19, MemberRole = Role.Task_Worker, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 5, MemberID = 8, MemberRole = Role.Task_Worker, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 4, MemberID = 9, MemberRole = Role.Manager, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 6, MemberID = 2, MemberRole = Role.Specialist, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 18, MemberID = 9, MemberRole = Role.Researcher, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 19, MemberID = 11, MemberRole = Role.Researcher, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 12, MemberID = 13, MemberRole = Role.Specialist, AssignmentDes = "Assignment Description"
                },
                    new ProjectMember {
                    ProjectID = 12, MemberID = 13, MemberRole = Role.Task_Worker, AssignmentDes = ""
                },
                    new ProjectMember {
                    ProjectID = 12, MemberID = 4, MemberRole = Role.Task_Worker, AssignmentDes = ""
                },
                    new ProjectMember {
                    ProjectID = 15, MemberID = 5, MemberRole = Role.Manager, AssignmentDes = ""
                },
                    new ProjectMember {
                    ProjectID = 15, MemberID = 6, MemberRole = Role.Task_Worker, AssignmentDes = ""
                },
                    new ProjectMember {
                    ProjectID = 11, MemberID = 7, MemberRole = Role.Specialist, AssignmentDes = ""
                },
                    new ProjectMember {
                    ProjectID = 11, MemberID = 8, MemberRole = Role.Researcher, AssignmentDes = ""
                },
                    new ProjectMember {
                    ProjectID = 11, MemberID = 1, MemberRole = Role.Manager, AssignmentDes = ""
                }

                    );

                context.SaveChanges();
            }
        }