02.00.00.sqldataprovider

SharpNuke源代码

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

/* rename all tables */
if '{objectQualifier}' <> ''
begin
  EXECUTE sp_rename N'{databaseOwner}Announcements', N'{objectQualifier}Announcements', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Banners', N'{objectQualifier}Banners', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}BannerTypes', N'{objectQualifier}BannerTypes', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Classification', N'{objectQualifier}Classification', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}ClickLog', N'{objectQualifier}ClickLog', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}CodeCountry', N'{objectQualifier}CodeCountry', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}CodeCurrency', N'{objectQualifier}CodeCurrency', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}CodeFrequency', N'{objectQualifier}CodeFrequency', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}CodeProcessor', N'{objectQualifier}CodeProcessor', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}CodeRegion', N'{objectQualifier}CodeRegion', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}CodeSiteLogReport', N'{objectQualifier}CodeSiteLogReport', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Contacts', N'{objectQualifier}Contacts', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Discussion', N'{objectQualifier}Discussion', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Documents', N'{objectQualifier}Documents', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}FAQs', N'{objectQualifier}FAQs', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Files', N'{objectQualifier}Files', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}HostSettings', N'{objectQualifier}HostSettings', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}HtmlText', N'{objectQualifier}HtmlText', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Links', N'{objectQualifier}Links', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}ModuleDefinitions', N'{objectQualifier}ModuleDefinitions', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}ModuleEvents', N'{objectQualifier}ModuleEvents', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Modules', N'{objectQualifier}Modules', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}ModuleSettings', N'{objectQualifier}ModuleSettings', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}PortalModuleDefinitions', N'{objectQualifier}PortalModuleDefinitions', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Portals', N'{objectQualifier}Portals', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Referrer', N'{objectQualifier}Referrer', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Roles', N'{objectQualifier}Roles', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Search', N'{objectQualifier}Search', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}SiteLog', N'{objectQualifier}SiteLog', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Tabs', N'{objectQualifier}Tabs', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}UserDefinedData', N'{objectQualifier}UserDefinedData', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}UserDefinedFields', N'{objectQualifier}UserDefinedFields', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}UserDefinedRows', N'{objectQualifier}UserDefinedRows', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}UserPortals', N'{objectQualifier}UserPortals', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}UserRoles', N'{objectQualifier}UserRoles', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Users', N'{objectQualifier}Users', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}VendorClassification', N'{objectQualifier}VendorClassification', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}VendorFeedback', N'{objectQualifier}VendorFeedback', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}VendorLog', N'{objectQualifier}VendorLog', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}Vendors', N'{objectQualifier}Vendors', 'OBJECT'
  EXECUTE sp_rename N'{databaseOwner}VendorSearch', N'{objectQualifier}VendorSearch', 'OBJECT'
end
GO

/* rename all PK, FK, DF, IX objects */
if '{objectQualifier}' <> ''
begin
  EXECUTE sp_rename N'PK_BannerType', N'PK_{objectQualifier}BannerType', 'OBJECT' 
  EXECUTE sp_rename N'PK_Banner', N'PK_{objectQualifier}Banner', 'OBJECT' 
  EXECUTE sp_rename N'PK_VendorCategory', N'PK_{objectQualifier}VendorCategory', 'OBJECT' 
  EXECUTE sp_rename N'PK_ClickLog', N'PK_{objectQualifier}ClickLog', 'OBJECT' 
  EXECUTE sp_rename N'PK_CodeCountry', N'PK_{objectQualifier}CodeCountry', 'OBJECT' 
  EXECUTE sp_rename N'PK_CodeCurrency', N'PK_{objectQualifier}CodeCurrency', 'OBJECT' 
  EXECUTE sp_rename N'PK_CodeFrequency', N'PK_{objectQualifier}CodeFrequency', 'OBJECT' 
  EXECUTE sp_rename N'PK_CodeProcessor', N'PK_{objectQualifier}CodeProcessor', 'OBJECT' 
  EXECUTE sp_rename N'PK_CodeRegion', N'PK_{objectQualifier}CodeRegion', 'OBJECT' 
  EXECUTE sp_rename N'PK_CodeSiteLogReport', N'PK_{objectQualifier}CodeSiteLogReport', 'OBJECT' 
  EXECUTE sp_rename N'PK_File', N'PK_{objectQualifier}File', 'OBJECT' 
  EXECUTE sp_rename N'PK_PortalModuleDefinitions', N'PK_{objectQualifier}PortalModuleDefinitions', 'OBJECT' 
  EXECUTE sp_rename N'PK_Referrer', N'PK_{objectQualifier}Referrer', 'OBJECT' 
  EXECUTE sp_rename N'PK_Search', N'PK_{objectQualifier}Search', 'OBJECT' 
  EXECUTE sp_rename N'PK_SiteLog', N'PK_{objectQualifier}SiteLog', 'OBJECT' 
  EXECUTE sp_rename N'PK_UserDefinedData', N'PK_{objectQualifier}UserDefinedData', 'OBJECT' 
  EXECUTE sp_rename N'PK_UserDefinedTable', N'PK_{objectQualifier}UserDefinedTable', 'OBJECT' 
  EXECUTE sp_rename N'PK_UserDefinedRows', N'PK_{objectQualifier}UserDefinedRows', 'OBJECT' 
  EXECUTE sp_rename N'PK_UserPortals', N'PK_{objectQualifier}UserPortals', 'OBJECT' 
  EXECUTE sp_rename N'PK_UserRoles', N'PK_{objectQualifier}UserRoles', 'OBJECT' 
  EXECUTE sp_rename N'PK_VendorClassification', N'PK_{objectQualifier}VendorClassification', 'OBJECT' 
  EXECUTE sp_rename N'PK_VendorFeedback', N'PK_{objectQualifier}VendorFeedback', 'OBJECT' 
  EXECUTE sp_rename N'PK_VendorLog', N'PK_{objectQualifier}VendorLog', 'OBJECT' 
  EXECUTE sp_rename N'PK_VendorSearch', N'PK_{objectQualifier}VendorSearch', 'OBJECT' 
  EXECUTE sp_rename N'PK_Vendor', N'PK_{objectQualifier}Vendor', 'OBJECT' 
  EXECUTE sp_rename N'DF_Announcements_Clicks', N'DF_{objectQualifier}Announcements_Clicks', 'OBJECT' 
  EXECUTE sp_rename N'PK_Announcements', N'PK_{objectQualifier}Announcements', 'OBJECT' 
  EXECUTE sp_rename N'DF_Banners_Views', N'DF_{objectQualifier}Banners_Views', 'OBJECT' 
  EXECUTE sp_rename N'DF_Banners_ClickThroughs', N'DF_{objectQualifier}Banners_ClickThroughs', 'OBJECT' 
  EXECUTE sp_rename N'PK_Contacts', N'PK_{objectQualifier}Contacts', 'OBJECT' 
  EXECUTE sp_rename N'PK_Discussion', N'PK_{objectQualifier}Discussion', 'OBJECT' 
  EXECUTE sp_rename N'DF_Documents_Clicks', N'DF_{objectQualifier}Documents_Clicks', 'OBJECT' 
  EXECUTE sp_rename N'PK_Documents', N'PK_{objectQualifier}Documents', 'OBJECT' 
  EXECUTE sp_rename N'IX_HostSettings', N'IX_{objectQualifier}HostSettings', 'OBJECT' 
  EXECUTE sp_rename N'PK_HtmlText', N'PK_{objectQualifier}HtmlText', 'OBJECT' 
  EXECUTE sp_rename N'DF_Links_NewWindow', N'DF_{objectQualifier}Links_NewWindow', 'OBJECT' 
  EXECUTE sp_rename N'DF_Links_Clicks', N'DF_{objectQualifier}Links_Clicks', 'OBJECT' 
  EXECUTE sp_rename N'PK_Links', N'PK_{objectQualifier}Links', 'OBJECT' 
  EXECUTE sp_rename N'DF_ModuleDefinitions_Secure', N'DF_{objectQualifier}ModuleDefinitions_Secure', 'OBJECT' 
  EXECUTE sp_rename N'DF_ModuleDefinitions_IsPremium', N'DF_{objectQualifier}ModuleDefinitions_IsPremium', 'OBJECT' 
  EXECUTE sp_rename N'PK_ModuleDefinitions', N'PK_{objectQualifier}ModuleDefinitions', 'OBJECT'  
  EXECUTE sp_rename N'IX_ModuleDefinitions', N'IX_{objectQualifier}ModuleDefinitions', 'OBJECT' 
  EXECUTE sp_rename N'PK_Events', N'PK_{objectQualifier}Events', 'OBJECT' 
  EXECUTE sp_rename N'{objectQualifier}ModuleSettings.IX_ModuleSettings', N'IX_{objectQualifier}ModuleSettings', 'INDEX' 
  EXECUTE sp_rename N'DF_Modules_AllTabs', N'DF_{objectQualifier}Modules_AllTabs', 'OBJECT' 
  EXECUTE sp_rename N'DF_Modules_ShowTitle', N'DF_{objectQualifier}Modules_ShowTitle', 'OBJECT' 
  EXECUTE sp_rename N'DF_Modules_Personalize', N'DF_{objectQualifier}Modules_Personalize', 'OBJECT' 
  EXECUTE sp_rename N'PK_Modules', N'PK_{objectQualifier}Modules', 'OBJECT' 
  EXECUTE sp_rename N'DF_PortalModuleDefinitions_HostFee', N'DF_{objectQualifier}PortalModuleDefinitions_HostFee', 'OBJECT' 
  EXECUTE sp_rename N'IX_PortalModuleDefinitions', N'IX_{objectQualifier}PortalModuleDefinitions', 'OBJECT' 
  EXECUTE sp_rename N'DF_Portals_UserRegistration', N'DF_{objectQualifier}Portals_UserRegistration', 'OBJECT' 
  EXECUTE sp_rename N'DF_Portals_BannerAdvertising', N'DF_{objectQualifier}Portals_BannerAdvertising', 'OBJECT' 
  EXECUTE sp_rename N'DF_Portals_HostFee', N'DF_{objectQualifier}Portals_HostFee', 'OBJECT' 
  EXECUTE sp_rename N'DF_Portals_HostSpace', N'DF_{objectQualifier}Portals_HostSpace', 'OBJECT' 
  EXECUTE sp_rename N'DF_Portals_GUId', N'DF_{objectQualifier}Portals_GUId', 'OBJECT' 
  EXECUTE sp_rename N'PK_Portals', N'PK_{objectQualifier}Portals', 'OBJECT' 
  EXECUTE sp_rename N'DF_Roles_ServiceFee', N'DF_{objectQualifier}Roles_ServiceFee', 'OBJECT' 
  EXECUTE sp_rename N'DF_Roles_IsPublic', N'DF_{objectQualifier}Roles_IsPublic', 'OBJECT' 
  EXECUTE sp_rename N'DF_Roles_AutoAssignment', N'DF_{objectQualifier}Roles_AutoAssignment', 'OBJECT' 
  EXECUTE sp_rename N'PK_Roles', N'PK_{objectQualifier}Roles', 'OBJECT'  
  EXECUTE sp_rename N'DF_Tabs_TabOrder', N'DF_{objectQualifier}Tabs_TabOrder', 'OBJECT' 
  EXECUTE sp_rename N'DF_Tabs_IsVisible', N'DF_{objectQualifier}Tabs_IsVisible', 'OBJECT' 
  EXECUTE sp_rename N'DF_Tabs_Level', N'DF_{objectQualifier}Tabs_Level', 'OBJECT' 
  EXECUTE sp_rename N'PK_Tabs', N'PK_{objectQualifier}Tabs', 'OBJECT' 
  EXECUTE sp_rename N'IX_Tabs', N'IX_{objectQualifier}Tabs', 'OBJECT' 
  EXECUTE sp_rename N'DF_UserDefinedFields_FieldOrder', N'DF_{objectQualifier}UserDefinedFields_FieldOrder', 'OBJECT' 
  EXECUTE sp_rename N'DF_Users_IsSuperUser', N'DF_{objectQualifier}Users_IsSuperUser', 'OBJECT' 
  EXECUTE sp_rename N'PK_Users', N'PK_{objectQualifier}Users', 'OBJECT' 
  EXECUTE sp_rename N'IX_Users', N'IX_{objectQualifier}Users', 'OBJECT'  
  EXECUTE sp_rename N'IX_VendorClassification', N'IX_{objectQualifier}VendorClassification', 'OBJECT' 
  EXECUTE sp_rename N'DF_Vendors_ClickThroughs', N'DF_{objectQualifier}Vendors_ClickThroughs', 'OBJECT' 
  EXECUTE sp_rename N'DF_Vendors_Views', N'DF_{objectQualifier}Vendors_Views', 'OBJECT' 
  EXECUTE sp_rename N'DF_Vendors_Authorized', N'DF_{objectQualifier}Vendors_Authorized', 'OBJECT' 
  EXECUTE sp_rename N'IX_Vendors', N'IX_{objectQualifier}Vendors', 'OBJECT' 
  EXECUTE sp_rename N'FK_Announcements_Modules', N'FK_{objectQualifier}Announcements_{objectQualifier}Modules', 'OBJECT' 
  EXECUTE sp_rename N'FK_Banner_Vendor', N'FK_{objectQualifier}Banner_{objectQualifier}Vendor', 'OBJECT' 
  EXECUTE sp_rename N'FK_Banners_BannerType', N'FK_{objectQualifier}Banners_{objectQualifier}BannerType', 'OBJECT' 
  EXECUTE sp_rename N'FK_Classification_Classification', N'FK_{objectQualifier}Classification_{objectQualifier}Classification', 'OBJECT' 
  EXECUTE sp_rename N'FK_Contacts_Modules', N'FK_{objectQualifier}Contacts_{objectQualifier}Modules', 'OBJECT' 
  EXECUTE sp_rename N'FK_Discussion_Modules', N'FK_{objectQualifier}Discussion_{objectQualifier}Modules', 'OBJECT' 
  EXECUTE sp_rename N'FK_Documents_Modules', N'FK_{objectQualifier}Documents_{objectQualifier}Modules', 'OBJECT' 
  EXECUTE sp_rename N'FK_HtmlText_Modules', N'FK_{objectQualifier}HtmlText_{objectQualifier}Modules', 'OBJECT' 
  EXECUTE sp_rename N'FK_Links_Modules', N'FK_{objectQualifier}Links_{objectQualifier}Modules', 'OBJECT' 
  EXECUTE sp_rename N'FK_Events_Modules', N'FK_{objectQualifier}Events_{objectQualifier}Modules', 'OBJECT' 
  EXECUTE sp_rename N'FK_ModuleSettings_Modules', N'FK_{objectQualifier}ModuleSettings_{objectQualifier}Modules', 'OBJECT' 
  EXECUTE sp_rename N'FK_Modules_ModuleDefinitions', N'FK_{objectQualifier}Modules_{objectQualifier}ModuleDefinitions', 'OBJECT' 
  EXECUTE sp_rename N'FK_Modules_Tabs', N'FK_{objectQualifier}Modules_{objectQualifier}Tabs', 'OBJECT' 
  EXECUTE sp_rename N'FK_PortalModuleDefinitions_ModuleDefinitions', N'FK_{objectQualifier}PortalModuleDefinitions_{objectQualifier}ModuleDefinitions', 'OBJECT' 
  EXECUTE sp_rename N'FK_PortalModuleDefinitions_Portals', N'FK_{objectQualifier}PortalModuleDefinitions_{objectQualifier}Portals', 'OBJECT' 
  EXECUTE sp_rename N'FK_Roles_CodeFrequency', N'FK_{objectQualifier}Roles_{objectQualifier}CodeFrequency', 'OBJECT' 
  EXECUTE sp_rename N'FK_Roles_Portals', N'FK_{objectQualifier}Roles_{objectQualifier}Portals', 'OBJECT' 
  EXECUTE sp_rename N'FK_SiteLog_Portals', N'FK_{objectQualifier}SiteLog_{objectQualifier}Portals', 'OBJECT' 
  EXECUTE sp_rename N'FK_Tabs_Portals', N'FK_{objectQualifier}Tabs_{objectQualifier}Portals', 'OBJECT' 
  EXECUTE sp_rename N'FK_Tabs_Tabs', N'FK_{objectQualifier}Tabs_{objectQualifier}Tabs', 'OBJECT' 
  EXECUTE sp_rename N'FK_UserDefinedData_UserDefinedFields', N'FK_{objectQualifier}UserDefinedData_{objectQualifier}UserDefinedFields', 'OBJECT' 
  EXECUTE sp_rename N'FK_UserDefinedData_UserDefinedRows', N'FK_{objectQualifier}UserDefinedData_{objectQualifier}UserDefinedRows', 'OBJECT' 
  EXECUTE sp_rename N'FK_UserDefinedFields_Modules', N'FK_{objectQualifier}UserDefinedFields_{objectQualifier}Modules', 'OBJECT' 
  EXECUTE sp_rename N'FK_UserDefinedRows_Modules', N'FK_{objectQualifier}UserDefinedRows_{objectQualifier}Modules', 'OBJECT' 
  EXECUTE sp_rename N'FK_UserPortals_Portals', N'FK_{objectQualifier}UserPortals_{objectQualifier}Portals', 'OBJECT' 
  EXECUTE sp_rename N'FK_UserPortals_Users', N'FK_{objectQualifier}UserPortals_{objectQualifier}Users', 'OBJECT' 
  EXECUTE sp_rename N'FK_UserRoles_Roles', N'FK_{objectQualifier}UserRoles_{objectQualifier}Roles', 'OBJECT' 
  EXECUTE sp_rename N'FK_UserRoles_Users', N'FK_{objectQualifier}UserRoles_{objectQualifier}Users', 'OBJECT' 
  EXECUTE sp_rename N'FK_VendorClassification_Classification', N'FK_{objectQualifier}VendorClassification_{objectQualifier}Classification', 'OBJECT' 
  EXECUTE sp_rename N'FK_VendorClassification_Vendors', N'FK_{objectQualifier}VendorClassification_{objectQualifier}Vendors', 'OBJECT' 
  EXECUTE sp_rename N'FK_VendorFeedback_Vendors', N'FK_{objectQualifier}VendorFeedback_{objectQualifier}Vendors', 'OBJECT' 
  EXECUTE sp_rename N'FK_VendorLog_Portals', N'FK_{objectQualifier}VendorLog_{objectQualifier}Portals', 'OBJECT' 
  EXECUTE sp_rename N'FK_VendorSearch_Portals', N'FK_{objectQualifier}VendorSearch_{objectQualifier}Portals', 'OBJECT' 
  EXECUTE sp_rename N'FK_Vendor_Portals', N'FK_{objectQualifier}Vendor_{objectQualifier}Portals', 'OBJECT' 
end
GO

ALTER TABLE {databaseOwner}{objectQualifier}UserPortals
	DROP CONSTRAINT FK_{objectQualifier}UserPortals_{objectQualifier}Users
GO

ALTER TABLE {databaseOwner}{objectQualifier}UserPortals WITH NOCHECK ADD CONSTRAINT
	FK_{objectQualifier}UserPortals_{objectQualifier}Users FOREIGN KEY
	(
	UserId
	) REFERENCES {databaseOwner}{objectQualifier}Users
	(
	UserId
	) ON DELETE CASCADE
	 NOT FOR REPLICATION

GO

/* script all stored procedures */
drop procedure dbo.AddAnnouncement
GO

create procedure {databaseOwner}{objectQualifier}AddAnnouncement

@ModuleId       int,
@UserName       nvarchar(100),
@Title          nvarchar(150),
@URL            nvarchar(150),
@Syndicate      bit,
@ExpireDate     DateTime,
@Description    nvarchar(2000),
@ViewOrder	int

as

insert into {objectQualifier}Announcements (
  ModuleId,
  CreatedByUser,
  CreatedDate,
  Title,
  URL,
  Syndicate,
  ExpireDate,
  Description,
  ViewOrder
)
values (
  @ModuleId,
  @UserName,
  getdate(),
  @Title,
  @URL,
  @Syndicate,
  @ExpireDate,
  @Description,
  @ViewOrder
)

select SCOPE_IDENTITY()

GO
drop procedure dbo.AddBanner
GO


create procedure {databaseOwner}{objectQualifier}AddBanner

@BannerName    nvarchar(100),
@VendorId      int,
@ImageFile     nvarchar(50),
@URL           nvarchar(100) = null,
@Impressions   int,
@CPM           float,
@StartDate     datetime = null,
@EndDate       datetime = null,
@UserName      nvarchar(100),
@BannerTypeId  int = null

as

insert into {objectQualifier}Banners (
    VendorId,
    ImageFile,
    BannerName,
    URL,
    Impressions,
    CPM,
    Views,
    ClickThroughs,
    StartDate,
    EndDate,
    CreatedByUser,
    CreatedDate,
    BannerTypeId
)
values (
    @VendorId,
    @ImageFile,
    @BannerName,
    @URL,
    @Impressions,
    @CPM,
    0,
    0,
    @StartDate,
    @EndDate,
    @UserName,
    getdate(),
    @BannerTypeId
)

select SCOPE_IDENTITY()

GO
drop procedure dbo.AddContact
GO


create procedure {databaseOwner}{objectQualifier}AddContact

@ModuleId int,
@UserName nvarchar(100),
@Name     nvarchar(50),
@Role     nvarchar(100),
@Email    nvarchar(100),
@Contact1 nvarchar(250),
@Contact2 nvarchar(250)

as

insert into {objectQualifier}Contacts (
  CreatedByUser,
  CreatedDate,
  ModuleId,
  Name,
  Role,
  Email,
  Contact1,
  Contact2
)
values (
  @UserName,
  getdate(),
  @ModuleId,
  @Name,
  @Role,
  @Email,
  @Contact1,
  @Contact2
)

select SCOPE_IDENTITY()

GO
drop procedure dbo.AddDocument
GO


create procedure {databaseOwner}{objectQualifier}AddDocument

@ModuleId         int,
@Title            nvarchar(150),
@URL              nvarchar(250),
@UserName         nvarchar(100),
@Category         nvarchar(50),
@Syndicate        bit

as

insert into {objectQualifier}Documents (
  ModuleId,
  Title,
  URL,
  CreatedByUser,
  CreatedDate,
  Category,
  Syndicate
)
values (
  @ModuleId,
  @Title,
  @URL,
  @UserName,
  getdate(),
  @Category,
  @Syndicate
)

select SCOPE_IDENTITY()

GO
drop procedure dbo.AddFAQ
GO


create procedure {databaseOwner}{objectQualifier}AddFAQ

@ModuleId int,
@UserName nvarchar(100),
@Question text,
@Answer   text

as

insert into {objectQualifier}FAQs (
  CreatedByUser,
  CreatedDate,
  ModuleId,
  Question,
  Answer
)
values (
  @UserName,
  getdate(),
  @ModuleId,
  @Question,
  @Answer
)

select SCOPE_IDENTITY()

GO
drop procedure dbo.AddFile
GO


create procedure {databaseOwner}{objectQualifier}AddFile

@PortalId    int,
@FileName    nvarchar(100),
@Extension   nvarchar(100),
@Size        int,
@WIdth       int,
@Height      int,
@ContentType nvarchar(200)

as

insert into {objectQualifier}Files ( 
  PortalId,
  FileName,
  Extension,
  Size,
  WIdth,
  Height,
  ContentType 
)
values (
  @PortalId,
  @FileName,
  @Extension,
  @Size,
  @WIdth,
  @Height,
  @ContentType 
)

select SCOPE_IDENTITY()

GO

create procedure {databaseOwner}{objectQualifier}UpdateFile

@FileId      int,
@FileName    nvarchar(100),
@Extension   nvarchar(100),
@Size        int,
@WIdth       int,
@Height      int,
@ContentType nvarchar(200)

as

update {objectQualifier}Files
set    FileName = @FileName,
       Extension = @Extension,
       Size = @Size,
       WIdth = @WIdth,
       Height = @Height,
       ContentType = @ContentType
where  FileId = @FileId
GO

drop procedure dbo.AddLink
GO

create procedure {databaseOwner}{objectQualifier}AddLink

@ModuleId    int,
@UserName    nvarchar(100),
@Title       nvarchar(100),
@Url         nvarchar(250),
@MobileUrl   nvarchar(250),
@ViewOrder   int,
@Description nvarchar(2000),
@NewWindow   bit

as

insert into {objectQualifier}Links (
  ModuleId,
  CreatedByUser,
  CreatedDate,
  Title,
  Url,
  MobileUrl,
  ViewOrder,
  Description,
  NewWindow
)
values (
  @ModuleId,
  @UserName,
  getdate(),
  @Title,
  @Url,
  @MobileUrl,
  @ViewOrder,
  @Description,
  @NewWindow
)

select SCOPE_IDENTITY()

GO
create procedure {databaseOwner}{objectQualifier}GetMessageByParentId

@ParentId int

as

select DisplayOrder
from   {objectQualifier}Discussion 
where  ItemId = @ParentId

GO

drop procedure dbo.AddMessage
GO


create procedure {databaseOwner}{objectQualifier}AddMessage

@Title nvarchar(100),
@Body nvarchar(3000),
@DisplayOrder nvarchar(750),
@UserName nvarchar(100),
@ModuleId int

as

insert into {objectQualifier}Discussion (
  Title,
  Body,
  DisplayOrder,
  CreatedDate, 
  CreatedByUser,
  ModuleId
)
values (
  @Title,
  @Body,
  @DisplayOrder,
  getdate(),
  @UserName,
  @ModuleId
)

select SCOPE_IDENTITY()

GO
drop procedure dbo.AddModule
GO