private static List <SeleniumTestParameters> GetRunInfo(String sheetName) { ExcelDataAccess runManagerAccess = new ExcelDataAccess(frameworkParameters.RelativePath, "Run Manager"); runManagerAccess.DatasheetName = sheetName; int nTestInstances = runManagerAccess.GetLastRowNum(); List <SeleniumTestParameters> testInstancesToRun = new List <SeleniumTestParameters>(); for (int currentTestInstance = 1; currentTestInstance <= nTestInstances; currentTestInstance++) { String executeFlag = runManagerAccess.GetValue(currentTestInstance, "Execute"); //Manik //string Env = ConfigurationManager.AppSettings["Environment"]; // if (executeFlag.Equals("Yes", StringComparison.CurrentCultureIgnoreCase)) { string currentScenario = runManagerAccess.GetValue(currentTestInstance, "Test_Scenario"); //Manik //string currentScenario = currentScenario1 + Env; //Manik string currentTestcase = runManagerAccess.GetValue(currentTestInstance, "Test_Case"); SeleniumTestParameters testParameters = new SeleniumTestParameters(currentScenario, currentTestcase); testParameters.CurrentTestDescription = runManagerAccess.GetValue(currentTestInstance, "Description"); testParameters.IterationMode = (IterationOptions)Enum.Parse(typeof(IterationOptions), runManagerAccess.GetValue(currentTestInstance, "Iteration_Mode")); String startIteration = runManagerAccess.GetValue(currentTestInstance, "Start_Iteration"); if (!startIteration.Equals("")) { testParameters.StartIteration = Convert.ToInt32(startIteration); } String endIteration = runManagerAccess.GetValue(currentTestInstance, "End_Iteration"); if (!endIteration.Equals("")) { testParameters.EndIteration = Convert.ToInt32(endIteration); } String browser = runManagerAccess.GetValue(currentTestInstance, "Browser"); if (!browser.Equals("")) { testParameters.Browser = (Browser)Enum.Parse(typeof(Browser), browser); } String browserVersion = runManagerAccess.GetValue(currentTestInstance, "Browser_Version"); if (!browserVersion.Equals("")) { testParameters.BrowserVersion = browserVersion; } String platform = runManagerAccess.GetValue(currentTestInstance, "Platform"); if (!platform.Equals("")) { testParameters.Platform = PlatformFactory.GetPlatform(platform); } testInstancesToRun.Add(testParameters); } } return(testInstancesToRun); }
private List <String> GetBusinessFlow() { ExcelDataAccess businessFlowAccess = new ExcelDataAccess(_frameworkParameters.RelativePath + Util.GetFileSeparator() + "Datatables", testParameters.CurrentScenario); businessFlowAccess.DatasheetName = "Business_Flow"; int rowNum = businessFlowAccess.GetRowNum(testParameters.CurrentTestcase, 0); if (rowNum == -1) { throw new FrameworkException("The test case \"" + testParameters.CurrentTestcase + "\" is not found in the Business Flow sheet!"); } String dataValue; List <String> businessFlowData = new List <String>(); int currentColumnNum = 1; while (true) { dataValue = businessFlowAccess.GetValue(rowNum, currentColumnNum); if (dataValue.Equals("")) { break; } businessFlowData.Add(dataValue); currentColumnNum++; } if (businessFlowData.Count() == 0) { throw new FrameworkException("No business flow found against the test case \"" + testParameters.CurrentTestcase + "\""); } return(businessFlowData); }