public IActionResult CreateDuplicateRule(EditDuplicateRuleModel model)
{
if (ModelState.IsValid)
{
var entity = new DuplicateRule();
model.CopyTo(entity);
entity.DuplicateRuleId = Guid.NewGuid();
entity.CreatedBy = CurrentUser.SystemUserId;
var conditions = new List <DuplicateRuleCondition>();
int i = 0;
foreach (var item in model.AttributeId)
{
var cd = new DuplicateRuleCondition
{
DuplicateRuleConditionId = Guid.NewGuid(),
DuplicateRuleId = entity.DuplicateRuleId,
EntityId = model.EntityId,
IgnoreNullValues = model.IgnoreNullValues[i],
IsCaseSensitive = model.IsCaseSensitive[i],
AttributeId = item
};
conditions.Add(cd);
i++;
}
entity.Conditions = conditions;
_duplicateRuleCreater.Create(entity);
return(CreateSuccess(new { id = entity.DuplicateRuleId }));
}
var msg = GetModelErrors(ModelState);
return(CreateFailure(msg));
}
/// <summary>
/// Creates any entity records that this sample requires.
/// </summary>
public static void CreateRequiredRecords(CrmServiceClient service)
{
// Create an account record named Fourth Coffee.
var account = new Account
{
Name = "Fourth Coffee",
AccountNumber = "ACC005"
};
accountId = service.Create(account);
Console.Write("Account {0} {1} created, ", account.Name, account.AccountNumber);
// Create a duplicate detection rule
var accountDuplicateRule = new DuplicateRule
{
Name = "DuplicateRule: Accounts with the same Account Number",
BaseEntityName = "account",
MatchingEntityName = "account"
};
ruleId = service.Create(accountDuplicateRule);
// Create a duplicate detection rule condition
DuplicateRuleCondition accountDupCondition = new DuplicateRuleCondition
{
BaseAttributeName = "accountnumber",
MatchingAttributeName = "accountnumber",
OperatorCode = new OptionSetValue(0), // Exact Match.
RegardingObjectId = new EntityReference(DuplicateRule.EntityLogicalName, ruleId)
};
Guid conditionId = service.Create(accountDupCondition);
Console.Write("'{0}' created, ", accountDuplicateRule.Name);
// Execute the publish request.
var response =
(PublishDuplicateRuleResponse)service.Execute(new PublishDuplicateRuleRequest()
{
DuplicateRuleId = ruleId
});
// When the publishDuplicateRule request returns, the state of the rule will still be "Publishing" (StatusCode = 1).
// we need to wait for the publishing operation to complete, so we keep polling the state of the
// rule until it becomes "Published" (StatusCode = 2).
int i = 0;
var retrievedRule =
(DuplicateRule)service.Retrieve(DuplicateRule.EntityLogicalName, ruleId, new ColumnSet(new String[] { "statuscode" }));
while (retrievedRule.StatusCode.Value == 1 && i < 20)
{
i++;
System.Threading.Thread.Sleep(1000);
retrievedRule =
(DuplicateRule)service.Retrieve(DuplicateRule.EntityLogicalName, ruleId, new ColumnSet(new String[] { "statuscode" }));
}
Console.Write("published.\n");
}
public IActionResult EditDuplicateRule(EditDuplicateRuleModel model)
{
if (ModelState.IsValid)
{
var entity = _duplicateRuleFinder.FindById(model.DuplicateRuleId.Value);
entity.Description = model.Description;
entity.Name = model.Name;
entity.Intercepted = model.Intercepted;
var conditions = _duplicateRuleConditionService.Query(n => n.Where(w => w.DuplicateRuleId == entity.DuplicateRuleId));
int i = 0;
entity.Conditions = new List <DuplicateRuleCondition>();
foreach (var item in model.AttributeId)
{
var id = model.DetailId[i];
var condition = new DuplicateRuleCondition
{
DuplicateRuleId = entity.DuplicateRuleId,
EntityId = model.EntityId,
IgnoreNullValues = model.IgnoreNullValues[i],
IsCaseSensitive = model.IsCaseSensitive[i],
AttributeId = item
};
if (id.Equals(Guid.Empty))
{
condition.DuplicateRuleConditionId = Guid.NewGuid();
_duplicateRuleConditionService.Create(condition);
}
else
{
condition.DuplicateRuleConditionId = id;
_duplicateRuleConditionService.Update(condition);
conditions.Remove(conditions.Find(n => n.DuplicateRuleConditionId == id));
}
entity.Conditions.Add(condition);
i++;
}
//delete lost detail
var lostid = conditions.Select(n => n.DuplicateRuleConditionId).ToList();
_duplicateRuleConditionService.DeleteById(lostid);
_duplicateRuleUpdater.Update(entity);
return(UpdateSuccess(new { id = entity.DuplicateRuleId }));
}
var msg = GetModelErrors(ModelState);
return(UpdateFailure(msg));
}
/// <summary>
/// Creates any entity records that this sample requires.
/// </summary>
public static void CreateRequiredRecords(CrmServiceClient service)
{
String accountName = "Contoso, Ltd";
String websiteUrl = "http://www.contoso.com/";
Console.WriteLine(" Creating duplicate records (Account name={0}, Website URL={1})", accountName,
websiteUrl);
// Create some duplicate records
for (int i = 0; i < 2; i++)
{
var account = new Account()
{
Name = accountName,
WebSiteURL = websiteUrl
};
account.Id = service.Create(account);
duplicateAccounts[i] = account;
}
accountName = "Contoso Pharmaceuticals";
Console.WriteLine(" Creating a non-duplicate record (Account name={0}, Website URL={1})",
accountName, websiteUrl);
// Create a record that is NOT a duplicate
var distinctAccount = new Account()
{
Name = accountName,
WebSiteURL = websiteUrl
};
distinctAccount.Id = service.Create(distinctAccount);
account = distinctAccount;
Console.WriteLine(" Creating a duplicate detection rule");
// Create a duplicate detection rule
rule = new DuplicateRule()
{
Name = "Accounts with the same Account name and website url",
BaseEntityName = Account.EntityLogicalName,
MatchingEntityName = Account.EntityLogicalName
};
rule.Id = service.Create(rule);
// Create a duplicate detection rule condition
var nameCondition = new DuplicateRuleCondition()
{
BaseAttributeName = "name",
MatchingAttributeName = "name",
OperatorCode = new OptionSetValue(0), // value 0 = 'exact match'
// set the regarding id to point to the rule created earlier,
// associating this condition with that rule
RegardingObjectId = rule.ToEntityReference()
};
service.Create(nameCondition);
var websiteCondition = new DuplicateRuleCondition()
{
BaseAttributeName = "websiteurl",
MatchingAttributeName = "websiteurl",
OperatorCode = new OptionSetValue(0),
RegardingObjectId = rule.ToEntityReference()
};
service.Create(websiteCondition);
Console.WriteLine(" Publishing duplicate detection rule");
// Publish the rule
var publishRequest = new PublishDuplicateRuleRequest()
{
DuplicateRuleId = rule.Id
};
var publishResponse = (PublishDuplicateRuleResponse)service.Execute(publishRequest);
// The PublishDuplicateRule request returns before the publish is completed,
// so we keep retrieving the async job state until it is "Completed"
Console.WriteLine(" Checking to see if duplicate detection rule has finished publishing");
WaitForAsyncJobToFinish(service, publishResponse.JobId, 120);
}
/// <summary>
/// Creates any entity records that this sample requires.
/// </summary>
public void CreateRequiredRecords()
{
#region Creating Accounts
String accountName = "Contoso, Ltd";
String websiteUrl = "http://www.contoso.com/";
Console.WriteLine(" Creating duplicate records (Account name={0}, Website URL={1})", accountName,
websiteUrl);
// Create some duplicate records
for (int i = 0; i < 2; i++)
{
Account account = new Account()
{
Name = accountName,
WebSiteURL = websiteUrl
};
account.Id = _serviceProxy.Create(account);
_duplicateAccounts[i] = account;
}
accountName = "Contoso Pharmaceuticals";
Console.WriteLine(" Creating a non-duplicate record (Account name={0}, Website URL={1})",
accountName, websiteUrl);
// Create a record that is NOT a duplicate
Account distinctAccount = new Account()
{
Name = accountName,
WebSiteURL = websiteUrl
};
distinctAccount.Id = _serviceProxy.Create(distinctAccount);
_account = distinctAccount;
#endregion
#region Create and Publish duplicate detection rule
Console.WriteLine(" Creating a duplicate detection rule");
// Create a duplicate detection rule
_rule = new DuplicateRule()
{
Name = "Accounts with the same Account name and website url",
BaseEntityName = Account.EntityLogicalName,
MatchingEntityName = Account.EntityLogicalName
};
_rule.Id = _serviceProxy.Create(_rule);
// Create a duplicate detection rule condition
DuplicateRuleCondition nameCondition = new DuplicateRuleCondition()
{
BaseAttributeName = "name",
MatchingAttributeName = "name",
OperatorCode = new OptionSetValue(0), // value 0 = 'exact match'
// set the regarding id to point to the rule created earlier,
// associating this condition with that rule
RegardingObjectId = _rule.ToEntityReference()
};
_serviceProxy.Create(nameCondition);
DuplicateRuleCondition websiteCondition = new DuplicateRuleCondition()
{
BaseAttributeName = "websiteurl",
MatchingAttributeName = "websiteurl",
OperatorCode = new OptionSetValue(0),
RegardingObjectId = _rule.ToEntityReference()
};
_serviceProxy.Create(websiteCondition);
Console.WriteLine(" Publishing duplicate detection rule");
// Publish the rule
PublishDuplicateRuleRequest publishRequest = new PublishDuplicateRuleRequest()
{
DuplicateRuleId = _rule.Id
};
PublishDuplicateRuleResponse publishResponse = (PublishDuplicateRuleResponse)_serviceProxy.Execute(publishRequest);
// The PublishDuplicateRule request returns before the publish is completed,
// so we keep retrieving the async job state until it is "Completed"
Console.WriteLine(" Checking to see if duplicate detection rule has finished publishing");
WaitForAsyncJobToFinish(publishResponse.JobId, 60);
#endregion
}
public bool Update(DuplicateRuleCondition entity)
{
return(_duplicateRuleConditionRepository.Update(entity));
}
/// <summary>
/// Creates any entity records that this sample requires.
/// </summary>
public void CreateRequiredRecords()
{
// Create an account record named Fourth Coffee.
Account account = new Account
{
Name = "Fourth Coffee",
AccountNumber = "ACC005"
};
_accountId = _service.Create(account);
Console.Write("Account {0} {1} created, ", account.Name, account.AccountNumber);
// Create a duplicate detection rule
DuplicateRule accountDuplicateRule = new DuplicateRule
{
Name = "DuplicateRule: Accounts with the same Account Number",
BaseEntityName = "account",
MatchingEntityName = "account"
};
_ruleId = _service.Create(accountDuplicateRule);
// Create a duplicate detection rule condition
DuplicateRuleCondition accountDupCondition = new DuplicateRuleCondition
{
BaseAttributeName = "accountnumber",
MatchingAttributeName = "accountnumber",
OperatorCode = new OptionSetValue(0), // Exact Match.
RegardingObjectId = new EntityReference(DuplicateRule.EntityLogicalName, _ruleId)
};
Guid conditionId = _service.Create(accountDupCondition);
Console.Write("'{0}' created, ", accountDuplicateRule.Name);
// Execute the publish request.
PublishDuplicateRuleResponse response =
(PublishDuplicateRuleResponse)_service.Execute(new PublishDuplicateRuleRequest() { DuplicateRuleId = _ruleId });
// When the publishDuplicateRule request returns, the state of the rule will still be "Publishing" (StatusCode = 1).
// we need to wait for the publishing operation to complete, so we keep polling the state of the
// rule until it becomes "Published" (StatusCode = 2).
int i = 0;
DuplicateRule retrievedRule =
(DuplicateRule)_service.Retrieve(DuplicateRule.EntityLogicalName, _ruleId, new ColumnSet(new String[] { "statuscode" }));
while (retrievedRule.StatusCode.Value == 1 && i < 20)
{
i++;
System.Threading.Thread.Sleep(1000);
retrievedRule =
(DuplicateRule)_service.Retrieve(DuplicateRule.EntityLogicalName, _ruleId, new ColumnSet(new String[] { "statuscode" }));
}
Console.Write("published.\n");
}
