public void SaveDefaultProject(int userId, int teamId, int?selectedProject) { var teamMember = db.TeamMembers.FirstOrDefault(s => s.MemberID == userId && s.TeamID == teamId); if (teamMember != null) { teamMember.DefaultProjectID = selectedProject; db.Entry(teamMember).State = EntityState.Modified; db.SaveChanges(); } }
public int Save(UserAccountDto userAccount) { var userEntity = new User(); userEntity.FirstName = userAccount.Name; userEntity.EmailAddress = userAccount.EmailAddress; userEntity.Password = userAccount.Password; userEntity.Avatar = userAccount.GravatarUrl; userEntity.CreatedDate = DateTime.UtcNow; db.Users.Add(userEntity); db.SaveChanges(); return(userEntity.ID); }
public int Save(CommentVM comment) { using (var db = new TeamEntitiesConn()) { var commentEntity = new Comment(); commentEntity.IssueID = comment.IssueId; commentEntity.CommentText = comment.CommentBody; commentEntity.CreatedDate = DateTime.Now; commentEntity.CreatedByID = comment.Author.Id; ; db.Comments.Add(commentEntity); db.SaveChanges(); return commentEntity.ID; } }
public int Save(CommentVM comment) { using (var db = new TeamEntitiesConn()) { var commentEntity = new Comment(); commentEntity.IssueID = comment.IssueId; commentEntity.CommentText = comment.CommentBody; commentEntity.CreatedDate = DateTime.Now; commentEntity.CreatedByID = comment.Author.Id; ; db.Comments.Add(commentEntity); db.SaveChanges(); return(commentEntity.ID); } }
public int Save(ActivityDto activity) { using (var db = new TeamEntitiesConn()) { var a = new Activity { OldState = activity.OldState, NewState = activity.NewState, ObjectID = activity.ObjectId, ObjectType = activity.ObjectType, ActivityDesc = activity.Description, ObjectTitle = activity.ObjectTite, CreatedByID = activity.Actor.Id, TeamID = activity.TeamId, CreatedDate = DateTime.Now }; db.Activities.Add(a); db.SaveChanges(); return a.ID; } }
public int Save(ActivityDto activity) { using (var db = new TeamEntitiesConn()) { var a = new Activity { OldState = activity.OldState, NewState = activity.NewState, ObjectID = activity.ObjectId, ObjectType = activity.ObjectType, ActivityDesc = activity.Description, ObjectTitle = activity.ObjectTite, CreatedByID = activity.Actor.Id, TeamID = activity.TeamId, CreatedDate = DateTime.Now }; db.Activities.Add(a); db.SaveChanges(); return(a.ID); } }
public int SaveIssue(CreateIssue issue) { Issue issueEntity = null; using (var db = new TeamEntitiesConn()) { if (issue.Id > 0) { issueEntity = db.Issues.FirstOrDefault(s => s.ID == issue.Id); if (issueEntity == null) { return 0; } } else { issueEntity = new Issue(); } issueEntity.Title = issue.Title; issueEntity.Description = issue.Description; issueEntity.ProjectID = issue.ProjectID; issueEntity.TeamID = issue.TeamID; issueEntity.CategoryID = issue.SelectedCategory; issueEntity.CreatedByID = issue.CreatedByID; issueEntity.Location = issue.Iteration; issueEntity.StatusID = issue.SelectedStatus; issueEntity.PriorityID = issue.SelectedPriority; if (issueEntity.CategoryID == 0) { issueEntity.CategoryID = db.Categories.FirstOrDefault().ID; } if (issueEntity.StatusID == 0) { var status = db.Status.FirstOrDefault(s => s.Code == "New"); issueEntity.StatusID = status.ID; } if (issueEntity.PriorityID == null || issueEntity.PriorityID.Value == 0) { var priority = db.Priorities.FirstOrDefault(s => s.Code == "Normal"); issueEntity.PriorityID = priority.ID; } if (issue.Id == 0) { issueEntity.CreatedDate = DateTime.UtcNow; issueEntity.Active = true; db.Issues.Add(issueEntity); } else { issueEntity.ModifiedDate = DateTime.Now; issueEntity.ModifiedByID = issue.CreatedByID; db.Entry(issueEntity).State = EntityState.Modified; } db.SaveChanges(); return issueEntity.ID; } }
public void SaveDefaultTeam(int userId, int teamId) { var user = db.Users.FirstOrDefault(s => s.ID == userId); if (user != null) { user.DefaultTeamID = teamId; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); } }
public int SaveIssue(CreateIssue issue) { Issue issueEntity = null; using (var db = new TeamEntitiesConn()) { if (issue.ID > 0) { issueEntity = db.Issues.FirstOrDefault(s => s.ID == issue.ID); if (issueEntity == null) { return(0); } } else { issueEntity = new Issue(); } issueEntity.Title = issue.Title; issueEntity.Description = issue.Description; issueEntity.ProjectID = issue.ProjectID; issueEntity.TeamID = issue.TeamID; issueEntity.CategoryID = issue.SelectedCategory; issueEntity.CreatedByID = issue.CreatedByID; issueEntity.Location = issue.Iteration; issueEntity.StatusID = issue.SelectedStatus; issueEntity.PriorityID = issue.SelectedPriority; if (issueEntity.CategoryID == 0) { issueEntity.CategoryID = db.Categories.FirstOrDefault().ID; } if (issueEntity.StatusID == 0) { var status = db.Status.FirstOrDefault(s => s.Code == "New"); issueEntity.StatusID = status.ID; } if (issueEntity.PriorityID == null || issueEntity.PriorityID.Value == 0) { var priority = db.Priorities.FirstOrDefault(s => s.Code == "Normal"); issueEntity.PriorityID = priority.ID; } if (issue.ID == 0) { issueEntity.CreatedDate = DateTime.UtcNow; issueEntity.Active = true; db.Issues.Add(issueEntity); } else { issueEntity.ModifiedDate = DateTime.Now; issueEntity.ModifiedByID = issue.CreatedByID; db.Entry(issueEntity).State = EntityState.Modified; } db.SaveChanges(); return(issueEntity.ID); } }