/// <summary>
/// This method is default wizard action event
/// </summary>
/// <param name="WizardEventArgs"></param>
public void WizardEvent(WizardEventArgs WizardEventArgs)
{
switch (WizardEventArgs.EventType)
{
case EventType.Init:
mWizard = (ImportDataSourceFromExcelWizard)WizardEventArgs.Wizard;
xSheetNameComboBox.BindControl(mWizard, nameof(ImportDataSourceFromExcelWizard.SheetName));
xSheetNameComboBox.AddValidationRule(new EmptyValidationRule());
chkHeadingRow.BindControl(mWizard, nameof(ImportDataSourceFromExcelWizard.HeadingRow));
chkModelParamsFile.BindControl(mWizard, nameof(ImportDataSourceFromExcelWizard.IsModelParamsFile));
chkImportEmptyColumns.BindControl(mWizard, nameof(ImportDataSourceFromExcelWizard.IsImportEmptyColumns));
break;
case EventType.Active:
string excelPath = ((ImportDataSourceFromExcelWizard)WizardEventArgs.Wizard).Path;
if (!string.IsNullOrEmpty(excelPath))
{
impParams.ExcelFileName = excelPath;
List <string> SheetsList = impParams.GetSheets(false);
SheetsList.Insert(0, "-- All --");
GingerCore.General.FillComboFromList(xSheetNameComboBox, SheetsList);
if (SheetsList.Contains(mWizard.SheetName))
{
xSheetNameComboBox.SelectedIndex = SheetsList.IndexOf(mWizard.SheetName);
}
}
break;
default:
break;
}
}
/// <summary>
/// This event handles browsing of Script File from user desktop
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void xBrowseButton_Click(object sender, RoutedEventArgs e)
{
try
{
System.Windows.Forms.OpenFileDialog dlg = new System.Windows.Forms.OpenFileDialog();
dlg.Multiselect = false;
dlg.Filter = "Excel Files|*.xls;*.xlsx;*.xlsm";
System.Windows.Forms.DialogResult result = dlg.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
xPathTextBox.Text = dlg.FileName;
impParams.ExcelFileName = dlg.FileName;
List <string> SheetsList = impParams.GetSheets(false);
}
}
catch (System.Exception ex)
{
Reporter.ToLog(eAppReporterLogLevel.ERROR, $"Method - {MethodBase.GetCurrentMethod().Name}, Error - {ex.Message}", ex);
}
}
/// <summary>
/// This event handles browsing of Script File from user desktop
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void xBrowseButton_Click(object sender, RoutedEventArgs e)
{
try
{
if (General.SetupBrowseFile(new System.Windows.Forms.OpenFileDialog()
{
Multiselect = false,
Filter = "Excel Files|*.xls;*.xlsx;*.xlsm"
}, false) is string fileName)
{
xPathTextBox.Text = fileName;
impParams.ExcelFileName = fileName;
List <string> SheetsList = impParams.GetSheets(false);
}
}
catch (System.Exception ex)
{
Reporter.ToLog(eLogLevel.ERROR, $"Method - {MethodBase.GetCurrentMethod().Name}, Error - {ex.Message}", ex);
}
}
