/// <summary>
/// Imports source metadata from template/database
/// </summary>
/// <param name="dataPrefix"></param>
/// <param name="sourceDBConnection"></param>
/// <param name="sourceDBQueries"></param>
/// <param name="selectedNIDs"></param>
/// <param name="selectionCount"></param>
/// <param name="metadataType"></param>
public void ImportSourceMetadata(string dataPrefix, DIConnection sourceDBConnection, DIQueries sourceDBQueries, string selectedNIDs, int selectionCount, MetaDataType metadataType)
{
DataTable TempDataTable;
ICType ClassificationType;
int CurrentRecordIndex = 0;
int SrcElementNid;
int TrgElementNid;
DI7MetadataCategoryBuilder SourceMetadataCategoryBuilder;
SourceBuilder ICBuilder;
try
{
this.RaiseStartProcessEvent();
ICBuilder = new SourceBuilder(this.DBConnection, this.DBQueries);
// import source categories
SourceMetadataCategoryBuilder = new DI7MetadataCategoryBuilder(this.DBConnection, this.DBQueries);
SourceMetadataCategoryBuilder.ImportAllMetadataCategories(sourceDBConnection, sourceDBQueries, MetadataElementType.Source);
ClassificationType = ICType.Source;
if (selectionCount == -1)
{
// -- GET ALL
TempDataTable = sourceDBConnection.ExecuteDataTable(sourceDBQueries.IndicatorClassification.GetIC(FilterFieldType.None, string.Empty, ClassificationType, FieldSelection.Heavy));
}
else
{
// -- GET SELECTED
TempDataTable = sourceDBConnection.ExecuteDataTable(sourceDBQueries.IndicatorClassification.GetIC(FilterFieldType.NId, selectedNIDs, ClassificationType, FieldSelection.Heavy));
}
////// -- Initialize Progress Bar
this.RaiseBeforeProcessEvent(TempDataTable.Rows.Count);
CurrentRecordIndex = 0;
foreach (DataRow Row in TempDataTable.Rows)
{
CurrentRecordIndex++;
SrcElementNid = Convert.ToInt32(Row[IndicatorClassifications.ICNId]);
TrgElementNid = ICBuilder.CheckSourceExists(Convert.ToString(Row[IndicatorClassifications.ICName]));
// import source metadadta
if (TrgElementNid > 0)
{
this.ImportMetadata(sourceDBConnection, sourceDBQueries, SrcElementNid, TrgElementNid, MetadataElementType.Source, MetaDataType.Source, IconElementType.MetadataSource);
}
////// -- Increemnt the Progress Bar Value
this.RaiseProcessInfoEvent(CurrentRecordIndex);
}
// -- Dispose the Data Table object
TempDataTable.Dispose();
}
catch (Exception ex)
{
throw new ApplicationException(ex.ToString());
}
}
/// <summary>
/// Imports area metadata from template/database
/// </summary>
/// <param name="dataPrefix"></param>
/// <param name="sourceDBConnection"></param>
/// <param name="sourceDBQueries"></param>
/// <param name="selectedNIDs"></param>
/// <param name="selectionCount"></param>
/// <param name="metadataType"></param>
public void ImportAreaMetadata(string dataPrefix, DIConnection sourceDBConnection, DIQueries sourceDBQueries, string selectedNIDs, int selectionCount, MetaDataType metadataType)
{
DataTable TempDataTable;
int CurrentRecordIndex = 0;
DI7MetadataCategoryBuilder AreaMetadataCategoryBuilder;
DataTable TempTargetTable;
try
{
this.RaiseStartProcessEvent();
// import area categories
AreaMetadataCategoryBuilder = new DI7MetadataCategoryBuilder(this.DBConnection, this.DBQueries);
AreaMetadataCategoryBuilder.ImportAllMetadataCategories(sourceDBConnection, sourceDBQueries, MetadataElementType.Area);
if (selectionCount == -1)
{
// -- GET ALL
TempDataTable = sourceDBConnection.ExecuteDataTable(sourceDBQueries.Area.GetAreaMapMetadata(string.Empty));
}
else
{
// -- GET SELECTED
TempDataTable = sourceDBConnection.ExecuteDataTable(sourceDBQueries.Area.GetAreaMapMetadata(selectedNIDs));
}
// -- Initialize Progress Bar
this.RaiseBeforeProcessEvent(TempDataTable.Rows.Count);
CurrentRecordIndex = 0;
//import area metadata
foreach (DataRow Row in TempDataTable.Rows)
{
CurrentRecordIndex++;
//-- Get Target table against LayerName
TempTargetTable = this.DBConnection.ExecuteDataTable(this.DBQueries.Area.GetAreaMapMetadataByName(
Row[Area_Map_Metadata.LayerName].ToString()));
foreach (DataRow TrgRow in TempTargetTable.Rows)
{
this.ImportMetadata(sourceDBConnection, sourceDBQueries, Convert.ToInt32(Row[Area_Map_Layer.LayerNId]), Convert.ToInt32(TrgRow[Area_Map_Layer.LayerNId]), MetadataElementType.Area, MetaDataType.Map, IconElementType.MetadataArea);
break;
}
// -- Increemnt the Progress Bar Value
this.RaiseProcessInfoEvent(CurrentRecordIndex);
}
}
catch (Exception ex)
{
throw new ApplicationException(ex.ToString());
}
finally
{
this.RaiseEndProcessEvent();
}
}
/// <summary>
/// Imports indicator metadata from template/database
/// </summary>
/// <param name="dataPrefix"></param>
/// <param name="sourceDBConnection"></param>
/// <param name="sourceDBQueries"></param>
/// <param name="selectedNIDs"></param>
/// <param name="selectionCount"></param>
/// <param name="metadataType"></param>
public void ImportIndicatorMetadata(string dataPrefix, DIConnection sourceDBConnection, DIQueries sourceDBQueries, string selectedNIDs, int selectionCount, MetaDataType metadataType)
{
DataTable TempDataTable;
int CurrentRecordIndex = 0;
DI7MetadataCategoryBuilder MetadataCategoryBuilderObj;
IndicatorInfo SourceIndicatorInfo = new IndicatorInfo();
IndicatorBuilder IndBuilder = null;
try
{
this.RaiseStartProcessEvent();
IndBuilder = new IndicatorBuilder(this.DBConnection, this.DBQueries);
// 1. import metadta categories
// import indicator metadata categories
MetadataCategoryBuilderObj = new DI7MetadataCategoryBuilder(this.DBConnection, this.DBQueries);
MetadataCategoryBuilderObj.ImportAllMetadataCategories(sourceDBConnection, sourceDBQueries, MetadataElementType.Indicator);
// 2. Imort metadata reports
if (selectionCount == -1)
{
// -- GET ALL
TempDataTable = sourceDBConnection.ExecuteDataTable(sourceDBQueries.Indicators.GetIndicator(FilterFieldType.None, string.Empty, FieldSelection.Heavy));
}
else
{
// -- GET SELECTED
TempDataTable = sourceDBConnection.ExecuteDataTable(sourceDBQueries.Indicators.GetIndicator(FilterFieldType.NId, selectedNIDs, FieldSelection.Heavy));
}
//////// -- Initialize Progress Bar
this.RaiseBeforeProcessEvent(TempDataTable.Rows.Count);
foreach (DataRow Row in TempDataTable.Rows)
{
CurrentRecordIndex++;
// get source indicator info
SourceIndicatorInfo = new IndicatorInfo();
SourceIndicatorInfo.Nid = Convert.ToInt32(Row[Indicator.IndicatorNId]);
SourceIndicatorInfo.GID = Convert.ToString(Row[Indicator.IndicatorGId]);
SourceIndicatorInfo.Name = Convert.ToString(Row[Indicator.IndicatorName]);
SourceIndicatorInfo.Global = Convert.ToBoolean(Row[Indicator.IndicatorGlobal]);
//import metadata
IndBuilder.ImportIndicatorMetadata(SourceIndicatorInfo, SourceIndicatorInfo.Nid, sourceDBQueries, sourceDBConnection);
// -- Increemnt the Progress Bar Value
this.RaiseProcessInfoEvent(CurrentRecordIndex);
}
}
catch (Exception ex)
{
throw new ApplicationException(ex.ToString());
}
finally
{
this.RaiseEndProcessEvent();
}
}
