UFN_MEMBERSHIP_GETRENEWALWINDOWENDDATE
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MEMBERSHIPID | uniqueidentifier | IN | |
| @ORIGINALTRANSACTIONEXPIRATIONDATE | datetime | IN |
Definition
Copy
create function dbo.UFN_MEMBERSHIP_GETRENEWALWINDOWENDDATE(@MEMBERSHIPID uniqueidentifier, @ORIGINALTRANSACTIONEXPIRATIONDATE datetime)
returns datetime
with execute as caller
as begin
declare @TOTALGRACEPERIODINMONTHS tinyint = 0
select @TOTALGRACEPERIODINMONTHS = RR.AFTEREXPIRATION
from dbo.MEMBERSHIP M
join dbo.MEMBERSHIPLEVEL ML
on M.MEMBERSHIPLEVELID = ML.ID
join dbo.MEMBERSHIPLEVELRENEWALRULES RR
on ML.ID = RR.MEMBERSHIPLEVELID
where M.ID = @MEMBERSHIPID
return DATEADD(month, @TOTALGRACEPERIODINMONTHS, @ORIGINALTRANSACTIONEXPIRATIONDATE)
end