public override void ExecuteCRMWorkFlowActivity(CodeActivityContext executionContext, LocalWorkflowContext crmWorkflowContext) { #region "Load CRM Service from context" objCommon = new Helper(executionContext); objCommon.tracingService.Trace("CreateContact activity:Load CRM Service from context --- OK"); #endregion #region "Create Execution" try { string jsonPayload = Payload.Get(executionContext); Contact contactPayload = JsonConvert.DeserializeObject <Contact>(jsonPayload); Entity contact = new Entity(CommonSchema.Contact.ENTITY);//,"defra_upn", _UPN); _errorMessage = FieldValidation(contactPayload); var ValidationContext = new ValidationContext(contactPayload, serviceProvider: null, items: null); ICollection <ValidationResult> ValidationResults = null; ICollection <ValidationResult> ValidationResultsAddress = null; var isValid = objCommon.Validate(contactPayload, out ValidationResults); Boolean isValidAddress = contactPayload.address == null ? true : objCommon.Validate(contactPayload.address, out ValidationResultsAddress); objCommon.tracingService.Trace("just after validation"); if (isValid && isValidAddress) { if (_errorMessage == string.Empty) { //search contact record based on key named B2COBJECTID to prevent duplicate contact OrganizationServiceContext orgSvcContext = new OrganizationServiceContext(objCommon.service); var ContactWithUPN = from c in orgSvcContext.CreateQuery(CommonSchema.Contact.ENTITY) where ((string)c[CommonSchema.Contact.B2COBJECTID]).Equals((contactPayload.b2cobjectid.Trim())) select new { ContactId = c.Id, UniqueReference = c[CommonSchema.Contact.UNIQUEREFERENCE] }; var contactRecordWithUPN = ContactWithUPN.FirstOrDefault() == null ? null : ContactWithUPN.FirstOrDefault(); if (contactRecordWithUPN != null) { _contactId = contactRecordWithUPN.ContactId; _uniqueReference = contactRecordWithUPN.UniqueReference.ToString(); } //Search contact record based on key named emailaddress to prevent duplicates if (!string.IsNullOrEmpty(contactPayload.email)) { var ContactWithEmail = from c in orgSvcContext.CreateQuery(CommonSchema.Contact.ENTITY) where ((string)c[CommonSchema.Contact.EMAILADDRESS1]).Equals((contactPayload.email.Trim())) select new { ContactId = c.Id, UniqueReference = c[CommonSchema.Contact.UNIQUEREFERENCE] }; var contactRecordWithEmail = ContactWithEmail.FirstOrDefault() == null ? null : ContactWithEmail.FirstOrDefault(); if (contactRecordWithEmail != null) { _contactId = contactRecordWithEmail.ContactId; _uniqueReference = contactRecordWithEmail.UniqueReference.ToString(); } } if (_contactId == Guid.Empty) { objCommon.tracingService.Trace("CreateContact activity:ContactRecordGuidWithUPN is empty started, Creating Contact.."); if (contactPayload.title != null) { //Check whether the gendercode is found in GenderEnum mapping if (Enum.IsDefined(typeof(ContactTitles), contactPayload.title)) { //Check whether gendercode is found in Dynamics GenderEnum mapping string contactTitle = Enum.GetName(typeof(ContactTitles), contactPayload.title); if (string.IsNullOrEmpty(contactTitle)) { defra_Title dynamicsTitle = (defra_Title)Enum.Parse(typeof(defra_Title), contactTitle); contact[CommonSchema.Contact.TITLE] = new OptionSetValue((int)dynamicsTitle); } } } if (contactPayload.firstname != null) { contact[CommonSchema.Contact.FIRSTNAME] = contactPayload.firstname; } if (contactPayload.lastname != null) { contact[CommonSchema.Contact.LASTNAME] = contactPayload.lastname; } if (contactPayload.middlename != null) { contact[CommonSchema.Contact.MIDDLENAME] = contactPayload.middlename; } if (contactPayload.email != null) { contact[CommonSchema.Contact.EMAILADDRESS1] = contactPayload.email; } if (contactPayload.b2cobjectid != null) { contact[CommonSchema.Contact.B2COBJECTID] = contactPayload.b2cobjectid; } if (contactPayload.tacsacceptedversion != null) { contact[CommonSchema.Contact.TACSACCEPTEDVERSION] = contactPayload.tacsacceptedversion; } if (contactPayload.telephone != null) { contact[CommonSchema.Contact.TELEPHONE1] = contactPayload.telephone; } objCommon.tracingService.Trace("setting contact date params:started.."); if (!string.IsNullOrEmpty(contactPayload.tacsacceptedon) && !string.IsNullOrWhiteSpace(contactPayload.tacsacceptedon)) { objCommon.tracingService.Trace("date accepted on in string" + contactPayload.tacsacceptedon); DateTime resultDate; if (DateTime.TryParse(contactPayload.tacsacceptedon, out resultDate)) { objCommon.tracingService.Trace("date accepted on in dateformat" + resultDate); contact[CommonSchema.Contact.TACSACCEPTEDON] = (resultDate); } } //set birthdate if (!string.IsNullOrEmpty(contactPayload.dob) && !string.IsNullOrWhiteSpace(contactPayload.dob)) { DateTime resultDob; if (DateTime.TryParse(contactPayload.dob, out resultDob)) { contact[CommonSchema.Contact.GENDERCODE] = resultDob; } } if (contactPayload.gender != null) { //Check whether the gendercode is found in GenderEnum mapping if (Enum.IsDefined(typeof(ContactGenderCodes), contactPayload.gender)) { //Check whether gendercode is found in Dynamics GenderEnum mapping string genderCode = Enum.GetName(typeof(Contact_GenderCode), contactPayload.gender); { Contact_GenderCode dynamicsGenderCode = (Contact_GenderCode)Enum.Parse(typeof(Contact_GenderCode), genderCode); contact[CommonSchema.Contact.GENDERCODE] = new OptionSetValue((int)dynamicsGenderCode); } } } objCommon.tracingService.Trace("CreateContact activity:started.."); _contactId = objCommon.service.Create(contact); Entity contactRecord = objCommon.service.Retrieve(CommonSchema.Contact.ENTITY, _contactId, new Microsoft.Xrm.Sdk.Query.ColumnSet(true));//Defra.CustMaster.D365.Common.schema.Contact.UNIQUEREFERENCE)); objCommon.tracingService.Trace((string)contactRecord[CommonSchema.Contact.UNIQUEREFERENCE]); _uniqueReference = (string)contactRecord[CommonSchema.Contact.UNIQUEREFERENCE]; _errorCode = 200;//Success objCommon.tracingService.Trace("CreateContact activity:ended. " + _contactId.ToString()); //create contact address and contact details if (contactPayload.address != null) { objCommon.CreateAddress(contactPayload.address, new EntityReference(D365.Common.schema.Contact.ENTITY, _contactId)); } } else { objCommon.tracingService.Trace("CreateContact activity:ContactRecordGuidWithB2C/Email is found/duplicate."); _errorCode = 412;//Duplicate UPN _errorMessage = "Duplicate Record"; } } } else { objCommon.tracingService.Trace("inside validation result"); StringBuilder ErrorMessage = new StringBuilder(); //this will throw an error foreach (ValidationResult vr in ValidationResults) { ErrorMessage.Append(vr.ErrorMessage + " "); } if (contactPayload.address != null) { foreach (ValidationResult vr in ValidationResultsAddress) { ErrorMessage.Append(vr.ErrorMessage + " "); } } _errorCode = 400; _errorMessage = ErrorMessage.ToString(); } objCommon.tracingService.Trace("CreateContact activity:setting output params like error code etc.. started"); objCommon.tracingService.Trace("CreateContact activity:setting output params like error code etc.. ended"); } catch (Exception ex) { _errorCode = 500;//Internal Error _errorMessage = "Error occured while processing request"; _errorMessageDetail = ex.Message; objCommon.tracingService.Trace(ex.Message); //throw ex; } finally { objCommon.tracingService.Trace("finally block start"); ContactResponse responsePayload = new ContactResponse() { code = _errorCode, message = _errorMessage, datetime = DateTime.UtcNow, version = "1.0.0.2", program = "CreateContact", status = _errorCode == 200 || _errorCode == 412 ? "success" : "failure", data = new ContactData() { contactid = _contactId == Guid.Empty ? null : _contactId.ToString(), uniquereference = _uniqueReference == string.Empty ? null : _uniqueReference, error = new ResponseErrorBase() { details = _errorMessageDetail == string.Empty ? _errorMessage : _errorMessageDetail } } }; string resPayload = JsonConvert.SerializeObject(responsePayload); Response.Set(executionContext, resPayload); objCommon.tracingService.Trace("finally block end"); } #endregion }
protected override void Execute(CodeActivityContext context) { // Construct the Local plug-in context. LocalWorkflowContext localcontext = new LocalWorkflowContext(context); localcontext.Trace("started execution"); #region "Load CRM Service from context" objCommon = new Helper(context); localcontext.Trace("CreateContact activity:Load CRM Service from context --- OK"); #endregion #region "Create Execution" try { string jsonPayload = this.PayLoad.Get(context); Contact contactPayload = JsonConvert.DeserializeObject <Contact>(jsonPayload); Boolean duplicateRecordExist = false; Entity contact; var ValidationContext = new ValidationContext(contactPayload, serviceProvider: null, items: null); ICollection <ValidationResult> ValidationResults = null; ICollection <ValidationResult> ValidationResultsAddress = null; var isValid = objCommon.Validate(contactPayload, out ValidationResults); Boolean isValidAddress = contactPayload.address == null ? true : objCommon.Validate(contactPayload.address, out ValidationResultsAddress); localcontext.Trace("just after validation"); if (isValid && isValidAddress) { if (_errorMessage == string.Empty) { //search contact record based on key named B2COBJECTID OrganizationServiceContext orgSvcContext = new OrganizationServiceContext(objCommon.service); var ContactWithUPN = from c in orgSvcContext.CreateQuery(CommonSchema.Contact.ENTITY) where ((string)c[CommonSchema.Contact.B2COBJECTID]).Equals((contactPayload.b2cobjectid.Trim())) select new { ContactId = c.Id, UniqueReference = c[CommonSchema.Contact.UNIQUEREFERENCE] }; var contactRecordWithUPN = ContactWithUPN.FirstOrDefault() == null ? null : ContactWithUPN.FirstOrDefault(); if (contactRecordWithUPN != null) { _contactId = contactRecordWithUPN.ContactId; _uniqueReference = contactRecordWithUPN.UniqueReference.ToString(); //Search contact record based on key named emailaddress to prevent duplicates if (!string.IsNullOrEmpty(contactPayload.email)) { localcontext.Trace("searching for contact ignoring current record"); //compare with record ignoring current record var ContactWithEmail = from c in orgSvcContext.CreateQuery(CommonSchema.Contact.ENTITY) where ((string)c[CommonSchema.Contact.EMAILADDRESS1]) == contactPayload.email.Trim() && (string)c[CommonSchema.Contact.UNIQUEREFERENCE] != _uniqueReference select new { ContactId = c.Id, UniqueReference = c[CommonSchema.Contact.UNIQUEREFERENCE] }; var contactRecordWithEmail = ContactWithEmail.FirstOrDefault() == null ? null : ContactWithEmail.FirstOrDefault(); duplicateRecordExist = contactRecordWithEmail == null ? false : true; localcontext.Trace("duplicate check: " + duplicateRecordExist); } if (!duplicateRecordExist) { contact = new Entity(CommonSchema.Contact.ENTITY, _contactId); localcontext.Trace("update activity:ContactRecordGuidWithUPN is empty started, update Contact.."); //Check whether the gendercode is found in GenderEnum mapping if (Enum.IsDefined(typeof(ContactTitles), contactPayload.title)) { //Check whether gendercode is found in Dynamics GenderEnum mapping string contactTitle = Enum.GetName(typeof(ContactTitles), contactPayload.title); if (string.IsNullOrEmpty(contactTitle)) { defra_Title dynamicsTitle = (defra_Title)Enum.Parse(typeof(defra_Title), contactTitle); contact[CommonSchema.Contact.TITLE] = new OptionSetValue((int)dynamicsTitle); } } localcontext.Trace("setting contact date params:started.."); if (!string.IsNullOrEmpty(contactPayload.tacsacceptedon) && !string.IsNullOrWhiteSpace(contactPayload.tacsacceptedon)) { localcontext.Trace("date accepted on in string" + contactPayload.tacsacceptedon); DateTime resultDate; if (DateTime.TryParse(contactPayload.tacsacceptedon, out resultDate)) { localcontext.Trace("date accepted on in dateformat" + resultDate); contact[CommonSchema.Contact.TACSACCEPTEDON] = (resultDate); } } //set birthdate if (!string.IsNullOrEmpty(contactPayload.dob) && !string.IsNullOrWhiteSpace(contactPayload.dob)) { DateTime resultDob; if (DateTime.TryParse(contactPayload.dob, out resultDob)) { contact[CommonSchema.Contact.GENDERCODE] = resultDob; } } if (contactPayload.gender != null) { //Check whether the gendercode is found in GenderEnum mapping if (Enum.IsDefined(typeof(ContactGenderCodes), contactPayload.gender)) { //Check whether gendercode is found in Dynamics GenderEnum mapping string genderCode = Enum.GetName(typeof(Contact_GenderCode), contactPayload.gender); { Contact_GenderCode dynamicsGenderCode = (Contact_GenderCode)Enum.Parse(typeof(Contact_GenderCode), genderCode); contact[CommonSchema.Contact.GENDERCODE] = new OptionSetValue((int)dynamicsGenderCode); } } } localcontext.Trace("contactid: " + _contactId); objCommon.service.Update(contact); _errorCode = 200;//Success localcontext.Trace("CreateContact activity:ended. " + _contactId.ToString()); } else { localcontext.Trace("CreateContact activity:ContactRecordGuidWithB2C/Email is found/duplicate."); _errorCode = 412;//Duplicate UPN _errorMessage = "Duplicate Record"; } } else { { localcontext.Trace("record does not exists"); _errorCode = 417;//record does not exists _errorMessage = "record does not exists."; } } } } else { localcontext.Trace("inside validation result"); StringBuilder ErrorMessage = new StringBuilder(); //this will throw an error foreach (ValidationResult vr in ValidationResults) { ErrorMessage.Append(vr.ErrorMessage + " "); } if (contactPayload.address != null) { foreach (ValidationResult vr in ValidationResultsAddress) { ErrorMessage.Append(vr.ErrorMessage + " "); } } _errorCode = 400; _errorMessage = ErrorMessage.ToString(); } localcontext.Trace("CreateContact activity:setting output params like error code etc.. started"); localcontext.Trace("CreateContact activity:setting output params like error code etc.. ended"); } catch (Exception ex) { _errorCode = 500;//Internal Error _errorMessage = "Error occured while processing request"; _errorMessageDetail = ex.Message; localcontext.Trace(ex.Message); //throw ex; } finally { localcontext.Trace("finally block start"); ContactResponse responsePayload = new ContactResponse() { code = _errorCode, message = _errorMessage, datetime = DateTime.UtcNow, version = "1.0.0.2", program = "UpdateContact", status = _errorCode == 200 || _errorCode == 412 ? "success" : "failure", data = new ContactData() { contactid = _contactId == Guid.Empty ? null : _contactId.ToString(), uniquereference = _uniqueReference == string.Empty ? null : _uniqueReference, error = new ResponseErrorBase() { details = _errorMessageDetail == string.Empty ? _errorMessage : _errorMessageDetail } } }; string resPayload = JsonConvert.SerializeObject(responsePayload); ReturnMessageDetails.Set(context, resPayload); localcontext.Trace("finally block end"); } #endregion ExecuteCRMWorkFlowActivity(context, localcontext); }