private void ExportToExcel(object sender, System.Windows.RoutedEventArgs e) { Ginger.DataSource.DataSourceExportToExcel DSEE = new Ginger.DataSource.DataSourceExportToExcel(); DSEE.ShowAsWindow(); string SolutionFolder = WorkSpace.Instance.Solution.Folder.ToUpper(); string sExcelPath = DSEE.mExcelConfig.ExcelPath; string sSheetName = DSEE.mExcelConfig.ExcelSheetName; if (sExcelPath != "") { if (sExcelPath.Contains(SolutionFolder)) { sExcelPath = sExcelPath.Replace(SolutionFolder, @"~\"); } } if (sExcelPath == "") { return; } //Add Data Source Tables List DSDetails.DSTableList = DSDetails.GetTablesList(); foreach (DataSourceTable dsTable in DSDetails.DSTableList) { Reporter.ToStatus(eStatusMsgKey.ExportItem, null, dsTable.Name, "Data Source Table"); dsTable.DSC.ExporttoExcel(dsTable.Name, sExcelPath, dsTable.Name); } Reporter.HideStatusMessage(); Reporter.ToUser(eUserMsgKey.ExportDetails); }
List <ITreeViewItem> ITreeViewItem.Childrens() { List <ITreeViewItem> Childrens = new List <ITreeViewItem>(); //Get Data Source Tables List DSDetails.DSTableList = DSDetails.GetTablesList(); if (DSDetails.DSTableList == null) { DSDetails.DSTableList = new ObservableList <DataSourceTable>(); } foreach (DataSourceTable dsTable in DSDetails.DSTableList) { if (TableTreeView == DataSourceFolderTreeItem.eDataTableView.All || (TableTreeView == DataSourceFolderTreeItem.eDataTableView.Key && dsTable.DSTableType == DataSourceTable.eDSTableType.GingerKeyValue) || (TableTreeView == DataSourceFolderTreeItem.eDataTableView.Customized && dsTable.DSTableType == DataSourceTable.eDSTableType.Customized)) { DataSourceTableTreeItem DSTTI = new DataSourceTableTreeItem(); DSTTI.DSTableDetails = dsTable; DSTTI.DSDetails = DSDetails; Childrens.Add(DSTTI); } } return(Childrens); }