private static PayloadObjectDTO ConvertQueryMtToRealTimeData(PayloadObjectDTO obj)
{
var result = new PayloadObjectDTO();
foreach (var map in RealTimeToMtMap)
{
if (map.Item2 == null)
{
result.PayloadObject.Add(new KeyValueDTO(map.Item1, ""));
}
else
{
string temp;
if (obj.TryGetValue(map.Item2, false, false, out temp))
{
result.PayloadObject.Add(new KeyValueDTO(map.Item1, temp ?? ""));
}
else
{
result.PayloadObject.Add(new KeyValueDTO(map.Item1, ""));
}
}
}
return(result);
}
private StandardPayloadDataCM BuildStandardPayloadData(Table data, Dictionary <string, DbType> columnTypes)
{
var findObjectHelper = new FindObjectHelper();
var payloadCM = new StandardPayloadDataCM();
var tableData = new List <PayloadObjectDTO>();
if (data.Rows != null)
{
foreach (var row in data.Rows)
{
if (row.Values == null)
{
continue;
}
var payloadObject = new PayloadObjectDTO();
foreach (var fieldValue in row.Values)
{
var columnName = data.TableInfo.ToString() + "." + fieldValue.Field;
DbType dbType;
if (!columnTypes.TryGetValue(columnName, out dbType))
{
throw new ApplicationException("No column data type found.");
}
payloadObject.PayloadObject.Add(
new KeyValueDTO()
{
Key = fieldValue.Field,
Value = findObjectHelper.ConvertValueToString(fieldValue.Value, dbType)
}
);
}
tableData.Add(payloadObject);
}
}
payloadCM.PayloadObjects.AddRange(tableData);
return(payloadCM);
}
public static StandardPayloadDataCM GetPayloadDataCM()
{
var curAccountTrans = new PayloadObjectDTO()
{
PayloadObject = new List <KeyValueDTO>()
{
new KeyValueDTO("Name", "DocuNum1"),
new KeyValueDTO("TransactionDate", "11-11-2015"),
new KeyValueDTO("Memo", "Testing Journal Entry")
}
};
var curFirstFinLine = new PayloadObjectDTO()
{
PayloadObject = new List <KeyValueDTO>()
{
new KeyValueDTO("AccountName", "Savings"),
new KeyValueDTO("AccountId", "1"),
new KeyValueDTO("Amount", "100"),
new KeyValueDTO("DebitOrCredit", "Debit"),
new KeyValueDTO("Description", "Move money from Savings")
}
};
var curSecondFinLine = new PayloadObjectDTO()
{
PayloadObject = new List <KeyValueDTO>()
{
new KeyValueDTO("AccountName", "Savings"),
new KeyValueDTO("AccountId", "1"),
new KeyValueDTO("Amount", "100"),
new KeyValueDTO("DebitOrCredit", "Credit"),
new KeyValueDTO("Description", "Move money to Savings")
}
};
var curPayloadObjectList = new List <PayloadObjectDTO>();
curPayloadObjectList.Add(curAccountTrans);
curPayloadObjectList.Add(curFirstFinLine);
curPayloadObjectList.Add(curSecondFinLine);
return(new StandardPayloadDataCM()
{
ObjectType = "StandardPayloadDataCM",
PayloadObjects = curPayloadObjectList
});
}
private Func <object, PayloadObjectDTO> CrateManifestToRowConverter(Type manifestType)
{
var accessors = new List <KeyValuePair <string, IMemberAccessor> >();
foreach (var member in manifestType.GetMembers(BindingFlags.Instance | BindingFlags.Public).OrderBy(x => x.Name))
{
IMemberAccessor accessor;
if (member is FieldInfo)
{
accessor = ((FieldInfo)member).ToMemberAccessor();
}
else if (member is PropertyInfo && !((PropertyInfo)member).IsSpecialName)
{
accessor = ((PropertyInfo)member).ToMemberAccessor();
}
else
{
continue;
}
accessors.Add(new KeyValuePair <string, IMemberAccessor>(member.Name, accessor));
}
return(x =>
{
var row = new PayloadObjectDTO();
foreach (var accessor in accessors)
{
row.PayloadObject.Add(new KeyValueDTO(accessor.Key, string.Format(CultureInfo.InvariantCulture, "{0}", accessor.Value.GetValue(x))));
}
return row;
});
}
