Beispiel #1
0
        public static List<Dictionary<String, String>> GetTestData(String suiteFilePath, String testCaseName)
        {
            List<Dictionary<String, String>> listOfData = new List<Dictionary<string, string>>();

            ExcelHelper eh = new ExcelHelper(GetAbsolutePathOfDataFile(suiteFilePath));

            // Find Row Number for testCaseName - by searching it in first Column
            int testRowNumber = eh.GetRowNumber("Data", 1, testCaseName);

            int colHeadersRowNumber = testRowNumber + 1;

            int testDataRowId = colHeadersRowNumber + 1;
            int endRowId = testDataRowId;
            while (!eh.GetCellData("Data", 1, endRowId).Equals(""))
                endRowId++;

            for (int i = testDataRowId; i < endRowId; i++)
            {
                Dictionary<String, String> data = new Dictionary<string, string>();
                int colId = 1;
                while (!eh.GetCellData("Data", colId, colHeadersRowNumber).Equals(""))
                {
                    data.Add(eh.GetCellData("Data", colId, colHeadersRowNumber), eh.GetCellData("Data", colId, i));
                    colId++;
                }

                listOfData.Add(data);
            }

            return listOfData;
        }
Beispiel #2
0
        public static bool IsTestSelected(String suiteFilePath, String testName)
        {
            ExcelHelper eh = new ExcelHelper(GetAbsolutePathOfDataFile(suiteFilePath));
            int testCaseRowNumber = eh.GetRowNumber("TestCases", "TestCases", testName);
            String runModeValue = eh.GetCellData("TestCases", "Runmode", testCaseRowNumber);

            // APPROACH 2
            return runModeValue.Equals("Y", StringComparison.OrdinalIgnoreCase);
        }
Beispiel #3
0
        public static bool IsSuiteSelected(String suitesFilePath, String suiteName)
        {
            ExcelHelper eh = new ExcelHelper(GetAbsolutePathOfDataFile(suitesFilePath));
            int suiteRowNumber = eh.GetRowNumber("Suite", "SuiteName", suiteName);
            String runModeValue = eh.GetCellData("Suite", "Runmode", suiteRowNumber);

            // APPROACH 1
            if (runModeValue.Equals("Y", StringComparison.OrdinalIgnoreCase))
                return true;
            return false;
        }