public TestCase GetTestCase(int testCaseId, int suiteID)
{
#region Pull Test Case from TFS
PropertiesReader config = new PropertiesReader("config.txt");
Properties props = new Properties();
props.PersonalAccessToken = config.get("personalaccesstoken");
props.TestPlanId = Convert.ToInt32(config.get("testplanid"));
props.TestSuiteId = Convert.ToInt32(config.get("testsuiteid"));
props.Project = config.get("project");
props.Uri = config.get("server");
props.SaveLocation = config.get("saveLocation");
props.FileName = StringTools.addExtension(config.get("fileName"), "xlsx");;
props.ExecutionSheetName = config.get("executionsheetname");
props.ScriptSheetName = config.get("scriptsheetname");
props.TestPlanId = Convert.ToInt32(config.get("testplanid"));
props.TestSuiteId = Convert.ToInt32(config.get("testsuiteid"));
Logger logger = new Logger(props.SaveLocation);
props.Logger = logger;
TestCase thisTestCase = new TestCase();
RequirementsTraceabilityJobs requirementsTraceabilityJob = new RequirementsTraceabilityJobs(props);
thisTestCase = requirementsTraceabilityJob.GetSingleTestCase(testCaseId, suiteID);
return(thisTestCase);
}
public DocX CreateWordDoc(int testCaseId, int suiteID)
{
#region Pull Test Case from TFS
PropertiesReader config = new PropertiesReader("config.txt");
Properties props = new Properties();
props.PersonalAccessToken = config.get("personalaccesstoken");
props.TestPlanId = Convert.ToInt32(config.get("testplanid"));
props.TestSuiteId = Convert.ToInt32(config.get("testsuiteid"));
props.Project = config.get("project");
props.Uri = config.get("server");
props.SaveLocation = config.get("saveLocation");
props.FileName = StringTools.addExtension(config.get("fileName"), "xlsx");;
props.ExecutionSheetName = config.get("executionsheetname");
props.ScriptSheetName = config.get("scriptsheetname");
props.TestPlanId = Convert.ToInt32(config.get("testplanid"));
props.TestSuiteId = Convert.ToInt32(config.get("testsuiteid"));
Logger logger = new Logger(props.SaveLocation);
props.Logger = logger;
TestCase thisTestCase = new TestCase();
RequirementsTraceabilityJobs requirementsTraceabilityJob = new RequirementsTraceabilityJobs(props);
thisTestCase = requirementsTraceabilityJob.GetSingleTestCase(testCaseId, suiteID);
Color royalBlue = Color.FromName("RoyalBlue");
Color white = Color.FromName("White");
string testName = thisTestCase.TestCaseId.ToString() + "_" + thisTestCase.TestCaseName.Replace(" ", "_") + ".docx";
DocX doc = DocX.Create(testName);
var columnWidths = new float[] { 225f, 225f, 225f };
Table testSummary = doc.AddTable(2, 3);
//Test Objective table
doc.InsertParagraph("Test Objective").FontSize(16);
testSummary.Rows[0].Cells[0].Paragraphs.First().Append("#").Color(white);
testSummary.Rows[0].Cells[1].Paragraphs.First().Append("Title").Color(white);
testSummary.Rows[0].Cells[2].Paragraphs.First().Append("Test Objective").Color(white);
testSummary.Rows[0].Cells[0].FillColor = royalBlue;
testSummary.Rows[0].Cells[1].FillColor = royalBlue;
testSummary.Rows[0].Cells[2].FillColor = royalBlue;
testSummary.Rows[1].Cells[0].Paragraphs.First().Append(thisTestCase.TestCaseId.ToString());
testSummary.Rows[1].Cells[1].Paragraphs.First().Append(thisTestCase.TestDescription);
testSummary.Rows[1].Cells[2].Paragraphs.First().Append(thisTestCase.TestObjective);
testSummary.SetWidths(columnWidths);
doc.InsertTable(testSummary);
doc.InsertParagraph("Steps to follow").FontSize(16);
Table testActionResult = doc.AddTable(thisTestCase.TestSteps.Count + 1, 3);
testActionResult.SetWidths(columnWidths);
testActionResult.Rows[0].Cells[0].Paragraphs.First().Append("Steps").Color(white);
testActionResult.Rows[0].Cells[1].Paragraphs.First().Append("Action").Color(white);
testActionResult.Rows[0].Cells[2].Paragraphs.First().Append("Expected Result").Color(white);
testActionResult.Rows[0].Cells[0].FillColor = royalBlue;
testActionResult.Rows[0].Cells[1].FillColor = royalBlue;
testActionResult.Rows[0].Cells[2].FillColor = royalBlue;
int i = 0;
foreach (TestStep testStep in thisTestCase.TestSteps)
{
i++;
string action = Utility.RemoveTags(testStep.Action);
string expected = Utility.RemoveTags(testStep.Expected);
testActionResult.Rows[i].Cells[0].Paragraphs.First().Append(testStep.StepNumber.ToString());
testActionResult.Rows[i].Cells[1].Paragraphs.First().Append(action);
testActionResult.Rows[i].Cells[2].Paragraphs.First().Append(expected);
}
doc.InsertTable(testActionResult);
#endregion
return(doc);
}
public void CreateWordDocSuite(string userName, int planID, int suiteID, bool claims)
{
#region Boring stuff
// Test Case Pull
#region Pull Test Case from TFS
PropertiesReader config = new PropertiesReader("config.txt");
Properties props = new Properties();
props.PersonalAccessToken = config.get("personalaccesstoken");
props.TestPlanId = Convert.ToInt32(config.get("testplanid"));
props.TestSuiteId = Convert.ToInt32(config.get("testsuiteid"));
props.Project = config.get("project");
props.Uri = config.get("server");
props.SaveLocation = config.get("saveLocation");
props.FileName = StringTools.addExtension(config.get("fileName"), "xlsx");;
props.ExecutionSheetName = config.get("executionsheetname");
props.ScriptSheetName = config.get("scriptsheetname");
props.TestPlanId = Convert.ToInt32(config.get("testplanid"));
props.TestSuiteId = Convert.ToInt32(config.get("testsuiteid"));
#endregion
Color royalBlue = Color.FromName("RoyalBlue");
Color white = Color.FromName("White");
string location = "C:\\Users\\" + userName + "\\Desktop\\EvidenceSuite " + suiteID;
Logger logger = new Logger(location + "\\");
props.Logger = logger;
RequirementsTraceabilityJobs requirementsTraceabilityJob = new RequirementsTraceabilityJobs(props);
System.IO.Directory.CreateDirectory(location);
List <TestCase> cases = new List <TestCase>();
cases = requirementsTraceabilityJob.GetTestCaseGivenPlanSuite(planID, suiteID);
foreach (TestCase testCase in cases)
{
string fileName = "";
int currentID = testCase.TestCaseId;
string testName = testCase.TestCaseId.ToString() + "_" + testCase.TestCaseName.Replace("<", "Less Than").Replace(">", "Greater Than").Replace(" ", "_").Replace(")", "_").Replace("(", "_").Replace("/", "_").Replace("\\", "_").Replace(" - ", "_").Replace("\"", "_").Replace("'", "_").Replace("▪", "_").Replace("*", "_");
if (testName.Length > 150)
{
fileName = testName.Substring(0, 150);
}
else
{
fileName = testName;
}
DocX doc = DocX.Create(testName);
var columnWidths = new float[] { 225f, 225f, 400f };
Table testSummary = doc.AddTable(2, 3);
//Test Objective table
try
{
string TestDescription = testCase.TestDescription.Replace("<br>>", "\n >").Replace(" ", "").Replace(" ", "").Replace(">", ">").Replace(">", ">").Replace("<br>   ", "\n").Replace("condiditons", "conditions").Replace("<", "<").Replace("<br>", "\n").Replace(";", "").Replace(" ", " ");
doc.InsertParagraph("Test Objective").FontSize(16);
testSummary.Rows[0].Cells[0].Paragraphs.First().Append("#").Color(white);
testSummary.Rows[0].Cells[1].Paragraphs.First().Append("Title").Color(white);
testSummary.Rows[0].Cells[2].Paragraphs.First().Append("Test Objective").Color(white);
testSummary.Rows[0].Cells[0].FillColor = royalBlue;
testSummary.Rows[0].Cells[1].FillColor = royalBlue;
testSummary.Rows[0].Cells[2].FillColor = royalBlue;
testSummary.Rows[1].Cells[0].Paragraphs.First().Append(testCase.TestCaseId.ToString());
testSummary.Rows[1].Cells[1].Paragraphs.First().Append(TestDescription);
testSummary.Rows[1].Cells[2].Paragraphs.First().Append(testCase.TestObjective);
}catch (NullReferenceException e)
{
doc.InsertParagraph("Test Objective").FontSize(16);
testSummary.Rows[0].Cells[0].Paragraphs.First().Append("#").Color(white);
testSummary.Rows[0].Cells[1].Paragraphs.First().Append("Title").Color(white);
testSummary.Rows[0].Cells[2].Paragraphs.First().Append("Test Objective").Color(white);
testSummary.Rows[0].Cells[0].FillColor = royalBlue;
testSummary.Rows[0].Cells[1].FillColor = royalBlue;
testSummary.Rows[0].Cells[2].FillColor = royalBlue;
testSummary.Rows[1].Cells[0].Paragraphs.First().Append(testCase.TestCaseId.ToString());
testSummary.Rows[1].Cells[1].Paragraphs.First().Append("Test description is empty");
testSummary.Rows[1].Cells[2].Paragraphs.First().Append(testCase.TestObjective);
}
testSummary.SetWidths(columnWidths);
doc.InsertTable(testSummary);
doc.InsertParagraph("Steps to follow").FontSize(16);
Table testActionResult;
if (!claims)
{
testActionResult = doc.AddTable(testCase.TestSteps.Count + 1, 3);
//Console.WriteLine("Create three rows");
}
else
{
testActionResult = doc.AddTable(testCase.TestSteps.Count + 1, 4);
//Console.WriteLine("Create four rows");
}
testActionResult.SetWidths(columnWidths);
testActionResult.Rows[0].Cells[0].Paragraphs.First().Append("Steps").Color(white);
testActionResult.Rows[0].Cells[1].Paragraphs.First().Append("Action").Color(white);
testActionResult.Rows[0].Cells[2].Paragraphs.First().Append("Expected Result").Color(white);
testActionResult.Rows[0].Cells[0].FillColor = royalBlue;
testActionResult.Rows[0].Cells[1].FillColor = royalBlue;
testActionResult.Rows[0].Cells[2].FillColor = royalBlue;
if (claims)
{
testActionResult.Rows[0].Cells[3].Paragraphs.First().Append("Actual Result").Color(white);
testActionResult.Rows[0].Cells[3].FillColor = royalBlue;
}
int i = 0;
if (testCase.TestSteps.Count <= 0)
{
testSummary.Rows[1].Cells[0].Paragraphs.First().Append("Test ");
testSummary.Rows[1].Cells[1].Paragraphs.First().Append("Test ");
testSummary.Rows[1].Cells[2].Paragraphs.First().Append("Test ");
//if (claims)
//{
// testSummary.Rows[1].Cells[3].Paragraphs.First().Append("Test ");
//}
}
else
{
foreach (TestStep testStep in testCase.TestSteps)
{
i++;
string action = Utility.RemoveTags(testStep.Action).Replace("<br>>", "\n >").Replace(" ", "").Replace(" ", "").Replace(">", ">").Replace(">", ">").Replace("<br>   ", "\n").Replace("condiditons", "conditions").Replace("<", "<").Replace("<br>", "\n").Replace(";", "").Replace(" ", " ");
string expected = Utility.RemoveTags(testStep.Expected).Replace("<br>>", "\n >").Replace(" ", "").Replace(" ", "").Replace(">", ">").Replace(">", ">").Replace("<br>   ", "\n").Replace("condiditons", "conditions").Replace("<", "<").Replace("<br>", "\n").Replace(";", "").Replace(" ", " ");
//Console.WriteLine("Test Step " + i);
testActionResult.Rows[i].Cells[0].Paragraphs[0].Append(testStep.StepNumber.ToString());
testActionResult.Rows[i].Cells[1].Paragraphs.First().Append(action);
testActionResult.Rows[i].Cells[2].Paragraphs.First().Append(expected);
if (claims)
{
testActionResult.Rows[i].Cells[3].Paragraphs.First();
}
}
}
doc.InsertTable(testActionResult);
try
{
doc.SaveAs(location + "//" + fileName + ".docx");
}catch (Exception e)
{
Console.WriteLine("Unable to make test case " + testCase.TestCaseId + " due to invalid name");
}
}
;
#endregion
}
public void CreateWordDocSuite(string userName, int planID, int suiteID)
{
#region Boring stuff
// Test Case Pull
#region Pull Test Case from TFS
PropertiesReader config = new PropertiesReader("config.txt");
Properties props = new Properties();
props.PersonalAccessToken = config.get("personalaccesstoken");
props.TestPlanId = Convert.ToInt32(config.get("testplanid"));
props.TestSuiteId = Convert.ToInt32(config.get("testsuiteid"));
props.Project = config.get("project");
props.Uri = config.get("server");
props.SaveLocation = config.get("saveLocation");
props.FileName = StringTools.addExtension(config.get("fileName"), "xlsx");;
props.ExecutionSheetName = config.get("executionsheetname");
props.ScriptSheetName = config.get("scriptsheetname");
props.TestPlanId = Convert.ToInt32(config.get("testplanid"));
props.TestSuiteId = Convert.ToInt32(config.get("testsuiteid"));
Logger logger = new Logger(props.SaveLocation);
props.Logger = logger;
#endregion
Color royalBlue = Color.FromName("RoyalBlue");
Color white = Color.FromName("White");
RequirementsTraceabilityJobs requirementsTraceabilityJob = new RequirementsTraceabilityJobs(props);
string location = "C:\\Users\\" + userName + "\\Desktop\\Evidence Docs for Suite " + suiteID;
System.IO.Directory.CreateDirectory(location);
List <TestCase> cases = new List <TestCase>();
cases = requirementsTraceabilityJob.GetTestCaseGivenPlanSuite(planID, suiteID);
foreach (TestCase testCase in cases)
{
string testName = testCase.TestCaseId.ToString() + "_" + testCase.TestCaseName.Replace(" ", "_").Replace(")", "_").Replace("(", "_").Replace("/", "_").Replace("\\", "_").Replace(" - ", "_").Replace("\"", "_").Replace("'", "_");
DocX doc = DocX.Create(testName);
var columnWidths = new float[] { 225f, 225f, 225f };
Table testSummary = doc.AddTable(2, 3);
//Test Objective table
string TestDescription = testCase.TestDescription.Replace(" ", " ");
doc.InsertParagraph("Test Objective").FontSize(16);
testSummary.Rows[0].Cells[0].Paragraphs.First().Append("#").Color(white);
testSummary.Rows[0].Cells[1].Paragraphs.First().Append("Title").Color(white);
testSummary.Rows[0].Cells[2].Paragraphs.First().Append("Test Objective").Color(white);
testSummary.Rows[0].Cells[0].FillColor = royalBlue;
testSummary.Rows[0].Cells[1].FillColor = royalBlue;
testSummary.Rows[0].Cells[2].FillColor = royalBlue;
testSummary.Rows[1].Cells[0].Paragraphs.First().Append(testCase.TestCaseId.ToString());
testSummary.Rows[1].Cells[1].Paragraphs.First().Append(testCase.TestDescription);
testSummary.Rows[1].Cells[2].Paragraphs.First().Append(testCase.TestObjective);
testSummary.SetWidths(columnWidths);
doc.InsertTable(testSummary);
doc.InsertParagraph("Steps to follow").FontSize(16);
Table testActionResult = doc.AddTable(testCase.TestSteps.Count + 1, 3);
testActionResult.SetWidths(columnWidths);
testActionResult.Rows[0].Cells[0].Paragraphs.First().Append("Steps").Color(white);
testActionResult.Rows[0].Cells[1].Paragraphs.First().Append("Action").Color(white);
testActionResult.Rows[0].Cells[2].Paragraphs.First().Append("Expected Result").Color(white);
testActionResult.Rows[0].Cells[0].FillColor = royalBlue;
testActionResult.Rows[0].Cells[1].FillColor = royalBlue;
testActionResult.Rows[0].Cells[2].FillColor = royalBlue;
Console.WriteLine(testName);
int i = 0;
Console.WriteLine("Test Case Count " + testCase.TestSteps.Count);
foreach (TestStep testStep in testCase.TestSteps)
{
i++;
string action = Utility.RemoveTags(testStep.Action);
string expected = Utility.RemoveTags(testStep.Expected);
testActionResult.Rows[i].Cells[0].Paragraphs[0].Append(testStep.StepNumber.ToString());
testActionResult.Rows[i].Cells[1].Paragraphs.First().Append(action);
testActionResult.Rows[i].Cells[2].Paragraphs.First().Append(expected);
}
doc.InsertTable(testActionResult);
doc.SaveAs(location + "//" + testName + ".docx");
}
;
#endregion
}
public void TestTFS()
{
#region Start up
ExtentTest test = null;
DateTime now = DateTime.Now;
string testName = "TFSDoc";
DocX doc = DocX.Create(testName);
// Test Case Pull
PropertiesReader config = new PropertiesReader("config.txt");
Properties props = new Properties();
props.PersonalAccessToken = config.get("personalaccesstoken");
props.TestPlanId = Convert.ToInt32(config.get("testplanid"));
props.TestSuiteId = Convert.ToInt32(config.get("testsuiteid"));
props.Project = config.get("project");
props.Uri = config.get("server");
props.SaveLocation = config.get("saveLocation");
props.FileName = StringTools.addExtension(config.get("fileName"), "xlsx");;
props.ExecutionSheetName = config.get("executionsheetname");
props.ScriptSheetName = config.get("scriptsheetname");
props.TestPlanId = Convert.ToInt32(config.get("testplanid"));
props.TestSuiteId = Convert.ToInt32(config.get("testsuiteid"));
Logger logger = new Logger(props.SaveLocation);
props.Logger = logger;
TestCase thisTestCase = new TestCase();
RequirementsTraceabilityJobs requirementsTraceabilityJob = new RequirementsTraceabilityJobs(props);
thisTestCase = requirementsTraceabilityJob.GetSingleTestCase(152599, 152048);
foreach (TestStep testStep in thisTestCase.TestSteps)
{
string action = testStep.Action;
string expected = testStep.Expected;
}
#endregion
using (context)
{
context.Manage().Timeouts().ImplicitWait = TimeSpan.FromSeconds(10);
context.Url = "http://somedomain/url_that_delays_loading";
IWebElement myDynamicElement = context.FindElement(By.Id("someDynamicElement"));
}
using (context)
{
context.Url = "http://somedomain/url_that_delays_loading";
WebDriverWait wait = new WebDriverWait(context, TimeSpan.FromSeconds(10));
IWebElement myDynamicElement = wait.Until <IWebElement>(d => d.FindElement(By.Id("someDynamicElement")));
}
try
{
foreach (TestStep testStep in thisTestCase.TestSteps)
{
string action = testStep.Action;
string expected = testStep.Expected;
Paragraph par = doc.InsertParagraph(action + ": " + expected);
}
doc.Save();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
public void CreateDoctest()
{
// Test Case Pull
#region Pull Test Case from TFS
PropertiesReader config = new PropertiesReader("config.txt");
Utility utility = new Utility(context);
Properties props = new Properties();
props.PersonalAccessToken = config.get("personalaccesstoken");
props.TestPlanId = Convert.ToInt32(config.get("testplanid"));
props.TestSuiteId = Convert.ToInt32(config.get("testsuiteid"));
props.Project = config.get("project");
props.Uri = config.get("server");
props.SaveLocation = config.get("saveLocation");
props.FileName = StringTools.addExtension(config.get("fileName"), "xlsx");;
props.ExecutionSheetName = config.get("executionsheetname");
props.ScriptSheetName = config.get("scriptsheetname");
props.TestPlanId = Convert.ToInt32(config.get("testplanid"));
props.TestSuiteId = Convert.ToInt32(config.get("testsuiteid"));
Logger logger = new Logger(props.SaveLocation);
props.Logger = logger;
TestCase thisTestCase = new TestCase();
RequirementsTraceabilityJobs requirementsTraceabilityJob = new RequirementsTraceabilityJobs(props);
thisTestCase = requirementsTraceabilityJob.GetSingleTestCase(152501, 152045);
List <TestCase> cases = new List <TestCase>();
cases = requirementsTraceabilityJob.GetTestCaseGivenPlanSuite(149579, 152045);
string testName = thisTestCase.TestCaseId.ToString() + "_" + thisTestCase.TestCaseName.Replace(" ", "_");
DocX doc = DocX.Create(testName);
var columnWidths = new float[] { 225f, 225f, 225f };
Table testSummary = doc.AddTable(2, 3);
//Test Objective table
doc.InsertParagraph("Test Objective").FontSize(16);
testSummary.Rows[0].Cells[0].Paragraphs.First().Append("#");
testSummary.Rows[0].Cells[1].Paragraphs.First().Append("Title");
testSummary.Rows[0].Cells[2].Paragraphs.First().Append("Test Objective");
testSummary.Rows[1].Cells[0].Paragraphs.First().Append(thisTestCase.TestCaseId.ToString());
testSummary.Rows[1].Cells[1].Paragraphs.First().Append(thisTestCase.TestDescription);
testSummary.Rows[1].Cells[2].Paragraphs.First().Append(thisTestCase.TestObjective);
testSummary.SetWidths(columnWidths);
doc.InsertTable(testSummary);
doc.InsertParagraph("Steps to follow").FontSize(16);
Table testActionResult = doc.AddTable(thisTestCase.TestSteps.Count + 1, 3);
testActionResult.SetWidths(columnWidths);
testActionResult.Rows[0].Cells[0].Paragraphs.First().Append("Steps");
testActionResult.Rows[0].Cells[1].Paragraphs.First().Append("Action");
testActionResult.Rows[0].Cells[2].Paragraphs.First().Append("Expected Result");
int i = 0;
foreach (TestStep testStep in thisTestCase.TestSteps)
{
i++;
string action = Utility.RemoveTags(testStep.Action);
string expected = Utility.RemoveTags(testStep.Expected);
testActionResult.Rows[i].Cells[0].Paragraphs.First().Append(testStep.StepNumber.ToString());
testActionResult.Rows[i].Cells[1].Paragraphs.First().Append(action);
testActionResult.Rows[i].Cells[2].Paragraphs.First().Append(expected);
}
doc.InsertTable(testActionResult);
doc.Save();
Process.Start("WINWORD.EXE", testName);
#endregion
}
