dbo.StartResellerSubscription.StoredProcedure.sql
2.46 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
USE [AIADatabaseV5]
GO
/****** Object: StoredProcedure [dbo].[StartResellerSubscription] Script Date: 2/1/2018 12:15:55 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StartResellerSubscription]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[StartResellerSubscription]
GO
CREATE PROCEDURE [dbo].[StartResellerSubscription]
-- Add the parameters for the stored procedure here
@iLicenseId int
AS
BEGIN
IF 1=0 BEGIN
SET FMTONLY OFF
END
DECLARE @iSubscriptionDiff INT
DECLARE @iLicenseSubscriptionId INT
SET @iLicenseSubscriptionId = 0
SET @iSubscriptionDiff = 0
SET @iLicenseSubscriptionId = (SELECT MAX(Id) FROM LicenseSubscriptionDetail WHERE LicenseId = @iLicenseId)
-- calculate the date difference of the reseller subscription
SET @iSubscriptionDiff = (SELECT DATEDIFF(D,SubscriptionValidFrom,SubscriptionValidThrough)
FROM LicenseSubscriptionDetail WHERE Id = @iLicenseSubscriptionId)
UPDATE LicenseSubscriptionDetail SET SubscriptionValidFrom = GETDATE(),
SubscriptionValidThrough = DATEADD(D,@iSubscriptionDiff,GETDATE())
WHERE Id = @iLicenseSubscriptionId
END
GO