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