Dynamics Community Forum Thread Details

Dynamics CRM- update contact entity record

Hi,

I have created contact record using asp.net. Now i need to Check if the contact record exists . If exists , update the same record. through advance find have downloaded fetch XML and added to my fetchxml variable. please suggest the logic .below is my code

using Microsoft.Crm.Sdk.Messages;
using Microsoft.Xrm.Client;
using Microsoft.Xrm.Client.Services;
using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Query;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace LandingPage
{

public class CrmDataProvider
{
public void CreateContact(ContactDetails contactInfo)
{

// Establish a connection to crm and get the connection proxy

string connectionString = "Url=xyz ; Username=xyz ;Password= xyz";
CrmConnection connect = CrmConnection.Parse(connectionString);
OrganizationService service;

using (service = new OrganizationService(connect))
{
WhoAmIRequest request = new WhoAmIRequest();
Guid userId = ((WhoAmIResponse)service.Execute(request)).UserId;

ContactDetails contact = new ContactDetails();

//Check if the contact record exists . If exists , update the same record.

//Fecthxml query
string fetchXml = @" <fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
<entity name='contact'>
<attribute name='fullname' />
<attribute name='parentcustomerid' />
<attribute name='telephone1' />
<attribute name='emailaddress1' />
<attribute name='contactid' />
<order attribute='fullname' descending='false' />
<filter type='and'>
<condition attribute= 'mobilephone' operator='not-null' />
</filter>
</entity>
</fetch>" ;
FetchExpression query = new FetchExpression(fetchXml);
EntityCollection results = service.RetrieveMultiple(query);

if (results.Entities.Count > 0)
{
Entity contactRecord = results[0];

contactRecord["firstname"] = contactInfo.FirstName;
contactRecord["lastname"] = contactInfo.LastName;
contactRecord["emailaddress1"] = contactInfo.EmailId;
contactRecord["mobilephone"] = contactInfo.MobilePhone;
contactRecord["address1_line1"] = contactInfo.Street1;
contactRecord["address1_line2"] = contactInfo.Street2;
contactRecord["address1_line3"] = contactInfo.Street3;
contactRecord["address1_city"] = contactInfo.City;

service.Update(contactRecord);

}

//Else, Create the contact record
else
{
Entity entity = new Entity();
entity.LogicalName = "contact";

entity["firstname"] = contactInfo.FirstName;
entity["lastname"] = contactInfo.LastName;
entity["emailaddress1"] = contactInfo.EmailId;
entity["mobilephone"] = contactInfo.MobilePhone;
entity["address1_line1"] = contactInfo.Street1;
entity["address1_line2"] = contactInfo.Street2;
entity["address1_line3"] = contactInfo.Street3;
entity["address1_city"] = contactInfo.City;
entity["address1_stateorprovince"] = contactInfo.State;
entity["address1_country"] = contactInfo.Country;
entity["spousesname"] = contactInfo.SpouseName;
entity["birthdate"] = contactInfo.Birthday;
entity["anniversary"] = contactInfo.Anniversary;

//Create entity gender with option value
if (contactInfo.Gender == "Male")
{
entity["gendercode"] = new OptionSetValue(1);
}
else
{
entity["gendercode"] = new OptionSetValue(2);
}

//entity["familystatuscode"] = contactInfo.MaritalStatus;

if (contactInfo.MaritalStatus == "Single")
{
entity["familystatuscode"] = new OptionSetValue(1);
}

else
{
entity["familystatuscode"] = new OptionSetValue(2);
}

service.Create(entity);
}
}

// Create the entity
}

}
}

Quick Links

Leaderboard