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