private void ExportToExcel(object sender, RoutedEventArgs e)
        {
            Ginger.DataSource.DataSourceExportToExcel DSEE = new Ginger.DataSource.DataSourceExportToExcel(DSTableDetails.Name);
            DSEE.ShowAsWindow();

            string SolutionFolder = WorkSpace.Instance.Solution.Folder.ToUpper();
            string sExcelPath     = DSEE.ExcelPath;
            string sSheetName     = DSEE.SheetName;

            if (sExcelPath != "")
            {
                if (sExcelPath.Contains(SolutionFolder))
                {
                    sExcelPath = sExcelPath.Replace(SolutionFolder, @"~\");
                }
            }
            if (sExcelPath == "")
            {
                return;
            }
            if (sSheetName == "")
            {
                sSheetName = DSTableDetails.Name;
            }
            Reporter.ToStatus(eStatusMsgKey.ExportItem, null, DSTableDetails.Name, "Data Source Table");
            DSTableDetails.DSC.ExporttoExcel(DSTableDetails.Name, sExcelPath, sSheetName);
            Reporter.HideStatusMessage();
        }
Exemple #2
0
        private void ExportToExcel(object sender, System.Windows.RoutedEventArgs e)
        {
            Ginger.DataSource.DataSourceExportToExcel DSEE = new Ginger.DataSource.DataSourceExportToExcel();
            DSEE.ShowAsWindow();

            string SolutionFolder = WorkSpace.UserProfile.Solution.Folder.ToUpper();
            string sExcelPath     = DSEE.ExcelPath;
            string sSheetName     = DSEE.SheetName;

            if (sExcelPath != "")
            {
                if (sExcelPath.Contains(SolutionFolder))
                {
                    sExcelPath = sExcelPath.Replace(SolutionFolder, @"~\");
                }
            }
            if (sExcelPath == "")
            {
                return;
            }


            //Add Data Source Tables List
            DSDetails.DSTableList = DSDetails.DSC.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();
            }
        }
Exemple #3
0
        private void ExportToExcel(object sender, RoutedEventArgs e)
        {
            Ginger.DataSource.DataSourceExportToExcel DSEE = new Ginger.DataSource.DataSourceExportToExcel(DSTableDetails.Name);
            DSEE.ShowAsWindow();

            string SolutionFolder = App.UserProfile.Solution.Folder.ToUpper();
            string sExcelPath     = DSEE.ExcelPath;
            string sSheetName     = DSEE.SheetName;

            if (sExcelPath != "")
            {
                if (sExcelPath.Contains(SolutionFolder))
                {
                    sExcelPath = sExcelPath.Replace(SolutionFolder, @"~\");
                }
            }
            if (sExcelPath == "")
            {
                return;
            }
            if (sSheetName == "")
            {
                sSheetName = DSTableDetails.Name;
            }
            Reporter.ToGingerHelper(eGingerHelperMsgKey.ExportItem, null, DSTableDetails.Name, "Data Source Table");
            DSTableDetails.DSC.ExporttoExcel(DSTableDetails.Name, sExcelPath, sSheetName);
            Reporter.CloseGingerHelper();
        }
Exemple #4
0
        private void ExportToExcel(object sender, System.Windows.RoutedEventArgs e)
        {
            Ginger.DataSource.DataSourceExportToExcel DSEE = new Ginger.DataSource.DataSourceExportToExcel();
            DSEE.ShowAsWindow();

            string SolutionFolder = App.UserProfile.Solution.Folder.ToUpper();
            string sExcelPath     = DSEE.ExcelPath;
            string sSheetName     = DSEE.SheetName;

            if (sExcelPath != "")
            {
                if (sExcelPath.Contains(SolutionFolder))
                {
                    sExcelPath = sExcelPath.Replace(SolutionFolder, @"~\");
                }
            }
            if (sExcelPath == "")
            {
                return;
            }

            if (DSDetails.DSTableList == null)
            {
                if (mDataSourcePage == null)
                {
                    mDataSourcePage = new DataSourcePage(DSDetails);
                }
                //Add Data Sources
                DSDetails.DSTableList = mDataSourcePage.GetTableList();
            }

            foreach (DataSourceTable dsTable in DSDetails.DSTableList)
            {
                Reporter.ToGingerHelper(eGingerHelperMsgKey.ExportItem, null, dsTable.Name, "Data Source Table");
                dsTable.DSC.ExporttoExcel(dsTable.Name, sExcelPath, dsTable.Name);
                Reporter.CloseGingerHelper();
            }
        }