// Update Tasks public void UpdateTask(Task editTask) { ProjectManagerContext pmContext = new ProjectManagerContext(); var existingTask = pmContext.Tasks.Where(m => m.Task_ID == editTask.Task_ID).FirstOrDefault(); existingTask.Parent_ID = editTask.Parent_ID; existingTask.TaskName = editTask.TaskName; existingTask.Start_Date = editTask.Start_Date; existingTask.End_Date = editTask.End_Date; existingTask.Priority = editTask.Priority; pmContext.SaveChanges(); var newUser = pmContext.Users.Where(m => m.User_ID == editTask.User_ID).FirstOrDefault(); var existingUser = pmContext.Users.Where(m => m.Task_ID == editTask.Task_ID).FirstOrDefault(); if (newUser != null) { existingUser.Employee_ID = newUser.Employee_ID; existingUser.FirstName = newUser.FirstName; existingUser.LastName = newUser.LastName; pmContext.SaveChanges(); } }
//Add New Users public void AddUser(User newUser) { ProjectManagerContext pmContext = new ProjectManagerContext(); pmContext.Users.Add(newUser); pmContext.SaveChanges(); }
//Get Completed Tasks by Project Id public List <Task> GetCompletedTasksByProjectId(int projectId) { ProjectManagerContext pmContext = new ProjectManagerContext(); var tasks = pmContext.Tasks.Where(m => m.Project_ID == projectId && m.End_Date > DateTime.Now); return(tasks.ToList()); }
//Delete User public void DeleteUser(int id) { ProjectManagerContext pmContext = new ProjectManagerContext(); var deleteUser = pmContext.Users.Where(m => m.User_ID == id).FirstOrDefault(); pmContext.Users.Remove(deleteUser); pmContext.SaveChanges(); }
// Get List of All Users public List <User> GetAllUsers() { ProjectManagerContext pmContext = new ProjectManagerContext(); List <User> UserList = new List <User>(); UserList = pmContext.Users.Distinct().ToList(); UserList = UserList.GroupBy(i => i.Employee_ID).Select(g => g.First()).ToList(); return(UserList); }
// Update Existing User public void UpdateUser(User editUser) { ProjectManagerContext pmContext = new ProjectManagerContext(); var existingUser = pmContext.Users.Where(m => m.User_ID == editUser.User_ID).FirstOrDefault(); existingUser.Project_ID = editUser.Project_ID; existingUser.FirstName = editUser.FirstName; existingUser.LastName = editUser.LastName; existingUser.Employee_ID = editUser.Employee_ID; pmContext.SaveChanges(); }
// delete Tasks Method public void DeleteTask(int id) { ProjectManagerContext pmContext = new ProjectManagerContext(); var existingUser = pmContext.Users.Where(m => m.Task_ID == id).FirstOrDefault(); if (existingUser != null) { existingUser.Task_ID = null; pmContext.SaveChanges(); } var deleteTask = pmContext.Tasks.Where(m => m.Task_ID == id).FirstOrDefault(); pmContext.Tasks.Remove(deleteTask); pmContext.SaveChanges(); }
// Add New Project public void AddProject(Project newProject) { ProjectManagerContext pmContext = new ProjectManagerContext(); pmContext.Projects.Add(newProject); pmContext.SaveChanges(); var existingUser = pmContext.Users.Where(m => m.User_ID == newProject.User_ID).FirstOrDefault(); User newUser = new User(); newUser.User_ID = 0; newUser.FirstName = existingUser.FirstName; newUser.LastName = existingUser.LastName; newUser.Project_ID = newProject.Project_ID; newUser.Employee_ID = existingUser.Employee_ID; pmContext.Users.Add(newUser); pmContext.SaveChanges(); }
// Update Existing Project public void UpdateProject(Project editProject) { ProjectManagerContext pmContext = new ProjectManagerContext(); var existingProject = pmContext.Projects.Where(m => m.Project_ID == editProject.Project_ID).FirstOrDefault(); existingProject.Project_ID = editProject.Project_ID; existingProject.ProjectName = editProject.ProjectName; existingProject.StartDate = editProject.StartDate; existingProject.EndDate = editProject.EndDate; existingProject.Priority = editProject.Priority; pmContext.SaveChanges(); var newUser = pmContext.Users.Where(m => m.User_ID == editProject.User_ID).FirstOrDefault(); var existingUser = pmContext.Users.Where(m => m.Project_ID == editProject.Project_ID && m.Task_ID == null).FirstOrDefault(); existingUser.Employee_ID = newUser.Employee_ID; existingUser.FirstName = newUser.FirstName; existingUser.LastName = newUser.LastName; pmContext.SaveChanges(); }
//Get List of All Parent Tasks public List <ParentTask> GetAllParentTasks() { ProjectManagerContext pmContext = new ProjectManagerContext(); return(pmContext.ParentTasks.ToList()); }
//Get List of all projects #region Projects public List <Project> GetAllProjects() { ProjectManagerContext pmContext = new ProjectManagerContext(); return(pmContext.Projects.ToList()); }