C# Class DotNetNuke.Modules.Forums.Providers.Data.SqlDataProvider.SqlDataProvider

SQL Server implementation (ie. concrete provider) of the abstract DataProvider class for the Forums module.

Inheritance: IDataProvider

ファイルを表示 Open project: DNNCommunity/DNN.Forum

Public Methods

Method	Description
AddFilter ( int portalId, int moduleId, int forumId, string find, string replace, string filterType, bool applyOnSave, bool applyOnRender ) : int
AddPermission ( string description, int portalId, string canView, string canRead, string canCreate, string canEdit, string canDelete, string canLock, string canPin, string canAttach, string canPoll, string canBlock, string canTrust, string canSubscribe, string canAnnounce, string canTag, string canPrioritize, string canModApprove, string canModMove, string canModSplit, string canModDelete, string canModUser, string canModEdit, string canModLock, string canModPin ) : int
AddPoll ( int topicId, int userId, string question, string pollType, System.DateTime createdOnDate ) : int
AddPollOption ( int pollId, string optionName, int priority, System.DateTime createdOnDate ) : int
AddPollResult ( int pollId, int pollOptionId, string response, string ipaddress, int userId, System.DateTime createdOnDate ) : int
AddPost ( int topicId, int parentPostId, string subject, string body, bool isApproved, bool isLocked, bool isPinned, int userId, string displayName, string emailAddress, string ipAddress, bool postReported, float rating, string postIcon, int statusId, string slug, string postData, System.DateTime approvedOnDate, System.DateTime createdDate ) : int
AddPostAttachment ( int postId, int fileId, string fileUrl, string fileName, bool displayInline ) : int
AddPostRating ( int postId, int userId, int rating, bool helpful, string comments, string ipAddress, System.DateTime createdOnDate ) : int	Adds a post rating (for a specific user and post) row to the data store.
AddRank ( int portalId, int moduleId, string rankName, int minPosts, int maxPosts, string display, System.DateTime createdOnDate ) : int
AddSetting ( string description, bool attachments, bool emoticons, bool html, bool postIcon, bool rss, bool scripts, bool moderated, int autoTrustLevel, int attachMaxCount, int attachMaxSize, bool attachAutoResize, int attachMaxHeight, int attachMaxWidth, int attachStore, string editorType, string editorHeight, string editorWidth, bool filters ) : int
AddSubscription ( int portalId, int moduleId, int forumId, int topicId, int subscriptionType, int userId ) : int
AddTopic ( int forumId, int viewCount, int replyCount, int topicTypeId, int lastPostId, string slug ) : int
AddTopicTracking ( int forumId, int topicId, int lastPostId, int userId, System.DateTime createdOnDate ) : int
AddTracking ( int forumId, int userId, int maxTopicRead, int maxPostRead, System.DateTime lastAccessedOnDate ) : int
AddUrl ( int portalId, int forumId, int topicId, string url, System.DateTime createdOnDate ) : int
AddUser ( int portalId, int userId, int topicCount, int replyCount, int rewardPoints, int answerCount, int questionCount, int trustLevel, string userCaption, System.DateTime lastPostDate, System.DateTime lastActivityDate, bool adminWatch, bool disableAttach, bool disableHtml, System.DateTime createdOnDate ) : int
DeleteFilter ( int filterId, int portalId ) : void
DeleteForum ( int forumId, int moduleId ) : void
DeletePermission ( int permissionId, int portalId ) : void
DeletePoll ( int pollId, int topicId ) : void
DeletePollOption ( int pollOptionId, int pollId ) : void
DeletePollResult ( int pollResultId, int pollId ) : void
DeletePost ( int postId, int topicId ) : void
DeletePostAttachment ( int attachmentId, int postId ) : void
DeletePostRating ( int ratingId, int portalId ) : void	Removes a post rating row from the data store.
DeleteRank ( int rankId, int portalId ) : void
DeleteSetting ( int settingId ) : void
DeleteSubscription ( int subscriptionId, int portalId ) : void
DeleteTopic ( int topicId, int forumId ) : void
DeleteTopicTracking ( int topicTrackingId ) : void
DeleteTracking ( int trackingId ) : void
DeleteUrl ( int id, int portalId ) : void
GetAllFilters ( int portalID, int moduleId, int forumId ) : IDataReader
GetAllSettings ( ) : IDataReader
GetAllUrls ( int portalId ) : IDataReader
GetFilter ( int filterId ) : IDataReader
GetForum ( int forumId ) : IDataReader
GetForumTopics ( int forumId, int pageIndex, int pageSize ) : IDataReader
GetModuleForums ( int moduleId ) : IDataReader
GetModuleRank ( int moduleId ) : IDataReader
GetPermission ( int permissionId ) : IDataReader
GetPollByTopic ( int topicId ) : IDataReader
GetPollOptions ( int pollId ) : IDataReader
GetPollResults ( int pollId ) : IDataReader
GetPortalPermissions ( int portalID ) : IDataReader
GetPost ( int postId ) : IDataReader
GetRank ( int rankId ) : IDataReader
GetSetting ( int settingId ) : IDataReader
GetSubscription ( int subscriptionId ) : IDataReader
GetTopic ( int topicId ) : IDataReader
GetTopicAttachments ( int topicId ) : IDataReader	Retrieves a collection of post attachments assigned to a topic from the data store. It seems like it would be more efficient to get all post attachments for posts in a single topic. You can then cache this and query via linq (handle in sproc.).
GetTopicPosts ( int topicId ) : IDataReader
GetTopicRatings ( int topicId ) : IDataReader	Retrieves a collection of post ratings assigned to a topic from the data store. It seems like it would be more efficient to get all post ratings for posts in a single topic. You could then cache this and query via linq (handle in sproc.).
GetTopicTrackingByForum ( int forumId ) : IDataReader
GetTopicTrackingByTopic ( int topicId ) : IDataReader
GetTopicsSubscribers ( int portalId, int moduleId, int forumId, int topicId ) : IDataReader
GetUrl ( int id ) : IDataReader
GetUser ( int portalId, int userId ) : IDataReader
GetUsersSubscriptions ( int portalId, int userId ) : IDataReader
GetUsersTrackedForums ( int userId ) : IDataReader
HardDeletePost ( int postId, int topicId ) : void
SaveForum ( int forumId, int portalId, int moduleId, int parentId, bool allowTopics, string name, string description, int sortOrder, bool active, bool hidden, int topicCount, int replyCount, int lastPostId, string slug, int permissionId, int settingId, string emailAddress, float siteMapPriority, int UserId ) : int
UpdateFilter ( int filterId, int portalId, int moduleId, int forumId, string find, string replace, string filterType, bool applyOnSave, bool applyOnRender ) : void
UpdatePermission ( int permissionId, string description, int portalId, string canView, string canRead, string canCreate, string canEdit, string canDelete, string canLock, string canPin, string canAttach, string canPoll, string canBlock, string canTrust, string canSubscribe, string canAnnounce, string canTag, string canPrioritize, string canModApprove, string canModMove, string canModSplit, string canModDelete, string canModUser, string canModEdit, string canModLock, string canModPin ) : void
UpdatePoll ( int pollId, int topicId, int userId, string question, string pollType, System.DateTime lastModifiedOnDate ) : void
UpdatePollOption ( int pollOptionId, int pollId, string optionName, int priority, System.DateTime lastModifiedOnDate ) : void
UpdatePollResult ( int pollResultId, int pollId, int pollOptionId, string response, string ipaddress, int userId, System.DateTime lastModifiedOnDate ) : void
UpdatePost ( int postId, int topicId, int parentPostId, string subject, string body, bool isApproved, bool isLocked, bool isPinned, string displayName, string emailAddress, bool postReported, float rating, string postIcon, int statusId, string slug, string postData, System.DateTime approvedOnDate, System.DateTime lastModifiedDate ) : void
UpdatePostAttachment ( int attachmentId, int postId, int fileId, string fileUrl, string fileName, bool displayInline ) : void
UpdatePostRating ( int ratingId, int postId, int userId, int rating, bool helpful, string comments, string ipAddress ) : void	Updates a post rating row in the data store.
UpdateRank ( int rankId, int portalId, int moduleId, string rankName, int minPosts, int maxPosts, string display, System.DateTime lastModifiedOnDate ) : void
UpdateSetting ( int settingId, string description, bool attachments, bool emoticons, bool html, bool postIcon, bool rss, bool scripts, bool moderated, int autoTrustLevel, int attachMaxCount, int attachMaxSize, bool attachAutoResize, int attachMaxHeight, int attachMaxWidth, int attachStore, string editorType, string editorHeight, string editorWidth, bool filters ) : void
UpdateSubscription ( int subscriptionId, int portalId, int moduleId, int forumId, int topicId, int subscriptionType, int userId ) : void
UpdateTopic ( int topicId, int forumId, int viewCount, int replyCount, int topicTypeId, int lastPostId, string slug, int contentItemId ) : void
UpdateTopicTracking ( int topicTrackingId, int forumId, int topicId, int lastPostId, int userId, System.DateTime lastModifiedOnDate ) : void
UpdateTracking ( int trackingId, int forumId, int userId, int maxTopicRead, int maxPostRead, System.DateTime lastAccessedOnDate ) : void
UpdateUrl ( int id, int portalId, int forumId, int topicId, string url, System.DateTime lastModifiedOnDate ) : void
UpdateUser ( int portalId, int userId, int topicCount, int replyCount, int rewardPoints, int answerCount, int questionCount, int trustLevel, string userCaption, System.DateTime lastPostDate, System.DateTime lastActivityDate, bool adminWatch, bool disableAttach, bool disableHtml, System.DateTime lastModifiedOnDate ) : void

Private Methods

Method	Description
GetFullyQualifiedName ( string name ) : string
GetNull ( object field ) : object

Method Details

AddFilter() public method

public AddFilter ( int portalId, int moduleId, int forumId, string find, string replace, string filterType, bool applyOnSave, bool applyOnRender ) : int
portalId	int
moduleId	int
forumId	int
find	string
replace	string
filterType	string
applyOnSave	bool
applyOnRender	bool
return	int

AddPermission() public method

public AddPermission ( string description, int portalId, string canView, string canRead, string canCreate, string canEdit, string canDelete, string canLock, string canPin, string canAttach, string canPoll, string canBlock, string canTrust, string canSubscribe, string canAnnounce, string canTag, string canPrioritize, string canModApprove, string canModMove, string canModSplit, string canModDelete, string canModUser, string canModEdit, string canModLock, string canModPin ) : int
description	string
portalId	int
canView	string
canRead	string
canCreate	string
canEdit	string
canDelete	string
canLock	string
canPin	string
canAttach	string
canPoll	string
canBlock	string
canTrust	string
canSubscribe	string
canAnnounce	string
canTag	string
canPrioritize	string
canModApprove	string
canModMove	string
canModSplit	string
canModDelete	string
canModUser	string
canModEdit	string
canModLock	string
canModPin	string
return	int

AddPoll() public method

public AddPoll ( int topicId, int userId, string question, string pollType, System.DateTime createdOnDate ) : int
topicId	int
userId	int
question	string
pollType	string
createdOnDate	System.DateTime
return	int

AddPollOption() public method

public AddPollOption ( int pollId, string optionName, int priority, System.DateTime createdOnDate ) : int
pollId	int
optionName	string
priority	int
createdOnDate	System.DateTime
return	int

AddPollResult() public method

public AddPollResult ( int pollId, int pollOptionId, string response, string ipaddress, int userId, System.DateTime createdOnDate ) : int
pollId	int
pollOptionId	int
response	string
ipaddress	string
userId	int
createdOnDate	System.DateTime
return	int

AddPost() public method

public AddPost ( int topicId, int parentPostId, string subject, string body, bool isApproved, bool isLocked, bool isPinned, int userId, string displayName, string emailAddress, string ipAddress, bool postReported, float rating, string postIcon, int statusId, string slug, string postData, System.DateTime approvedOnDate, System.DateTime createdDate ) : int
topicId	int
parentPostId	int
subject	string
body	string
isApproved	bool
isLocked	bool
isPinned	bool
userId	int
displayName	string
emailAddress	string
ipAddress	string
postReported	bool
rating	float
postIcon	string
statusId	int
slug	string
postData	string
approvedOnDate	System.DateTime
createdDate	System.DateTime
return	int

AddPostAttachment() public method

public AddPostAttachment ( int postId, int fileId, string fileUrl, string fileName, bool displayInline ) : int
postId	int
fileId	int
fileUrl	string
fileName	string
displayInline	bool
return	int

AddPostRating() public method

Adds a post rating (for a specific user and post) row to the data store.

public AddPostRating ( int postId, int userId, int rating, bool helpful, string comments, string ipAddress, System.DateTime createdOnDate ) : int
postId	int
userId	int
rating	int
helpful	bool
comments	string
ipAddress	string
createdOnDate	System.DateTime
return	int

AddRank() public method

public AddRank ( int portalId, int moduleId, string rankName, int minPosts, int maxPosts, string display, System.DateTime createdOnDate ) : int
portalId	int
moduleId	int
rankName	string
minPosts	int
maxPosts	int
display	string
createdOnDate	System.DateTime
return	int

AddSetting() public method

public AddSetting ( string description, bool attachments, bool emoticons, bool html, bool postIcon, bool rss, bool scripts, bool moderated, int autoTrustLevel, int attachMaxCount, int attachMaxSize, bool attachAutoResize, int attachMaxHeight, int attachMaxWidth, int attachStore, string editorType, string editorHeight, string editorWidth, bool filters ) : int
description	string
attachments	bool
emoticons	bool
html	bool
postIcon	bool
rss	bool
scripts	bool
moderated	bool
autoTrustLevel	int
attachMaxCount	int
attachMaxSize	int
attachAutoResize	bool
attachMaxHeight	int
attachMaxWidth	int
attachStore	int
editorType	string
editorHeight	string
editorWidth	string
filters	bool
return	int

AddSubscription() public method

public AddSubscription ( int portalId, int moduleId, int forumId, int topicId, int subscriptionType, int userId ) : int
portalId	int
moduleId	int
forumId	int
topicId	int
subscriptionType	int
userId	int
return	int

AddTopic() public method

public AddTopic ( int forumId, int viewCount, int replyCount, int topicTypeId, int lastPostId, string slug ) : int
forumId	int
viewCount	int
replyCount	int
topicTypeId	int
lastPostId	int
slug	string
return	int

AddTopicTracking() public method

public AddTopicTracking ( int forumId, int topicId, int lastPostId, int userId, System.DateTime createdOnDate ) : int
forumId	int
topicId	int
lastPostId	int
userId	int
createdOnDate	System.DateTime
return	int

AddTracking() public method

public AddTracking ( int forumId, int userId, int maxTopicRead, int maxPostRead, System.DateTime lastAccessedOnDate ) : int
forumId	int
userId	int
maxTopicRead	int
maxPostRead	int
lastAccessedOnDate	System.DateTime
return	int

AddUrl() public method

public AddUrl ( int portalId, int forumId, int topicId, string url, System.DateTime createdOnDate ) : int
portalId	int
forumId	int
topicId	int
url	string
createdOnDate	System.DateTime
return	int

AddUser() public method

public AddUser ( int portalId, int userId, int topicCount, int replyCount, int rewardPoints, int answerCount, int questionCount, int trustLevel, string userCaption, System.DateTime lastPostDate, System.DateTime lastActivityDate, bool adminWatch, bool disableAttach, bool disableHtml, System.DateTime createdOnDate ) : int
portalId	int
userId	int
topicCount	int
replyCount	int
rewardPoints	int
answerCount	int
questionCount	int
trustLevel	int
userCaption	string
lastPostDate	System.DateTime
lastActivityDate	System.DateTime
adminWatch	bool
disableAttach	bool
disableHtml	bool
createdOnDate	System.DateTime
return	int

DeleteFilter() public method

public DeleteFilter ( int filterId, int portalId ) : void
filterId	int
portalId	int
return	void

DeleteForum() public method

public DeleteForum ( int forumId, int moduleId ) : void
forumId	int
moduleId	int
return	void

DeletePermission() public method

public DeletePermission ( int permissionId, int portalId ) : void
permissionId	int
portalId	int
return	void

DeletePoll() public method

public DeletePoll ( int pollId, int topicId ) : void
pollId	int
topicId	int
return	void

DeletePollOption() public method

public DeletePollOption ( int pollOptionId, int pollId ) : void
pollOptionId	int
pollId	int
return	void

DeletePollResult() public method

public DeletePollResult ( int pollResultId, int pollId ) : void
pollResultId	int
pollId	int
return	void

DeletePost() public method

public DeletePost ( int postId, int topicId ) : void
postId	int
topicId	int
return	void

DeletePostAttachment() public method

public DeletePostAttachment ( int attachmentId, int postId ) : void
attachmentId	int
postId	int
return	void

DeletePostRating() public method

Removes a post rating row from the data store.

public DeletePostRating ( int ratingId, int portalId ) : void
ratingId	int
portalId	int
return	void

DeleteRank() public method

public DeleteRank ( int rankId, int portalId ) : void
rankId	int
portalId	int
return	void

DeleteSetting() public method

public DeleteSetting ( int settingId ) : void
settingId	int
return	void

DeleteSubscription() public method

public DeleteSubscription ( int subscriptionId, int portalId ) : void
subscriptionId	int
portalId	int
return	void

DeleteTopic() public method

public DeleteTopic ( int topicId, int forumId ) : void
topicId	int
forumId	int
return	void

DeleteTopicTracking() public method

public DeleteTopicTracking ( int topicTrackingId ) : void
topicTrackingId	int
return	void

DeleteTracking() public method

public DeleteTracking ( int trackingId ) : void
trackingId	int
return	void

DeleteUrl() public method

public DeleteUrl ( int id, int portalId ) : void
id	int
portalId	int
return	void

GetAllFilters() public method

public GetAllFilters ( int portalID, int moduleId, int forumId ) : IDataReader
portalID	int
moduleId	int
forumId	int
return	IDataReader

GetAllSettings() public method

public GetAllSettings ( ) : IDataReader
return	IDataReader

GetAllUrls() public method

public GetAllUrls ( int portalId ) : IDataReader
portalId	int
return	IDataReader

GetFilter() public method

public GetFilter ( int filterId ) : IDataReader
filterId	int
return	IDataReader

GetForum() public method

public GetForum ( int forumId ) : IDataReader
forumId	int
return	IDataReader

GetForumTopics() public method

public GetForumTopics ( int forumId, int pageIndex, int pageSize ) : IDataReader
forumId	int
pageIndex	int
pageSize	int
return	IDataReader

GetModuleForums() public method

public GetModuleForums ( int moduleId ) : IDataReader
moduleId	int
return	IDataReader

GetModuleRank() public method

public GetModuleRank ( int moduleId ) : IDataReader
moduleId	int
return	IDataReader

GetPermission() public method

public GetPermission ( int permissionId ) : IDataReader
permissionId	int
return	IDataReader

GetPollByTopic() public method

public GetPollByTopic ( int topicId ) : IDataReader
topicId	int
return	IDataReader

GetPollOptions() public method

public GetPollOptions ( int pollId ) : IDataReader
pollId	int
return	IDataReader

GetPollResults() public method

public GetPollResults ( int pollId ) : IDataReader
pollId	int
return	IDataReader

GetPortalPermissions() public method

public GetPortalPermissions ( int portalID ) : IDataReader
portalID	int
return	IDataReader

GetPost() public method

public GetPost ( int postId ) : IDataReader
postId	int
return	IDataReader

GetRank() public method

public GetRank ( int rankId ) : IDataReader
rankId	int
return	IDataReader

GetSetting() public method

public GetSetting ( int settingId ) : IDataReader
settingId	int
return	IDataReader

GetSubscription() public method

public GetSubscription ( int subscriptionId ) : IDataReader
subscriptionId	int
return	IDataReader

GetTopic() public method

public GetTopic ( int topicId ) : IDataReader
topicId	int
return	IDataReader

GetTopicAttachments() public method

Retrieves a collection of post attachments assigned to a topic from the data store.

It seems like it would be more efficient to get all post attachments for posts in a single topic. You can then cache this and query via linq (handle in sproc.).

public GetTopicAttachments ( int topicId ) : IDataReader
topicId	int
return	IDataReader

GetTopicPosts() public method

public GetTopicPosts ( int topicId ) : IDataReader
topicId	int
return	IDataReader

GetTopicRatings() public method

Retrieves a collection of post ratings assigned to a topic from the data store.

It seems like it would be more efficient to get all post ratings for posts in a single topic. You could then cache this and query via linq (handle in sproc.).

public GetTopicRatings ( int topicId ) : IDataReader
topicId	int
return	IDataReader

GetTopicTrackingByForum() public method

public GetTopicTrackingByForum ( int forumId ) : IDataReader
forumId	int
return	IDataReader

GetTopicTrackingByTopic() public method

public GetTopicTrackingByTopic ( int topicId ) : IDataReader
topicId	int
return	IDataReader

GetTopicsSubscribers() public method

public GetTopicsSubscribers ( int portalId, int moduleId, int forumId, int topicId ) : IDataReader
portalId	int
moduleId	int
forumId	int
topicId	int
return	IDataReader

GetUrl() public method

public GetUrl ( int id ) : IDataReader
id	int
return	IDataReader

GetUser() public method

public GetUser ( int portalId, int userId ) : IDataReader
portalId	int
userId	int
return	IDataReader

GetUsersSubscriptions() public method

public GetUsersSubscriptions ( int portalId, int userId ) : IDataReader
portalId	int
userId	int
return	IDataReader

GetUsersTrackedForums() public method

public GetUsersTrackedForums ( int userId ) : IDataReader
userId	int
return	IDataReader

HardDeletePost() public method

public HardDeletePost ( int postId, int topicId ) : void
postId	int
topicId	int
return	void

SaveForum() public method

public SaveForum ( int forumId, int portalId, int moduleId, int parentId, bool allowTopics, string name, string description, int sortOrder, bool active, bool hidden, int topicCount, int replyCount, int lastPostId, string slug, int permissionId, int settingId, string emailAddress, float siteMapPriority, int UserId ) : int
forumId	int
portalId	int
moduleId	int
parentId	int
allowTopics	bool
name	string
description	string
sortOrder	int
active	bool
hidden	bool
topicCount	int
replyCount	int
lastPostId	int
slug	string
permissionId	int
settingId	int
emailAddress	string
siteMapPriority	float
UserId	int
return	int

UpdateFilter() public method

public UpdateFilter ( int filterId, int portalId, int moduleId, int forumId, string find, string replace, string filterType, bool applyOnSave, bool applyOnRender ) : void
filterId	int
portalId	int
moduleId	int
forumId	int
find	string
replace	string
filterType	string
applyOnSave	bool
applyOnRender	bool
return	void

UpdatePermission() public method

public UpdatePermission ( int permissionId, string description, int portalId, string canView, string canRead, string canCreate, string canEdit, string canDelete, string canLock, string canPin, string canAttach, string canPoll, string canBlock, string canTrust, string canSubscribe, string canAnnounce, string canTag, string canPrioritize, string canModApprove, string canModMove, string canModSplit, string canModDelete, string canModUser, string canModEdit, string canModLock, string canModPin ) : void
permissionId	int
description	string
portalId	int
canView	string
canRead	string
canCreate	string
canEdit	string
canDelete	string
canLock	string
canPin	string
canAttach	string
canPoll	string
canBlock	string
canTrust	string
canSubscribe	string
canAnnounce	string
canTag	string
canPrioritize	string
canModApprove	string
canModMove	string
canModSplit	string
canModDelete	string
canModUser	string
canModEdit	string
canModLock	string
canModPin	string
return	void

UpdatePoll() public method

public UpdatePoll ( int pollId, int topicId, int userId, string question, string pollType, System.DateTime lastModifiedOnDate ) : void
pollId	int
topicId	int
userId	int
question	string
pollType	string
lastModifiedOnDate	System.DateTime
return	void

UpdatePollOption() public method

public UpdatePollOption ( int pollOptionId, int pollId, string optionName, int priority, System.DateTime lastModifiedOnDate ) : void
pollOptionId	int
pollId	int
optionName	string
priority	int
lastModifiedOnDate	System.DateTime
return	void

UpdatePollResult() public method

public UpdatePollResult ( int pollResultId, int pollId, int pollOptionId, string response, string ipaddress, int userId, System.DateTime lastModifiedOnDate ) : void
pollResultId	int
pollId	int
pollOptionId	int
response	string
ipaddress	string
userId	int
lastModifiedOnDate	System.DateTime
return	void

UpdatePost() public method

public UpdatePost ( int postId, int topicId, int parentPostId, string subject, string body, bool isApproved, bool isLocked, bool isPinned, string displayName, string emailAddress, bool postReported, float rating, string postIcon, int statusId, string slug, string postData, System.DateTime approvedOnDate, System.DateTime lastModifiedDate ) : void
postId	int
topicId	int
parentPostId	int
subject	string
body	string
isApproved	bool
isLocked	bool
isPinned	bool
displayName	string
emailAddress	string
postReported	bool
rating	float
postIcon	string
statusId	int
slug	string
postData	string
approvedOnDate	System.DateTime
lastModifiedDate	System.DateTime
return	void

UpdatePostAttachment() public method

public UpdatePostAttachment ( int attachmentId, int postId, int fileId, string fileUrl, string fileName, bool displayInline ) : void
attachmentId	int
postId	int
fileId	int
fileUrl	string
fileName	string
displayInline	bool
return	void

UpdatePostRating() public method

Updates a post rating row in the data store.

public UpdatePostRating ( int ratingId, int postId, int userId, int rating, bool helpful, string comments, string ipAddress ) : void
ratingId	int
postId	int
userId	int
rating	int
helpful	bool
comments	string
ipAddress	string
return	void

UpdateRank() public method

public UpdateRank ( int rankId, int portalId, int moduleId, string rankName, int minPosts, int maxPosts, string display, System.DateTime lastModifiedOnDate ) : void
rankId	int
portalId	int
moduleId	int
rankName	string
minPosts	int
maxPosts	int
display	string
lastModifiedOnDate	System.DateTime
return	void

UpdateSetting() public method

public UpdateSetting ( int settingId, string description, bool attachments, bool emoticons, bool html, bool postIcon, bool rss, bool scripts, bool moderated, int autoTrustLevel, int attachMaxCount, int attachMaxSize, bool attachAutoResize, int attachMaxHeight, int attachMaxWidth, int attachStore, string editorType, string editorHeight, string editorWidth, bool filters ) : void
settingId	int
description	string
attachments	bool
emoticons	bool
html	bool
postIcon	bool
rss	bool
scripts	bool
moderated	bool
autoTrustLevel	int
attachMaxCount	int
attachMaxSize	int
attachAutoResize	bool
attachMaxHeight	int
attachMaxWidth	int
attachStore	int
editorType	string
editorHeight	string
editorWidth	string
filters	bool
return	void

UpdateSubscription() public method

public UpdateSubscription ( int subscriptionId, int portalId, int moduleId, int forumId, int topicId, int subscriptionType, int userId ) : void
subscriptionId	int
portalId	int
moduleId	int
forumId	int
topicId	int
subscriptionType	int
userId	int
return	void

UpdateTopic() public method

public UpdateTopic ( int topicId, int forumId, int viewCount, int replyCount, int topicTypeId, int lastPostId, string slug, int contentItemId ) : void
topicId	int
forumId	int
viewCount	int
replyCount	int
topicTypeId	int
lastPostId	int
slug	string
contentItemId	int
return	void

UpdateTopicTracking() public method

public UpdateTopicTracking ( int topicTrackingId, int forumId, int topicId, int lastPostId, int userId, System.DateTime lastModifiedOnDate ) : void
topicTrackingId	int
forumId	int
topicId	int
lastPostId	int
userId	int
lastModifiedOnDate	System.DateTime
return	void

UpdateTracking() public method

public UpdateTracking ( int trackingId, int forumId, int userId, int maxTopicRead, int maxPostRead, System.DateTime lastAccessedOnDate ) : void
trackingId	int
forumId	int
userId	int
maxTopicRead	int
maxPostRead	int
lastAccessedOnDate	System.DateTime
return	void

UpdateUrl() public method

public UpdateUrl ( int id, int portalId, int forumId, int topicId, string url, System.DateTime lastModifiedOnDate ) : void
id	int
portalId	int
forumId	int
topicId	int
url	string
lastModifiedOnDate	System.DateTime
return	void

UpdateUser() public method

public UpdateUser ( int portalId, int userId, int topicCount, int replyCount, int rewardPoints, int answerCount, int questionCount, int trustLevel, string userCaption, System.DateTime lastPostDate, System.DateTime lastActivityDate, bool adminWatch, bool disableAttach, bool disableHtml, System.DateTime lastModifiedOnDate ) : void
portalId	int
userId	int
topicCount	int
replyCount	int
rewardPoints	int
answerCount	int
questionCount	int
trustLevel	int
userCaption	string
lastPostDate	System.DateTime
lastActivityDate	System.DateTime
adminWatch	bool
disableAttach	bool
disableHtml	bool
lastModifiedOnDate	System.DateTime
return	void