Example #1
0
        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
        }
Example #2
0
        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);
        }