Using QueryExpression get the Link Entity details in D365

-

 public static void Main()

{

    EntityCollection salesOrderCollection = this.GetAccounts(customerId, salesOrderCreationDate);

}


public EntityCollection GetAccounts(string customerId, DateTime AccountBaseCreationDate)

{

    QueryExpression ContactItemQuery = new QueryExpression(AccountBase.LogicalName);


    // Add Condition to Customer.

    ContactItemQuery.Criteria.AddCondition(AccountBase.Id, ConditionOperator.Equal, customerId);

    FilterExpression mainFilter = new FilterExpression(LogicalOperator.And);

    mainFilter.AddCondition(AccountBase.CreatedOn, ConditionOperator.GreaterThan, AccountBaseCreationDate);

    FilterExpression statusCodeFilter = new FilterExpression(LogicalOperator.Or);

    statusCodeFilter.AddCondition(AccountBase.Status, ConditionOperator.Equal, (int)AccountBase.AccountStatus.Submitted);

    statusCodeFilter.AddCondition(AccountBase.Status, ConditionOperator.Equal, (int)AccountBase.AccountStatus.Fulfilled);

    statusCodeFilter.AddCondition(AccountBase.Status, ConditionOperator.Equal, (int)AccountBase.AccountStatus.Invoiced);

    mainFilter.AddFilter(statusCodeFilter);

    ContactItemQuery.Criteria.AddFilter(mainFilter)

            // Add Link to Price List Entity.

            LinkEntity Contact = new LinkEntity(

                AccountBase.LogicalName,

                ContactBase.LogicalName,

               AccountBase.Contact,

                ContactBase.Id,

                JoinOperator.Inner);


    // Add Link to ContactItems Entity.

    LinkEntity ContactItems = new LinkEntity(

       ContactBase.LogicalName,

       ContactItemsBase.LogicalName,

       ContactBase.Id,

       ContactItemsBase.Contact,

       JoinOperator.Inner);

    ContactItems.EntityAlias = "pi";

    ContactItems.Columns.AddColumns(ContactItemsBase.Product, ContactItemsBase.Unit);

    Contact.LinkEntities.Add(ContactItems);


    // Add Link to Unit Entity.

    LinkEntity unit = new LinkEntity(

       ContactItemsBase.LogicalName,

       UnitBase.LogicalName,

       ContactItemsBase.Unit,

       UnitBase.Id,

       JoinOperator.Inner);

    unit.LinkCriteria.AddCondition(UnitBase.UnitType, ConditionOperator.Equal, (int)UnitBase.UnitTypeValue.Case);

    ContactItems.LinkEntities.Add(unit);

    ContactItemQuery.LinkEntities.Add(Contact);


    // Execute Query.

    return this.organizationService.RetrieveMultiple(ContactItemQuery);

}


Comments

Post a Comment

Popular posts from this blog

Meta Data Using WebApiRequest

-
////////////////Query Entity Metadata along with all attributes///////////// var url = req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/EntityDefinitions(LogicalName='contact')/Attributes", false); /////////////////Entity Object Type code///////////////////////  req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.0/EntityDefinitions?$filter=LogicalName eq '" + entityLogicalName + "'&$select=ObjectTypeCode", false); ////////////////////////////////////Querying single Field Metadata///////////////////// var url = req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/EntityDefinitions(LogicalName='contact')/Attributes(LogicalName='firstname')", false); /////////////////Querying Relationships/////////////////// var url = req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/RelationshipDefinitions(SchemaName...
Read more

Sample CRUD Operations Using C# in MSCRM

-
Sample CRUD Operations Using C# in MSCRM Steps to Achieve: Create a console Application in Visual Studio and add (Microsoft.Crm.Sdk.Proxy.dll, Microsoft.Xrm.Sdk.dll) in references section. Download this C# Class files to get crm service ,If you have this files just skip this step https://www.dropbox.com/s/pyj6zym6u9ea7wp/deviceidmanager.cs?dl=0 https://www.dropbox.com/s/q82xp39jn0nqi0j/OnlineService.cs?dl=0 Open OnlineService.cs file and enter your crm credentials as shown below            ClientCredentials credentials = new ClientCredentials();             credentials.UserName.UserName = "Username@Domain.onmicrosoft.com";//Username             credentials.UserName.Password = "yourpasswordhere";//Password             var _servproxy = new OrganizationServiceProxy(new     Uri("https://Domain.api.crm5.dynamics.com/XRMServices/2011/Organization.svc"), n...
Read more

Basic Plugin Code in D365 using C#

-
 using System; using Microsoft.Xrm.Sdk; using Microsoft.Xrm.Sdk.Query; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.Xrm.Sdk.Messages; using Microsoft.Xrm.Sdk.Metadata; namespace  apy.CWA.Arcese.Security {     public class PostOperationCreateQuote : IPlugin     {         public void Execute(IServiceProvider serviceProvider)         {             ITracingService tracingService = (ITracingService)serviceProvider.GetService(typeof(ITracingService));             IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));             IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));           ...
Read more