/// <summary>
/// This method is default wizard action event
/// </summary>
/// <param name="WizardEventArgs"></param>
public void WizardEvent(WizardEventArgs WizardEventArgs)
{
mWizardEventArgs = WizardEventArgs;
switch (WizardEventArgs.EventType)
{
case EventType.Init:
break;
case EventType.Active:
Path = ((ImportDataSourceFromExcelWizard)mWizardEventArgs.Wizard).Path;
SheetName = ((ImportDataSourceFromExcelWizard)mWizardEventArgs.Wizard).SheetName;
HeadingRow = ((ImportDataSourceFromExcelWizard)mWizardEventArgs.Wizard).HeadingRow;
IsModelParamsFile = ((ImportDataSourceFromExcelWizard)mWizardEventArgs.Wizard).IsModelParamsFile;
IsImportEmptyColumns = ((ImportDataSourceFromExcelWizard)mWizardEventArgs.Wizard).IsImportEmptyColumns;
impParams.ExcelFileName = Path;
impParams.ExcelSheetName = SheetName;
DisplayData();
break;
case EventType.LeavingForNextPage:
if (xSelectRowTextBox.Text != null && !(string.IsNullOrWhiteSpace(xSelectRowTextBox.Text)))
{
impParams.ExcelWhereCondition = Convert.ToString(xSelectRowTextBox.Text);
DataTable dt = impParams.GetExceSheetlData(true);
if (dt != null)
{
xExcelDataGrid.ItemsSource = dt.AsDataView();
xExcelDataGridDockPanel.Visibility = Visibility.Visible;
}
DataSet TableWithWhereCondition = new DataSet();
dt.TableName = SheetName;
TableWithWhereCondition.Tables.Add(dt);
ExcelImportData = TableWithWhereCondition;
((ImportDataSourceFromExcelWizard)mWizardEventArgs.Wizard).ExcelImportData = ExcelImportData;
}
else
{
((ImportDataSourceFromExcelWizard)mWizardEventArgs.Wizard).ExcelImportData = ExcelImportData;
}
break;
default:
break;
}
}
/// <summary>
/// This event is used to view the data from excel with the condition
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void xExcelViewWhereButton_Click(object sender, RoutedEventArgs e)
{
try
{
Mouse.OverrideCursor = Cursors.Wait;
mWizardEventArgs.Wizard.ProcessStarted();
impParams.ExcelFileName = Path;
impParams.ExcelSheetName = SheetName;
impParams.ExcelWhereCondition = Convert.ToString(xSelectRowTextBox.Text);
DataTable dt = impParams.GetExceSheetlData(true);
if (dt != null)
{
xExcelDataGrid.ItemsSource = dt.AsDataView();
xExcelDataGridDockPanel.Visibility = Visibility.Visible;
}
mWizardEventArgs.Wizard.ProcessEnded();
Mouse.OverrideCursor = null;
}
catch (System.Exception ex)
{
Reporter.ToLog(eLogLevel.ERROR, $"Method - {MethodBase.GetCurrentMethod().Name}, Error - {ex.Message}", ex);
}
}
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");
}
