public override void ExecuteCRMWorkFlowActivity(CodeActivityContext executionContext, LocalWorkflowContext crmWorkflowContext)
{
#region local variables
SCII.Helper objCommon;
//EntityReference _Contact;
int _errorCode = 400; //Bad Request
string _errorMessageDetail = string.Empty;
int? optionSetValue;
Guid orgId = Guid.Empty;
Entity existingAccountRecord = new Entity();
StringBuilder _errorMessage = new StringBuilder();
string _uniqueReference = string.Empty;
string _crn = string.Empty;
bool isOrgExists = false;
#endregion
LocalWorkflowContext localcontext = new LocalWorkflowContext(executionContext);
Entity AccountObject = new Entity(SCS.AccountContants.ENTITY_NAME);
try
{
objCommon = new SCII.Helper(executionContext);
OrganizationServiceContext orgSvcContext = new OrganizationServiceContext(objCommon.service);
localcontext.Trace("started execution");
localcontext.Trace("attempt to seriallised");
string jsonPayload = ReqPayload.Get(executionContext);
SCII.UpdateOrganisationRequest accountPayload = JsonConvert.DeserializeObject <SCII.UpdateOrganisationRequest>(jsonPayload);
//if (accountPayload.clearlist != null)
// //localcontext.Trace("TRACE TO CHECK:" + accountPayload.clearlist[0].ToString());
// localcontext.Trace("TRACE TO CHECK:" + accountPayload.clearlist.fields[0].ToString());
var ValidationContext = new ValidationContext(accountPayload, serviceProvider: null, items: null);
ICollection <ValidationResult> ValidationResults = null;
ICollection <ValidationResult> ValidationResultUpdates = null;
var isValid = objCommon.Validate(accountPayload, out ValidationResults);
Boolean isValidUpdate = accountPayload.updates == null ? true :
objCommon.Validate(accountPayload.updates, out ValidationResultUpdates);
localcontext.Trace("TRACE TO valid:" + isValid);
if (isValid && isValidUpdate)
{
//check organisation id exists
if (!string.IsNullOrEmpty(accountPayload.organisationid) && !string.IsNullOrWhiteSpace(accountPayload.organisationid))
{
if (Guid.TryParse(accountPayload.organisationid, out orgId))
{
existingAccountRecord = objCommon.service.Retrieve(SCS.AccountContants.ENTITY_NAME, orgId, new Microsoft.Xrm.Sdk.Query.ColumnSet(SCS.AccountContants.UNIQUEREFERENCE, SCS.AccountContants.PARENTACCOUNTID));
if (existingAccountRecord != null && existingAccountRecord.Id != null)
{
AccountObject.Id = existingAccountRecord.Id;
_uniqueReference = (string)existingAccountRecord[SCS.AccountContants.UNIQUEREFERENCE];
isOrgExists = true;
}
}
}
// if org exists then go on to update the organisation
if (isOrgExists && accountPayload.updates != null)
{
localcontext.Trace("length:" + accountPayload.updates.name.Length);
//if (accountPayload.updates.hierarchylevel != 0)
#region Cannot be Cleared Update Fields
if (accountPayload.updates.name != null)
{
AccountObject[SCS.AccountContants.NAME] = accountPayload.updates.name;
}
if (accountPayload.updates.type != null)
{
if (!String.IsNullOrEmpty(Enum.GetName(typeof(SCSE.defra_OrganisationType), accountPayload.updates.type)))
{
optionSetValue = accountPayload.updates.type;
localcontext.Trace("before assigning type " + accountPayload.updates.type);
localcontext.Trace(optionSetValue.ToString());
localcontext.Trace("after setting up option set value");
OptionSetValueCollection BusinessTypes = new OptionSetValueCollection();
BusinessTypes.Add(new OptionSetValue(optionSetValue.Value));
AccountObject[SCS.AccountContants.TYPE] = BusinessTypes;
}
else
{
_errorMessage = _errorMessage.Append(String.Format("Option set value {0} for orgnisation type does not exists.",
accountPayload.updates.type));
}
}
#endregion
#region Clear able update fields
//Flag to check if the clearing of data is required for the selected OrganisationRequest fields
bool clearRequired = accountPayload.clearlist != null &&
accountPayload.clearlist.fields != null && accountPayload.clearlist.fields.Length > 0;
//Hierarchy Level
if (clearRequired && accountPayload.clearlist.fields.Contains(SCII.OrganisationClearFields.hierarchylevel))
{
AccountObject[SCS.AccountContants.HIERARCHYLEVEL] = null;
}
else if (accountPayload.updates.hierarchylevel != null)
{
localcontext.Trace("hierarchylevel level:" + accountPayload.updates.hierarchylevel);
if (!String.IsNullOrEmpty(Enum.GetName(typeof(SCSE.defra_OrganisationHierarchyLevel), accountPayload.updates.hierarchylevel)))
{
localcontext.Trace("before assinging value");
AccountObject[SCS.AccountContants.HIERARCHYLEVEL] = new OptionSetValue((int)accountPayload.updates.hierarchylevel);
localcontext.Trace("after assinging value");
}
else
{
_errorMessage = _errorMessage.Append(String.Format("Option set value {0} for orgnisation hirarchy level not found.",
accountPayload.updates.hierarchylevel));
}
}
if (clearRequired && accountPayload.clearlist.fields.Contains(SCII.OrganisationClearFields.crn))
{
localcontext.Trace("before clearing identifier value");
//AccountObject[SCS.AccountContants.COMPANY_HOUSE_ID] = null;
objCommon.ClearIdentifier(SCS.Identifers.COMPANYHOUSEIDENTIFIERNAME, AccountObject.Id);
}
else
{
//check if crn exists
if (accountPayload.updates.crn != null)
{
orgSvcContext = new OrganizationServiceContext(objCommon.service);
//var checkCRNExistis = from c in orgSvcContext.CreateQuery("account")
// where (string)c[SCS.AccountContants.COMPANY_HOUSE_ID] == accountPayload.updates.crn
// select new { organisationid = c.Id };
Guid?IdentifierId = objCommon.CheckIfSameIdenfierExists(SCS.Identifers.COMPANYHOUSEIDENTIFIERNAME, accountPayload.updates.crn, AccountObject.Id);
if (IdentifierId == null)
{
//AccountObject[SCS.AccountContants.COMPANY_HOUSE_ID] = accountPayload.updates.crn;
localcontext.Trace("updaing identifier in update org" + IdentifierId);
objCommon.UpdateIdentifier(SCS.Identifers.COMPANYHOUSEIDENTIFIERNAME, accountPayload.updates.crn, AccountObject.Id);
}
else
{
_errorCode = 412;
throw new Exception("Company house id already exists.");
}
}
}
if (clearRequired && accountPayload.clearlist.fields.Contains(SCII.OrganisationClearFields.telephone))
{
AccountObject[SCS.AccountContants.TELEPHONE1] = null;
}
else
{
if (accountPayload.updates.telephone != null)
{
AccountObject[SCS.AccountContants.TELEPHONE1] = accountPayload.updates.telephone;
}
}
localcontext.Trace("after setting other fields");
if (clearRequired && accountPayload.clearlist.fields.Contains(SCII.OrganisationClearFields.parentorganisationcrmid))
{
AccountObject[SCS.AccountContants.PARENTACCOUNTID] = null;
}
else
{
bool IsValidGuid;
Guid ParentAccountId;
if (!String.IsNullOrEmpty(accountPayload.updates.parentorganisationcrmid))
{
IsValidGuid = Guid.TryParse(accountPayload.updates.parentorganisationcrmid, out ParentAccountId);
if (IsValidGuid)
{
var checkParentOrgExists = from c in orgSvcContext.CreateQuery(SCS.AccountContants.ENTITY_NAME)
where (string)c[SCS.AccountContants.ACCOUNTID] == accountPayload.updates.parentorganisationcrmid
select new
{
organisationid = c.Id
};
if (checkParentOrgExists.FirstOrDefault() != null)
{
if (existingAccountRecord.Contains(SCS.AccountContants.PARENTACCOUNTID))
{
localcontext.Trace("inside parent update:" + ParentAccountId);
if (((EntityReference)existingAccountRecord[SCS.AccountContants.PARENTACCOUNTID]).Id.ToString() != accountPayload.updates.parentorganisationcrmid)
{
AccountObject[SCS.AccountContants.PARENTACCOUNTID] = new EntityReference(SCS.AccountContants.ENTITY_NAME, ParentAccountId);
}
}
else
{
AccountObject[SCS.AccountContants.PARENTACCOUNTID] = new EntityReference(SCS.AccountContants.ENTITY_NAME, ParentAccountId);
}
}
else
{
localcontext.Trace("throwing error becuase organisation does not exists.");
throw new Exception("Parent account id does not exists.");
}
}
else
{
localcontext.Trace("throwing error becuase invalid Guid;");
throw new Exception("parentorganisationcrmid is not valid guid;");
}
}
}
if (clearRequired && accountPayload.clearlist.fields.Contains(SCII.OrganisationClearFields.email))
{
AccountObject[SCS.AccountContants.EMAILADDRESS1] = null;
}
else
{
if (accountPayload.updates.email != null)
{
AccountObject[SCS.AccountContants.EMAILADDRESS1] = accountPayload.updates.email;
}
}
if (clearRequired && accountPayload.clearlist.fields.Contains(SCII.OrganisationClearFields.validatedwithcompanieshouse))
{
AccountObject[SCS.AccountContants.VALIDATED_WITH_COMPANYHOUSE] = null;
}
else
{
if (accountPayload.updates.validatedwithcompanieshouse != null)
{
localcontext.Trace("inside validated with companies house:" + accountPayload.updates.validatedwithcompanieshouse);
bool isValidCompaniesHouse = false;
if (Boolean.TryParse(accountPayload.updates.validatedwithcompanieshouse.ToString(), out isValidCompaniesHouse))
{
AccountObject[SCS.AccountContants.VALIDATED_WITH_COMPANYHOUSE] = isValidCompaniesHouse;
}
else
{
_errorMessage = _errorMessage.Append(String.Format("validated with companyhouse value {0} is not valid;",
accountPayload.updates.validatedwithcompanieshouse));
}
}
}
#endregion
localcontext.Trace("outside validated with companies house:" + accountPayload.updates.validatedwithcompanieshouse);
localcontext.Trace("before updating guid:" + AccountObject.Id.ToString());
objCommon.service.Update(AccountObject);
EntityReference AccountEntityReference = new EntityReference(SCS.AccountContants.ENTITY_NAME, AccountObject.Id);
if (clearRequired && accountPayload.clearlist.fields.Contains(SCII.OrganisationClearFields.email))
{
objCommon.UpsertContactDetails((int)SCII.EmailTypes.PrincipalEmailAddress, accountPayload.updates.email, AccountEntityReference, false, true);
}
else if (accountPayload.updates.email != null)
{
objCommon.UpsertContactDetails((int)SCII.EmailTypes.PrincipalEmailAddress, accountPayload.updates.email, AccountEntityReference, true, false);
}
//if phone is in clear list then deactivate the contact details record of principalphonenumber
if (clearRequired && accountPayload.clearlist.fields.Contains(SCII.OrganisationClearFields.telephone))
{
objCommon.UpsertContactDetails((int)SCII.PhoneTypes.PrincipalPhoneNumber, accountPayload.updates.telephone, AccountEntityReference, false, true);
}
else if (accountPayload.updates.telephone != null)
{
objCommon.UpsertContactDetails((int)SCII.PhoneTypes.PrincipalPhoneNumber, accountPayload.updates.telephone, AccountEntityReference, true, false);
}
localcontext.Trace("after updating guid:" + AccountObject.Id.ToString());
_errorCode = 200;
}
//if the organisation does not exists
else
{
_errorCode = 404;
_errorMessage = _errorMessage.Append(String.Format("Oranisation with id {0} does not exists.",
accountPayload.organisationid));
}
}
else
{
localcontext.Trace("inside validation result");
_errorMessage = new StringBuilder();
//this will throw an error
foreach (ValidationResult vr in ValidationResults)
{
_errorMessage.Append(vr.ErrorMessage + " ");
}
if (ValidationResultUpdates != null)
{
foreach (ValidationResult vr in ValidationResultUpdates)
{
_errorMessage.Append(vr.ErrorMessage + " ");
}
}
_errorCode = 400;
}
}
catch (Exception ex)
{
localcontext.Trace("inside exception");
_errorCode = 500;
_errorMessage = _errorMessage.Append("Error occured while processing request");
_errorMessageDetail = ex.Message;
localcontext.Trace(ex.Message);
}
finally
{
localcontext.Trace("finally block start");
SCIIR.AccountResponse responsePayload = new SCIIR.AccountResponse()
{
code = _errorCode,
message = _errorMessage.ToString(),
datetime = DateTime.UtcNow,
version = "1.0.0.2",
status = _errorCode == 200 ? "success" : "failure",
data = new SCIIR.AccountData()
{
accountid = AccountObject.Id,
uniquereference = _uniqueReference,
error = new SCIIR.ResponseErrorBase()
{
details = _errorMessageDetail == string.Empty ? _errorMessage.ToString() : _errorMessageDetail
}
}
};
string resPayload = JsonConvert.SerializeObject(responsePayload);
ResPayload.Set(executionContext, resPayload);
localcontext.Trace("finally block end");
}
}
public override void ExecuteCRMWorkFlowActivity(CodeActivityContext executionContext, LocalWorkflowContext crmWorkflowContext)
{
String PayloadDetails = request.Get(executionContext);
int? optionSetValue;
int ErrorCode = 400; //400 -- bad request
String _ErrorMessage = string.Empty;
String _ErrorMessageDetail = string.Empty;
Guid ContactId = Guid.Empty;
Guid CrmGuid = Guid.Empty;
StringBuilder ErrorMessage = new StringBuilder();
String UniqueReference = string.Empty;
Guid? ExistingID = null;
try
{
objCommon = new SCII.Helper(executionContext);
objCommon.tracingService.Trace("Load CRM Service from context --- OK");
Entity AccountObject = new Entity(Defra.CustMaster.D365.Common.schema.AccountContants.ENTITY_NAME);
objCommon.tracingService.Trace("attempt to seriallised new");
SCII.OrganisationRequest AccountPayload = JsonConvert.DeserializeObject <SCII.OrganisationRequest>(PayloadDetails);
objCommon.tracingService.Trace("seriallised object working");
var ValidationContext = new ValidationContext(AccountPayload, serviceProvider: null, items: null);
ICollection <System.ComponentModel.DataAnnotations.ValidationResult> ValidationResults = null;
ICollection <System.ComponentModel.DataAnnotations.ValidationResult> ValidationResultsAddress = null;
var isValid = objCommon.Validate(AccountPayload, out ValidationResults);
Boolean isValidAddress = AccountPayload.address == null ? true :
objCommon.Validate(AccountPayload.address, out ValidationResultsAddress);
if (AccountPayload.address != null && AccountPayload.address.type != null)
{
if (!Enum.IsDefined(typeof(SCII.AddressTypes), AccountPayload.address.type))
{
ErrorMessage.Append(String.Format("Option set value for address of type {0} not found;", AccountPayload.address.type));
}
}
if (isValid & isValidAddress && ErrorMessage.Length == 0)
{
objCommon.tracingService.Trace("length{0}", AccountPayload.name.Length);
objCommon.tracingService.Trace("hierarchylevel level: {0}", AccountPayload.hierarchylevel);
if (AccountPayload.hierarchylevel == 0 || !String.IsNullOrEmpty(Enum.GetName(typeof(SCSE.defra_OrganisationHierarchyLevel), AccountPayload.hierarchylevel))
)
{
objCommon.tracingService.Trace("before assinging value");
if (AccountPayload.hierarchylevel != 0)
{
AccountObject[Defra.CustMaster.D365.Common.schema.AccountContants.HIERARCHYLEVEL] = new OptionSetValue(AccountPayload.hierarchylevel);
}
objCommon.tracingService.Trace("after assinging value");
if (!String.IsNullOrEmpty(Enum.GetName(typeof(SCSE.defra_OrganisationType), AccountPayload.type)))
{
//check if crn exists
OrganizationServiceContext orgSvcContext = new OrganizationServiceContext(objCommon.service);
if (AccountPayload.crn != null && AccountPayload.crn != string.Empty)
{
ExistingID = objCommon.CheckIfSameIdenfierExists(SCS.Identifers.COMPANYHOUSEIDENTIFIERNAME, AccountPayload.crn, null);
objCommon.tracingService.Trace("company housid from identifier:" + ExistingID);
}
//var checkCRNExistis = from c in orgSvcContext.CreateQuery("account")
// where (string)c[Defra.CustMaster.D365.Common.schema.AccountContants.COMPANY_HOUSE_ID] == AccountPayload.crn
// select new { organisationid = c.Id };
if (ExistingID == null)
{
objCommon.tracingService.Trace("After completing validation 12" + AccountPayload.type);
optionSetValue = AccountPayload.type;
objCommon.tracingService.Trace("before assigning type " + AccountPayload.type);
objCommon.tracingService.Trace(optionSetValue.ToString());
objCommon.tracingService.Trace("after setting up option set value");
OptionSetValueCollection BusinessTypes = new OptionSetValueCollection();
BusinessTypes.Add(new OptionSetValue(optionSetValue.Value));
AccountObject[Defra.CustMaster.D365.Common.schema.AccountContants.TYPE] = BusinessTypes;
AccountObject[Defra.CustMaster.D365.Common.schema.AccountContants.NAME] = AccountPayload.name == null ? string.Empty : AccountPayload.name;
//AccountObject[Defra.CustMaster.D365.Common.schema.AccountContants.COMPANY_HOUSE_ID] = AccountPayload.crn == string.Empty ? null : AccountPayload.crn;
AccountObject[Defra.CustMaster.D365.Common.schema.AccountContants.TELEPHONE1] = AccountPayload.telephone == null ? string.Empty : AccountPayload.telephone;
if (AccountPayload.validatedwithcompanieshouse != null)
{
bool isValidCompaniesHouse = false;
if (Boolean.TryParse(AccountPayload.validatedwithcompanieshouse.ToString(), out isValidCompaniesHouse))
{
AccountObject[SCS.AccountContants.VALIDATED_WITH_COMPANYHOUSE] = isValidCompaniesHouse;
}
else
{
ErrorMessage = ErrorMessage.Append(string.Format("Validated with companyhouse value {0} is not valid;",
AccountPayload.validatedwithcompanieshouse));
}
}
objCommon.tracingService.Trace("after setting other fields");
bool IsValidGuid;
Guid ParentAccountId;
if (AccountPayload.parentorganisation != null && !string.IsNullOrEmpty(AccountPayload.parentorganisation.parentorganisationcrmid))
{
objCommon.tracingService.Trace("before checking value");
IsValidGuid = Guid.TryParse(AccountPayload.parentorganisation.parentorganisationcrmid, out ParentAccountId);
if (IsValidGuid)
{
var checkParentOrgExists = from c in orgSvcContext.CreateQuery("account")
where (string)c[Defra.CustMaster.D365.Common.schema.AccountContants.ACCOUNTID] == AccountPayload.parentorganisation.parentorganisationcrmid
select new
{
organisationid = c.Id
};
if (checkParentOrgExists.FirstOrDefault() != null)
{
AccountObject[Defra.CustMaster.D365.Common.schema.AccountContants.PARENTACCOUNTID]
= new EntityReference(SCS.AccountContants.ENTITY_NAME, ParentAccountId);
objCommon.tracingService.Trace("after assinging value");
}
else
{
objCommon.tracingService.Trace("throwing error becuase organisation does not exists.");
throw new Exception("Parent account id does not exists.");
}
}
else
{
objCommon.tracingService.Trace("invalid Guid.");
throw new Exception("Invalid parent account Id.");
}
}
AccountObject[Defra.CustMaster.D365.Common.schema.AccountContants.EMAILADDRESS1] = AccountPayload.email;
objCommon.tracingService.Trace("before createing guid:");
CrmGuid = objCommon.service.Create(AccountObject);
objCommon.CreateIdentifier(SCS.Identifers.COMPANYHOUSEIDENTIFIERNAME, AccountPayload.crn, new EntityReference(SCS.AccountContants.ENTITY_NAME, CrmGuid));
//create contactdetail record for primary contact details
if (AccountPayload.email != null)
{
objCommon.tracingService.Trace("email id before upsert contact");
objCommon.UpsertContactDetails((int)SCII.EmailTypes.PrincipalEmailAddress, AccountPayload.email, new EntityReference(SCS.AccountContants.ENTITY_NAME, CrmGuid), false, false);
objCommon.tracingService.Trace("email id after upsert contact");
}
if (AccountPayload.telephone != null)
{
objCommon.tracingService.Trace("telephone before upsert contact");
objCommon.UpsertContactDetails((int)SCII.PhoneTypes.PrincipalPhoneNumber, AccountPayload.telephone, new EntityReference(SCS.AccountContants.ENTITY_NAME, CrmGuid), false, false);
objCommon.tracingService.Trace("telephone after upsert contact");
}
objCommon.tracingService.Trace("after createing guid:{0}", CrmGuid.ToString());
Entity AccountRecord = objCommon.service.Retrieve("account", CrmGuid, new Microsoft.Xrm.Sdk.Query.ColumnSet(SCS.AccountContants.UNIQUEREFERENCE));
UniqueReference = (string)AccountRecord[SCS.AccountContants.UNIQUEREFERENCE];
if (AccountPayload.address != null)
{
objCommon.CreateAddress(AccountPayload.address, new EntityReference(Defra.CustMaster.D365.Common.schema.AccountContants.ENTITY_NAME, CrmGuid));
}
ErrorCode = 200;
}
else
{
ErrorCode = 412;
ErrorMessage = ErrorMessage.Append(string.Format("Company house id already exists.;"));
}
}
else
{
ErrorCode = 400;
ErrorMessage = ErrorMessage.Append(string.Format("Option set value {0} for orgnisation type does not exists.",
AccountPayload.type));
}
}
else
{
ErrorCode = 400;
ErrorMessage = ErrorMessage.Append(string.Format("Option set value {0} for orgnisation hirarchy level not found.",
AccountPayload.hierarchylevel));
}
}
else
{
objCommon.tracingService.Trace("inside validation result");
//ErrorMessage = new StringBuilder();
//this will throw an error
foreach (System.ComponentModel.DataAnnotations.ValidationResult vr in ValidationResults)
{
ErrorMessage.Append(vr.ErrorMessage + " ");
}
if (ValidationResultsAddress != null)
{
foreach (System.ComponentModel.DataAnnotations.ValidationResult vr in ValidationResultsAddress)
{
ErrorMessage.Append(vr.ErrorMessage + " ");
}
}
ErrorCode = 400;
}
}
catch (Exception ex)
{
objCommon.tracingService.Trace("inside exception");
ErrorCode = 500;
ErrorMessage.Append(ex.Message);
_ErrorMessageDetail = ex.Message;
ErrorCode = 400;
this.response.Set(executionContext, _ErrorMessageDetail);
objCommon.tracingService.Trace(ex.Message);
}
finally
{
objCommon.tracingService.Trace("finally block start");
SCIIR.AccountResponse responsePayload = new SCIIR.AccountResponse()
{
code = ErrorCode,
message = ErrorMessage.ToString(),
datetime = DateTime.UtcNow,
version = "1.0.0.2",
status = ErrorCode == 200 ? "success" : "failure",
data = new SCIIR.AccountData()
{
accountid = CrmGuid,
uniquereference = UniqueReference,
error = new SCIIR.ResponseErrorBase()
{
details = _ErrorMessageDetail
}
}
};
objCommon.tracingService.Trace("attempting to serialise");
string json = JsonConvert.SerializeObject(responsePayload);
response.Set(executionContext, json);
// OutputCode.Set(executionContext, _errorCode);
objCommon.tracingService.Trace("json {0}", json);
objCommon.tracingService.Trace("finally block end");
}
}