spAddUpdate_JobPosts
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @ProfessionCodeID | int | IN | |
| @Title | nvarchar(510) | IN | |
| @Description | ntext | IN | |
| @SalaryMin | money | IN | |
| @SalaryMax | money | IN | |
| @CompanyName | nvarchar(510) | IN | |
| @Division | nvarchar(300) | IN | |
| @City | nvarchar(100) | IN | |
| @State | nvarchar(4) | IN | |
| @Country | nvarchar(6) | IN | |
| @County | nvarchar(100) | IN | |
| nvarchar(510) | IN | ||
| @URL | nvarchar(2048) | IN | |
| @AdditionalInfo | nvarchar(2048) | IN | |
| @Guid | uniqueidentifier | IN | |
| @PostedByID | int | IN | |
| @ShowMyInfo | bit | IN | |
| @JobBoardID | int | IN | |
| @Approved | bit | IN | |
| @HideCompanyInfo | bit | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spAddUpdate_JobPosts]
(
@PKID int output,
@ProfessionCodeID int,
@Title nvarchar(510),
@Description ntext,
@SalaryMin money,
@SalaryMax money,
@CompanyName nvarchar(510),
@Division nvarchar(300),
@City nvarchar(100),
@State nvarchar(4),
@Country nvarchar(6),
@County nvarchar(100),
@EMail nvarchar(510),
@URL nvarchar(2048),
@AdditionalInfo nvarchar(2048),
@Guid uniqueidentifier,
@PostedByID int,
@ShowMyInfo bit,
@JobBoardID int,
@Approved bit,
@HideCompanyInfo bit
)
AS
set nocount on
begin transaction
if (@PKID<=0)
begin
declare @ApprovedDate datetime
declare @ApprovedID int
if @Approved=1
begin
set @ApprovedDate = getutcdate()
set @ApprovedID = @PostedByID
end
else
begin
set @ApprovedDate = null
set @ApprovedID = null
end
INSERT INTO [dbo].JobPosts
(
ProfessionCodeID,
Title ,
Description ,
SalaryMin ,
SalaryMax ,
CompanyName ,
Division ,
City ,
State ,
Country ,
County ,
EMail ,
URL ,
AdditionalInfo ,
Guid ,
PostedByID ,
ShowMyInfo ,
JobBoardID ,
Approved ,
ApprovedID ,
ApprovedDate,
HideCompanyInfo
)
VALUES
(
@ProfessionCodeID ,
@Title ,
@Description ,
@SalaryMin ,
@SalaryMax ,
@CompanyName ,
@Division ,
@City ,
@State ,
@Country ,
@County ,
@EMail ,
@URL ,
@AdditionalInfo ,
@Guid ,
@PostedByID ,
@ShowMyInfo ,
@JobBoardID ,
@Approved ,
@ApprovedID ,
@ApprovedDate ,
@HideCompanyInfo
)
SELECT @PKID = @@Identity
end
else
begin
UPDATE [dbo].JobPosts SET
ProfessionCodeID=@ProfessionCodeID,
Title =@Title,
Description =@Description,
SalaryMin =@SalaryMin,
SalaryMax =@SalaryMax,
CompanyName =@CompanyName,
Division =@Division,
City =@City,
State =@State,
Country =@Country,
County =@County,
EMail =@EMail,
URL =@URL,
AdditionalInfo =@AdditionalInfo,
ShowMyInfo =@ShowMyInfo,
HideCompanyInfo =@HideCompanyInfo,
UpdateDate =getutcdate()
WHERE ID=@PKID
end
commit transaction