All, I'm attempting to calculate a total from child records and save that total in the parent record.
I created a QueryExpression to iterate through the child records; my goal is to simply accumulate the total payment amount. However, I cannot seem to find the correct syntax.
Please look at the code below and tell me what needs to change.
Thanks!
-Dan
QueryExpression query = new QueryExpression
{
EntityName = "contact",
ColumnSet = new ColumnSet("firstname", "lastname", "new_paymentamount")
};
query.Criteria.AddCondition("parentcustomerid", ConditionOperator.Equal, contactEntityReference.Id);
IOrganizationService contactService = factory.CreateOrganizationService(context.UserId);
EntityCollection results2 = contactService.RetrieveMultiple(query);
addrString = "Test:";
foreach (var r in results2.Entities)
{
try
{
//subMoneyTotal = subMoneyTotal.Value + (Money)r.Attributes["new_paymentamount"]; // Operator + cannot be applied to operands of type decimal and Microsoft.Xrm.Sdk.Money
//subMoneyTotal = subMoneyTotal + (Money)r.Attributes["new_paymentamount"]; // Same error message Operator + cannot be applied ...
}
catch
{
//subMoneyTotal.Value = subMoneyTotal.Value;
}
};
addrCount = results2.TotalRecordCount;
tracer.Trace("Found the following number of records: " + addrCount.ToString());
Entity newAccount = contactService.Retrieve("account", contactEntityReference.Id, new ColumnSet(true)); // This line gives me an error that The given key was not present in the dictionary
tracer.Trace("Got to Entity newAccount");
//Never got this far, is the line below the correct way to write the value into new_totalpayments?
//newAccount.Attributes.Add("new_totalpayments", subMoneyTotal) // Never got this far
contactService.Update(newAccount);
tracer.Trace("Updated new account ... I think ...");
Dan Packer
