private static void AddRowsMappingInfo(DataSet dts, CrossTabTableInfo srcTableTableInfo, int tableIndex)
{
DataTable MappedTable;
DataTable MapTypeTable;
string MappedValueString = string.Empty;
string MappedTypeString = string.Empty;
string Value = string.Empty;
string GID = string.Empty;
string[] MappedValues;
string[] MappedTypes;
string[] ElementValue;
Mapping RowMapping;
try
{
if (srcTableTableInfo != null)
{
// only if mappedRow and maptype table exists
if (dts.Tables.Contains(TablesName.MAPPEDROW_TBLNAME + tableIndex) && dts.Tables.Contains(TablesName.MAPTYPEROW_TBLNAME + tableIndex))
{
MapTypeTable = dts.Tables[TablesName.MAPTYPEROW_TBLNAME + tableIndex];
MappedTable = dts.Tables[TablesName.MAPPEDROW_TBLNAME + tableIndex];
if (MapTypeTable.Rows.Count == MappedTable.Rows.Count)
{
for (int Index = 0; Index < MapTypeTable.Rows.Count; Index++)
{
MappedTypeString = Convert.ToString(MapTypeTable.Rows[Index][0]);
MappedValueString = Convert.ToString(MappedTable.Rows[Index][0]);
RowMapping = srcTableTableInfo.RowsMapping[Index].Mappings.CellMap;
//import mapping
DXSFileConveter.ImportMapping(MappedValueString, MappedTypeString, RowMapping);
}
}
}
}
}
catch (Exception ex)
{
throw new ApplicationException(ex.ToString());
}
}
private static void AddColumnsMappingInfo(DataSet dts, CrossTabTableInfo srcTableTableInfo, int tableIndex)
{
DataTable MappedTable;
DataTable MapTypeTable;
string MappedValueString = string.Empty;
string MappedTypeString = string.Empty;
string Value = string.Empty;
string GID = string.Empty;
string[] MappedValues;
string[] MappedTypes;
string[] ElementValue;
Mapping ColMapping;
try
{
if (srcTableTableInfo != null)
{
// only if mappedCol and maptype table exists
if (dts.Tables.Contains(TablesName.MAPPEDCOL_TBLNAME + tableIndex) && dts.Tables.Contains(TablesName.MAPTYPECOL_TBLNAME + tableIndex))
{
MapTypeTable = dts.Tables[TablesName.MAPTYPECOL_TBLNAME + tableIndex];
MappedTable = dts.Tables[TablesName.MAPPEDCOL_TBLNAME + tableIndex];
if (MapTypeTable.Columns.Count == MappedTable.Columns.Count)
{
for (int Index = 0; Index < MapTypeTable.Columns.Count; Index++)
{
MappedTypeString = Convert.ToString(MapTypeTable.Rows[0][Index]);
MappedValueString = Convert.ToString(MappedTable.Rows[0][Index]);
ColMapping = srcTableTableInfo.ColumnsMapping[Index].Mappings.CellMap;
//import mapping
DXSFileConveter.ImportMapping(MappedValueString, MappedTypeString, ColMapping);
}
}
////// if (!string.IsNullOrEmpty(MappedValueString) && !string.IsNullOrEmpty(MappedTypeString))
////// {
////// MappedTypes = DICommon.SplitString(MappedTypeString, "\r\n");
////// MappedValues = DICommon.SplitString(MappedValueString, "\r\n");
////// for (int i = 0; i < MappedTypes.Length; i++)
////// {
////// // only if value exists
////// if (!string.IsNullOrEmpty(MappedTypes[i]) && !string.IsNullOrEmpty(MappedValues[Index]))
////// {
////// ColMapping = srcTableTableInfo.ColumnsMapping[Index].Mappings.CellMap;
////// ElementValue = DICommon.SplitString(MappedValues[i], "||");
////// // only if element value have value and GID
////// if (ElementValue.Length == 2)
////// {
////// Value = Convert.ToString(ElementValue[0]);
////// GID= Convert.ToString(ElementValue[1]);
////// switch (MappedTypes[i].ToUpper())
////// {
////// case "INDICATOR":
////// ColMapping.IndicatorName = Value;
////// ColMapping.IndicatorGID = GID;
////// break;
////// case "UNIT":
////// ColMapping.UnitName = Value;
////// ColMapping.UnitGID = GID;
////// break;
////// case "SUBGROUP":
////// ColMapping.SubgroupVal = Value;
////// ColMapping.SubgroupValGID = GID;
////// break;
////// case "AREA":
////// ColMapping.Area = Value;
////// ColMapping.AreaID = GID;
////// break;
////// case "SOURCE":
////// ColMapping.Source = Value;
////// break;
////// case "TIMEPERIOD":
////// ColMapping.Timeperiod = Value;
////// break;
////// case "AGE":
////// case "SEX":
////// case "LOCATION":
////// case "OTHERS":
////// if(ColMapping.Subgroups.ContainsKey(GID)==false)
////// {
////// DevInfo.Lib.DI_LibBAL.DA.DML.DI6SubgroupInfo SG =new DevInfo.Lib.DI_LibBAL.DA.DML.DI6SubgroupInfo();
////// SG.Name=Value;
////// SG.GID=GID;
////// ColMapping.Subgroups.Add(GID, SG);
////// }
////// break;
////// default:
////// break;
////// }
////// }
////// }
////// }
////// }
////// }
//////}
}
}
}
catch (Exception ex)
{
throw new ApplicationException(ex.ToString());
}
}
