Entity Framework - Problems Displaying Events

Scheduler ASP.NET MVC
#1

Hello!

I currently am working on a scheduler that connects to an Oracle database using Entity Framework. For some reason, the Data() method correctly returns all entries in the database, but does not display any of them on the calendar. The scheduler saves saved events correctly in the database. On each refresh, the scheduler continues to display nothing. I have included all the code I think is necessary - unfortunately the entire zipped file is too large.

Any help in solving this problem would be appreciated!
DHTMLXSchedulerEntity1.7z (5.86 KB)

#2

Oh, sorry, I just realized that I posted this in the wrong forum! I’m using the Scheduler .NET for MVC.

#3

Hello,

After further stepping through my code, I think I realize what the problem is - all events, regardless of whether they are recurring, exceptions to recurring, or normal events, are being saved in the database with the normal id, text, start_date, and end_date properties as well as event_length, event_pid, and rec_type properties. For each event entry, they all have correct and non-null id, text, start_date, and end_date values. However, the values for the event_length, event_pid, and rec_type properties for non-recurring events are being set to null (or for recurring events that are not exceptions, the event_pid value is set to null). Although the columns in the database are set to nullable values, I think this is why the ContentResult Data() method is returning an events string, but the scheduler is not correctly reading the SchedulerAjaxData content result - and therefore, why the events are not being displayed. Any advice on how to approach and solve this issue would be very much appreciated.

Also, I’m not sure if I also need a Data.cshtml view to be associated with the ContentResult Data() method, or if my Index.cshtml method suffices. Maybe that’s also my problem?

Currently my ContentResult Data() method is as follows (my code is already attached but I thought I’d add it here also):
public ContentResult Data() {
var data = new SchedulerAjaxData(
new Entities().PZ_T_TMP_SCHEDULERNET_EVENTS.AsEnumerable()
.Select(e => new { e.ID, e.TEXT, e.START_DATE, e.END_DATE, e.EVENT_LENGTH, e.EVENT_PID, e.REC_TYPE })
);
return data;

And my SchedulerAjaxData events string is such:
data = {[{ID:1375960857167,TEXT:“New event 3”,START_DATE:“2013-08-08 4:05”,END_DATE:“2013-08-08 5:10”,EVENT_LENGTH:null,EVENT_PID:null,REC_TYPE:null},{ID:1375961650985,TEXT:“Sarina Test 2”,START_DATE:“2013-08-08 9:05”,END_DATE:“2013-08-08 10:05”,EVENT_LENGTH:null,…

I believe my problem is similar (perhaps identical) to this post from March. viewtopic.php?f=25&t=28898

Thanks for any help that can be provided!

#4

Hello,
check this article
scheduler-net.com/docs/loading_d … quirements

Property names are case-sensitive, try specifying them in lower case: .Select(e => new { id = e.ID, text = e.TEXT, start_date = e.START_DATE, end_date = e.END_DATE, event_length = e.EVENT_LENGTH, event_pid = e.EVENT_PID, rec_type = e.REC_TYPE })
then event should be processed on the client correctly