UpdateSpecific Method (ShiftSchedule)
- Last UpdatedMar 17, 2026
- 4 minute read
The UpdateSpecific() method updates selected columns of the specified shift schedule record in the Shift_Schedule table. The record to be updated is identified by the patternId, startTime, endTime, and shiftId parameters.
'Declaration
Public Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal patternId As Integer, _
ByVal startTime As Date, _
ByVal endTime As Date, _
ByVal endDaySpan As Nullable(Of Integer), _
ByVal shiftId As Integer, _
ByVal sunday As Nullable(Of Boolean), _
ByVal monday As Nullable(Of Boolean), _
ByVal tuesday As Nullable(Of Boolean), _
ByVal wednesday As Nullable(Of Boolean), _
ByVal thursday As Nullable(Of Boolean), _
ByVal friday As Nullable(Of Boolean), _
ByVal saturday As Nullable(Of Boolean), _
ByVal break1Start As DBDateTime, _
ByVal break1End As DBDateTime, _
ByVal break2Start As DBDateTime, _
ByVal break2End As DBDateTime, _
ByVal break3Start As DBDateTime, _
ByVal break3End As DBDateTime, _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal spare5 As DBString, _
ByVal spare6 As DBString, _
ByRef lastEditAt As Nullable(Of Date) _
)
'Usage
Dim sessionId As Integer
Dim patternId As Integer
Dim startTime As Date
Dim endTime As Date
Dim endDaySpan As Nullable(Of Integer)
Dim shiftId As Integer
Dim sunday As Nullable(Of Boolean)
Dim monday As Nullable(Of Boolean)
Dim tuesday As Nullable(Of Boolean)
Dim wednesday As Nullable(Of Boolean)
Dim thursday As Nullable(Of Boolean)
Dim friday As Nullable(Of Boolean)
Dim saturday As Nullable(Of Boolean)
Dim break1Start As DBDateTime
Dim break1End As DBDateTime
Dim break2Start As DBDateTime
Dim break2End As DBDateTime
Dim break3Start As DBDateTime
Dim break3End As DBDateTime
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim spare5 As DBString
Dim spare6 As DBString
Dim lastEditAt As Nullable(Of Date)
ShiftSchedule.UpdateSpecific(sessionId, patternId, startTime, endTime, endDaySpan, shiftId, sunday, monday, tuesday, wednesday, thursday, friday, saturday, break1Start, break1End, break2Start, break2End, break3Start, break3End, spare1, spare2, spare3, spare4, spare5, spare6, lastEditAt)
public static void UpdateSpecific(
int sessionId,
int patternId,
DateTime startTime,
DateTime endTime,
Nullable<int> endDaySpan,
int shiftId,
Nullable<bool> sunday,
Nullable<bool> monday,
Nullable<bool> tuesday,
Nullable<bool> wednesday,
Nullable<bool> thursday,
Nullable<bool> friday,
Nullable<bool> saturday,
DBDateTime break1Start,
DBDateTime break1End,
DBDateTime break2Start,
DBDateTime break2End,
DBDateTime break3Start,
DBDateTime break3End,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString spare5,
DBString spare6,
ref Nullable<DateTime> lastEditAt
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- patternId
- Required. Holds the ID of the shift pattern to which the shift is assigned.
- startTime
- Required. Holds the shift start time (the date portion of the parameter is ignored). When the shift pattern for this shift schedule is assigned to entities, this time is considered to be in the local time specific to each entity.
- endTime
- Required. Holds the shift end time (the date portion of the parameter is ignored). When the shift pattern for this shift schedule is assigned to entities, this time is considered to be in the local time specific to each entity.
- endDaySpan
Optional. Holds the shift's end day span.
For a shift that spans one or more days, this property specifies the number of days beyond the start day of the day the shift ends. A shift can span up to 6 additional days. If the shift does not span into another day, set the value to 0.
- shiftId
- Required. Holds the ID of the shift to which the schedule applies.
- sunday
- Optional. Holds a flag that, if set to true, specifies that the shift is enabled on Sunday.
- monday
- Optional. Holds a flag that, if set to true, specifies that the shift is enabled on Monday.
- tuesday
- Optional. Holds a flag that, if set to true, specifies that the shift is enabled on Tuesday.
- wednesday
- Optional. Holds a flag that, if set to true, specifies that the shift is enabled on Wednesday.
- thursday
- Optional. Holds a flag that, if set to true, specifies that the shift is enabled on Thursday.
- friday
- Optional. Holds a flag that, if set to true, specifies that the shift is enabled on Friday.
- saturday
- Optional. Holds a flag that, if set to true, specifies that the shift is enabled on Saturday.
- break1Start
- Optional. Holds the shift break1 start time (the date portion of the parameter is ignored).
- break1End
- Optional. Holds the shift break1 end time (the date portion of the parameter is ignored).
- break2Start
- Optional. Holds the shift break2 start time (the date portion of the parameter is ignored).
- break2End
- Optional. Holds the shift break2 end time (the date portion of the parameter is ignored).
- break3Start
- Optional. Holds the shift break3 start time (the date portion of the parameter is ignored).
- break3End
- Optional. Holds the shift break3 end time (the date portion of the parameter is ignored).
- spare1
- Optional. Holds new content for the spare1 field.
- spare2
- Optional. Holds new content for the spare2 field.
- spare3
- Optional. Holds new content for the spare3 field.
- spare4
- Optional. Holds new content for the spare4 field.
- spare5
- Optional. Holds new content for the spare5 field.
- spare6
- Optional. Holds new content for the spare6 field.
- lastEditAt
Optional. Holds the date/time when this record was added or last edited, for optimistic concurrency control. If it is specified, the passed value must match the lastEditAt value in the record for the update to succeed.
Output. Holds the date/time value when this record was updated by this called method.
Observe the following input parameter rules:
- Optional non-DB* parameters: Either enter a value or pass a null. If passing a null and a default value has been defined, the default value will be used for the parameter.
- Optional DB* parameters: To enter no value for the parameter, pass DB*.null (e.g., DBInt.null). To use the default value for the parameter if one has been defined for the object being added, pass a null.