Пример #1
0
        /// <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);
            }
        }
Пример #2
0
        /// /// <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;
            }
        }