/// <summary>
/// Process Mapped Areas from MappedRows.
/// </summary>
public void ProcessMappedAreas()
{
DIConnection SrcDBConnection = null;
DIQueries SrcDBQueries = null;
AreaBuilder TrgAreaBuilder = null;
AreaBuilder SourceAreaBuilder = null;
AreaInfo SrcAreaInfo = null;
DataTable Table = null;
string SourceFileWPath = string.Empty;
int TrgAreaNid = 0;
if (this.MappedTables.ContainsKey(TemplateMergeControlType.Areas))
{
TrgAreaBuilder = new AreaBuilder(this.DBConnection, this.DBQueries);
foreach (DataRow Row in this.MappedTables[TemplateMergeControlType.Areas].MappedTable.MappedTable.Rows)
{
//todo:
Table = this.DBConnection.ExecuteDataTable(TemplateQueries.GetImportAreas());
TrgAreaNid = Convert.ToInt32(Row[MergetTemplateConstants.Columns.AVAILABLE_COL_Prefix + Area.AreaNId]);
if (Table != null && Table.Rows.Count > 0)
{
try
{
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 Source Area Info
SourceAreaBuilder = new AreaBuilder(SrcDBConnection, SrcDBQueries);
SrcAreaInfo= SourceAreaBuilder.GetAreaInfo(FilterFieldType.NId, Convert.ToString(Table.Rows[0][MergetTemplateConstants.Columns.COLUMN_SRCNID]));
// Import Mapped Area
TrgAreaBuilder.ImportAreaFrmMappedArea(SrcAreaInfo, SrcAreaInfo.Nid, TrgAreaNid, SrcDBQueries, SrcDBConnection);
}
finally
{
if (SrcDBConnection != null)
{
SrcDBConnection.Dispose();
SrcDBQueries.Dispose();
}
}
}
}
}
}
