How get a set of meetings for a particular day at a time from the database?

[Abdalla]

In scheduler asp.net Core Demo.  ISchedulerEventService has method GetAll() to get all data “meetings/appointments”  from the database and bind it to the scheduler. to find a way to get a set of meetings for a particular day at a time from the database? In the demo it gets all the meetings from the database and filters on the client. The application I am working on will contain of resources with a large number of bookings per day. I would like to only pull the data for each day to limit the amount of data being loaded at any given time and to improve the load performance. My app will have hundreds of meetings per day so loading all the meetings from the database is not an option.  

[Ivan Danchev]

Hello Abdalla,

See the following example (not a Core example but the implementation should be similar), which shows how you can implement server filtering so that only events from the visible range (the selected day in the day view for instance) are loaded. Note how additional parameters are sent to the server:

.ServerOperation(true)
.Read(read => read.Action("Read", "Home").Data("getAdditionalData"))

And these parameters are used on the server to get the events within the specific range:

public virtual JsonResult Read(DataSourceRequest request, FilterRange range)
{
    var data = taskService.GetRange(range.Start, range.End);
    return Json(data.ToDataSourceResult(request));
}

Regards,
Ivan Danchev
Progress Telerik