url.EID=decrypt(#url.EID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex"); DELETE FROM #Request.prefix_db_agency#.Employee_Workschedule where employeeworkschedule_id = #x# Insert into #Request.prefix_db_agency#.Employee_Workschedule (ScheduleDate,Employee_ID,Agency_ID,ScheduleDayofWeek,ScheduleStart,ScheduleEnd,Status,Reason,ScheduleType) VALUES (#initialdate#,#session.cs.employeeid#,#session.agencyid#,0,'#AddStartTime#','#AddEndTime#',1,'#form.schedulereason#','#form.scheduletype#') UPDATE #Request.prefix_db_agency#.Employee_Workschedule SET ScheduleStart='#EditStartTime#',ScheduleEnd='#EditEndTime#',Reason='#form.schedulereason#',ScheduleType='#form.scheduletype#' WHERE employeeworkschedule_ID=#form.scheduleAvailableId# DELETE FROM #Request.prefix_db_agency#.Employee_Workschedule where employeeworkschedule_id = #url.wsid# Insert into #Request.prefix_db_agency#.Employee_Workschedule ( ScheduleDate, Employee_ID, Agency_ID, ScheduleDayofWeek, ScheduleStart, ScheduleEnd, Status, Reason, ScheduleType ) VALUES ( #initialdate#, #session.cs.employeeid#, #session.agencyid#, 0, '#EmpstartTime#', '#EmpendTime#', 1, '#Session.AddSchedule.Reason#', '#Session.AddSchedule.Available#' )

Employees Work Schedule

Range of Recurrence

">
">


#MonthAsString(month)# #year#

Go to:
#Left(DayOfWeekAsString(LoopDay), attributes.DayLetter)#
#DateInMonth# - Add
 Select * from GetAvailability where ScheduleDayofWeek = #DayOfWeek(ThisDate)# AND status = 1
#timeformat(schedulestart,'HH:MM')# - #timeformat(Scheduleend,'HH:MM')# Select * from GetAvailability where ScheduleDate = '#dateformat(ThisDate,"YYYY-MM-DD")#' and ScheduleDayofWeek = 0 AND status = 1
#timeformat(schedulestart,'HH:MM')# - #timeformat(Scheduleend,'HH:MM')#     Edit

    #Reason#