How to loop through SalesSalesOrderService to get all SalesLine records in C#?

(0) Share

Report

Posted on by Community Member

I couldn't find any examples that loops through a document service.. i found this example for ax 2009 but got a massive headache after going through it(not sure if it's applicable to ax 2012): https://msdn.microsoft.com/en-us/library/cc652581%28v=ax.50%29.aspx (opens new window)

Here's what I have so far:

                // Create the service client proxy
                SalesOrderService.SalesOrderServiceClient c1 = new SalesOrderService.SalesOrderServiceClient();

                // Create the Call Context
                SalesOrderService.CallContext cc = new SalesOrderService.CallContext();

                // Set the partition to "MyPartition"
                cc.PartitionKey = ConfigurationManager.AppSettings["Partition"];

                // Set the company to "MyCompany"
                cc.Company = ConfigurationManager.AppSettings["Company"];

                SalesOrderService.AxdSalesOrder salesResp;

                SalesOrderService.EntityKey[] readSalesKeys = new SalesOrderService.EntityKey[1];
                readSalesKeys[0] = new SalesOrderService.EntityKey();
                readSalesKeys[0].KeyData = new SalesOrderService.KeyField[1];
                readSalesKeys[0].KeyData[0] = new SalesOrderService.KeyField();
                readSalesKeys[0].KeyData[0].Field = "SALESID";

                readSalesKeys[0].KeyData[0].Value = "000733";

How would I loop through salesResp.SalesTable[0].SalesLine[i] to get all the salesline records for this order?

Code examples would be much appreciated!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

Report
This question is purely about C#, so you would be better off opening C# documentation or asking in a C# forum.

Anyway, C# offers several ways how it iterate arrays. The easiest one is using foreach:

foreach (var line in salesResp.SalesTable[0].SalesLine) { ... }

You could also use the for loop, in the same way as in X++. You could also use an enumerator. But you likely want to simply use foreach.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ah thanks, I didn't know it was this straightforward with AX document services.

Was this reply helpful? Yes No
Martin Dráb 237,976 Most Valuable Professional on at

Like (0)

Report

What you work with are normal .NET classes, properties, arrays etc. When you add a service reference, Visual Studio reads the web service definition and generated these so-called proxy classes for you. It doesn't actually know anything about Dynamics AX.

Was this reply helpful? Yes No

Community site session details

How to loop through SalesSalesOrderService to get all SalesLine records in C#?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

How to loop through SalesSalesOrderService to get all SalesLine records in C#?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates