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

updating appointement

1 Answer 67 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
nahla
Top achievements
Rank 1
nahla asked on 11 Jul 2011, 08:18 AM

good day for u all

i've a radschadular that gets data from oracle DB the schadual is all credits avilable for students each credit has a group type/types under that group type the appointements avilablefor it.

what i need is

when the student checks one group type he can't leave to another credit if it hase more than group type untill checking all.

iwrote oracle procedure as follow to check this in the DB.

X VARCHAR2(20);
  A NUMBER;
  B NUMBER;
    
BEGIN

SELECT COUNT (GROUP_TYPE) INTO A
     FROM OLR.VIEW_COURSE_GROUP_TYPE
    WHERE COURSEID      = OLR.complete_group_type.COURSEID;
    
    
SELECT COUNT(A.GROUP_TYPE_CD) INTO B
     FROM OLR.STUDENT_REG_GROUP A
    WHERE A.STUDENTID     = OLR.complete_group_type.STUDENTID
      AND A.SEMESTERID    = (SELECT SEMESTERID FROM MSA.SEMESTER@MSA WHERE CURRENT_SEM = '1')
      AND A.COURSEID      = OLR.complete_group_type.COURSEID;
      
IF A<>B THEN

SELECT GROUP_TYPE INTO X
     FROM OLR.VIEW_COURSE_GROUP_TYPE
    WHERE COURSEID      = OLR.complete_group_type.COURSEID
    AND GROUP_TYPE NOT IN (SELECT A.GROUP_TYPE_CD
                             FROM OLR.STUDENT_REG_GROUP A
                            WHERE A.STUDENTID     = OLR.complete_group_type.STUDENTID
                              AND A.SEMESTERID    = (SELECT SEMESTERID FROM MSA.SEMESTER@MSA WHERE CURRENT_SEM = '1')
                              AND A.COURSEID      = OLR.complete_group_type.COURSEID);

RETURN ('YOU NOT CHOOSE GROUP TYPE '||X);


END IF;
EXCEPTION WHEN TOO_MANY_ROWS THEN
       RETURN ('PLEASE CHOOSE ALL COURSE GROUP TYPE');
END complete_group_type;

but i could't find the approbriate event to use it n how i used the rad shadular event appointement update

but i don't know how to use the upove function.

1 Answer, 1 is accepted

Sort by
0
Veronica
Telerik team
answered on 12 Jul 2011, 10:11 AM
Hello Nahla,

Please take a look at this forum post for how to perform Insert, Update and Delete via stored procedures.

Hope this helps.

Veronica Milcheva
the Telerik team

Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

Tags
Scheduler
Asked by
nahla
Top achievements
Rank 1
Answers by
Veronica
Telerik team
Share this question
or