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

2 posts, 0 answers
  1. Abdalla
    Abdalla avatar
    8 posts
    Member since:
    May 2017

    Posted 31 May Link to this post


    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. I want to find a way to get a set of meetings for a particular day at a time from the database? In the demo app it gets all the meetings from the database and filters on the client. The application I am working on will contain high number 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.  
  2. Ivan Danchev
    Admin
    Ivan Danchev avatar
    1268 posts

    Posted 05 Jun Link to this post

    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.
Back to Top