Binding to OData seems to throw erroneous 500's & another question/request

[John Crumpton]

I'm using Web API 2 w/ OData 3

Client side looks like this...

When I run that, the Kanban UI just shows loading, but never completes. Browser console shows this...

But, if I right-click on the URL and select "open in new tab"... so I'm using the exact same url that the DataManager used, the browser doesn't get an error... it returns json as expected.

I've also stepped through the server-side code and it doesn't return a 500.

Additional questions/requests.

Notice in the first screenshot that I'm using MVC Razor to build up the columns array... it would be VERY nice if I could bind that in javascript to a property of the datamanager's result... ie. DataManager querys for a Project object. Project contains arrays for Columns and Cards... would be nice if the Kanaban control had properties to specify which property on the datasource contains the cards and which contains the columns. It seems to expect the datasource to only return an array of cards. Each Project could have different columns (statuses), so having to hard-code those is a huge limitation. The MVC server-side approach works, but I would prefer a client-side option.

It also seems that the Kanaban control is applying a lot of unnecessary query filters... checking for status in one of the columns, inlinecount and params

ensuring that cards are associated with a column belongs in the BL layer, not the UI. If somehow, a card gets orphaned (assigned to a Status w/ no corresponding Column), it should still get returned by the datasource. 

I'm not sure what purpose the inlinecount and params parts of the querystring serve... it returns the same results w/ those removed.

I see that in the screenshot, I have the wrong column names in the edit template, but that has since been removed... no impact, same error.

thanks,

john

[John Crumpton]

Related to this... is it possible to just bind your controls to a javascript array w/o having to use the datamanager? Datamanager seems to be the source of a lot of my issues... the UI controls all work great. It may very well be the reason I have trouble w/ the datamanager is that I don't fully understand it and am misusing it... but I've been through the documentation repeatedly... it's a bit sparse. I also don't really see what I gain from using it as opposed to a simple ajax call using jquery/angular/ etc.

thanks again,

john

[Kavitha Narayanan]

Hi John, 

 

Thank you for contacting Syncfusion support. 

 

To Create sample with Datamanager using WebAPI and OData 

 

We did not face any issue in datamanager while using WebAPI with OData. We need to use below code in the WebApiConfig.cs file to resolve your mentioned issue. 

 

 

 

public static void Register(HttpConfiguration config) 

        { 

            HttpServer server = new HttpServer(config); 

            IEdmModel model; 

            using (NORTHWNDEntities context = new NORTHWNDEntities()) 

            { 

                model = GetModel();//Get model from dataSouce. 

            } 

 

            // Create our batch handler and associate it with the OData service. 

            ODataBatchHandler batchHandler = new DefaultODataBatchHandler(GlobalConfiguration.DefaultServer); 

            config.MapODataServiceRoute("odata", "odata", model, batchHandler); 

           

            config.EnsureInitialized(); 

           

        } 

        public static Microsoft.OData.Edm.IEdmModel GetModel() 

        { 

            ODataModelBuilder builder = new ODataConventionModelBuilder(); 

 

            var order = builder.EntitySet<Employee>("Employee"); 

 

            FunctionConfiguration myFirstFunction = order.EntityType.Collection.Function("MyFirstFunction"); 

            

            myFirstFunction.ReturnsCollectionFromEntitySet<Employee>("Employee"); 

            

            return builder.GetEdmModel(); 

        } 

        } 

 

 

We have created a sample using WebAPI and OData without any issues. Please download from the following link. 

 

Sample: http://www.syncfusion.com/downloads/support/directtrac/125302/ze/KanbanOdata1994658987.zip  

 

For more information, please refer to the link. 

 

Link: https://blogs.msdn.microsoft.com/odatateam/2014/07/20/tutorial-sample-open-complex-type-step-by-step-with-web-api-2-2-for-odata-v4-0/  

 

We will create a KB for OData configuration and will update you once we completed. 

 

To Create sample without Datamanager 

 

Query: is it possible to just bind your controls to a javascript array w/o having to use the datamanager? 

 

We don’t face any issues with Data Manager using OData. For your request we prepared sample without using Data Manager. Can you please share us issues you are facing with Data Manager it will be helpful to analyze and resolve the issue. 

 

In another way, We are updating the Kanban datasource using “dataSource” method of Kanban through $.ajax method. 

 

Please refer to the code and sample. 

 

 

create: "CreateEvent",//create event 

. . . . . . . . .  

 

function CreateEvent(args) 

    {       

            var obj = $("#kanban").data("ejKanban") 

            $.ajax({ 

                url: 'Home/DataSource',//URL 

                type: 'GET', 

                data: { "id": obj._id }, 

                success: function (data1) { 

                    $("#kanban").ejKanban({ dataSource: data1 })//Assign the value to dataSource 

                } 

            }) 

    } 

 

public ActionResult DataSource(string id) 

        { 

            var DataSource = OrderRepository.GetAllRecords(); 

            return Json(DataSource, JsonRequestBehavior.AllowGet); 

        } 

 

Sample: http://www.syncfusion.com/downloads/support/directtrac/125302/ze/sample-1235666692.zip  

 

Regards, 

Kavitha N.