USP_DATAFORMTEMPLATE_EDIT_NAMEFORMATPARAMETER
The save procedure used by the edit dataform template "Name Format Parameter Edit Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter indicating the ID of the record being edited. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @NAME | nvarchar(100) | IN | Name |
| @DESCRIPTION | nvarchar(255) | IN | Description |
| @ADDRESSEEFORMATID | uniqueidentifier | IN | Use this format, if defined |
| @ALTADDRESSEEFORMATID | uniqueidentifier | IN | Otherwise, use this format |
| @ADDRESSEEFUNCTIONID | uniqueidentifier | IN | Addressee system format |
| @SALUTATIONFORMATID | uniqueidentifier | IN | Use this format, if defined |
| @ALTSALUTATIONFORMATID | uniqueidentifier | IN | Otherwise, use this format |
| @SALUTATIONFUNCTIONID | uniqueidentifier | IN | Salutation system format |
| @CONTACTADDRESSEEFORMATID | uniqueidentifier | IN | Use this format, if defined |
| @ALTCONTACTADDRESSEEFORMATID | uniqueidentifier | IN | Otherwise, use this format |
| @CONTACTADDRESSEEFUNCTIONID | uniqueidentifier | IN | Contact addressee system format |
| @ORGSALUTATIONCODE | tinyint | IN | Organization salutation |
| @CONTACTSALUTATIONFORMATID | uniqueidentifier | IN | Use this format, if defined |
| @ALTCONTACTSALUTATIONFORMATID | uniqueidentifier | IN | Otherwise, use this format |
| @CONTACTSALUTATIONFUNCTIONID | uniqueidentifier | IN | Contact salutation system format |
| @CONTACTSALUTATIONOPTIONCODE | tinyint | IN | If contact is not available, use |
| @CUSTOMNAME | nvarchar(100) | IN | Custom name |
| @USEADDRESSEEFORMAT | bit | IN | Use the pre-defined name formats for addressee |
| @USESALUTATIONFORMAT | bit | IN | Use the pre-defined name formats for salutation |
| @USECONTACTADDRESSEEFORMAT | bit | IN | Use the pre-defined name formats for addressee |
| @USECONTACTSALUTATIONFORMAT | bit | IN | Use the pre-defined name formats for salutation |
| @USEADDRESSEESYSTEMFUNCTION | bit | IN | Use a system function to build the name formats for addressee |
| @USESALUTATIONSYSTEMFUNCTION | bit | IN | Use a system function to build the name formats for salutation |
| @USECONTACTADDRESSEESYSTEMFUNCTION | bit | IN | Use a system function to build the name formats for addressee |
| @USECONTACTSALUTATIONSYSTEMFUNCTION | bit | IN | Use a system function to build the name formats for salutation |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_NAMEFORMATPARAMETER
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@NAME nvarchar(100),
@DESCRIPTION nvarchar(255),
@ADDRESSEEFORMATID uniqueidentifier,
@ALTADDRESSEEFORMATID uniqueidentifier,
@ADDRESSEEFUNCTIONID uniqueidentifier,
@SALUTATIONFORMATID uniqueidentifier,
@ALTSALUTATIONFORMATID uniqueidentifier,
@SALUTATIONFUNCTIONID uniqueidentifier,
@CONTACTADDRESSEEFORMATID uniqueidentifier,
@ALTCONTACTADDRESSEEFORMATID uniqueidentifier,
@CONTACTADDRESSEEFUNCTIONID uniqueidentifier,
@ORGSALUTATIONCODE tinyint,
@CONTACTSALUTATIONFORMATID uniqueidentifier,
@ALTCONTACTSALUTATIONFORMATID uniqueidentifier,
@CONTACTSALUTATIONFUNCTIONID uniqueidentifier,
@CONTACTSALUTATIONOPTIONCODE tinyint,
@CUSTOMNAME nvarchar(100),
@USEADDRESSEEFORMAT bit,
@USESALUTATIONFORMAT bit,
@USECONTACTADDRESSEEFORMAT bit,
@USECONTACTSALUTATIONFORMAT bit,
@USEADDRESSEESYSTEMFUNCTION bit,
@USESALUTATIONSYSTEMFUNCTION bit,
@USECONTACTADDRESSEESYSTEMFUNCTION bit,
@USECONTACTSALUTATIONSYSTEMFUNCTION bit
)
as
set nocount on;
declare @CURRENTDATE datetime;
begin try
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @CURRENTDATE = GetDate();
declare @IA1PRIMARY bit
if @ADDRESSEEFORMATID='00000000-0000-0000-0000-000000000001'
begin
set @IA1PRIMARY = 1
set @ADDRESSEEFORMATID=null
end
else
set @IA1PRIMARY = 0
declare @IA2PRIMARY bit
if @ALTADDRESSEEFORMATID='00000000-0000-0000-0000-000000000001'
begin
set @IA2PRIMARY = 1
set @ALTADDRESSEEFORMATID=null
end
else
set @IA2PRIMARY = 0
declare @IS1PRIMARY bit
if @SALUTATIONFORMATID='00000000-0000-0000-0000-000000000001'
begin
set @IS1PRIMARY = 1
set @SALUTATIONFORMATID=null
end
else
set @IS1PRIMARY = 0
declare @IS2PRIMARY bit
if @ALTSALUTATIONFORMATID='00000000-0000-0000-0000-000000000001'
begin
set @IS2PRIMARY = 1
set @ALTSALUTATIONFORMATID=null
end
else
set @IS2PRIMARY = 0
declare @CA1PRIMARY bit
if @CONTACTADDRESSEEFORMATID='00000000-0000-0000-0000-000000000001'
begin
set @CA1PRIMARY = 1
set @CONTACTADDRESSEEFORMATID=null
end
else
set @CA1PRIMARY = 0
declare @CA2PRIMARY bit
if @ALTCONTACTADDRESSEEFORMATID='00000000-0000-0000-0000-000000000001'
begin
set @CA2PRIMARY = 1
set @ALTCONTACTADDRESSEEFORMATID=null
end
else
set @CA2PRIMARY = 0
declare @CS1PRIMARY bit
if @CONTACTSALUTATIONFORMATID='00000000-0000-0000-0000-000000000001'
begin
set @CS1PRIMARY = 1
set @CONTACTSALUTATIONFORMATID=null
end
else
set @CS1PRIMARY = 0
declare @CS2PRIMARY bit
if @ALTCONTACTSALUTATIONFORMATID='00000000-0000-0000-0000-000000000001'
begin
set @CS2PRIMARY = 1
set @ALTCONTACTSALUTATIONFORMATID=null
end
else
set @CS2PRIMARY = 0
update
dbo.NAMEFORMATPARAMETER
set
NAME = @NAME,
DESCRIPTION = @DESCRIPTION,
ADDRESSEEFORMATID = @ADDRESSEEFORMATID,
ADDRESSEEFORMATISPRIMARY = @IA1PRIMARY,
ALTADDRESSEEFORMATID = @ALTADDRESSEEFORMATID,
ALTADDRESSEEFORMATISPRIMARY = @IA2PRIMARY,
ADDRESSEEFUNCTIONID = @ADDRESSEEFUNCTIONID,
SALUTATIONFORMATID = @SALUTATIONFORMATID,
SALUTATIONFORMATISPRIMARY = @IS1PRIMARY,
ALTSALUTATIONFORMATID = @ALTSALUTATIONFORMATID,
ALTSALUTATIONFORMATISPRIMARY = @IS2PRIMARY,
SALUTATIONFUNCTIONID = @SALUTATIONFUNCTIONID,
CONTACTADDRESSEEFORMATID = @CONTACTADDRESSEEFORMATID,
CONTACTADDRESSEEFORMATISPRIMARY = @CA1PRIMARY,
ALTCONTACTADDRESSEEFORMATID = @ALTCONTACTADDRESSEEFORMATID,
ALTCONTACTADDRESSEEFORMATISPRIMARY = @CA2PRIMARY,
CONTACTADDRESSEEFUNCTIONID = @CONTACTADDRESSEEFUNCTIONID,
ORGSALUTATIONCODE = @ORGSALUTATIONCODE,
CONTACTSALUTATIONFORMATID = @CONTACTSALUTATIONFORMATID,
CONTACTSALUTATIONFORMATISPRIMARY = @CS1PRIMARY,
ALTCONTACTSALUTATIONFORMATID = @ALTCONTACTSALUTATIONFORMATID,
ALTCONTACTSALUTATIONFORMATISPRIMARY = @CS2PRIMARY,
CONTACTSALUTATIONFUNCTIONID = @CONTACTSALUTATIONFUNCTIONID,
CONTACTSALUTATIONOPTIONCODE = @CONTACTSALUTATIONOPTIONCODE,
CUSTOMNAME = @CUSTOMNAME,
USEADDRESSEEFORMAT = @USEADDRESSEEFORMAT,
USESALUTATIONFORMAT = @USESALUTATIONFORMAT,
USECONTACTADDRESSEEFORMAT = @USECONTACTADDRESSEEFORMAT,
USECONTACTSALUTATIONFORMAT = @USECONTACTSALUTATIONFORMAT,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = @CURRENTDATE
where
NAMEFORMATPARAMETER.ID = @ID;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;