EJS Grid duplicate rows after insert

[Kamil]

When executing add method on the grid the row is properly added to the system, new row shows up in the grid, but also one additional row is added - only in the view itself because the JSON data behind doesn't have this row.  Then changing the grid order duplicate this empty row. 
Scenario:
1. one funky grid 

2. lets add record 
3. dafuq is this?

4. oh no!

5. please stop!

6. Can't even delete it! 

Doesn't matter if  I  return an added object (grid displays it properly) or null, the additional empty row is always added. 

How to solve this? 

and check this not working url :)  https://ej2.syncfusion.com/aspnetmvc/documentation/grid/global-and-local

 @(Html.EJS().Grid("TestGrid")

                .DataSource(dataManager => 

{ dataManager.Json(Model.Workers.ToArray())

             .InsertUrl(@Url.Action("Insert", ""))

     .UpdateUrl(@Url.Action("Update", ""))

      .RemoveUrl(@Url.Action("Delete", ""))

      .Adaptor("RemoteSaveAdaptor"); 

                                  })                                                                                                                                                                         

                .Columns(col =>

                   {

                       col.Field(nameof(PlannedTime.Id)).HeaderText("Id").Width("0").Visible(false)

     .IsIdentity(true).IsPrimaryKey(true).AllowEditing(false).ShowInColumnChooser(false).Add();

                       col.Field(nameof(PlannedTime.Comment)).HeaderText("Test").Width("200").Add();

                      })

                .EditSettings(edit => 

{ edit.AllowAdding(true).AllowEditing(true).AllowDeleting(true).ShowDeleteConfirmDialog(true)

      .AllowEditOnDblClick(false).Mode(Syncfusion.EJ2.Grids.EditMode.Dialog); })

                .Toolbar(new List() 

{ "Add", "Edit", "Delete", "Update", "Cancel","ExcelExport" }).ToolbarClick("toolbarClick")

                .AllowExcelExport().AllowSorting(true).AllowSelection(true)

                .Render()

        )

[Mohammed Farook J]

Hi Kamil, 

 

Thanks for contacting Syncfusion support. 

 

We have validated and tried to reproduce the reported issue but it was unsuccessful. So please find the code example and sample for your reference. 

 

 

Code example 

 

[index.cshtml] 

 

  @Html.EJS().Grid("Grid").ActionBegin("actionBegin").DataSource(dataManager =>{dataManager.Json(ViewBag.dataSource).InsertUrl("/Home/Insert").RemoveUrl("/Home/Delete").UpdateUrl("/Home/Update").Adaptor("RemoteSaveAdaptor"); 

}).EditSettings(edit => 

{ 

    edit.AllowAdding(true).AllowEditing(true).AllowDeleting(true).ShowDeleteConfirmDialog(true) 

        .AllowEditOnDblClick(false).Mode(Syncfusion.EJ2.Grids.EditMode.Dialog); 

}).Columns(col => 

{ 

    col.Field("OrderID").HeaderText("Order ID").Visible(false).IsIdentity(true).IsPrimaryKey(true).Width("30%").Add(); 

    col.Field("EmployeeID").HeaderText("Employee ID").Width("150").Add(); 

    col.Field("CustomerID").HeaderText("CustomerID").Width("70").Add(); 

 

}).AllowPaging().Toolbar(new List<string>() { "Add", "Edit", "Delete", "Update", "Cancel" }).Render() 

 

</div> 

 

<script> 

    var PkValue = 1000; 

 

    function actionBegin(args) { 

    

        if (args.requestType == 'save' && args.action == 'add') { 

            args.data[this.getPrimaryKeyFieldNames()[0]] = ++PkValue; 

        } 

    } 

</script> 

 

 

[controller] 

 

public ActionResult Index() 

        { 

            ViewBag.dataSource = OrdersDetails.GetAllRecords().ToArray(); 

            return View(); 

        } 

 

        public ActionResult Update(OrdersDetails value) 

        { 

            var ord = value; 

            OrdersDetails val = OrdersDetails.GetAllRecords().Where(or => or.OrderID == ord.OrderID).FirstOrDefault(); 

            val.OrderID = ord.OrderID; 

            val.EmployeeID = ord.EmployeeID; 

            val.CustomerID = ord.CustomerID; 

            return Json(value); 

        } 

        //insert the record 

        public ActionResult Insert(OrdersDetails value) 

        { 

 

            OrdersDetails.GetAllRecords().Insert(0, value); 

            return Json(new { data = value }); 

        } 

        //Delete the record 

        public ActionResult Delete(int key) 

        { 

            OrdersDetails.GetAllRecords().Remove(OrdersDetails.GetAllRecords().Where(or => or.OrderID == key).FirstOrDefault()); 

            var data = OrdersDetails.GetAllRecords(); 

            return Json(data); 

        } 

 

  . . .  

 

} 

 

 

Sample:  http://www.syncfusion.com/downloads/support/directtrac/general/ze/gridmvclocalization1425016046.zip  

 

 

Please ensure your application has return data properly in add method at server side. Please find the screenshot for your reference. 

 

 

addRecord at server side 

 

 

 

 

data at response 

 

 

 

 

 

Note: Grid can bind the data what did you return from server while using CRUD action with DataAdaptors. 

 

 

Still if you have faced same issue again , could you please share following details 

 

• Please share the EJ2 version details

 

• Please share the full grid code example

 

• Please share the response of network tab of your browser

 

• Please share the sample if it is possible

 

 

 

Regards, 

J Mohammed Farook 

[Kamil]

I have reproduced the issue with your example project. 
Just change reference to:    src="https://cdn.syncfusion.com/ej2/dist/ej2.min.js"

[Mohammed Farook J]

Hi Kamil, 

 

We have validated the reported issue and we are able to reproduce the issue. So We have considered the “RemoteSaveAdaptor returns empty row while perform adding in Grid” ” as an issue and logged a report for the same. This fix will be available  on December 05, 2018 patch release. 

 

Until then we appreciate your patience. 

 

 

Regards, 

J Mohammed Farook 

[Kamil]

I just checked the new 16.4.40-beta version and the issue is not fixed :(

[Mohammed Farook J]

 

Hi Kamil,  

 

Sorry for the inconvenience cost, due to the complexity of the issue “RemoteSaveAdaptor returns empty row while perform adding in Grid” we are not able to include the fix in the Volume 4, 2018 Beta release. We will include the fix in our next patch release. Which will be available at the first week of January 2019. Until then we appreciate your patience. 

Regards, 

J Mohammed Farook 

[TAC]

It's now end of January 2019. Has this issue been resolved? Solution path appreciated

[Pavithra Subramaniyam]

Hi Kamil, 

 

Thanks for your patience. 

 

We are glad to announce that the issue “To provide support for handling whole dataset in ODataV4 with Batch editing” has been fixed and this fix is now available in our latest Essential JavaScript 2 package(v16.4.48). So please upgrade Essential JavaScript 2 package and use our latest source in your application. 

 

Regards, 

Pavithra S.