/// <summary>
/// Get Integration Transaction Details
/// </summary>
/// <param name="pIntegrationTransactionID"></param>
/// <returns></returns>
public DataTable GetIntegrationTransactionDetails(int pIntegrationTransactionID)
{
DataTable dtResults = null;
IntegrationTransaction transaction = null;
try
{
dtResults = new DataTable(Constants.TableName_Results);
transaction = base.AppRuntime.DataService.GetEntity(GetDataRequest <IntegrationTransaction> .Create(c =>
c.IntegrationTransactionID == pIntegrationTransactionID,
"IntegrationProcess.IntegrationProcessMappings.SourceIntegrationAdapterField",
"IntegrationProcess.IntegrationProcessMappings.DestinationIntegrationAdapterField",
"IntegrationTransactionDetails"));
if (transaction != null)
{
DataColumn col_ID = new DataColumn(Constants.ColumnName_ID, typeof(Int32));
dtResults.Columns.Add(col_ID);
DataColumn col_RecordStatus = new DataColumn(Constants.ColumnName_RecordStatus, typeof(String));
dtResults.Columns.Add(col_RecordStatus);
if (transaction.IntegrationProcess != null)
{
List <string> columns = new List <string>();
foreach (IntegrationProcessMapping mappingItem in transaction.IntegrationProcess.IntegrationProcessMappings.Where(c =>
c.DestinationIntegrationAdapterField != null))
{
if (!dtResults.Columns.Contains(mappingItem.DestinationIntegrationAdapterField.FieldName))
{
DataColumn dcMappingField = new DataColumn(
mappingItem.DestinationIntegrationAdapterField.FieldName,
DataUtilities.GetMappedType(mappingItem.DestinationIntegrationAdapterField.FieldDataTypeEnum));
dtResults.Columns.Add(dcMappingField);
columns.Add(dcMappingField.ColumnName);
}
}
foreach (IntegrationTransactionDetail detail in transaction.IntegrationTransactionDetails)
{
try
{
DataRow drDetail = dtResults.NewRow();
drDetail[col_ID] = detail.IntegrationTransactionDetailID;
drDetail[col_RecordStatus] = ((RecordTransactionStatus)detail.IntegrationTransactionDetailStatus).GetDescription();
StringReader dataReader = new StringReader(
CoreUtilities.GetString(detail.IntegrationTransactionDetailData));
XElement xData = XElement.Load(dataReader);
foreach (XElement item in xData.Nodes())
{
string columnName = CoreUtilities.FormatXMLColumnName(item.Name.LocalName, false);
if (columnName != Constants.ColumnName_RecordStatus &&
drDetail.Table.Columns.Contains(columnName))
{
drDetail[columnName] = DataUtilities.ConvertValueToDataColumnType(
item.Value, drDetail.Table.Columns[columnName].DataType);
}
}
dtResults.Rows.Add(drDetail);
}
catch (Exception ex)
{
LogManager.LogException(ex);
}
}
}
}
}
catch (Exception ex)
{
LogManager.LogException(ex);
}
finally
{
transaction = null;
}
return(dtResults);
}
