public List <WorkItemDto> GetIncompleteItemsByUserIdList(int serverId, int employeeId, List <int> employeeIdList) { TeamServer server = null; List <WorkItem> workItems = null; List <WorkItemDto> workItemsDtoList = new List <WorkItemDto>(); UserServerInfo userServerInfo = null; try { using (TeamServerRepository teamServerRepository = new TeamServerRepository()) { server = teamServerRepository.GetById(serverId); if (server == null) { throw new Exception(string.Format("Invalid Server Id : {0}", serverId)); } } UserInfo userInfo = null; using (UserInfoRepository userInfoRepository = new UserInfoRepository()) { userInfo = userInfoRepository.Find(x => x.EmployeeId == employeeId); if (userInfo == null) { throw new Exception(string.Format("User with Employee ID {0} Not Found", employeeId)); } } List <string> serverUserIdList = new List <string>(); using (UserServerInfoRepository userServerInfoRepository = new UserServerInfoRepository()) { userServerInfo = userServerInfoRepository.FindLocal(x => x.EmployeeId == employeeId && x.TfsId == serverId); if (userServerInfo == null) { throw new Exception(string.Format("User with employee id : {0} is not registered with server id : {1}", employeeId, serverId)); } string test = userServerInfoRepository.Filter(x => employeeIdList.Contains(x.EmployeeId)) .Select(x => x.UserId).Aggregate((current, next) => "'" + current + "' OR "); string credentialHash = userServerInfo.CredentialHash; string url = server.Url; string query = "Select * From WorkItems " + "Where [System.AssignedTo] = @me " + "AND ([System.State] = 'To Do' OR [System.State] = 'In Progress')" + "Order By [State] Asc, [Changed Date] Desc"; workItems = _teamServerManagementService.GetWorkItemByQuery(query, url, credentialHash); } foreach (WorkItem workItem in workItems) { workItemsDtoList.Add(workItem.ToDto()); } return(workItemsDtoList); } catch (Exception ex) { logger.Error(ex); throw; } }
public UserSessionDto Login(string userId, string password) { if (string.IsNullOrEmpty(userId)) { throw new ArgumentException("User Id cannot be null", nameof(userId)); } if (string.IsNullOrEmpty(password)) { throw new ArgumentException("Password cannot be null", nameof(password)); } UserLogin userLoginEntity = null; using (UserLoginRepository userLoginRepository = new UserLoginRepository()) { string securePassword = password.Encrypt(); userLoginEntity = userLoginRepository.Find(x => x.UserId == userId && x.Password == securePassword); if (userLoginEntity == null) { throw new ApplicationException("Invalid UserId/Password"); } } using (UserInfoRepository repository = new UserInfoRepository()) { UserInfo userInfo = repository.Find(x => x.UserId == userId); if (userInfo == null) { throw new ApplicationException("User Info not found."); } string sessionId = Guid.NewGuid().ToString(); using (UserSessionRepository userSessionRepository = new UserSessionRepository()) { UserSession userSession = new UserSession { UserId = userId, SessionId = sessionId, ValidFrom = DateTime.Now, ExpiresOn = DateTime.Now.AddDays(1) }; userSessionRepository.Insert(userSession); } return(new UserSessionDto() { SessionId = sessionId, User = new UserInfoDto() { FirstName = userInfo.FirstName, LastName = userInfo.LastName, Email = userInfo.EMail, UserId = userInfo.UserId, Gender = userInfo.Gender } }); } }
public int RegisterServer(int serverId, string userId, string serverUserId, string serverPassword, string serverDomain) { TeamServer teamServerEntity; try { using (TeamServerRepository teamServerRepository = new TeamServerRepository()) { teamServerEntity = teamServerRepository.GetById(serverId); if (teamServerEntity == null) { throw new Exception("Invalid server id"); } } using (UserInfoRepository userInfoRepository = new UserInfoRepository()) { UserInfo userInfoEntity = userInfoRepository.Find(x => x.UserId == userId); if (userInfoEntity == null) { throw new Exception("Invalid user id"); } } using (UserServerInfoRepository userServerInfoRepository = new UserServerInfoRepository()) { UserServerInfo userServerInfoEntity = userServerInfoRepository.Find( x => x.UserId.ToUpper() == userId.ToUpper() && x.TfsId == serverId); if (userServerInfoEntity != null) { throw new Exception(string.Format("Server {0} is already registered to the user {1} .", serverId, userId)); } // Dependency Injection of Team Service. NetworkCredential credential = new NetworkCredential(serverUserId, serverPassword, serverDomain); string hash = JsonConvert.SerializeObject(credential).Encrypt(); _authenticationService.Authenticate(serverId, hash); userServerInfoEntity = new UserServerInfo() { UserId = userId, TfsId = serverId, TfsUserId = serverUserId, CredentialHash = hash }; return(userServerInfoRepository.Insert(userServerInfoEntity)); } } catch (Exception ex) { _logger.Error(ex); throw; } }
public WorkItemDto GetWorkItemById(int taskId, int serverId, string userId) { TeamServer server = null; UserServerInfo userServerInfo = null; try { using (TeamServerRepository teamServerRepository = new TeamServerRepository()) { server = teamServerRepository.GetById(serverId); if (server == null) { throw new Exception(string.Format("Invalid Server Id : {0}", serverId)); } } UserInfo userInfo = null; using (UserInfoRepository userInfoRepository = new UserInfoRepository()) { userInfo = userInfoRepository.Find(x => x.UserId != null && x.UserId.ToUpper() == userId.ToUpper()); if (userInfo == null) { throw new Exception(string.Format("User with ID {0} Not Found", userId)); } } using (UserServerInfoRepository userServerInfoRepository = new UserServerInfoRepository()) { userServerInfo = userServerInfoRepository.FindLocal( x => x.UserId != null && x.UserId.ToUpper() == userId.ToUpper() && x.TfsId == serverId); if (userServerInfo == null) { throw new Exception(string.Format("User : {0} is not registered with server id : {1}", userId, serverId)); } string credentialHash = userServerInfo.CredentialHash; string url = server.Url; WorkItem workItem = _teamServerManagementService.GetWorkItemById(taskId, url, credentialHash); if (workItem != null) { return(workItem.ToEntity(serverId).ToDto(workItem.Id)); } } return(null); } catch (Exception ex) { _logger.Error(ex); throw; } }
public UserSessionDto GetUserSessionBySessionId(string sessionId) { if (string.IsNullOrEmpty(sessionId)) { return(null); } UserSession userSession = null; using (UserSessionRepository userSessionRepository = new UserSessionRepository()) { userSession = userSessionRepository.Find(x => x.SessionId == sessionId); } if (userSession == null) { return(null); } else { UserInfo userInfo = new UserInfo(); using (UserInfoRepository userInfoRepository = new UserInfoRepository()) { userInfo = userInfoRepository.Find(x => x.UserId == userSession.UserId); } if (userInfo != null) { return(new UserSessionDto() { SessionId = sessionId, User = new UserInfoDto() { FirstName = userInfo.FirstName, LastName = userInfo.LastName, Email = userInfo.EMail, UserId = userInfo.UserId, Gender = userInfo.Gender } }); } } return(null); }
public List <WorkItemDto> GetUserCurrentWeekSyncedTasks(string userId, bool includeIncompleteItems = true) { List <WorkItemDto> currentWeekTasks = new List <WorkItemDto>(); WeekInfo currentWeek = null; UserInfo currentUser = null; using (UserInfoRepository userInfoRepository = new UserInfoRepository()) { currentUser = userInfoRepository.Find(x => x.UserId == userId); if (currentUser == null) { throw new Exception(string.Format("User Id {0} not found", userId)); } } // Get current week. using (WeekInfoRepository repository = new WeekInfoRepository()) { currentWeek = repository.GetCurrentWeekInfo(); if (currentWeek == null) { throw new Exception("Current Week is not registered."); } } // Get servers configured for the user. List <UserServerInfo> userServers = new List <UserServerInfo>(); using (UserServerInfoRepository repository = new UserServerInfoRepository()) { userServers = repository.Filter(x => x.UserId == userId).ToList(); } // Get user incomplete tasks from task repository. List <int> currentWeekTaskIdList = new List <int>(); List <int> currentWeekMovedTaskList = new List <int>(); foreach (UserServerInfo server in userServers) { using (WorkItemRepository workItemRepository = new WorkItemRepository()) { IQueryable <UserWorkItem> currentWeekSavedTasks = workItemRepository .Filter(x => x.ServerId == server.Id && x.UserId == userId && x.State != WorkItemState.Moved && x.WeekId == currentWeek.Id); IQueryable <UserWorkItem> currentWeekMovedTasks = workItemRepository .Filter(x => x.ServerId == server.Id && x.UserId == userId && x.State == WorkItemState.Moved && x.WeekId == currentWeek.Id); currentWeekTaskIdList = currentWeekSavedTasks.Select(x => x.TaskId).ToList(); currentWeekMovedTaskList = currentWeekSavedTasks.Select(x => x.TaskId).ToList(); } TeamServer teamServer = null; using (TeamServerRepository repository = new TeamServerRepository()) { teamServer = repository.Find(x => x.Id == server.TfsId); if (teamServer == null) { continue; } } // Get all tasks by id including to do items. List <WorkItem> userIncompleteItems = _teamServerManagementService .GetWorkItemsByIds(currentWeekTaskIdList, teamServer.Url, server.CredentialHash, includeIncompleteItems); using (WorkItemRepository workItemRepository = new WorkItemRepository()) { foreach (WorkItem item in userIncompleteItems) { // Add new items. UserWorkItem existingWorkItem = workItemRepository.Find(x => x.UserId == userId && x.WeekId == currentWeek.Id && x.TaskId == item.Id); if (existingWorkItem == null) { UserWorkItem newWorkItem = item.ToEntity(server.TfsId); newWorkItem.UserId = userId; newWorkItem.AssignedTo = currentUser.FirstName + " " + currentUser.LastName; newWorkItem.WeekId = currentWeek.Id; int newWorkItemId = workItemRepository.Insert(newWorkItem); currentWeekTasks.Add(newWorkItem.ToDto(newWorkItemId)); } else { existingWorkItem.Title = item.Title; existingWorkItem.Status = item.State; existingWorkItem.Sprint = item.IterationPath; existingWorkItem.Project = item.AreaPath; existingWorkItem.Description = item.Description; workItemRepository.Update(existingWorkItem); currentWeekTasks.Add(existingWorkItem.ToDto(existingWorkItem.Id)); } } } } return(currentWeekTasks); }
public List <WorkItemDto> GetUserIncompleteSyncedTasks(int serverId, string userId) { TeamServer server = null; List <WorkItemDto> workItemsDtoList = new List <WorkItemDto>(); UserServerInfo userServerInfo = null; try { using (TeamServerRepository teamServerRepository = new TeamServerRepository()) { server = teamServerRepository.GetById(serverId); if (server == null) { throw new Exception(string.Format("Invalid Server Id : {0}", serverId)); } } UserInfo userInfo = null; using (UserInfoRepository userInfoRepository = new UserInfoRepository()) { userInfo = userInfoRepository.Find(x => x.UserId == userId); if (userInfo == null) { throw new Exception(string.Format("User with ID {0} Not Found", userId)); } } using (UserServerInfoRepository userServerInfoRepository = new UserServerInfoRepository()) { userServerInfo = userServerInfoRepository.FindLocal( x => x.UserId == userId && x.TfsId == serverId ); if (userServerInfo == null) { throw new Exception(string.Format("User with id : {0} is not registered with server id : {1}", userId, serverId)); } } string credentialHash = userServerInfo.CredentialHash; string url = server.Url; WeekInfo currentWeek = null; using (WeekInfoRepository weekInfoRepository = new WeekInfoRepository()) { currentWeek = weekInfoRepository.GetCurrentWeekInfo(); if (currentWeek == null) { throw new Exception("Current Week is not registered."); } } List <WorkItem> tfsWorkItems = _teamServerManagementService.GetUserIncompleteItems(url, credentialHash); using (WorkItemRepository workItemRepository = new WorkItemRepository()) { foreach (WorkItem item in tfsWorkItems) { // Add new items. UserWorkItem existingWorkItem = workItemRepository.Find(x => x.UserId == userId && x.WeekId == currentWeek.Id && x.TaskId == item.Id); if (existingWorkItem == null) { UserWorkItem newWorkItem = item.ToEntity(userServerInfo.TfsId); newWorkItem.UserId = userId; newWorkItem.AssignedTo = userInfo.FirstName + " " + userInfo.LastName; newWorkItem.WeekId = currentWeek.Id; int newWorkItemId = workItemRepository.Insert(newWorkItem); workItemsDtoList.Add(newWorkItem.ToDto(newWorkItemId)); } else { existingWorkItem.Title = item.Title; existingWorkItem.Status = item.State; existingWorkItem.Sprint = item.IterationPath; existingWorkItem.Project = item.AreaPath; existingWorkItem.Description = item.Description; workItemRepository.Update(existingWorkItem); workItemsDtoList.Add(existingWorkItem.ToDto(existingWorkItem.Id)); } } } return(workItemsDtoList); } catch (Exception ex) { _logger.Error(ex); throw; } }