Dear Community,
I am using EntityEventListener to update a connected record of a records before deleting it using the following method:
public override void OnDeleting(object sender, EntityBeforeEventArgs e)
But when deleting the record it says there is connected records, I think this is linked to the count I am doing to check the number of records that match a condition.
Here the full code :
[EntityEventListener(SchemaName = "Activity")] public class ActivityEventListener : BaseEntityEventListener { public override void OnDeleting(object sender, EntityBeforeEventArgs e) { base.OnDeleting(sender, e); Entity activity = (Entity)sender; var userConnection = activity.UserConnection; var accountId = activity.GetTypedColumnValue<Guid>("AccountId"); var activityId = activity.GetTypedColumnValue<Guid>("Id"); int count = CountNumberOfActivityRdv(accountId, userConnection); Guid ContactClientOuRepresentantNon = new Guid("f550b45d-093e-43ba-bdd1-bc0bd43c8e16"); if (count > 0) { var update = new Update(userConnection, "Account") .Set("ContactClientOuRepresentantId", Column.Parameter(ContactClientOuRepresentantNon)) .Where ("Id").IsEqual(activityId.ToString()); update.Execute(); } } public int CountNumberOfActivityRdv(Guid accountId, UserConnection userconnection) { int count = 0; var select = new Select(userconnection) .Column(Func.Count("Id")) .From("Activity") .Where("ActivityCategoryId").IsEqual("42c74c49-58e6-df11-971b-001d60e938c6") .And("AccountId").IsEqual(accountId.ToString()) as Select; count = select.ExecuteScalar<int>(); return count; }
Do I have to clear the cache or set the select to null ?
Like
Oscar Dylan,
I've done it differently, when deleting the activity I send a message with the accountId linked to the activity deleted, and I catch it in the account edit page to do the necessaries processing. I had no problem with this method. Here is the code I've made for the sake of it.
onActivityDeletedReceived: function(scope, message) { var sender = message && message.Header.Sender; // make sure the message received is the one you sent if (sender === "ActivityDeleted") { // if you sent some data with the message you can get it from the message Body var MessageText = message.Body; var array = []; var esq = Ext.create("Terrasoft.EntitySchemaQuery", { rootSchemaName: "Activity" }); // Add column with account name that refers to given account. esq.addColumn("Id", "Id"); esq.addColumn("Account.Id", "AccountId"); esq.filters.logicalOperation = Terrasoft.LogicalOperatorType.AND; var esqAccountFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "Account.Id", MessageText); var esqRdvFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "ActivityCategory.Id", "42c74c49-58e6-df11-971b-001d60e938c6"); var esqRealiseFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "Status.Id", "4bdbb88f-58e6-df11-971b-001d60e938c6"); esq.filters.add("esqAccountFilter", esqAccountFilter); esq.filters.add("esqRdvFilter", esqRdvFilter); esq.filters.add("esqRealiseFilter", esqRealiseFilter); // Get entire record collection esq.getEntityCollection(function (result) { if (!result.success) { // error processing/logging, for example this.showInformationDialog("Data query error"); return; } result.collection.each(function (item) { array.push(item.get("AccountId")); }); if(array.length === 0) { this.set("ContactClientOuRepresentant", {value:"f550b45d-093e-43ba-bdd1-bc0bd43c8e16" , displayValue:"Non"}); this.save({isSilent:true}); } }, this); } },
Regards,
Arthur
Hello Arthur,
And which connected records does the system show you? Also what happens when you drop the select result to null?
Best regards,
Oscar
Oscar Dylan,
When the screen of the connected records pop-up and I click to check the records there is nothing.
Also, when I set the result to null the same thing happen.
Regards,
Arthur
Arthur Hertz,
What is the result of the
select top 5 * from MultiDeleteQueue
order by CreatedOn desc
right after trying to delete a record (message column values needed)? Also what error message do you receive in the application logs?
Best regards,
Oscar
Oscar Dylan,
I've put the csv file of the request in the post and also in the application logs in the "MultiDelete.log" file it's telling me this :
Terrasoft.Common.DbOperationException: L'instruction DELETE est en conflit avec la contrainte SAME TABLE REFERENCE "FKPkYRMonMU4O22bg1UtAWBnc3Y8". Le conflit s'est produit dans la base de données "MetropoleGestion", table "dbo.Activity", column 'ActivityConnectionId'.
Regards,
Arthur
Arthur Hertz,
And can you please perform this select:
select ActivityConnectionId from Activity where Id = 'Id of the activity you delete'
and
select Id from Activity where ActivityConnectionId = 'Id of the activity you delete'
?
Seems that this column is not empty for some activity and uses its value as a reference for the activity you delete.
Best regards,
Oscar
Oscar Dylan,
The first request ActivityConnectionId is equal to NULL and for the second one there are no records.
Regards,
Arthur
Arthur Hertz,
Then you need to connect your local app to the IDE and debug the execution of deletion in the Visual Studio. There is something with the delete that is provoked by the code you've developed and you need to debug this logic.
Best regards,
Oscar
Oscar Dylan,
I've done it differently, when deleting the activity I send a message with the accountId linked to the activity deleted, and I catch it in the account edit page to do the necessaries processing. I had no problem with this method. Here is the code I've made for the sake of it.
onActivityDeletedReceived: function(scope, message) { var sender = message && message.Header.Sender; // make sure the message received is the one you sent if (sender === "ActivityDeleted") { // if you sent some data with the message you can get it from the message Body var MessageText = message.Body; var array = []; var esq = Ext.create("Terrasoft.EntitySchemaQuery", { rootSchemaName: "Activity" }); // Add column with account name that refers to given account. esq.addColumn("Id", "Id"); esq.addColumn("Account.Id", "AccountId"); esq.filters.logicalOperation = Terrasoft.LogicalOperatorType.AND; var esqAccountFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "Account.Id", MessageText); var esqRdvFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "ActivityCategory.Id", "42c74c49-58e6-df11-971b-001d60e938c6"); var esqRealiseFilter = esq.createColumnFilterWithParameter(Terrasoft.ComparisonType.EQUAL, "Status.Id", "4bdbb88f-58e6-df11-971b-001d60e938c6"); esq.filters.add("esqAccountFilter", esqAccountFilter); esq.filters.add("esqRdvFilter", esqRdvFilter); esq.filters.add("esqRealiseFilter", esqRealiseFilter); // Get entire record collection esq.getEntityCollection(function (result) { if (!result.success) { // error processing/logging, for example this.showInformationDialog("Data query error"); return; } result.collection.each(function (item) { array.push(item.get("AccountId")); }); if(array.length === 0) { this.set("ContactClientOuRepresentant", {value:"f550b45d-093e-43ba-bdd1-bc0bd43c8e16" , displayValue:"Non"}); this.save({isSilent:true}); } }, this); } },
Regards,
Arthur