public async Task SaveLastLoginAsync(int userId) { var user = db.Users.FirstOrDefault(s => s.ID == userId); if (user != null) { user.LastLoginDate = DateTime.UtcNow; db.Entry(user).State = EntityState.Modified; await db.SaveChangesAsync(); } }
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 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; } }
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); } }