public async Task <IActionResult> OnPostDeleteMemberAsync(int?id) { _log.LogWarning($"OnPost: ProjectID {id}, DROP member {MemberIdToDelete}"); if (id == null) { return(NotFound()); } Project = await _context.Projects.Include(pm => pm.ProjectMembers).ThenInclude(m => m.Member).FirstOrDefaultAsync(m => m.ProjectID == id); if (Project == null) { return(NotFound()); } ProjectMember memberToDrop = _context.ProjectMembers.Where(pm => pm.MemberID == MemberIdToDelete && pm.ProjectID == id).FirstOrDefault(); if (memberToDrop != null) { _context.Remove(memberToDrop); _context.SaveChanges(); } else { _log.LogWarning("Member NOT assigned project"); } return(Page()); }
public async Task <IActionResult> OnPostDeleteProjectAsync(int?id) { _log.LogWarning($"OnPost: MemberId {id}, DROP project {ProjectIdToDelete}"); if (id == null) { return(NotFound()); } Member = await _context.Members.Include(pm => pm.ProjectMembers).ThenInclude(p => p.Project).FirstOrDefaultAsync(m => m.MemberID == id); AllProjects = await _context.Projects.ToListAsync(); ProjectDropDown = new SelectList(AllProjects, "ProjectID", "ProjectName"); if (Member == null) { return(NotFound()); } ProjectMember projectToDrop = _context.ProjectMembers.Where(pm => pm.ProjectID == ProjectIdToDelete && pm.MemberID == id).FirstOrDefault(); if (projectToDrop != null) { _context.Remove(projectToDrop); _context.SaveChanges(); } else { _log.LogWarning("Member not in project"); } return(RedirectToPage(new { id = id })); }
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(); } }