private void ProcessRow(Project p, Run r, Result result, Models.JiraModels.Issue issue)
{
QueriedItems.Add(new ReportRow()
{
ProjectID = p.ID,
ProjectName = p.Name,
SuiteID = r.Suite.ID,
Milestone = r.Milestone.SprintName,
Run = r.Name,
IsCompleted = r.IsCompleted,
TestID = "T" + result.Test.ID,
CaseID = "C" + result.Test.Case.ID,
Case = result.Test.Case.Title,
Defects = result.Defects,
TestedBy = result.TestedBy.Name,
TestedOn = result.TestedOn.ToString(),
Status = result.Status.Name,
Priority = result.Test.Priority.Name,
Area = result.Test.Area.Name,
Feature = result.Test.Feature.Name,
Reference = result.Test.Reference,
Type = result.Test.Type.Name,
RunID = "R" + r.ID,
Bug_Key = issue.Key,
Bug_ProjectName = issue.ProjectName,
Bug_CreatedBy = issue.Creator,
Bug_CreatedOn = issue.Created.ToString(),
Bug_Resolution = issue.Resolution.ToString(),
Bug_Status = issue.Status,
Bug_Priority = issue.Priority
});
}
private Task <Boolean> ExportExcel(String filelocation)
{
return(Task.Run <Boolean>
(
async() =>
{
SetInfo("Preparing data to export file " + filelocation);
if (QueriedItems.Count < 1)
{
SetInfo("There are not items to export" + Environment.NewLine);
return false;
}
var data = QueriedItems.ToDataTable();
SetInfo("Exporting file...");
var result = await WorkbookCreation.WriteDataTableToExcel(data, filelocation);
SetInfo("Exported file " + filelocation);
return result;
}
));
}
