Delete using composite key

[Mahindra Morar]

Hi,

Is there any way of passing a composite key instead of just the Key to a back end service when using the UrlAdaptor?  

Thanks

[Mani Sankar Durai]

Hi Mahindra, 

Thanks for contacting Syncfusion support. 

We have analyzed your query and we found that you want to pass the composite key to server side while deleting the record in grid. We can achieve it by passing through the headers while deleting. Based on your requirement we have prepared a sample that can be downloaded from the below link 

Link: http://www.syncfusion.com/downloads/support/forum/133663/ze/WebApplication1-1849195276 

Refer the code example 

 

        <ej-grid id="Grid" allow-paging="true" action-begin="begin"> 

            <e-datamanager url="/Home/DataSource" insert-url="/Home/NormalInsert" update-url="/Home/NormalUpdate" remove-url="/Home/NormalDelete" adaptor="UrlAdaptor" /> 

            <e-edit-settings allow-adding="true" allow-editing="true" allow-deleting="true" edit-mode="Normal" show-delete-confirm-dialog="true" /> 

            <e-toolbar-settings show-toolbar="true" toolbar-items='@new List<string> {"add","edit","delete","update","cancel"}' /> 

            <e-columns> 

... 

            </e-columns> 

 

        </ej-grid> 

    

<script type="text/javascript"> 

    function begin(args) { 

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

            args.model.dataSource.dataSource.headers = []; 

            args.model.dataSource.dataSource.headers.push({ "additional_key": args.data.EmployeeID, "additional_key1": args.data.ShipCity }); 

        } 

    } 

     

</script> 

 

[HomeController.cs] 

public ActionResult NormalDelete([FromBody]CRUDModel<OrderDetails> value) 

        { 

            int obj = Int32.Parse(Request.Headers["additional_key"]); //key1 

            string obj1 = Request.Headers["additional_key1"]; //key2 

            order.Remove(order.Where(or => or.OrderID == int.Parse(value.Key.ToString())).FirstOrDefault()); 

            return Json(value); 

        } 

From the above code example we have achieved it using action-begin event in grid  

Refer the API link 

Link:  

https://help.syncfusion.com/api/js/ejgrid#events:actionbegin 

Please let us know if you need further assistance. 

Regards, 

Manisankar Durai.