This is a migrated thread and some comments may be shown as answers.

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

1 Answer 69 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Abdalla
Top achievements
Rank 1
Abdalla asked on 31 May 2017, 02:28 PM

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.  

1 Answer, 1 is accepted

Sort by
0
Ivan Danchev
Telerik team
answered on 05 Jun 2017, 01:36 PM
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
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Scheduler
Asked by
Abdalla
Top achievements
Rank 1
Answers by
Ivan Danchev
Telerik team
Share this question
or