Differences

This shows you the differences between two versions of the page.

--- custom_reservatie_check [2017/09/28 17:31]
kristof aangemaakt
+++ — (current)
@@ Line 1: / Line 1: @@
-====== Custom check voor reservaties ======
-Stop een database trigger met de custom check in de database, de error die hierin wordt geraised zal netjes getoond worden in alle applicaties.
-**Voorbeeld:**
-//CREATE TRIGGER [Member].[TRMEMBERSET_CHECK_RESERVATION] ON [Member].[STMEMBERSET] FOR INSERT
-AS
-DECLARE @member_id int
-DECLARE @count_reserverations int
-DECLARE @seq int
-DECLARE @reservation_date datetime
-DECLARE @settype int
-BEGIN
-select @member_id = member_id from inserted
-select @seq = set_sequence_no from inserted
-select @settype = log_type from inserted
-select @reservation_date = b.start_date
-from inserted a, planner.stcalendar b
-where a.cal_id = b.cal_id
-IF
-convert(datetime, floor(convert(float, @reservation_date))) <= convert(datetime, floor(convert(float, getdate())))
-AND @settype <> 0
-BEGIN
-        RAISERROR ('Niet toegelaten van te reserveren op de dag zelf.', 16, 1)
-        DELETE from member.stmemberset where set_sequence_no = @seq
-        RETURN
-    END
-END
-//

API WIKI