/// <summary> /// Buffer application value. /// </summary> private void BufferApps() { var applicationClass = new ApplicationClass(); try { TestCase.TestStepList = new List <TestStep>(); TestCase.UiControls = new List <UiControl>(); ConfigStep.TestConfigNames = new List <ConfigStep>(); TestCase.Verifications = new List <Verification>(); Data.LoadUiControls(applicationClass); Data.LoadVerifications(applicationClass); Data.LoadTestCases(applicationClass); } catch (Exception ex) { LogHelper.ErrorLog(ex, Entities.Constants.ClassName.UiActionsClassName, MethodBase.GetCurrentMethod().Name); } finally { WorkBookUtility.CloseExcel(applicationClass); } }
/// /// <summary> /// This function Loads Web Service API Data. /// </summary> /// <param name="applicationClass">Application class.</param> /// <value>Application class value.</value> public void LoadAPIResponseData(ApplicationClass applicationClass) { try { var workbook = WorkBookUtility.OpenWorkBook(applicationClass, TestCase.RootFilePath + new StringBuilder().Append(ConfigurationManager.AppSettings.Get(Entities.Constants.AppSetting.LoadWebServiceAPIData))); dynamic worksheet = (Worksheet)workbook.Worksheets[1]; var rowsCount = worksheet.UsedRange.Rows.Count; var cellCount = worksheet.UsedRange.Columns.Count + 1; for (var rowindex = 2; rowindex <= rowsCount; rowindex++) { if (string.IsNullOrEmpty(Convert.ToString(worksheet.Cells[rowindex, 1].value))) { break; //// reading the sheet untill the first empty row } else { requestURL = Convert.ToString(worksheet.Cells[rowindex, 3].value); webRequest = (HttpWebRequest)HttpWebRequest.Create(requestURL); response = (HttpWebResponse)webRequest.GetResponse(); streamReader = new StreamReader(response.GetResponseStream()); singleAPIResponseData = streamReader.ReadToEnd(); if (!singleAPIResponseData.StartsWith("[")) { singleAPIResponseData = singleAPIResponseData.Replace(singleAPIResponseData, "[" + singleAPIResponseData + "]"); } dynamic jsonObject = JArray.Parse(singleAPIResponseData); responseDataList.Add(jsonObject); } } WorkBookUtility.CloseWorkBook(workbook); } catch (Exception ex) { LogHelper.ErrorLog(ex, Entities.Constants.ClassName.Data, MethodBase.GetCurrentMethod().Name); throw; } }