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);
}
Page ITreeViewItem.EditPage()
{
DSDetails.SaveBackup();//to mark the Data Source as changed
if (mDataSourceTablePage == null)
{
mDataSourceTablePage = new DataSourceTablePage(DSTableDetails);
}
return(mDataSourceTablePage);
}
Page ITreeViewItem.EditPage(Amdocs.Ginger.Common.Context mContext)
{
DSDetails.SaveBackup();//to mark the Data Source as changed
DSDetails.StartDirtyTracking();
if (mDataSourceTablePage == null)
{
mDataSourceTablePage = new DataSourceTablePage(DSTableDetails);
}
return(mDataSourceTablePage);
}
private void Duplicate(object sender, RoutedEventArgs e)
{
if (Reporter.ToUser(eUserMsgKey.LooseLocalChanges) == Amdocs.Ginger.Common.eUserMsgSelection.No)
{
return;
}
DataSourceTable copy = (DataSourceTable)DSTableDetails.CreateCopy();
copy.Name = DSDetails.CopyTable(DSTableDetails.Name);
copy.DataTable = DSTableDetails.DataTable;
copy.DSC = DSTableDetails.DSC;
copy.DSTableType = DSTableDetails.DSTableType;
DSDetails.DSTableList.Add(copy);
mTreeView.Tree.RefreshSelectedTreeNodeParent();
}
/// <summary>
/// This method is used to add new KeyValue table
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AddNewKeyValueTable(object sender, System.Windows.RoutedEventArgs e)
{
try
{
string name = string.Empty;
char[] pathChars = System.IO.Path.GetInvalidPathChars();
char[] inValidTableNameChars = new char[pathChars.Length + 1];
pathChars.CopyTo(inValidTableNameChars, 0);
inValidTableNameChars[pathChars.Length] = ' ';
if (GingerCore.GeneralLib.InputBoxWindow.GetInputWithValidation("Add New Key Value Table", "Table Name", ref name, inValidTableNameChars))
{
CreateTable(name, DSDetails.AddNewKeyValueTableQuery(), DataSourceTable.eDSTableType.GingerKeyValue);
}
}
catch (Exception ex)
{
Reporter.ToLog(eLogLevel.ERROR, ex.StackTrace);
}
}
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);
}
private void InitDSConnection()
{
DSDetails.InitConnection();
}
