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.
Unfortunately, activation email could not send to your email. Please try again.

Reccuring Schedule Server Side

Thread ID:

Created:

Updated:

Platform:

Replies:

124713 Jun 24,2016 03:21 AM Jun 27,2016 09:14 AM ASP.NET MVC 1
loading
Tags: Schedule
Geoffroy PERRIER
Asked On June 24, 2016 03:21 AM

Hi 
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 09:14 AM

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. 
<Code> 
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); 
        } 
</Code> 
 
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). 
 
 
Regards, 
Karthigeyan 


CONFIRMATION

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.

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.

;