// Calculate time spent on a issue in given date range public IssueWorklog GetIssueTimeSpent(WorklogOfIssue workLogsOfIssue, DateTime toDate, DateTime fromDate) { int timeSpentSeconds = 0; string loggedInPerson = string.Empty; string timeSpent = string.Empty; IssueWorklog objIssueWorklog = new IssueWorklog(); List <LoggedInUserTimeSpent> objInUserTimeSpents = new List <LoggedInUserTimeSpent>(); foreach (Worklogs worklogs in workLogsOfIssue.Worklogs) { if (worklogs.Started.DateTime >= toDate && worklogs.Started.DateTime <= fromDate) { LoggedInUserTimeSpent objUserTimeSpent = new LoggedInUserTimeSpent(); if (objInUserTimeSpents.All(o => o.LoggedInPerson != worklogs.Author.Name)) { objUserTimeSpent.LoggedInPerson = worklogs.Author.Name; objUserTimeSpent.TimeSpent = worklogs.TimeSpentSeconds; objInUserTimeSpents.Add(objUserTimeSpent); } else { int index = objInUserTimeSpents.FindIndex(objLoggedInUserTimeSpent => objLoggedInUserTimeSpent.LoggedInPerson.Equals(worklogs.Author.Name, StringComparison.Ordinal)); objInUserTimeSpents.ElementAt(index).TimeSpent += worklogs.TimeSpentSeconds; } if (timeSpentSeconds > 0) { timeSpentSeconds = timeSpentSeconds + worklogs.TimeSpentSeconds; } else { timeSpentSeconds = worklogs.TimeSpentSeconds; } } } foreach (var loggedInDetails in objInUserTimeSpents) { if (!string.IsNullOrEmpty(timeSpent)) { loggedInPerson += "<br/>" + loggedInDetails.LoggedInPerson; } else { loggedInPerson = loggedInDetails.LoggedInPerson; } if (!string.IsNullOrEmpty(timeSpent)) { timeSpent += "<br/>" + loggedInDetails.TimeSpent; } else { timeSpent = loggedInDetails.TimeSpent.ToString(); } } objIssueWorklog.TimeSpentSeconds = timeSpentSeconds; objIssueWorklog.TimeSpent = timeSpent; objIssueWorklog.LoggedInPerson = loggedInPerson; return(objIssueWorklog); }
// Calculate time spent on a issue in given date range public IssueWorklog GetIssueTimeSpent(WorklogOfIssue workLogsOfIssue, DateTime toDate, DateTime fromDate) { int timeSpentSeconds = 0; string loggedInPerson = string.Empty; string timeSpent = string.Empty; IssueWorklog objIssueWorklog = new IssueWorklog(); List<LoggedInUserTimeSpent> objInUserTimeSpents = new List<LoggedInUserTimeSpent>(); foreach (Worklogs worklogs in workLogsOfIssue.Worklogs) { if (worklogs.Started.DateTime >= toDate && worklogs.Started.DateTime <= fromDate) { LoggedInUserTimeSpent objUserTimeSpent = new LoggedInUserTimeSpent(); if (objInUserTimeSpents.All(o => o.LoggedInPerson != worklogs.Author.Name)) { objUserTimeSpent.LoggedInPerson = worklogs.Author.Name; objUserTimeSpent.TimeSpent = worklogs.TimeSpentSeconds; objInUserTimeSpents.Add(objUserTimeSpent); } else { int index = objInUserTimeSpents.FindIndex(objLoggedInUserTimeSpent => objLoggedInUserTimeSpent.LoggedInPerson.Equals(worklogs.Author.Name,StringComparison.Ordinal)); objInUserTimeSpents.ElementAt(index).TimeSpent += worklogs.TimeSpentSeconds; } if (timeSpentSeconds > 0) { timeSpentSeconds = timeSpentSeconds + worklogs.TimeSpentSeconds; } else { timeSpentSeconds = worklogs.TimeSpentSeconds; } } } foreach (var loggedInDetails in objInUserTimeSpents) { if (!string.IsNullOrEmpty(timeSpent)) { loggedInPerson += "<br/>" + loggedInDetails.LoggedInPerson; } else { loggedInPerson = loggedInDetails.LoggedInPerson; } if (!string.IsNullOrEmpty(timeSpent)) { timeSpent += "<br/>" + loggedInDetails.TimeSpent; } else { timeSpent = loggedInDetails.TimeSpent.ToString(); } } objIssueWorklog.TimeSpentSeconds = timeSpentSeconds; objIssueWorklog.TimeSpent = timeSpent; objIssueWorklog.LoggedInPerson = loggedInPerson; return objIssueWorklog; }
public WorklogOfIssue GetWorkLogsForIssue(string issue) { string argument = issue + "/worklog"; string result = RunQuery(JiraResource.issue, argument); WorklogOfIssue response = JsonConvert.DeserializeObject <WorklogOfIssue>(result); return(response); }
// Process issue details and its worlogs public List <JiraTimeSheet> ProcessIssueWorkLogs(string issues, DateTime startDate, DateTime endDate) { List <JiraTimeSheet> jiraTimeSheetList = new List <JiraTimeSheet>(); JiraManager manager = new JiraManager(); int startAt = 0; int total; do { Expand keyDetailsList = manager.GetIssueDetails(issues, startAt); foreach (Issue keyDetails in keyDetailsList.IssueList) { //Call jira rest api to get all worklogs for a issue WorklogOfIssue workLogs = manager.GetWorkLogsForIssue(keyDetails.Key); IssueWorklog objWorklog = GetIssueTimeSpent(workLogs, startDate, endDate); if (objWorklog.TimeSpentSeconds > 0) { JiraTimeSheet jiraTimeSheet = new JiraTimeSheet(); foreach (FixVersion fixVersion in keyDetails.Fields.FixVersions) { if (!string.IsNullOrEmpty(jiraTimeSheet.FixVersions)) { jiraTimeSheet.FixVersions += fixVersion.Version; } else { jiraTimeSheet.FixVersions = fixVersion.Version; } } if (keyDetails.Fields.AssigneeName != null) { jiraTimeSheet.Assignee = keyDetails.Fields.AssigneeName.Name; } if (keyDetails.Fields.OriginalAssignee != null) { jiraTimeSheet.OriginalAssignee = keyDetails.Fields.OriginalAssignee.Originalassignee; } jiraTimeSheet.Created = keyDetails.Fields.CreatedDate.DateTime; jiraTimeSheet.IssueType = keyDetails.Fields.IssueType.Name; jiraTimeSheet.Key = keyDetails.Key; jiraTimeSheet.Project = keyDetails.Fields.Project.Name; jiraTimeSheet.Reporter = keyDetails.Fields.Reporter.reporter; jiraTimeSheet.Status = keyDetails.Fields.Status.Name; jiraTimeSheet.Summary = keyDetails.Fields.Summary; jiraTimeSheet.TimeLoggedBy = objWorklog.LoggedInPerson; jiraTimeSheet.TimeSpent = objWorklog.TimeSpent; jiraTimeSheet.TotalTimeSpent = objWorklog.TimeSpentSeconds; jiraTimeSheet.Updated = keyDetails.Fields.UpdatedDate.DateTime; if (keyDetails.Fields.Website != null) { jiraTimeSheet.Website = keyDetails.Fields.Website.WebSite; } jiraTimeSheetList.Add(jiraTimeSheet); } } total = keyDetailsList.Total; startAt = startAt + 50; } while (startAt < total); if (jiraTimeSheetList.Count > 0) { jiraTimeSheetList = jiraTimeSheetList.OrderBy(o => o.Updated).ThenBy(o => o.Created).ThenBy(o => o.FixVersions).ToList(); } return(jiraTimeSheetList); }