public void ImportOptionalFromExcelRegressionTest() { createPaymentProfileFileName = TestResources.GetTestResourcesFile(@"AutoPilot\ImportOptionalValue\createPayment.xml"); ImportOptionalValues.CreateParser(createPaymentProfileFileName); APIConfigurationsDocumentParserBase parser = ImportOptionalValues.CurrentParser; createPaymentProfileModels = parser.ParseDocument(createPaymentProfileFileName); ImportOptionalValues.ExcelFileName = TestResources.GetTestResourcesFile(@"AutoPilot\ImportOptionalValue\CretaePaymentOptinalValues.xlsx"); ImportOptionalValues.ExcelSheetName = "wsdl_createPayment"; DataTable dt = ImportOptionalValues.GetExceSheetlData(); Dictionary <string, List <string> > dic = ImportOptionalValues.UpdateParametersOptionalValuesFromCurrentExcelTable(); ImportOptionalValues.PopulateExcelDBOptionalValuesForAPIParametersExcelDB(createPaymentProfileModels[0], createPaymentProfileModels[0].AppModelParameters.ToList(), dic); Assert.AreEqual(createPaymentProfileModels.Count, 1, "APIModels count"); Assert.AreEqual(createPaymentProfileModels[0].AppModelParameters.Count, 26, "AppModelParameters count"); Assert.AreEqual(createPaymentProfileModels[0].AppModelParameters[0].OptionalValuesList.Count, 7, "Optional Values Count After Import From Excel"); Assert.AreEqual(dic.Count, 9, "Count of Parameters With New Optional Values"); }