public static SortedDictionary <string, string> GetAllTestCases(string suites, string planId) { SortedDictionary <string, string> lsTestCasesQuery = new SortedDictionary <string, string>(); try { ITestSuiteHelper iTSuiteHelp = proj.TestSuites; string[] suiteArray = suites.Split(','); foreach (string str in suiteArray) { ITestSuiteBase iTSB = iTSuiteHelp.Find(Convert.ToInt32(str)); ITestCaseCollection itCColl = iTSB.AllTestCases; foreach (ITestCase iTc in itCColl) { lsTestCasesQuery.Add(iTc.Id.ToString(), iTc.Title.ToString()); } } } catch (Exception ex) { lsTestCasesQuery.Add("-1", "Error. Load Project,pland and config"); } return(lsTestCasesQuery); }
void Access_Excel(ITestCaseCollection testcases) { try { FileInfo new_file = new FileInfo(File_Name.Text); // FileInfo template = new FileInfo(System.Windows.Forms.Application.StartupPath + "\\Resources\\Test_Case_Template.xlsx"); FileInfo template = new FileInfo(Directory.GetCurrentDirectory() + "\\Test_Case_Template.xlsx"); using (ExcelPackage xlpackage = new ExcelPackage(new_file,template)) { ExcelWorksheet worksheet = xlpackage.Workbook.Worksheets["Test Case"]; GetTestCases(testcases, worksheet); xlpackage.Save(); MessageBox.Show("File has been saved at " + File_Name.Text); } } catch (Exception theException) { String errorMessage; errorMessage = "Error: "; errorMessage = String.Concat(errorMessage, theException.Message); errorMessage = String.Concat(errorMessage, " Line: "); errorMessage = String.Concat(errorMessage, theException.Source); MessageBox.Show(errorMessage, "Error"); } }
/// <summary> /// Проходит по всем тестовым ситуациям тестового плана и заполняет Excel таблицу, /// указывая подзаголовком категорию теста - наименования тестовой ситуации. /// </summary> private void ByTestSuites() { try { this.plans = teamProject.TestPlans.Query("Select * From TestPlan"); foreach (ITestPlan plan in plans) { if (plan.Name == testPlanName) { this.testSuites = plan.RootSuite.Entries; } } foreach (ITestSuiteEntry suite_entry in testSuites) { this.suite = suite_entry; IStaticTestSuite newSuite = suite_entry.TestSuite as IStaticTestSuite; if (newSuite != null) { xlWorkSheet.get_Range("a" + row, "d" + row).Merge(true); xlWorkSheet.Cells[row, 1] = newSuite.Title; xlWorkSheet.Cells[row, 1].Font.Bold = true; xlWorkSheet.Cells[row, 1].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; row = row + 1; ITestCaseCollection cases = newSuite.AllTestCases; ByTestCases(cases); } else { ITestCase test = suite_entry.TestCase as ITestCase; if (test != null) { ByTest(test); } } } } catch { } }
static void Main(string[] args) { var u = new Uri("http://server:8080/tfs/DefaultCollection"); var c = new VssClientCredentials(); TfsTeamProjectCollection tpc = new TfsTeamProjectCollection(u, c); tpc.EnsureAuthenticated(); ITestManagementService itms = tpc.GetService <ITestManagementService>(); ITestManagementTeamProject ittp = itms.GetTeamProject("LCScrum"); ITestSuiteBase suite = ittp.TestSuites.Find(352); ITestCaseCollection testCaseCollection = suite.AllTestCases; foreach (var tc in testCaseCollection) { ITestCase testcase = ittp.TestCases.Find(tc.Id); foreach (ITestAction action in testcase.Actions) { Console.WriteLine(String.Format("{0} - {1}", testcase.Id, action)); } } Console.Read(); }
void GetTestCases(ITestCaseCollection testcases, ExcelWorksheet oSheet) { int i = 2; foreach (ITestCase Testcase in testcases) { int j = 1; string str1 = null; string str2 = null; foreach (ITestAction action in Testcase.Actions) { ISharedStep shared_step = null; ISharedStepReference shared_ref = action as ISharedStepReference; if (shared_ref != null) { shared_step = shared_ref.FindSharedStep(); foreach (ITestAction shr_action in shared_step.Actions) { var test_step = shr_action as ITestStep; str1 = str1 + j.ToString() + "." + ((test_step.Title.ToString().Length ==0)? "<<Not Recorded>>" : test_step.Title.ToString()) + System.Environment.NewLine; str2 = str2 + j.ToString() + "." + ((test_step.ExpectedResult.ToString().Length ==0) ? "<<Not Recorded>>" : test_step.ExpectedResult.ToString()) + System.Environment.NewLine; j++; } } else { var test_step = action as ITestStep; str1 = str1 + j.ToString() + "." + ((test_step.Title.ToString().Length ==0) ? "<<Not Recorded>>" : test_step.Title.ToString()) + System.Environment.NewLine; str2 = str2 + j.ToString() + "." + ((test_step.ExpectedResult.ToString().Length ==0) ? "<<Not Recorded>>" : test_step.ExpectedResult.ToString()) + System.Environment.NewLine; j++; } } string result = null; string tot_result = null; foreach (ITestPoint test_point in TP.QueryTestPoints(string.Format("Select * from TestPoint where TestCaseId = {0} ", Testcase.Id))) { ITestCaseResult tc_res = test_point.MostRecentResult; if (tc_res != null) { if (tc_res.Outcome.ToString().Equals("None")) result= tc_res.TestConfigurationName + " : In Progress" + System.Environment.NewLine; else result = tc_res.TestConfigurationName + " : " + tc_res.Outcome.ToString() + System.Environment.NewLine; } else result = test_point.ConfigurationName + " : Active" + System.Environment.NewLine; tot_result = tot_result + result; } Query query = new Query(_store,string.Format("SELECT [Target].[System.Id] FROM WorkItemLinks WHERE ([Source].[System.Id] = {0}) and ([Source].[System.WorkItemType] = 'Test Case') And ([Target].[System.WorkItemType] = 'Bug')mode(MustContain)", Testcase.Id)); WorkItemLinkInfo[] workItemLinkInfoArray = null; if (query.IsLinkQuery) { workItemLinkInfoArray = query.RunLinkQuery(); } else { throw new Exception("Run link query fail. Query passed is not a link query"); } string bug_list = null; for (int k = 0; k < workItemLinkInfoArray.Length; k++) { if (workItemLinkInfoArray[k].LinkTypeId != 0) bug_list = bug_list + workItemLinkInfoArray[k].TargetId.ToString() + System.Environment.NewLine; } oSheet.Cells[i, 1].Value = Testcase.Id.ToString(); oSheet.Cells[i, 2].Value = Testcase.Title.ToString(); oSheet.Cells[i, 3].Value = str1; oSheet.Cells[i, 4].Value = str2; oSheet.Cells[i, 8].Value = Testcase.WorkItem.CreatedBy.ToString(); oSheet.Cells[i, 5].Value = Testcase.Description.ToString() + " "; oSheet.Cells[i, 9].Value = tot_result; oSheet.Cells[i, 10].Value = bug_list; i++; } }
private void Get_TestCases(IStaticTestSuite testSuite) { this.testCases = testSuite.AllTestCases; }
public void CloneTestCases(ITestSuiteBase suite, ITestSuiteBase destinationSuite) { ITestCaseCollection testCases = suite.AllTestCases; AddTestCasesToSuite(testCases, destinationSuite); }