How to delete a record from a gird that has multiple primary keys

[Danyelle]

I have a grid and the records in it use two fields to make up the primary key. How can I pass both field values to the controller so that I can make sure I delete the correct record? My code is below:

@Html.EJS().Grid("ContainerGrid").DataSource(DataManager => { DataManager.Json(@Model.ContainerTransactions.ToArray()).InsertUrl("Home/AddContainerItem").UpdateUrl("Home/UpdateContainerItem").RemoveUrl("Home/DeleteContainerItem").Adaptor("RemoteSaveAdaptor"); }).Width("auto").Columns(col =>

        {

            col.Field("InventoryID").HeaderText("Item").IsPrimaryKey(true).Width("40").EditType("dropdownedit").Edit(new { @params = itemDropDown }).ValidationRules(new { required = true }).Add();

            col.Field("ContainerID").ValueAccessor(containerAccessor).IsPrimaryKey(true).Visible(false).Add();

            col.Field("Description").HeaderText("Description").ValueAccessor(descriptionAccessor).Width("90").Add();

           ...

        }).EditSettings(edit => { edit.AllowAdding(true).AllowEditing(true).AllowDeleting(true).Mode(Syncfusion.EJ2.Grids.EditMode.Dialog); }).Toolbar(new List<string>() { "Add", "Edit","Delete" }).Render()

[Sujith Kumar Rajkumar]

Hi Danyelle, 

 

Greetings from Syncfusion support. 

 

Based on the provided information we could understand that your requirement is to send additional data in the server request on deleting a record. You can achieve it by using the Grid’s actionBegin event(triggers on performing delete action) and set the required data value to the Grid’s query property. 

 

This is demonstrated in the below code snippet, 

 

// Grid’s detailDataBound event handler 

function onActionBegin(args) { 

   if (args.requestType === 'delete') { 

       // Condition executes on performing delete action 

       this.query = new ej.data.Query().addParams('CustomerID', args.data[0]["CustomerID"]); 

   } 

} 

 

On doing this the additional data will be send along with the request as shown in the below image, 

 

 

 

 

And it can be accessed in the server side as shown in the below code, 

 

public ActionResult Delete([FromBody]CRUDModel1<OrdersDetails> dm) 

{ 

    // The additional value sent in query can be accessed here 

    var queryValue = dm.CustomerID; 

        ... 

} 

 

public class CRUDModel1<OrdersDetails> 

{ 

              ... 

    public string CustomerID { get; set; } 

} 

 

We have prepared a sample based on this for your reference. You can find it below, 

 

Sample: https://www.syncfusion.com/downloads/support/forum/167782/ze/GridWithRemoteSave(SendAdditionalParametersOnDelete)1754733645 

 

More details on the query property can be checked in the below documentation link, 

 

Documentation: https://ej2.syncfusion.com/aspnetmvc/documentation/grid/data-binding/#sending-additional-parameters-to-the-server 

 

API links: https://help.syncfusion.com/cr/aspnetmvc-js2/Syncfusion.EJ2.Grids.GridBuilder-1.html#Syncfusion_EJ2_Grids_GridBuilder_1_ActionBegin_System_String_ 

                  https://ej2.syncfusion.com/documentation/api/grid/#query 

 

Please get back to us if you require any further assistance. 

 

Regards, 

Sujith R 

[Danyelle]

How would I pass two parameters?

  this.query = new ej.data.Query().addParams('CustomerID', args.data[0]["CustomerID"]); 

  this.query = new ej.data.Query().addParams('InventoryID', args.data[0]["InventoryID"]); 

[Danyelle]

I figured it out. 

this.query = new ej.data.Query().addParams('ContainerID', args.data[0]["ContainerID"]).addParams('CreatedDate', args.data[0]["CreatedDate"]);

[Balaji Sekar]

Hi Danyelle,  

  

We are happy that the problem has been solved.  

  

Please get back to us if you need any further assistance.   

                           

Regards,  

Balaji S.