spCustomFormSettings_AddUpdate

Parameters

Parameter	Parameter Type	Mode
@FormGUID	uniqueidentifier	IN
@CustomConfirmationPage	nvarchar(max)	IN
@LoginProperties	xml	IN
@OAProperties	xml	IN
@ConfirmationEmailBody	nvarchar(max)	IN
@ConfirmationEmailFromAddress	nvarchar(max)	IN
@ConfirmationEmailFromName	nvarchar(max)	IN
@ConfirmationEmailName	nvarchar(max)	IN
@ConfirmationEmailSubject	nvarchar(max)	IN
@ConfirmationEmailTemplateID	int	IN
@LanguageData	xml	IN
@Disabled	bit	IN
@ConfirmationEmailReplyAddress	nvarchar(max)	IN
@ConfirmationEmailForwardDSN	bit	IN
@ConfirmationEmailForwardDSNAddress	nvarchar(max)	IN
@ClientSitesID	int	IN
@NotificationProperties	xml	IN
@SendNotification	bit	IN
@NotificationEmailTemplateID	int	IN
Definition

Copy

                CREATE PROCEDURE [dbo].[spCustomFormSettings_AddUpdate](        
                  @FormGUID            uniqueidentifier, 
                  @CustomConfirmationPage        nvarchar(max), 
                  @LoginProperties    xml,
                  @OAProperties        xml,
                  @ConfirmationEmailBody    nvarchar(max), 
                  @ConfirmationEmailFromAddress    nvarchar(max), 
                  @ConfirmationEmailFromName    nvarchar(max), 
                  @ConfirmationEmailName    nvarchar(max), 
                  @ConfirmationEmailSubject    nvarchar(max),
                  @ConfirmationEmailTemplateID int,
                  @LanguageData xml,
                  @Disabled bit,
                  @ConfirmationEmailReplyAddress nvarchar(max),
                  @ConfirmationEmailForwardDSN bit,
                  @ConfirmationEmailForwardDSNAddress nvarchar(max),
                  @ClientSitesID int,
                  @NotificationProperties xml = NULL,
                  @SendNotification bit = 0,
                  @NotificationEmailTemplateID int = 0
              )
              AS
              BEGIN

                  BEGIN TRANSACTION

                  UPDATE [dbo].[CustomFormSettings] 
                  SET 
                      [FormGUID] = @FormGUID
                      ,[CustomConfirmationPage] = @CustomConfirmationPage
                      ,[LoginProperties] = @LoginProperties
                      ,[OAProperties] = @OAProperties
                      ,[ConfirmationEmailBody] = @ConfirmationEmailBody
                      ,[ConfirmationEmailFromAddress] = @ConfirmationEmailFromAddress
                      ,[ConfirmationEmailFromName] = @ConfirmationEmailFromName
                      ,[ConfirmationEmailName] = @ConfirmationEmailName
                      ,[ConfirmationEmailSubject] = @ConfirmationEmailSubject
                      ,[ConfirmationEmailTemplateID] = @ConfirmationEmailTemplateID
                      ,[LanguageData] = @LanguageData
                      ,[Disabled] = @Disabled 
                      ,[ConfirmationEmailReplyAddress] = @ConfirmationEmailReplyAddress
                      ,[ConfirmationEmailForwardDSN] = @ConfirmationEmailForwardDSN
                      ,[ConfirmationEmailForwardDSNAddress] = @ConfirmationEmailForwardDSNAddress
                      ,[ClientSitesID] = @ClientSitesID
                      ,[NotificationProperties] = @NotificationProperties
                      ,[SendNotification] = @SendNotification
                      ,[NotificationEmailTemplateID] = @NotificationEmailTemplateID

              WHERE CustomFormSettings.FormGUID = @FormGUID

                  IF @@ROWCOUNT = 0                 
                  BEGIN
                      INSERT INTO [dbo].[CustomFormSettings]
                      (
                          [FormGUID] 
                          ,[CustomConfirmationPage] 
                          ,[LoginProperties] 
                          ,[OAProperties] 
                          ,[ConfirmationEmailBody]
                          ,[ConfirmationEmailFromAddress] 
                          ,[ConfirmationEmailFromName]
                          ,[ConfirmationEmailName]
                          ,[ConfirmationEmailSubject]
                          ,[ConfirmationEmailTemplateID]
                          ,[LanguageData] 
                          ,[Disabled]
                          ,[ConfirmationEmailReplyAddress] 
                          ,[ConfirmationEmailForwardDSN] 
                          ,[ConfirmationEmailForwardDSNAddress]
                          ,[ClientSitesID]
                          ,[NotificationProperties]
                          ,[SendNotification]
                          ,[NotificationEmailTemplateID]
                      )
                      VALUES
                      (
                          @FormGUID            
                          ,@CustomConfirmationPage        
                          ,@LoginProperties    
                          ,@OAProperties    
                          ,@ConfirmationEmailBody
                          ,@ConfirmationEmailFromAddress
                          ,@ConfirmationEmailFromName
                          ,@ConfirmationEmailName
                          ,@ConfirmationEmailSubject
                          ,@ConfirmationEmailTemplateID
                          ,@LanguageData
                          ,@Disabled 
                          ,@ConfirmationEmailReplyAddress
                          ,@ConfirmationEmailForwardDSN
                          ,@ConfirmationEmailForwardDSNAddress
                          ,@ClientSitesID
                          ,@NotificationProperties
                          ,@SendNotification
                          ,@NotificationEmailTemplateID 
                      )

                  END

                  COMMIT TRANSACTION
              END