Console Application For Microsoft Dynamics CRM

• Once this is done, paste the below code. NOTE: The logic is written in such a way below that it only updates records within a certain timeframe given as input by the users.

using System;

using System.Configuration;

using Microsoft.Xrm.Sdk;

using Microsoft.Crm.Sdk.Messages;

using Microsoft.Xrm.Tooling.Connector;

using Microsoft.Xrm.Sdk.Query;

namespace Dynamics_365_Demo

{

class Program

{

static void Main(string[] args)

{

IOrganizationService _service;

try

{

Console.WriteLine(“Setting up Dynamics 365 connection”);

//Create the Dynamics 365 Connection:

string connectionString = ConfigurationManager.ConnectionStrings[“DEV_Connection”].ConnectionString;

CrmServiceClient devConnection = new CrmServiceClient(connectionString);

//Create the IOrganizationService:

_service = (IOrganizationService)devConnection.OrganizationWebProxyClient != null ?

(IOrganizationService)devConnection.OrganizationWebProxyClient :

(IOrganizationService)devConnection.OrganizationServiceProxy;

Console.WriteLine(“Validating Connection”);

if (_service != null)

{

//Get the current user ID:

Guid userid = ((WhoAmIResponse)_service.Execute(new WhoAmIRequest())).UserId;

if (userid != Guid.Empty)

{

Console.WriteLine(“Connection Successful!:”+userid);

int onOrAfterYear = Int32.Parse(args[0]);

int onOrAfterMonth = Int32.Parse(args[1]);

int onOrAfterDate = Int32.Parse(args[2]);

int onOrBeforeYear = Int32.Parse(args[3]);

int onOrBeforeMonth = Int32.Parse(args[4]);

int onOrBeforeDate = Int32.Parse(args[5]);

DateTime onOrAfterTime = new DateTime(onOrAfterYear, onOrAfterMonth, onOrAfterDate, 0, 0, 0);

DateTime onOrBeforeTime = new DateTime(onOrBeforeYear, onOrBeforeMonth, onOrBeforeDate, 0, 0, 0);

QueryExpression queryExpression = new QueryExpression(“mf_opportunitypay”);

queryExpression.ColumnSet = new ColumnSet(“mf_event”, “mf_eventstart”,”mf_eventend”, “statecode”, “statuscode”);

queryExpression.PageInfo = new PagingInfo();

queryExpression.PageInfo.Count = 5000;

queryExpression.PageInfo.PageNumber = 1;

queryExpression.PageInfo.ReturnTotalRecordCount = true;

queryExpression.Criteria.AddCondition(new ConditionExpression(“bamf_eventstart”, ConditionOperator.OnOrAfter, onOrAfterTime));

queryExpression.Criteria.AddCondition(new ConditionExpression(“bamf_eventstart”, ConditionOperator.OnOrBefore, onOrBeforeTime));

queryExpression.Criteria.AddCondition(new ConditionExpression(“statecode”, ConditionOperator.Equal, 0));

queryExpression.Orders.Add(new OrderExpression(“mf_eventstart”, OrderType.Ascending));

EntityCollection ppEvents = _service.RetrieveMultiple(queryExpression);

EntityCollection finalPPEvents = new EntityCollection();

foreach (Entity finalEvent in ppEvents.Entities)

{

finalPPEvents.Entities.Add(finalEvent);

}

do

{

queryExpression.PageInfo.PageNumber += 1;

queryExpression.PageInfo.PagingCookie = ppEvents.PagingCookie;

ppEvents = _service.RetrieveMultiple(queryExpression);

foreach (Entity opportunity in ppEvents.Entities)

finalPPEvents.Entities.Add(opportunity);

} while (ppEvents.MoreRecords);

int i = 0;

Console.WriteLine(“Data fetched:number of events is:” + finalPPEvents.Entities.Count);

foreach (Entity ppEvent in finalPPEvents.Entities)

{

Console.WriteLine(i.ToString() + “:” + ppEvent.GetAttributeValue(“mf_event”).Name);

i++;

DateTime ppEventStart = ppEvent.GetAttributeValue(“mf_eventstart”);

DateTime ppEventEnd = ppEvent.GetAttributeValue(“mf_eventend”);

Guid eventId = ppEvent.GetAttributeValue(“mf_event”).Id;

Entity eventRecord = _service.Retrieve(“opportunity”, eventId, new ColumnSet(“mf_eventstart”,”mf_eventend”));

DateTime eventStart = eventRecord.GetAttributeValue(“mf_eventstart”);

DateTime eventEnd = eventRecord.GetAttributeValue(“mf_eventend”);

if (ppEventStart != eventStart || ppEventEnd != eventEnd)

{

Entity ppEventToUpdate = new Entity(“bamf_partypayevent”);

ppEventToUpdate.Id = ppEvent.Id;

ppEventToUpdate[“mf_eventstart”] = eventStart;

ppEventToUpdate[“mf_eventend”] = eventEnd;

_service.Update(ppEventToUpdate);

Console.WriteLine(“Record updated”);

}

}

Console.ReadKey();

}

}

else

{

Console.WriteLine(“Connection failed…”);

}

}

catch (Exception ex)

{

Console.WriteLine(“Error – ” + ex.ToString());

}

Console.ReadKey();

}

}

}

• The app config file should look like the following:

<?xml version=”1.0″ encoding=”utf-8″ ?>

<configuration>

<startup>

<supportedRuntime version=”v4.0″ sku=”.NETFramework,Version=v4.5.2″ />

</startup>

<connectionStrings>

<add name=”DEV_Connection” connectionString=”AuthType=AD;Url= Enter URL here;Username=Enter user name here;Password = Enter password here;” />

</connectionStrings>

</configuration>

• I faced a lot of issues in finding the connection string for my organization. The way I found the connection string for my organization is to go to XRM toolbox. Click on Connect. Select the connection which you want to see the connection string for. Click on the yellow highlighted button.

• Copy the connection string and replace the above config file with your connection string. (Goes after connectionString =”Your Connection string goes here…” Make sure the ; is added in the end after the password.

• NOTE- The above method is based on an assumption that you’re already connected to the organization through the XRM toolbox using the connection wizard, SDK login control or connection wizard.

• Once the code is ready to build the solution and your console application is ready.

With Dynamics, you can usher a transformation in the way your business operates. AhaApps knows that with the right custom-made solutions, one can get the best out of the CRM. Speak with us to know more.