private void UpdateXsltMetadata()
{
DataTable MapTable = null;
string MetadataText = string.Empty;
// Get Area_Map Metadata Table
MapTable = this.DBConnection.ExecuteDataTable(this.DBQueries.Xslt.GetXSLT(FilterFieldType.Search, XSLT.XSLTText + " IS NOT NULL OR " + XSLT.XSLTText + " <> '' "));
foreach (DataRow Row in MapTable.Rows)
{
MetadataText = Convert.ToString(Row[XSLT.XSLTText]);
if (!string.IsNullOrEmpty(MetadataText))
{
MetadataText = MetadataConverter.ConvertXml(MetadataText);
// Update IndicatorClassificationInfo(Metadata)
this.DBConnection.ExecuteNonQuery(DevInfo.Lib.DI_LibDAL.Queries.Xslt.Update.UpdateXSLT(this.DBQueries.DataPrefix, DICommon.RemoveQuotes(MetadataText), Convert.ToString(Row[XSLT.XSLTFile])));
}
}
}
private void ConvertICMetadata()
{
DataTable ICTable = null;
string ICInfo = string.Empty;
// Get Indicator Metadata Table
ICTable = this.DBConnection.ExecuteDataTable(this.DBQueries.IndicatorClassification.GetICForSearch(FilterFieldType.Search, IndicatorClassifications.ICInfo + " IS NOT NULL AND " + IndicatorClassifications.ICInfo + " <> '' ", FieldSelection.Heavy));
// Update each Indicator Row where Metadata exists
foreach (DataRow Row in ICTable.Rows)
{
ICInfo = Convert.ToString(Row[IndicatorClassifications.ICInfo]);
if (!string.IsNullOrEmpty(ICInfo))
{
ICInfo = MetadataConverter.ConvertXml(ICInfo);
// Update IndicatorClassificationInfo(Source Metadata)
this.DBConnection.ExecuteNonQuery(DALQueries.IndicatorClassification.Update.UpdateICInfo(this.DBQueries.DataPrefix, this.DBQueries.LanguageCode, DICommon.RemoveQuotes(ICInfo), ICType.Source, Convert.ToInt32(Row[IndicatorClassifications.ICNId])));
}
}
}
