Hi,

I want to pass an additional parameter to my Read ajax method from Grid along with currently passing the controller name and method name.

Currently I have something like below in my cshtml file:
.DataSource(dataSource => dataSource
            .Ajax()
            .PageSize(5)
            .Model(model => model.Id(m => m.Id))
            .Create(create => create.Action("Create", controllerName))
            .Read(read => read.Action("Read", controllerName))
            .Update(update => update.Action("Update", controllerName))
            .Destroy(delete => delete.Action("Delete", controllerName))
        )
And my Action method is below:
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{}

Please can you show my how to pass addtional parameter (i.e Id) in Grid for Read operation and how to handle it in corresponding Controller?

Thanks,
Nirav

Hello Nirav,


You could pass additional data either using object route values
E.g.

OR
via the Data method, which specifies a JavaScript function, which will return the additional parameters.
E.g.


In both cases, you should add the two additional parameters to you Action.
E.g.

 

Kind regards,
Dimiter Madjarov
the Telerik team

Thanks Dimiter, It worked as expected.

But what if any of the additional parameter is optional? If we take your example then what if Id param is optional? How to handle it in 
.Read(read => read.Action("Products_Read", "Grid", new { name = "test", id = 2 }))

In my example below I may or may not pass Id. Means Id could be any integer value or it could be null.
.Read(read => read.Action("Read", controllerName. new { Id = 3 }))

I know the implementation part in controller class but not in cshtml.

Regards,
Nirav

Hi Nirav,


Since the parameter is optional in the current scenario, you should specify it's type to be nullable in the controller. 
E.g.

 

Kind regards,
Dimiter Madjarov
the Telerik team

Hi Dimiter,

I understood your solution provided that I have to implement it in controller.

But since it is an interger I cannot assign null in Ajax Read action mentiond below. It gives a compilation error.
.Read(read => read.Action("Products_Read", "Grid", new { Id = null}))

Either I have to give it a non zero value or it should be 0 (zero). In this case in my controller I have to explicitely check if Id is 0 then perform normal operation and if Id is non zero perform specific operation.

I can do it the way I have explained above but I am finding any logical and clear solution.

Regards,
Nirav

Hello Nirav,


This is quote from my answer in the support thread.

---

If the parameter is defined as nullable in the controller and you don't want to pass it in the current scenario, you should just omit the RouteValues object.
E.g.

otherwise, you could add the Id with an integer value.
E.g.

---

Nirav, it would be easier for us to provide you better support if we continue only one of the two threads (forum and support). If you need additional support, please reply only in the support thread or here in the forum if you think, that this information is useful for other customers too.

Wish you a great day!

 

Kind regards,
Dimiter Madjarov
the Telerik team

Hi,

If I omit the RouteValues it doesn't work.
Means for .Read(read => read.Action("Products_Read", "Grid")), if I pass the parameter or not, none of the below controller actions invoke.
public ActionResult Products_Read([DataSourceRequest] DataSourceRequest request)
public ActionResult Products_Read([DataSourceRequest] DataSourceRequest request, int id)

And if I use the below controller actions, each time whether I pass the id (in query string or as a parameter) or not, only the second action invokes.
public ActionResult Products_Read([DataSourceRequest] DataSourceRequest request)
public ActionResult Products_Read([DataSourceRequest] DataSourceRequest request, int? id)

I have closed the similar support ticket to allow discussion at one place and for all here on forum.

Thanks,
Nirav

Hi,
I have similar question.
I'm trying to pass serialized form as an additional parameter to Read ajax datasource method but no success, model isn't constructing.

Here is my Razor code:
Here is code from MyController.cs:
Here is code from FilterModel.cs: In MyController GetGridData method I have empty model with default values for dates and null for array.

However if I use simple ajax like following
GetGridData method takes filled model.
I used Fiddler to see what is transfered during Read ajax method and simple ajax call:
Read ajax method:
0%5Bname%5D=FilterCriteria.DateFrom&0%5Bvalue%5D=8%2F6%2F2013+10%3A55+AM&1%5Bname%5D=FilterCriteria.DateTo&1%5Bvalue%5D=8%2F6%2F2013+11%3A55+AM&sort=&page=1&pageSize=15&group=&filter=
simple ajax:
FilterCriteria.DateFrom=8%2F6%2F2013+10%3A54+AM&FilterCriteria.DateTo=8%2F6%2F2013+11%3A54+AM

Probably because of this difference I cann't take filled model in controller action.

So, can someone, please, advice how can I get filled model in controller action for ajax Read datasource of the Grid using form serialization?

Hi,

How does the posted data looks like? You can find this by using the Network tab of your browser's developer tools. Most probably ASP.NET MVC default model binder cannot parse the data returned by jQuery serializeArray().

Regards,
Atanas Korchev
Telerik

Hi, 

I have a similar question.
.Read(read => read.Action("action", "controller").Data("GetCommitteeSearchParam")) is not working in IE 10. In IE8 and chrome the same code is working fine without any issues. Once we upgraded to IE 10, it stopped working. The function "GetCommitteeSearchParam" is not reached, so parameters are not passed. Could you provide any alternate solution for this?

function GetCommitteeSearchParam()
{


    return {
        committeeName: $('#txtCommName').val(),
        committeeType: $('#CommitteeTypeList').val()
    };
}

@(Html.Kendo().Grid(Model)
        .Name("CommitteeGrid")
        .Columns(col =>
            {
                col.Bound(c => c.committeeView.CommitteeName).
                col.Bound(c => c.committeeView.CommitteeTypeValue).Width("250").Title("Committee Type");
                col.Bound(c => c.committeeView.CommitteeSize).Width("80");                   
            })
              .Pageable(pager=> pager
                .PreviousNext(false)
            )
             .Sortable()  
    
    .DataSource(dataSource => dataSource
      .Ajax()
          
        .Read(read => read.Action("action", "controller").Data("GetCommitteeSearchParam"))
        .PageSize(15)
        .ServerOperation(true)
        .Model(model => model.Id(c => c.CommitteeID))
        
        )
        
        )

Hello,

Unfortunately this is not a known issue and we cannot reproduce it locally. I recommend opening a support ticket and attaching a short sample project which reproduces that behavior. 

Regards,
Atanas Korchev
Telerik

how to include variables in additionalInfo? I tried below, it does not work. Thanks.

Hi,

How can I achieve this with a scheduler defined in javascript (i.e. not Razor) but still calling an MVC controller action?

 

Thanks,

Gavin

 

Hello Gavin,

The approach in this case would be the same - the transport.read.data configuration of the dataSource should be used in order to provide the additional data.

I hope this information helps, if further assistance is required, please open a separate thread in the Scheduler section or a support ticket.

Regards,
Dimiter Madjarov
Telerik

Thanks Dimiter!

Hello

I am having a similar but very weird issue.

I am creating an editable grid in a view passing an integer model. I have configured edit, destroy and create actions. In every action I am passing back the integer model of the view to the controller. The Read, Update and Destroy actions are correctly passing this integer model. However, the Create action is not, even though it is defined in the same was as the others:

 

My Grid

@model int

@(Html.Kendo().Grid<MyGridModel>()
          .Name("MyGridModelGrid" + Model)
          .Columns(cols =>
          {
              cols.Bound(a => a.SomeProperty);
              cols.Bound(a => a.SomeListProperty).ClientTemplate("#=iterateOver(SomeListProperty)#").Title("Properties");
              cols.Command(command =>
             {
                 command.Edit();
                 command.Destroy();
             }).Width(172);
          })
          .ToolBar(toolbar => toolbar.Create())
          .Editable(editable => editable.Mode(GridEditMode.InLine))
          .DataSource(dataSource => dataSource
              .Ajax()
              .Model(m =>
              {
                  m.Id(model=>model.Id);
                  m.Field(model=>model.SomeProperty);
                  m.Field(model=>model.SomeListProperty).DefaultValue(new List<string>());
              })
            .Create(update => update.Action("AddModelFor", "MyController", new { area = "MyArea" , modelId= Model}))
            .Read(read => read.Action("ReadModelsFor", "MyController", new { area = "MyArea", modelId= Model }))
            .Update(update => update.Action("UpdateModelFor", "MyController", new { area = "MyArea", modelId= Model }))
            .Destroy(update => update.Action("RemoveModelFor", "MyController", new { area = "MyArea",modelId = Model }))
          )
    )

 

My MVC controller:

 

 public JsonResult ReadModelsFor([DataSourceRequest] DataSourceRequest request, int modelId)
        {
            //correctly receiving both parameters
        }

        [HttpPost]
         public ActionResult RemoveModelFor([DataSourceRequest]DataSourceRequest request, ServiceMapping serviceMapping, int modelId)
         {
                //correctly receiving the three parameters
         }

         [HttpPost]
         public ActionResult AddModelFor([DataSourceRequest]DataSourceRequest request, ServiceMapping serviceMapping, int modelId)
         {
             //THIS DOES NOT RECEIVE THE MODELID! 
         }

         [HttpPost]
         public ActionResult UpdateModelFor([DataSourceRequest]DataSourceRequest request, ServiceMapping serviceMapping, int  modelId)
         {
             //correctly receiving the three parameters
         }

Hello Luis,

The code seems correct, so we cannot state for sure what is causing the problem. I would suggest to open a support ticket for the issue and send us small runnable project, so we can see it in action.

Thanks for the understanding.

Regards,
Dimiter Madjarov
Telerik

Hi Luis,

If you solved the parameter issue for the Create method please tell me how.

I am facing exactly the same problem.

Kind Regards,

Sure Ahmad

Inside my razor view I identified the method which was not sending correctly the missing property (In my case the id). So I added the following:

               .Create(create => create.Action("​MyMethod", "​MyController", new {area = "​MyArea", modelId = Model}).Data("customJSFunction"))

 

And inside my customJSFunction I just set the missing property that was not being sent to my controller:

 

customJSFunction(modelSent){

e.MissingProperty = "someValue" // can be substituted with any value

}

 

When your model is ​recieved to the controller, the MissingProperty will be set to "SomeValue"

I hope this helps/

 

Thank you Luis,

I also found another solution 

 .Create("VipProfile_Create", "VipProfiles", new { parentId = @ViewBag.PersonID })

The trick is to use a variable name (e.g. parentId) that is different from data source fields.

Hope this will save time for somebody.

Kind Regards

Does this also work for Create, Update and Delete? !?!?!?

Does this also work for Create, Update and Delete? !?!?!?

Hello Geary,

Yes, additional parameters could be passed the same way for the other CRUD operations.

Regards,
Dimiter Madjarov
Telerik

Hi Dimiter,

I have grid on the button click , which takes parameters from viewbag. It works fine when first time loads. when i click the button for the different record, it still takes the same parameter values of the first one.

I am reading the grid again on the button click. 

 

Can you please tell me how to refresh the grid with different parameter values on button click.  I am sending parameters like this while initial load .

 

 

Thanks,

Veena

Hello DHHS,

When the additional parameters are added in the Grid configuration as route values, they are attached to the read action URL.
E.g.

so they will be send each time.

Another approach that you could try would be to omit them and use the Data() method to define a JavaScript function that will return the additional data for the request. This way you could include the custom logic for determining what values to be sent inside this function.
E.g.

Regards,
Dimiter Madjarov
Telerik

Hi Dimiter,

I have tried to pass parameters via the Data method but the data is not getting through when it's a variable or a value of an input element.

The code that is commented out does not work, but using the static values work. Can you help with this? Thank you

 

function getWHparameters() {            
            return {
                qtline: 1, //$("[name=whindex]").val(), //document.getElementById("whindex").value,
                vendor: 'Vendor' //$("[name=whvendor]").val() // document.getElementById("whvendor").value
            }
        } 

Hello tam,

I would recommend to debug the function and assure that the value of the input element is retrieved as expected.

Regards,
Dimiter Madjarov
Telerik

Hello dimiter,

Is it possible to pass DataSourceRequest class properties from KendoGrid, like this:

Public ActionResult Index(string filterValue, int? currentPage = 1, string Sort = "FirstName", string Sortdir = "ASC", int RowPerPage = 10, string PageRefresh = "False")

{

//my custom code

}

 

now from kendo call Can I do this:

.Read(read => read.Action("Orders_Read", "Grid").Data("getAdditionalData"))
function getAdditionalData(e) {
    return {
        PageNo: 1, PageSize: ?what how value?, Filters: ?what how value?, Groups:?what how value?

    };
}

 

?what how value? : how these values will get fetched?????

 

I want to pass it from kendo grid rather than doing it by own using DataSourceRequest as shown below:

 public ActionResult readPagingData([Kendo.Mvc.UI.DataSourceRequest] Kendo.Mvc.UI.DataSourceRequest request)
        {

var result = new Kendo.Mvc.UI.DataSourceResult()
            {
                Data = GetData(),
                Total = TotalRe
            };
            return Json(result, JsonRequestBehavior.AllowGet);

}