doctor and patient appointment by Scheduler

[arkan]

hi all

im working on HIS system and i see its great idea to work with Scheduler to manage doctor's calendar with this perfect tool ,

our doctor calendar build on days in week and it repeated and we have to be able to disable calendar if doctor gone with holidays , there is a duration time for each appointment , its not important to view patients name or id on this calendar all requirement is to view  available time line in available days in week and vacant time  

look forward to hearing from you 

 

 

[Peter Milchev]

Hello Arkan,

I would like to focus your attention on the following demo that shows how to use the client-side API to restrict appointment creation and rescheduling:

• Scheduler / Resource Availability 

You could also use the Scheduler documentation for further reference.

Regards,
Peter Milchev
Telerik by Progress

[arkan]

hi

can you just explain how design this db 

I am working on doctor scheduler page requirement. The below is the screen for showing a usual weekdays schedule for a doctor.

The doctor may visit only few days on a week and only between a period of time
A doctor may be on leave some day. They add that entry
I need to design the database table to handle above scheduling.
I have no idea how a database table can be designed for 7 days with hours and doctors mapped.
The most important thing is for a given week i should be able to check the doctor availability.
I created a DoctorLeave table below to handle only doctor leave days
DoctorId, LeaveDate, Comment
But, How do i design scheduler table? Any idea/suggestions pls

[Peter Milchev]

Hello,

You could check the database structure requirements for the Scheduler in the following article: Database Structure. I would also recommend reviewing the implementation of our examples for further reference. 

Regards,
Peter Milchev
Telerik by Progress