public static object[] getData(ExcelReaderFile xls, string testCaseName)
{
string sheetName = "Data";
// Read data for only testCaseName
int testStartRowNum = 1;
//int colStartRowNum = 1;
while (!xls.getCellData(sheetName, 0, testStartRowNum).Equals(testCaseName))
{
testStartRowNum++;
}
Console.WriteLine("Test starts from row : " + testStartRowNum);
int colStartRowNum = 1 + testStartRowNum;
int dataStartRowNum = 2 + testStartRowNum;
// Calculate rows of data
int rows = 0;
while (!xls.getCellData(sheetName, 0, dataStartRowNum + rows).Equals(""))
{
rows++;
}
Console.WriteLine("Total number of rows : " + rows);
// Calculate total number of cols
int cols = 0;
while (!xls.getCellData(sheetName, cols, colStartRowNum).Equals(""))
{
cols++;
}
Console.WriteLine("Total number of cols : " + cols);
// Read data
object[][] data = new object[rows][];
int dataRow = 0;
Dictionary <string, string> table = null;
for (int rNum = dataStartRowNum; rNum < dataStartRowNum + rows; rNum++)
{
data[rNum - dataStartRowNum] = new object[1];
table = new Dictionary <string, string>();
for (int cNum = 0; cNum < cols; cNum++)
{
string key = xls.getCellData(sheetName, cNum, colStartRowNum);
string value = xls.getCellData(sheetName, cNum, rNum);
table.Add(key, value);
}
data[dataRow][0] = table;
dataRow++;
}
return(data);
}
public static bool isSkip(ExcelReaderFile xls, string testCaseName)
{
// true - N
// false - Y
int rows = xls.getRowCount("TestCases");
for (int rNum = 2; rNum <= rows; rNum++)
{
string tcid = xls.getCellData("TestCases", "TCID", rNum);
if (tcid.Equals(testCaseName))
{
return(true);
}
}
return(true);
}
public void executeKeywords(string testUnderExecution, ExcelReaderFile xls, Dictionary <string, string> testData)
{
app = new AppKeywords(test);
int rows = xls.getRowCount(Constants.SHEETNAME);
for (int rNum = 2; rNum <= rows; rNum++)
{
//app.reportFailure("Error Message");
string TCID = xls.getCellData(Constants.SHEETNAME, Constants.TCID_COL, rNum);
if (TCID.Equals(testUnderExecution))
{
string data = null;
string keyword = xls.getCellData(Constants.SHEETNAME, Constants.KEYWORD_COL, rNum);
string objct = xls.getCellData(Constants.SHEETNAME, Constants.OBJECT_COL, rNum);
string key = xls.getCellData(Constants.SHEETNAME, Constants.DATA_COL, rNum);
if (!key.Equals(""))
{
data = testData[key];
}
test.Log(Status.Info, TCID + "-----" + keyword + "-----" + objct + "-----" + data);
string result = "";
if (keyword.Equals("openBrowser"))
{
result = app.openBrowser(data);
}
else if (keyword.Equals("navigate"))
{
result = app.navigate(objct);
}
else if (keyword.Equals("input"))
{
result = app.input(objct, data);
}
else if (keyword.Equals("input"))
{
result = app.input(objct, data);
}
else if (keyword.Equals("click"))
{
result = app.click(objct);
}
else if (keyword.Equals("closeBrowser"))
{
result = app.closeBrowser();
}
else if (keyword.Equals("wait"))
{
result = app.wait(objct);
}
else if (keyword.Equals("verifyElementPresent"))
{
result = app.verifyElementPresent(objct);
}
else if (keyword.Equals("verifyElementNotPresent"))
{
result = app.verifyElementNotPresent(objct);
}
else if (keyword.Equals("list_of_elements"))
{
result = app.list_of_elements(objct);
}
else if (keyword.Equals("verify"))
{
result = app.verify();
}
if (!result.Equals(Constants.PASS))
{
Assert.Fail(result);
}
}
}
}
