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");
}
