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; }); }