public override string GetMetadataTextFrmDB(int elementNid) { string RetVal = string.Empty; string ElementGID = string.Empty; DataTable Table = null; DA.DML.DI7MetaDataBuilder MDBuilder = null; try { Table = this.DBConnection.ExecuteDataTable(this.DBQueries.IndicatorClassification.GetIC(FilterFieldType.NId, elementNid.ToString(), FieldSelection.Heavy)); foreach (DataRow Row in Table.Rows) { ElementGID = Convert.ToString(Row[IndicatorClassifications.ICGId]); // 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.Source, "MDAgency", this.DBQueries.LanguageCode.Replace("_", ""), this.DBConnection, this.DBQueries).InnerXml; MDBuilder = new DA.DML.DI7MetaDataBuilder(this.DBConnection, this.DBQueries); RetVal = MDBuilder.GetMetadataReportWCategoryName(RetVal, MetadataElementType.Source).InnerXml; break; } } catch (Exception) { RetVal = string.Empty; } return(RetVal); }
public override string GetMetadataTextFrmDB(int elementNid) { string RetVal = string.Empty; string ElementGID = string.Empty; DataTable Table = null; DA.DML.DI7MetaDataBuilder MDBuilder = null; try { Table = this.DBConnection.ExecuteDataTable(this.DBQueries.IndicatorClassification.GetIC(FilterFieldType.NId, elementNid.ToString(), FieldSelection.Heavy)); foreach (DataRow Row in Table.Rows) { ElementGID = Convert.ToString(Row[IndicatorClassifications.ICGId]); // 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.Source, "MDAgency", this.DBQueries.LanguageCode.Replace("_", ""), this.DBConnection, this.DBQueries).InnerXml; MDBuilder = new DA.DML.DI7MetaDataBuilder(this.DBConnection, this.DBQueries); RetVal = MDBuilder.GetMetadataReportWCategoryName(RetVal, MetadataElementType.Source).InnerXml; break; } } catch (Exception) { RetVal = string.Empty; } return RetVal; }