private void ProcessMappedUnits()
{
DIConnection SrcDBConnection = null;
DIQueries SrcDBQueries = null;
UnitBuilder TrgUnitBilder = null;
UnitInfo SrcUnitInfoObj = null;
UnitBuilder SrcUnitBuilderObj = null;
DataTable Table = null;
string SourceFileWPath = string.Empty;
int TrgUnitNid = 0;
if (this.MappedTables.ContainsKey(TemplateMergeControlType.Unit))
{
TrgUnitBilder = new UnitBuilder(this.DBConnection, this.DBQueries);
foreach (DataRow Row in this.MappedTables[TemplateMergeControlType.Unit].MappedTable.MappedTable.Rows)
{
Table = this.DBConnection.ExecuteDataTable(TemplateQueries.GetImportUnits(Convert.ToString(Row[MergetTemplateConstants.Columns.UNMATCHED_COL_Prefix + Unit.UnitNId])));
TrgUnitNid = Convert.ToInt32(Row[MergetTemplateConstants.Columns.AVAILABLE_COL_Prefix + Unit.UnitNId]);
if (Table != null && Table.Rows.Count > 0)
{
SourceFileWPath = Convert.ToString(Table.Rows[0][MergetTemplateConstants.Columns.COLUMN_SOURCEFILENAME]);
SrcDBConnection = new DIConnection(DIServerType.MsAccess, string.Empty, string.Empty, SourceFileWPath, string.Empty, string.Empty);
SrcDBQueries = DataExchange.GetDBQueries(SrcDBConnection);
// get unit info
SrcUnitBuilderObj = new UnitBuilder(SrcDBConnection, SrcDBQueries);
SrcUnitInfoObj = SrcUnitBuilderObj.GetUnitInfo(FilterFieldType.NId, Convert.ToString(Table.Rows[0][MergetTemplateConstants.Columns.COLUMN_SRCNID]));
// Import Mapped Unit Values
TrgUnitBilder.ImportMappedUnitInformation(SrcUnitInfoObj, SrcUnitInfoObj.Nid, TrgUnitNid, SrcDBQueries, SrcDBConnection);
SrcDBConnection.Dispose();
}
}
}
}
