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