03.02.06.sqldataprovider

Module articles for Dot Net Nuke 3.x.x , 4.x.x

if exists (select * from sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}Articles_AddArticle') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}Articles_AddArticle
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}Articles_AddArticle

	@PortalId	int,
	@ModuleId	int,
	@UserId		int,
	@Title		nvarchar(150),
	@Description	nvarchar(2000),
	@Keywords	nvarchar(300),
	@Authed		bit,
	@Featured	bit,
	@Article	ntext,
	@Categories	nvarchar(200),
	@ImageFile	nvarchar(200),
	@PublishDate	datetime,
	@ExpireDate	datetime

AS

INSERT INTO
	{databaseOwner}{objectQualifier}Article(
		PortalId,
		ModuleId,
		UserId,
		Title,
		Description,
		Keywords,
		Authed,
		Featured,
		Article,
		ImageFile,
		PublishDate,
		ExpireDate,
		CreatedDate,
		LastModifiedDate
	)
VALUES
	(
	@PortalId,
	@ModuleId,
	@UserId,
	@Title,
	@Description,
	@Keywords,
	@Authed,
	@Featured,
	@Article,
	@ImageFile,
	@PublishDate,
	@ExpireDate,
	GetDate(),
	GetDate()
	)

DECLARE @ArticleId INT	
SET @ArticleId = @@IDENTITY
	
INSERT INTO {databaseOwner}{objectQualifier}ArticleCategories SELECT @ArticleID, intValue FROM {databaseOwner}{objectQualifier}csvToInt(@Categories)

GO

/***************************************************************************/
if exists (select * from sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}Articles_UpdateArticle') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}Articles_UpdateArticle
GO

CREATE  PROCEDURE {databaseOwner}{objectQualifier}Articles_UpdateArticle

	@ItemId		int,
	@UserId		int,
	@Title		nvarchar(150),
	@Description	nvarchar(2000),
	@Keywords	nvarchar(300),
	@Authed		bit,
	@Featured 	bit,
	@Article	ntext,
	@Categories	nvarchar(200),
	@ImageFile	nvarchar(200),
	@PublishDate	datetime,
	@ExpireDate	datetime
AS
UPDATE
	{databaseOwner}{objectQualifier}Article
SET
	UserId = @UserId,
	Title = @Title,
	Description = @Description,
	Keywords = @Keywords,
	Authed = @Authed,
	Featured = @Featured,
	Article = @Article,
	ImageFile = @ImageFile,
	PublishDate = @PublishDate,
	ExpireDate = @ExpireDate,
	LastModifiedDate = GetDate()
WHERE
	ItemId = @ItemId
	
DELETE {databaseOwner}{objectQualifier}ArticleCategories WHERE ArticleID = @ItemID
INSERT INTO {databaseOwner}{objectQualifier}ArticleCategories SELECT @ItemId, intValue FROM {databaseOwner}{objectQualifier}csvToInt(@Categories)
GO