@BeforeTest
public void checkCaseToRun() throws IOException {
// Called init() function from SuiteBase class to Initialize .xls Files
init();
// To set SuiteTwo.xls file's path In FilePath Variable.
FilePath = TestCaseListExcelTwo;
TestCaseName = this.getClass().getSimpleName();
// SheetName to check CaseToRun flag against test case.
SheetName = "TestCasesList";
// Name of column In TestCasesList Excel sheet.
ToRunColumnNameTestCase = "CaseToRun";
// Name of column In Test Case Data sheets.
ToRunColumnNameTestData = "DataToRun";
// To check test case's CaseToRun = Y or N In related excel sheet.
// If CaseToRun = N or blank, Test case will skip execution. Else It will be executed.
if (!SuiteUtility.checkToRunUtility(
FilePath, SheetName, ToRunColumnNameTestCase, TestCaseName)) {
// To report result as skip for test cases In TestCasesList sheet.
SuiteUtility.WriteResultUtility(FilePath, SheetName, "Pass/Fail/Skip", TestCaseName, "SKIP");
// To throw skip exception for this test case.
throw new SkipException(
TestCaseName
+ "'s CaseToRun Flag Is 'N' Or Blank. So Skipping Execution Of "
+ TestCaseName);
}
// To retrieve DataToRun flags of all data set lines from related test data sheet.
TestDataToRun =
SuiteUtility.checkToRunUtilityOfData(FilePath, TestCaseName, ToRunColumnNameTestData);
}
// @AfterMethod method will be executed after execution of @Test method every time.
@AfterMethod
public void reporterDataResults() {
if (Testskip) {
// If found Testskip = true, Result will be reported as SKIP against data set line In excel
// sheet.
SuiteUtility.WriteResultUtility(
FilePath, TestCaseName, "Pass/Fail/Skip", DataSet + 1, "SKIP");
} else if (Testfail) {
// To make object reference null after reporting In report.
s_assert = null;
// Set TestCasePass = false to report test case as fail In excel sheet.
TestCasePass = false;
// If found Testfail = true, Result will be reported as FAIL against data set line In excel
// sheet.
SuiteUtility.WriteResultUtility(
FilePath, TestCaseName, "Pass/Fail/Skip", DataSet + 1, "FAIL");
} else {
// If found Testskip = false and Testfail = false, Result will be reported as PASS against
// data set line In excel sheet.
SuiteUtility.WriteResultUtility(
FilePath, TestCaseName, "Pass/Fail/Skip", DataSet + 1, "PASS");
}
// At last make both flags as false for next data set.
Testskip = false;
Testfail = false;
}
// To report result as pass or fail for test cases In TestCasesList sheet.
@AfterTest
public void closeBrowser() {
// To Close the web browser at the end of test.
closeWebBrowser();
if (TestCasePass) {
SuiteUtility.WriteResultUtility(FilePath, SheetName, "Pass/Fail/Skip", TestCaseName, "PASS");
} else {
SuiteUtility.WriteResultUtility(FilePath, SheetName, "Pass/Fail/Skip", TestCaseName, "FAIL");
}
}
// This data provider method will return 3 column's data one by one In every Iteration.
@DataProvider
public Object[][] SuiteTwoCaseOneData() {
// To retrieve data from Data 1 Column,Data 2 Column and Expected Result column of
// SuiteTwoCaseOne data Sheet.
// Last two columns (DataToRun and Pass/Fail/Skip) are Ignored programatically when reading test
// data.
return SuiteUtility.GetTestDataUtility(FilePath, TestCaseName);
}