This is a migrated thread and some comments may be shown as answers.

Drag Appointment Set Insert Parameter for SQL

2 Answers 39 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Daniel
Top achievements
Rank 1
Daniel asked on 07 Feb 2016, 07:06 AM

I've made a lot of progress with the scheduler, but I am running into one issue.

I am working on scheduling physicians and they are either scheduled as a person or a group.

I have two seperate drop down boxes.  One for physicians and one for groups.

 I am able to display the appointment and return either the group name or physician name on the appointment box, but I have set a parameter for inserting or updating entries with a @Type parameter.  @Type is defined in my c# code and works for all other function, except when dragging an appointment to another day.  @Type sets whether the insertion was a physician or a group.  When I do a report it will need to know if the ID stored is a physician ID or group ID.  Based on that it will resolve group/physician names and create links.

 

Long story short I need to be able to define @Type insert parameter while the appointment is being moved to another day.  The appointment wouldn't necessarily be the last appointment open, which is making it harder.  The javascripting I've tried so far with OnClientAppointmentMoveEnd has caused the appointment to not be stored in SQL at all.

2 Answers, 1 is accepted

Sort by
0
Daniel
Top achievements
Rank 1
answered on 07 Feb 2016, 07:11 AM
I'm thinking I may be able to add a hidden element to the form.  When the selection changes in group it can be set to group or vice versa and then store that value that way.  That would hold that value while it is being moved.
0
Daniel
Top achievements
Rank 1
answered on 07 Feb 2016, 07:42 AM
Hidden field and a session value did the trick.
Tags
Scheduler
Asked by
Daniel
Top achievements
Rank 1
Answers by
Daniel
Top achievements
Rank 1
Share this question
or