# "UpdateContact" Stored Procedure

Description:

This stored procedure is used by the Contacts edit page to apply changes to an existing contact item. The input parameters include the item's primary key (ItemID), plus contact name, role, team and contact information. The editor's UserName is also passed in, and used to update the CreatedByUser field.

Definition:

       CREATE PROCEDURE Portal_UpdateContact
       (
           @ItemID   int,
           @UserName nvarchar(100),
           @Name     nvarchar(50),
           @Role     nvarchar(100),
           @Email    nvarchar(100),
           @Contact1 nvarchar(250),
           @Contact2 nvarchar(250)
       )
       AS

       UPDATE Portal_Contacts

       SET
           CreatedByUser = @UserName,
           CreatedDate   = GetDate(),
           Name          = @Name,
           Role          = @Role,
           Email         = @Email,
           Contact1      = @Contact1,
           Contact2      = @Contact2

       WHERE
           ItemID = @ItemID

Database Tables Used:

Contacts: Each record in the Contacts table is a single item, as displayed by the Contacts Portal Module. Since all Contacts modules store their record in this table, each item contains a ModuleID to permit related items to be retrieved in a single query.

The primary key in this table is the ItemID identity field.