﻿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
