Schedule Resources datasource is not updating

[Alan]

My application is in ASP.NET MVC 5 using Razor views and remote data stored in a SQL Server database.

I have a Kendo Grid which contains a list of Users. This list of users then becomes a resource list in a Kendo Scheduler.

The problem I have is when I add a new user to the grid, open the scheduler then open the task editor the new user does not appear in the resource list; the new user appears in the grid and is created in the database. If I exit the application and then re-run it the user is present in the scheduler resource dropdown. In other words the resource datasource is not being refreshed when the scheduler is displayed.

Now the complication:
The user grid sits in a Partial View: The grid has a toolbar template consisting of a 'Create New User' button(editing is via a popup)  and a Kendo button which calls a script to display a Kendo Window; the window is model and configured via .LoadContentsFrom to display the scheduler view.

I have tried several methods, found on this forum, to get the scheduler resources to update before opening the task editor without success.

Your help would be appreciated

Alan

[Rosen]

Hello Alan,

Judging from the provided description, in your case the way the scheduler resource DataSource should be refreshed depends on your scenario exact implementation. Therefore, could you please provide runnable sample application which demonstrates your scenario. This will allow us to get better understanding about your case and provide you with more to the point answer. 

Regards,
Rosen
Telerik

[Alan]

Hi Rosen,
My apologies for the delay in responding. I have attached a project which demonstrates my implementation and the issue

Thanks

Alan

[Rosen]

Hi Alan, 

I have looked at the sample you have provided and it seems that the described issue is not related to our widgets but to the logic responsible for saving and retrieving the data from the backend. It seems that when the scheduler resources are retrieved the DataContext is not yet updated with the newly created data and it still returns the older state of the data. Modifying the code responsible for creating the DbContext seems to fix the issue in question:

public class SchedulerDemoController : Controller
{
    ApplicationDbContext _db;

    public SchedulerDemoController()
    {
       _db = new ApplicationDbContext();
    }

   //......
 }

Regards,
Rosen
Telerik

[Alan]

Hi Rosen,

I have just moved the dbContext instantiation into the controller constructor but it has made no difference to the result.

The resource dropdown is still not being populated with the newly created person until I close and re-run the application.
I need a way to ensure the resource list is refreshed when the schedule window is opened so it picks up new users in the database. At the moment it seems to be loaded when the grid view, where the kendo window is declared, is loaded. instead of when the window is opened.

Thanks for your help

Alan

[Rosen]

Hello Alan,

Indeed, you are correct the behavior I was observing seems to be due to sample project misbehaving when run locally on my machine. Thus, please disregard my previous suggestion.

However, you may try to refresh the content of the window by calling its refresh method prior to opening:

function ShowSchedule(e) {
    e.preventDefault();
    $("#ScheduleWindow").data("kendoWindow").refresh().maximize().open();
}

Regards,
Rosen
Telerik

[Alan]

Hi Rosen,
Thank you again for your help;

Still no luck with this; Below is the Fiddler output when using refresh(). 

As you can see the Scheduler View is loaded at the same time as the user grid view. When I click on the button to display the scheduler I do get a new call to the Scheduler Action and a new read of the tasks but the UserResource_Read action is not called again to pick up the new user created just before.

200 HTTP localhost:39586 /
200 HTTP localhost:39586 /__browserLink/requestData/49dcc69baadc4500a1f120477b42ae34
200 HTTP localhost:39586 /SchedulerDemo
200 HTTP localhost:39586 /SchedulerDemo/ServiceUser_Read
200 HTTP localhost:39586 /SchedulerDemo/Scheduler
200 HTTP localhost:39586 /__browserLink/requestData/15437a4f46574251b7ce9fd298b3478b
200 HTTP localhost:39586 /SchedulerDemo/UserResource_Read
200 HTTP localhost:39586 /SchedulerDemo/Tasks_Read
NOTE: New User Added
200 HTTP localhost:39586 /SchedulerDemo/ServiceUser_Create
NOTE: Schedule button clicked
200 HTTP localhost:39586 /SchedulerDemo/Scheduler
200 HTTP localhost:39586 /SchedulerDemo/Tasks_Read

[Rosen]

Hello Alan,

I have prepared a short video which captures the sample project behavior before and after applying the suggested change. Please take a look maybe I'm missing something obvious.

Regards,
Rosen
Telerik

[Alan]

Hi Rosen,
Thank you again for your help.

It would seem this is a browser related issue - my development is in IE11

I noticed you are using Chrome so I ran the project in Firefox and Chrome.

With the refresh() added when I clicked the Schedule button directly after adding a new user I got an error from $("#ScheduleWindow").data("kendoWindow").refresh().maximize().open();
0x800a138f - JavaScript runtime error: Unable to get property 'open' of undefined or null reference
Just in case anyone else hits this error in VS2013 which uses jquery-1.10.2 it is fixed by adding jquery-migrate-1.2.1.min.js.

So all is working correctly in Firefox and Chrome but not IE11 which still does not reload the resources.

I would appreciate it if you could test this in IE

Again many thanks

Alan

[Rosen]

Hello Alan,

I'm afraid that IE11 seems to behave the same as Chrome on my end. Please take a look at this short video.

However, maybe you have enabled the IE caching. In which case you may consider changing the type of the resources request to be POST as this should force the browser to issue new request every time:

.Resources(resources => resources.Add(r =>
           r.OwnerID)
           .Title("User")
           .DataTextField("Name")
           .DataValueField("UserId")
           .DataColorField("Colour")
           .DataSource(ds => ds.Read(read => read.Action("UserResource_Read", "SchedulerDemo").Type(HttpVerbs.Post))))

Regards,
Rosen
Telerik

[Alan]

Rosen,

Many thanks for that; as you say IE Caching is most likely to blame.
Your post workaround appears to have worked

Again many thanks for your time and effort with this.

Alan