public void InsertUser(User user)
{
using (var context = new ProjectManagementContext())
{
context.Users.Add(user);
context.SaveChanges();
}
}
public void SetStartDate(int projectId, DateTime today)
{
using (var context = new ProjectManagementContext())
{
var project = context.Projects.Find(projectId);
project.StartDate = today;
context.SaveChanges();
}
}
public void AddTask(int userStoryId, Task task)
{
using (var context = new ProjectManagementContext())
{
var userStory = context.UserStories.Include(u => u.Tasks).FirstOrDefault(u => u.Id == userStoryId);
userStory.Tasks.Add(task);
context.SaveChanges();
}
}
public void DenyTask(int taskId)
{
using (var context = new ProjectManagementContext())
{
var task = context.Tasks.Find(taskId);
task.IsDone = false;
context.SaveChanges();
}
}
public void UpdateMemberRole(int memberId, Role role)
{
using (var context = new ProjectManagementContext())
{
var updatingMember = context.Members.Find(memberId);
updatingMember.Role = role;
context.SaveChanges();
}
}
public void ApproveTask(int taskId)
{
using (var context = new ProjectManagementContext())
{
var task = context.Tasks.Find(taskId);
task.IsApproved = true;
context.SaveChanges();
}
}
public void DeleteProject(int projectId)
{
using (var context = new ProjectManagementContext())
{
var project = context.Projects.Find(projectId);
context.Projects.Remove(project);
context.SaveChanges();
}
}
public void ResetAssignedMember(int id)
{
using (var context = new ProjectManagementContext())
{
var task = context.Tasks.Include(t => t.AssignedMember).FirstOrDefault(t => t.Id == id);
task.AssignedMember = null;
context.SaveChanges();
}
}
public void InsertProject(Project project)
{
using (var context = new ProjectManagementContext())
{
context.Users.Attach(project.CreatedUser);
context.Projects.Add(project);
context.SaveChanges();
}
}
public void UpdateUserStoryState(int id, UserStoryState state)
{
using (var context = new ProjectManagementContext())
{
var userStory = context.UserStories.Find(id);
userStory.State = state;
context.SaveChanges();
}
}
public void UpdateTaskCompletion(int taskId, bool completion)
{
using (var context = new ProjectManagementContext())
{
var task = context.Tasks.Find(taskId);
task.IsDone = completion;
context.SaveChanges();
}
}
public void EditProjectInfo(int id, string projectName, string projectKey)
{
using (var context = new ProjectManagementContext())
{
var project = context.Projects.Find(id);
project.Name = projectName;
project.Key = projectKey;
context.SaveChanges();
}
}
public void EndSprint(int id, DateTime date)
{
using (var context = new ProjectManagementContext())
{
var sprint = context.Sprints.Find(id);
sprint.State = SprintState.FINISHED;
sprint.EndDate = date;
context.SaveChanges();
}
}
public void UpdateUser(User updatingUser)
{
using (var context = new ProjectManagementContext())
{
var user = context.Users.Find(updatingUser.Id);
user.Username = updatingUser.Username;
user.Password = updatingUser.Password;
user.Permission = updatingUser.Permission;
context.SaveChanges();
}
}
public void AssignTask(int memberId, int taskId)
{
using (var context = new ProjectManagementContext())
{
var task = context.Tasks.Find(taskId);
var member = context.Members.Find(memberId);
context.Members.Attach(member);
task.AssignedMember = member;
context.SaveChanges();
}
}
public void DeleteUser(int id)
{
using (var context = new ProjectManagementContext())
{
var user = context.Users.Find(id);
if (user != null)
{
context.Users.Remove(user);
context.SaveChanges();
}
}
}
public void UpdateProject(Project project)
{
using (var context = new ProjectManagementContext())
{
var updatingProject = context.Projects.Find(project.Id);
project.Key = updatingProject.Key;
project.Members = updatingProject.Members;
project.Name = updatingProject.Name;
project.CreatedUser = updatingProject.CreatedUser;
context.SaveChanges();
}
}
public void AddSprint(int projectId, Sprint sprint)
{
using (var context = new ProjectManagementContext())
{
var project = context.Projects.Include(p => p.CreatedUser).Include(p => p.Members)
.Include(p => p.Epics).Include(p => p.Sprints).FirstOrDefault(p => p.Id == projectId);
context.Projects.Attach(project);
sprint.UserStories = new System.Collections.ObjectModel.ObservableCollection <UserStory>();
project.Sprints.Add(sprint);
context.SaveChanges();
}
}
public void AddUserStoryToSprint(int sprintId, UserStory userStory)
{
using (var context = new ProjectManagementContext())
{
var sprint = context.Sprints.Include(s => s.UserStories).FirstOrDefault(s => s.Id == sprintId);
var selectedUserStory = context.UserStories.Find(userStory.Id);
context.UserStories.Attach(selectedUserStory);
selectedUserStory.State = userStory.State;
sprint.UserStories.Add(selectedUserStory);
context.SaveChanges();
}
}
public void DeleteUserStory(int id, int projectId)
{
using (var context = new ProjectManagementContext())
{
var userStory = context.UserStories.Include(u => u.Tasks).FirstOrDefault(u => u.Id == id);
foreach (var task in userStory.Tasks)
{
context.Tasks.Remove(task);
}
context.UserStories.Remove(userStory);
context.SaveChanges();
}
}
public void InsertMember(int id, Member member)
{
using (var context = new ProjectManagementContext())
{
var project = context.Projects.Include(p => p.Members).FirstOrDefault(p => p.Id == id);
var user = context.Users.Find(member.User.Id);
context.Users.Attach(user);
context.Projects.Attach(project);
member.Project = project;
member.User = user;
project.Members.Add(member);
context.SaveChanges();
}
}
public void AddUserStory(int epicId, string title, string description, int storyPoints)
{
using (var context = new ProjectManagementContext())
{
var selectedEpic = context.Epics.Include(epic => epic.UserStories).FirstOrDefault(epic => epic.Id == epicId);
selectedEpic.UserStories.Add(new UserStory()
{
Title = title,
Description = description,
StoryPoints = storyPoints,
State = UserStoryState.BACKLOG
});
context.SaveChanges();
}
}
public void AddEpic(int projectId, string epicTitle, string epicDescription)
{
using (var context = new ProjectManagementContext())
{
var project = context.Projects.Include(p => p.CreatedUser).Include(p => p.Members)
.Include(p => p.Epics).Include(p => p.Sprints).FirstOrDefault(p => p.Id == projectId);
context.Projects.Attach(project);
project.Epics.Add(new Epic()
{
Title = epicTitle,
Description = epicDescription,
Project = project
});
context.SaveChanges();
}
}
public void DeleteMember(int projectId, int memberId)
{
using (var context = new ProjectManagementContext())
{
var deletingMember = context.Members.Find(memberId);
if (deletingMember != null)
{
context.Members.Remove(deletingMember);
var memberProject = context.Projects.Include(project => project.Members).FirstOrDefault(project => project.Id == projectId);
if (memberProject != null)
{
deletingMember = memberProject.Members.FirstOrDefault(member => member.Id == memberId);
memberProject.Members.Remove(deletingMember);
}
context.SaveChanges();
}
}
}
public void DeleteEpic(int id, int projectId)
{
using (var context = new ProjectManagementContext())
{
var epic = context.Epics.Include(e => e.UserStories).Include(e => e.UserStories.Select(u => u.Tasks)).FirstOrDefault(e => e.Id == id);
foreach (var userStory in epic.UserStories)
{
foreach (var task in userStory.Tasks)
{
context.Tasks.Remove(task);
}
context.UserStories.Remove(userStory);
}
var project = context.Projects.Include(p => p.Epics).FirstOrDefault(p => p.Id == projectId);;
project.Epics.Remove(epic);
context.Epics.Remove(epic);
context.SaveChanges();
}
}