Hi all,
I have to design an appointment schedule in asterisk. Say, a patient calls the doctor,then asterisk itself has to take the call and ask the person's name,record it and read the intime and outtime for that person and update in database.... Upto this point, am done . Now, after accepting intime and outtime, I will have to check

a) if the slot is open. If not - you should ask the caller to enter a
different time---------It can be done through database check,this is OK..
b) do some time validations (shouldn't be too late)
c) caller should even be able to cancel the slot automatically. I
should do a check on his phone number.
d) if the number is not known from callerid (blocked), you should
prompt the user to provide you with the number.

Hw to make it???????????
Pls help me in this, If possible pls send me sample project code also.

Expecting a favourable reply and thanx in advance............

Padmaja T N.