Kendo Grid, MVC Wrappers, oData WCF Plain

[DEX]

I trying to hunt down and example on how to wire the Kendo Grid using the uber-awesome MVC Wrappers to call WCF Plain services that I generated from the Telerik OpenAccess rlinq file. I know there are plenty of examples using javascript but my whole website is using the MVC Wrappers and I don't like to have any one-offs - if you know what I mean. Please help.

@(Html.Kendo().Grid(Model)

    .Name("Grid").Sortable().Selectable().Scrollable().Filterable().Groupable()

    .Resizable(c => c.Columns(true))

    .Columns(columns =>

    {

        columns.AutoGenerate(true);

        columns.Command(c => c.Edit());

    })

    .Pageable(pager => pager

        .PageSizes(new int[] { 15, 30, 50, 100 })

    )

    .ToolBar(commands => 

    {

        commands.Create();

        commands.Custom()

            .Text("Clear Filters")

            .Action("Index", "Jobs");

    })

    .DataSource(dataSource => dataSource

        .Ajax()

        .Model(m => m.Id(v => v.JOB_TITLE_ID))

        .PageSize(15)

        .Read(read => read.Url("localhost:8082/TrainingService.svc/ReadJOB_TITLEs"))

        .Update(update => update.Action("Edit", "Jobs"))

        .Create(create => create.Action("Create", "Jobs"))

     )

)

[DEX]

For the record, I also created oData 3 services and still cannot get it to work. Any help would be greatly appreciated.

[Atanas Korchev]

Hello Ricky,

 Currently Kendo Grid for ASP.NET MVC can only be bound to an ASP.NET MVC action method. You can find more info in the ajax binding help topic. If you need to use OData or WCF you need to request those services server-side from your action method:

public ActionResult Products_Read([DataSourceRequest]DataSourceRequest request)
{
    // ProductService is the wrapper of the OData or WCF service.
    var products = ProductsService.GetAll();

    DataSourceResult result = products.ToDataSourceResult(request);

    return Json(result);
}

The other option is to use the JavaScript-only version of Kendo Grid.

Regards,
Atanas Korchev
the Telerik team

[DEX]

The infamous Atanas... hello sir and thanks for getting back to me.

Ok. So server-side it is then. Do you know of any way to tear open the DataSourceRequest so I can send the query strings to the oData service? I would really rather not GetAll() for everything as some of these tables have hundreds of thousands or records.

[Atanas Korchev]

Hello Ricky,

 You can configure your service method to accept paging parameters then pass it the DataSourceRequest properties:

var products = ProductsService.Get(request.Page, request.PageSize);

Regards,
Atanas Korchev
the Telerik team

[DEX]

That's simple enough. But what about the filters, sorts, and aggregates? I tried to create the expressions from the IFilterDescriptor but failed horribly.

[Atanas Korchev]

Hello Ricky,

 I recommend checking the custom binding help example which is available in the ASP.NET MVC sample application. The interesting file is Controllers\Web\Grid\CustomAjaxBindingController.cs

Regards,
Atanas Korchev
the Telerik team

[DEX]

Looks good. I'll try that. Thanks a bunch Atanas.

[DG]

Is there any wrapper to convert a DataSourceRequest  to an oData Uri

I am calling oData from a .Net client and would like to do the following
    DataSourceRequest request = new DataSourceRequest();

            Uri uri = new Uri("http://localhost:61055/odata/");
            var queryUriAll = new Uri("Entity", UriKind.Relative);
            
           I would like to build the following Uri from DataSourceRequest
             var queryUriAllinline = new Uri("Member?$top=2&$skip=1&$inlinecount=allpages", UriKind.Relative);
            var container = new oDataServiceReference.Container(uri );
            
            var entity = container.Execute<MemberServiceReference.Entity>(queryUri).ToList();
            var dataResult = entity.ToDataSourceResult(request); 

[Atanas Korchev]

Hello Douglas,

Currently there is no built in code which will convert a DataSourceRequest to an OData Uri.

Regards,
Atanas Korchev
Telerik