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;
}
}
