Grid with OData 2-way binding

[CS]

I have my grid as such (partial code):

@(Html.EJ().Grid(Of Office)("OfficeGrid") _

            .AllowResizeToFit(True) _

    .Datasource("/OData/Office") _

    .EditSettings(Function(edit) edit.AllowAdding().AllowDeleting().AllowEditing()) _

    .ToolbarSettings(

        Sub(toolbar)

                toolbar.ShowToolbar().ToolbarItems( _

                    Sub(items)

                            items.AddTool(ToolBarItems.Add)

                            items.AddTool(ToolBarItems.Edit)

                            items.AddTool(ToolBarItems.Delete)

                            items.AddTool(ToolBarItems.Update)

                            items.AddTool(ToolBarItems.Cancel)

                    End Sub)

        End Sub) _

    .AllowPaging() _

    .PageSettings(Function(page) page.PageSize(10)) _

    .Columns( _

        Sub(col)

                col.Field("Id").HeaderText("Id").IsPrimaryKey(True).IsIdentity(True).TextAlign(TextAlign.Right).Width(10).Add()

                col.Field("Company_PKey").HeaderText("Company").ForeignKeyField("Id").ForeignKeyValue("Descrp").DataSource(ViewBag.listOfCompany).Add()

                col.Field("Code").HeaderText("Code").Width(20).ValidationRules( _

                    Sub(v)

                            v.AddRule("required", True).AddRule("number", True)

                    End Sub

                    ).Add()

                col.Field("Descrp").HeaderText("Description").TextAlign(TextAlign.Right).Width(50).Add()

        End Sub

    ) _

    .ClientSideEvents( _

        Sub(eve)

                eve.Load("gridLoad").ActionComplete("CompleteHandler").ActionBegin("BeginHandler")

                eve.EndAdd("EndAdd")

        End Sub

    )

)

When I edit the foreign key column, the data that was sent to the server was:

1. Code: "office2"
2. Company_PKey: "2"
3. Company_PKey_input: "Company Name"
4. Descrp: "Office Two"
5. Id: 2
6. OfficeGridCompany_PKey: 2

I don't want the Company_PKey_input and the OfficeGridCompany_PKey in the request, it is making my delta becoming null upon submission.

Anyway that I can fix this?

[Ragavee U S]

Hi Chen Choong Seng

 

Thanks for your interest in Syncfusion products.

 

We have analyzed the reported query and we are sorry to let you know that we are not able to reproduce the issue mentioned.

 

Based on your information, we have created a simple sample and the same can be downloaded from the below location.

 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/Sample78883895.zip

 

Please reproduce the issue in the above sample and provide us the replication procedure for the same. The provided information will be helpful for us to analyze the issue and provide response as early as possible.

 

Please let us know if you have any queries.

 

Regards

Ragavee U S

[CS]

Tested your example, it works well, the difference that I've observed:

1. I'm using 12.2450.0.39, and the sample is using 12.2400.0.36

2. The dropdownlist field in the sample, its primary and foreign key column is of the same name "EmployeeID".

Wonder if it makes a difference, I'm trying to replicate in your example, but went into some other nuget problem :-(

[CS]

Hi Ragavee,

I've managed to replicate the issue, the issue lies in the Syncfusion's javascript, the version that you've provided in the sample differs from the version that I've got from Syncfusion nuget.

Please find the issue replicated in the attached file.

Thank you.

Attachment: Wrapper_WepAPI_Replicate_20141003_4a1b7694.rar

[Alan Sangeeth S]

Hi Chen,

 

We are sorry for the inconvenience caused.

 

We are able to reproduce the issue “Invalid fields are passing to server-side” in our end and we have logged defect report for this. The fix for this issue will be included in Volume 3, 2014 Service Pack 1 release.

 

Please let us know if you have any queries.

Regards,
Alan Sangeeth S