/// <summary>
/// This method is used to display the data for the selected sheet
/// </summary>
private void DisplayData()
{
try
{
Mouse.OverrideCursor = Cursors.Wait;
mWizardEventArgs.Wizard.ProcessStarted();
if (SheetName != "-- All --")
{
xExcelDataGrid.Visibility = Visibility.Visible;
tabDynamic.Visibility = Visibility.Collapsed;
SelectPanel.Visibility = Visibility.Visible;
xExcelGridSplitter.Visibility = Visibility.Visible;
ExcelImportData = impParams.GetExcelAllSheetData(SheetName, HeadingRow, true, IsModelParamsFile);
if (ExcelImportData != null && ExcelImportData.Tables.Count >= 1)
{
if (ExcelImportData.Tables.Count == 1)
{
xExcelDataGrid.ItemsSource = ExcelImportData.Tables[0].AsDataView();
xExcelDataGridDockPanel.Visibility = Visibility.Visible;
}
}
}
else
{
SelectPanel.Visibility = Visibility.Collapsed;
xExcelGridSplitter.Visibility = Visibility.Collapsed;
xExcelDataGrid.Visibility = Visibility.Collapsed;
tabDynamic.Visibility = Visibility.Visible;
xExcelDataGridDockPanel.Visibility = Visibility.Visible;
ExcelImportData = impParams.GetExcelAllSheetData(SheetName, HeadingRow, true, IsModelParamsFile);
if (ExcelImportData != null && ExcelImportData.Tables.Count >= 1)
{
_tabItems = new List <TabItem>();
foreach (DataTable dt in ExcelImportData.Tables)
{
AddTabItem(dt.TableName, dt);
}
// bind tab control
tabDynamic.DataContext = _tabItems;
tabDynamic.SelectedIndex = 0;
}
}
mWizardEventArgs.Wizard.ProcessEnded();
Mouse.OverrideCursor = null;
}
catch (System.Exception ex)
{
Reporter.ToLog(eLogLevel.ERROR, $"Method - {MethodBase.GetCurrentMethod().Name}, Error - {ex.Message}", ex);
mWizardEventArgs.Wizard.ProcessEnded();
Mouse.OverrideCursor = null;
}
}
/// <summary>
/// This method is the final finish method
/// </summary>
public override void Finish()
{
try
{
ImportOptionalValuesForParameters impParams = new ImportOptionalValuesForParameters();
impParams.ExcelFileName = Path;
impParams.ExcelSheetName = SheetName;
if (ExcelImportData == null || ExcelImportData.Tables.Count <= 0)
{
ExcelImportData = impParams.GetExcelAllSheetData(SheetName, HeadingRow, IsImportEmptyColumns, IsModelParamsFile);
}
foreach (DataTable dt in ExcelImportData.Tables)
{
string cols = GetColumnNameListForTableCreation(dt);
AddDefaultColumn(dt);
CreateTable(dt.TableName, cols);
mDSDetails.SaveTable(dt);
}
}
catch (System.Exception ex)
{
Reporter.ToLog(eLogLevel.ERROR, $"Method - {MethodBase.GetCurrentMethod().Name}, Error - {ex.Message}", ex);
}
}
