private void ConvertMetadataXmlIntoDatabse()
{
DI7MetadataConverter MetadataConverter = new DI7MetadataConverter(this._DBConnection, this._DBQueries);
DIQueries TempDBQueries = null;
string DataPrefix = string.Empty;
string LanguageCode = string.Empty;
try
{
// step1: create table for all dataset
foreach (DataRow DataPrefixRow in this._DBConnection.DIDataSets().Rows)
{
DataPrefix = DataPrefixRow[DBAvailableDatabases.AvlDBPrefix].ToString() + "_";
// get language for all available langauges
foreach (DataRow LanguageRow in this._DBConnection.DILanguages(DataPrefix).Rows)
{
LanguageCode = "_" + LanguageRow[Language.LanguageCode].ToString();
// check table already exists or not
TempDBQueries = new DIQueries(DataPrefix, LanguageCode);
MetadataConverter = new DI7MetadataConverter(this._DBConnection, TempDBQueries);
MetadataConverter.WrongMetdataFoundEvent += new WrongMetadataFound(MetadataConverter_WrongMetdataFoundEvent);
// convert Indicator,Map and Source Info
MetadataConverter.ConvertIndicatorMapICAndXsltMetadataIntoNewFormat();
}
}
}
catch (Exception ex)
{
ExceptionFacade.ThrowException(ex);
}
}
private void ConvertMetadataXmlIntoDatabse()
{
DI7MetadataConverter MetadataConverter = new DI7MetadataConverter(this._DBConnection, this._DBQueries);
DIQueries TempDBQueries = null;
string DataPrefix = string.Empty;
string LanguageCode = string.Empty;
try
{
// step1: create table for all dataset
foreach (DataRow DataPrefixRow in this._DBConnection.DIDataSets().Rows)
{
DataPrefix = DataPrefixRow[DBAvailableDatabases.AvlDBPrefix].ToString() + "_";
// get language for all available langauges
foreach (DataRow LanguageRow in this._DBConnection.DILanguages(DataPrefix).Rows)
{
LanguageCode = "_" + LanguageRow[Language.LanguageCode].ToString();
// check table already exists or not
TempDBQueries = new DIQueries(DataPrefix, LanguageCode);
MetadataConverter = new DI7MetadataConverter(this._DBConnection, TempDBQueries);
MetadataConverter.WrongMetdataFoundEvent += new WrongMetadataFound(MetadataConverter_WrongMetdataFoundEvent);
// convert Indicator,Map and Source Info
MetadataConverter.ConvertIndicatorMapICAndXsltMetadataIntoNewFormat();
}
}
}
catch (Exception ex)
{
ExceptionFacade.ThrowException(ex);
}
}
