its
ALTER PROCEDURE [dbo].[JobsDb_ContactInfo_InsertUpdateSingleItem]
@Userid int ,
@UserName varchar(50),
@Title varchar(50),
@FirstName varchar(50) ,
@LastName varchar(50),
@Email varchar(50),
@StreetAddress1 Varchar(50),
@StreetAddress2 Varchar(50),
@ZiporPost varchar(40),
@CountryId int,
@StateId int,
@City varchar(50),
@PrimaryPhone varchar(50),
@SecondaryPhone varchar(50),
@WorkStatus smallint,
@SHMyName char(1),
@SHMyEmail char(1),
@SHMyPhones char(1),
@ActivityDate datetime
AS
DECLARE @ReturnValue int
IF (@Userid IS NULL) -- New Item
BEGIN
INSERT INTO JobsDb\_ContactInformation
(\[UserName\] ,
\[Title\],
\[FirstName\] ,
\[LastName\] ,
\[Email\],
\[StreetAddress1\],
\[StreetAddress2\] ,
\[ZiporPost\] ,
\[CountryID\],
\[StateId\],
\[City\],
\[PrimaryPhone\] ,
\[SecondaryPhone\],
\[WorkStatus\],
\[SHMyName\] ,
\[SHMyEmail\],
\[SHMyPhones\],
\[ActivityDate\]
)
VALUES
(
@UserName,
@Title,
@FirstName,
@LastName,
@Email,
@StreetAddress1,
@StreetAddress2,
@ZiporPost,
@CountryId,
@StateId,
@City,
@PrimaryPhone,
@SecondaryPhone,
@WorkStatus,
@SHMyName,
@SHMyEmail,
@SHMyPhones,
@ActivityDate
)
SELECT @ReturnValue = SCOPE\_IDENTITY()
END
ELSE
BEGIN
UPDATE JobsDb\_ContactInformation SET
\[UserName\] = @UserName,
\[Title\] = @Title,
\[FirstName\] = @FirstName,
\[LastName\] = @LastName,
\[Email\] = @Email,
\[StreetAddress1\] = @StreetAddress1,
\[StreetAddress2\] = @StreetAddress2,
\[ZiporPost\] = @ZiporPost,
\[CountryId\]= @CountryId,
\[StateId\] = @StateId,
\[City\] = @City,
\[PrimaryPhone\] = @PrimaryPhone,
\[SecondaryPhone\] = @SecondaryPhone,
\[WorkStatus\]=@WorkStatus,
\[SHMyName\] = @SHMyName,
\[SHMyEmail\]=@SHMyEmail,
\[SHMyPhones\]=@SHMyPhones,
\[ActivityDate\]= @ActivityDate
WHERE
UserId = @Userid
SELECT @ReturnValue = @Userid
END
IF (@@ERROR != 0)
BEGIN
RETURN -1
END
ELSE
BEGIN
RETURN @ReturnValue
END
appu
