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