01.00.00.sqldataprovider

Job post Job post

/************************************************************/
/*****              SqlDataProvider                     *****/
/*****                                                  *****/
/*****                                                  *****/
/***** Note: To manually execute this script you must   *****/
/*****       perform a search and replace operation     *****/
/*****       for {databaseOwner} and {objectQualifier}  *****/
/*****                                                  *****/
/************************************************************/

/* =====================================================================================
/   TABLE: JobPost
/  ===================================================================================== */

-- DROP GET PROCEDURE -------------------------------------------------------------------------------------%>
/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}JobPostGet    Script Date: Monday, 22 September 2008 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}JobPostGet') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}JobPostGet 
GO

-- DROP LIST PROCEDURE -------------------------------------------------------------------------------------%>
/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}JobPostGetAll     Script Date: Monday, 22 September 2008 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}JobPostGetAll') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}JobPostGetAll
GO

-- DROP INSERT PROCEDURE -----------------------------------------------------------------------------------%>
/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}JobPostAdd    Script Date: Monday, 22 September 2008 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}JobPostAdd') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}JobPostAdd
GO

-- DROP UPDATE PROCEDURE -------------------------------------------------------------------------------------%>
/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}JobPostUpdate    Script Date: Monday, 22 September 2008 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}JobPostUpdate') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}JobPostUpdate
GO

-- DROP DELETE PROCEDURE -------------------------------------------------------------------------------------%>
/****** Object:  Stored Procedure {databaseOwner}{objectQualifier}JobPostDelete    Script Date: Monday, 22 September 2008 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}JobPostDelete') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}JobPostDelete
GO

-- GET PROCEDURE -------------------------------------------------------------------------------------%>
/* -------------------------------------------------------------------------------------
/   {databaseOwner}{objectQualifier}JobPostGet
/  ------------------------------------------------------------------------------------- */
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}JobPostGet
	@JobId int
	
AS

SELECT
	[JobId],
	[Code],
	[ShortDescription],
	[Description],
	[Status],
	[SortNumber],
	[DateCreated],
	[JobDate],
	[Title]
FROM {objectQualifier}JobPost
WHERE
	([JobId] = @JobId OR @JobId IS NULL)
	
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO



/* -------------------------------------------------------------------------------------
/   {databaseOwner}{objectQualifier}JobPostGetAll 
/  ------------------------------------------------------------------------------------- */
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}JobPostGetAll
	
AS

SELECT
	[JobId],
	[Code],
	[ShortDescription],
	[Description],
	[Status],
	[SortNumber],
	[DateCreated],
	[JobDate],
	[Title]
FROM {objectQualifier}JobPost

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


-- INSERT PROCEDURE -------------------------------------------------------------------------------------%>
/* -------------------------------------------------------------------------------------
/   {databaseOwner}{objectQualifier}JobPostAdd
/  ------------------------------------------------------------------------------------- */
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}JobPostAdd
	@Code varchar(50),
	@ShortDescription varchar(255),
	@Description ntext,
	@Status int,
	@SortNumber int,
	@DateCreated datetime,
	@JobDate varchar(50),
	@Title varchar(50)
AS

INSERT INTO {objectQualifier}JobPost (
	[Code],
	[ShortDescription],
	[Description],
	[Status],
	[SortNumber],
	[DateCreated],
	[JobDate],
	[Title]
) VALUES (
	@Code,
	@ShortDescription,
	@Description,
	@Status,
	@SortNumber,
	@DateCreated,
	@JobDate,
	@Title
)

select SCOPE_IDENTITY()
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

-- UPDATE PROCEDURE -------------------------------------------------------------------------------------%>
/* -------------------------------------------------------------------------------------
/   {databaseOwner}{objectQualifier}JobPostUpdate
/  ------------------------------------------------------------------------------------- */
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}JobPostUpdate
	@JobId int, 
	@Code varchar(50), 
	@ShortDescription varchar(255), 
	@Description ntext, 
	@Status int, 
	@SortNumber int, 
	@DateCreated datetime, 
	@JobDate varchar(50), 
	@Title varchar(50) 
AS

UPDATE {objectQualifier}JobPost SET
	[Code] = @Code,
	[ShortDescription] = @ShortDescription,
	[Description] = @Description,
	[Status] = @Status,
	[SortNumber] = @SortNumber,
	[DateCreated] = @DateCreated,
	[JobDate] = @JobDate,
	[Title] = @Title
WHERE
	[JobId] = @JobId
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

/* -------------------------------------------------------------------------------------
/   {databaseOwner}{objectQualifier}JobPostDelete
/  ------------------------------------------------------------------------------------- */
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}JobPostDelete
	@JobId int
AS

DELETE FROM {objectQualifier}JobPost
WHERE
	[JobId] = @JobId
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO