We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Reccuring Schedule Server Side

Thread ID:





124713 Jun 24,2016 07:21 AM UTC Jun 27,2016 01:14 PM UTC ASP.NET MVC 1
Tags: Schedule
Geoffroy PERRIER
Asked On June 24, 2016 07:21 AM UTC

I'm looking for samples that show how to handle appointments on the server side. The appointment are stored in a SQL server no trouble with that my concern is about how to query on it.

My need is to know for a specific day all the appointments including the recurring ones.
Example: for the appointments below if I query about the 1st june I get "reccuring 1" and "Apmnt 1" ( and their properties)

Thank You

Karthigeyan Krishnamurthi [Syncfusion]
Replied On June 27, 2016 01:14 PM UTC

Hi Geoffroy, 
Thank you for contacting Syncfusion support. 
We have prepared the sample for your requirement “Need to perform server side filtering” which can be downloaded from the following location: 
In the above sample, default Schedule is rendered with some appointments. When the button is clicked current date appointment’s alone will be displayed in the Scheduler. Filtering process are done on controller side via ajax post. Kindly refer to the following code example used in the above sample. 
public JsonResult appFilter(DateTime curDate) 
            var DataSource = new DataClasses1DataContext().ScheduleDatas.ToList(); 
            List<ScheduleData> appointmentList = DataSource.ToList(); 
            DateTime StartDate = curDate; 
            DateTime EndDate = curDate.AddHours(24); 
            appointmentList = DataSource.ToList().Where(app => app.StartTime >= StartDate && app.StartTime <= EndDate || app.Recurrence == 1).ToList();// here particular date appointment is filtered 
            return Json(appointmentList, JsonRequestBehavior.AllowGet); 
If we have misunderstood your requirement or if the above code doesn’t suit’s your needs – kindly share us with some more details like on which scenario you need to query the scheduler data based on date (i.e. how do you want to choose the particular date, based on which you need to query). 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon