Exemplo n.º 1
0
        /// <summary>
        /// Imports records from source database to target database/template
        /// </summary>
        /// <param name="selectedNids"></param>
        /// <param name="allSelected">Set true to import all records</param>
        public override void ImportValues(List <string> SelectedNids, bool allSelected)
        {
            DI7MetaDataBuilder MetaData = new DI7MetaDataBuilder(this._TargetDBConnection, this._TargetDBQueries);

            MetaData.BeforeProcess += new ProcessInfoDelegate(MetaData_BeforeProcess);
            MetaData.ProcessInfo   += new ProcessInfoDelegate(MetaData_ProcessInfo);

            if (this.InputFileType != DataSourceType.Database && this.InputFileType != DataSourceType.Template)
            {
                // Import data from xml file
                this.RaiseInitializeProgessBarEvent(1);
                if (System.IO.Path.GetExtension(this._SelectedFiles[0]).ToUpper() == DICommon.FileExtension.Excel.ToUpper())
                {
                    // import from excel
                    MetaData.ImportMetataFromExcel(MetadataElementType.Area, MetaDataType.Map, this.SelectedNidInTrgDatabase, this._SelectedFiles[0].ToString(), this.XsltFolderPath);
                }
                else
                {
                    ////MetaData.ImportMetadataFromXML(this.GetFileText(this._SelectedFiles[0]), MetaDataType.Map, this.SelectedNidInTrgDatabase, this.XsltFolderPath);
                    MetaData.ImportMetadataFromXML(this.GetFileText(this._SelectedFiles[0]), MetadataElementType.Area, this.SelectedNidInTrgDatabase, this.XsltFolderPath);
                }
                this.RaiseIncrementProgessBarEvent(1);
            }
            else
            {
                int SelectedCount = SelectedNids.Count;
                if (allSelected)
                {
                    SelectedCount = -1;
                }

                MetaData.ImportAreaMetadata(this._TargetDBQueries.DataPrefix, this.SourceDBConnection, this.SourceDBQueries, string.Join(",", SelectedNids.ToArray()), SelectedCount, MetaDataType.Map);
            }
        }
        /// <summary>
        /// Returns the metadata text from database
        /// </summary>
        /// <param name="elementNid"></param>
        /// <returns></returns>
        public override string GetMetadataTextFrmDB(int elementNid)
        {
            string             RetVal     = string.Empty;
            string             ElementGID = string.Empty;
            DataTable          Table;
            DI7MetaDataBuilder MDBuilder = null;

            try
            {
                Table = this.DBConnection.ExecuteDataTable(this.DBQueries.Area.GetAreaByLayer(elementNid.ToString()));

                foreach (DataRow Row in Table.Rows)
                {
                    ElementGID = Convert.ToString(Row[Area.AreaID]);

                    // get xml file from SDMX library
                    RetVal = DevInfo.Lib.DI_LibSDMX.SDMXUtility.Get_MetadataReport(DI_LibSDMX.SDMXSchemaType.Two_One, ElementGID, DevInfo.Lib.DI_LibSDMX.MetadataTypes.Area, "MDAgency", this.DBQueries.LanguageCode.Replace("_", ""), this.DBConnection, this.DBQueries).InnerXml;

                    MDBuilder = new DI7MetaDataBuilder(this.DBConnection, this.DBQueries);
                    RetVal    = MDBuilder.GetMetadataReportWCategoryName(RetVal, MetadataElementType.Area).InnerXml;

                    break;
                }
            }
            catch (Exception)
            {
                RetVal = string.Empty;
            }

            return(RetVal);
        }
Exemplo n.º 3
0
        /// <summary>
        /// Returns the metadata text from database
        /// </summary>
        /// <param name="elementNid"></param>
        /// <returns></returns>
        public override string GetMetadataTextFrmDB(int elementNid)
        {
            string             RetVal     = string.Empty;
            string             ElementGID = string.Empty;
            IndicatorBuilder   Indicators;
            DI7MetaDataBuilder MDBuilder = null;

            try
            {
                Indicators = new IndicatorBuilder(this.DBConnection, this.DBQueries);
                ElementGID = Indicators.GetIndicatorInfo(FilterFieldType.NId, elementNid.ToString(), FieldSelection.Light).GID;

                // get xml file from SDMX library
                RetVal = DevInfo.Lib.DI_LibSDMX.SDMXUtility.Get_MetadataReport(DI_LibSDMX.SDMXSchemaType.Two_One, ElementGID, DevInfo.Lib.DI_LibSDMX.MetadataTypes.Indicator, "MDAgency", this.DBQueries.LanguageCode.Replace("_", ""), this.DBConnection, this.DBQueries).InnerXml;

                MDBuilder = new DI7MetaDataBuilder(this.DBConnection, this.DBQueries);
                RetVal    = MDBuilder.GetMetadataReportWCategoryName(RetVal, MetadataElementType.Indicator).InnerXml;
            }
            catch (Exception)
            {
                RetVal = string.Empty;
            }

            return(RetVal);
        }
        /// <summary>
        /// Imports records from source database to target database/template
        /// </summary>
        /// <param name="selectedNids"></param>
        /// <param name="allSelected">Set true to import all records</param>
        public override void ImportValues(List <string> SelectedNids, bool allSelected)
        {
            DI7MetaDataBuilder MetaData     = new DI7MetaDataBuilder(this._TargetDBConnection, this._TargetDBQueries);
            MetaDataType       MetaDataType = MetaDataType.Sector;

            switch (this._IndicatorClassificationType)
            {
            case ICType.Sector:
                MetaDataType = MetaDataType.Sector;
                break;

            case ICType.Goal:
                MetaDataType = MetaDataType.Goal;
                break;

            case ICType.CF:
                MetaDataType = MetaDataType.CF;
                break;

            case ICType.Theme:
                MetaDataType = MetaDataType.Theme;
                break;

            case ICType.Source:
                MetaDataType = MetaDataType.Source;
                break;

            case ICType.Institution:
                MetaDataType = MetaDataType.Institution;
                break;

            case ICType.Convention:
                MetaDataType = MetaDataType.Convention;
                break;

            default:
                break;
            }

            if (this.InputFileType != DataSourceType.Database && this.InputFileType != DataSourceType.Template)
            {
                this.RaiseInitializeProgessBarEvent(1);

                if (MetaDataType == MetaDataType.Source)
                {
                    if (System.IO.Path.GetExtension(this._SelectedFiles[0]).ToUpper() == DICommon.FileExtension.Excel.ToUpper())
                    {
                        // import from excel
                        MetaData.ImportMetataFromExcel(MetadataElementType.Source, MetaDataType.Source, this.SelectedNidInTrgDatabase, this._SelectedFiles[0].ToString(), this.XsltFolderPath);
                    }
                    else
                    {
                        // Import data from xml file
                        ////MetaData.ImportMetadataFromXML(this.GetFileText(this._SelectedFiles[0]), MetaDataType, this.SelectedNidInTrgDatabase, this.XsltFolderPath);
                        MetaData.ImportMetadataFromXML(this.GetFileText(this._SelectedFiles[0]), MetadataElementType.Source, this.SelectedNidInTrgDatabase, this.XsltFolderPath);
                    }
                }
                else
                {
                    // Import data from rtf file
                    MetaData.ImportMetadataFromRTFFile(this.GetFileText(this._SelectedFiles[0]), MetaDataType, this.SelectedNidInTrgDatabase);
                }

                this.RaiseIncrementProgessBarEvent(1);
            }
            else
            {
                //improt data from database/template
                MetaData.BeforeProcess += new ProcessInfoDelegate(MetaData_BeforeProcess);
                MetaData.ProcessInfo   += new ProcessInfoDelegate(MetaData_ProcessInfo);

                if (MetaDataType == MetaDataType.Source)
                {
                    MetaData.ImportSourceMetadata(this._TargetDBQueries.DataPrefix, this.SourceDBConnection, this.SourceDBQueries, string.Join(",", SelectedNids.ToArray()), SelectedNids.Count, MetaDataType);
                }
                else
                {
                    MetaData.ImportICMetadata(this._TargetDBQueries.DataPrefix, this.SourceDBConnection, this.SourceDBQueries, string.Join(",", SelectedNids.ToArray()), SelectedNids.Count, MetaDataType, this._IndicatorClassificationType);
                }
            }
        }