public string buildRequestBodyTestExecution(TestExecution testExecution) { FieldsTestExecution fields = new FieldsTestExecution { project = testExecution.fields.project, priority = testExecution.fields.priority, summary = testExecution.fields.summary, description = testExecution.fields.description, labels = testExecution.fields.labels, issuetype = new FieldByName { name = "Test Execution" }, environment = testExecution.fields.environment, versions = testExecution.fields.versions }; TestExecution testExecClone = new TestExecution { fields = fields }; var settings = new JsonSerializerSettings(); settings.NullValueHandling = NullValueHandling.Ignore; settings.DefaultValueHandling = DefaultValueHandling.Ignore; return(JsonConvert.SerializeObject(testExecClone, settings)); }
public static List <FieldsTestExecution> getDataTestExecution(String pathFile, string projectKey) { var result = new List <FieldsTestExecution>(); FileInfo fileInfo = new FileInfo(pathFile); ExcelPackage.LicenseContext = LicenseContext.NonCommercial; ExcelPackage package = new ExcelPackage(fileInfo); ExcelWorksheet worksheet = package.Workbook.Worksheets.FirstOrDefault(); // get number of rows and columns in the sheet int rows = worksheet.Dimension.Rows; // 20 for (int i = 2; i <= rows; i++) { FieldsTestExecution issue = new FieldsTestExecution(); issue.summary = getDataCell(worksheet.Cells[i, 1]); issue.description = getDataCell(worksheet.Cells[i, 2]); issue.labels = getDataCell(worksheet.Cells[i, 3]).Split(','); string component = getDataCell(worksheet.Cells[i, 4]); List <FieldByName> components = new List <FieldByName>(); if (!string.IsNullOrEmpty(component.Trim())) { string[] componentStrings = component.Split(','); foreach (var p in componentStrings) { if (!string.IsNullOrEmpty(p)) { components.Add(new FieldByName { name = p }); } } } issue.components = components.Count > 0 ? components : null; string version = getDataCell(worksheet.Cells[i, 5]); List <FieldByName> versions = new List <FieldByName>(); if (!string.IsNullOrEmpty(version)) { string[] versionsString = version.Split(','); foreach (var p in versionsString) { versions.Add(new FieldByName { name = p }); } } issue.versions = versions.Count > 0 ? versions : null; issue.priority = new FieldByName { name = getDataCell(worksheet.Cells[i, 6]) }; issue.environment = getDataCell(worksheet.Cells[i, 7]); issue.testEnvironment = getDataCell(worksheet.Cells[i, 8]); issue.testPlanKey = getDataCell(worksheet.Cells[i, 9]); issue.project = new FieldByKey { key = projectKey }; result.Add(issue); } return(result); }