C# Класс DotNetNuke.Modules.Forums.Providers.Data.SqlDataProvider.SqlDataProvider

SQL Server implementation (ie. concrete provider) of the abstract DataProvider class for the Forums module.
Наследование: IDataProvider
Показать файл Открыть проект

Открытые методы

Метод Описание
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

Приватные методы

Метод Описание
GetFullyQualifiedName ( string name ) : string
GetNull ( object field ) : object

Описание методов

AddFilter() публичный Метод

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
Результат int

AddPermission() публичный Метод

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
Результат int

AddPoll() публичный Метод

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
Результат int

AddPollOption() публичный Метод

public AddPollOption ( int pollId, string optionName, int priority, System.DateTime createdOnDate ) : int
pollId int
optionName string
priority int
createdOnDate System.DateTime
Результат int

AddPollResult() публичный Метод

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
Результат int

AddPost() публичный Метод

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
Результат int

AddPostAttachment() публичный Метод

public AddPostAttachment ( int postId, int fileId, string fileUrl, string fileName, bool displayInline ) : int
postId int
fileId int
fileUrl string
fileName string
displayInline bool
Результат int

AddPostRating() публичный Метод

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
Результат int

AddRank() публичный Метод

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
Результат int

AddSetting() публичный Метод

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
Результат int

AddSubscription() публичный Метод

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
Результат int

AddTopic() публичный Метод

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
Результат int

AddTopicTracking() публичный Метод

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
Результат int

AddTracking() публичный Метод

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
Результат int

AddUrl() публичный Метод

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
Результат int

AddUser() публичный Метод

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
Результат int

DeleteFilter() публичный Метод

public DeleteFilter ( int filterId, int portalId ) : void
filterId int
portalId int
Результат void

DeleteForum() публичный Метод

public DeleteForum ( int forumId, int moduleId ) : void
forumId int
moduleId int
Результат void

DeletePermission() публичный Метод

public DeletePermission ( int permissionId, int portalId ) : void
permissionId int
portalId int
Результат void

DeletePoll() публичный Метод

public DeletePoll ( int pollId, int topicId ) : void
pollId int
topicId int
Результат void

DeletePollOption() публичный Метод

public DeletePollOption ( int pollOptionId, int pollId ) : void
pollOptionId int
pollId int
Результат void

DeletePollResult() публичный Метод

public DeletePollResult ( int pollResultId, int pollId ) : void
pollResultId int
pollId int
Результат void

DeletePost() публичный Метод

public DeletePost ( int postId, int topicId ) : void
postId int
topicId int
Результат void

DeletePostAttachment() публичный Метод

public DeletePostAttachment ( int attachmentId, int postId ) : void
attachmentId int
postId int
Результат void

DeletePostRating() публичный Метод

Removes a post rating row from the data store.
public DeletePostRating ( int ratingId, int portalId ) : void
ratingId int
portalId int
Результат void

DeleteRank() публичный Метод

public DeleteRank ( int rankId, int portalId ) : void
rankId int
portalId int
Результат void

DeleteSetting() публичный Метод

public DeleteSetting ( int settingId ) : void
settingId int
Результат void

DeleteSubscription() публичный Метод

public DeleteSubscription ( int subscriptionId, int portalId ) : void
subscriptionId int
portalId int
Результат void

DeleteTopic() публичный Метод

public DeleteTopic ( int topicId, int forumId ) : void
topicId int
forumId int
Результат void

DeleteTopicTracking() публичный Метод

public DeleteTopicTracking ( int topicTrackingId ) : void
topicTrackingId int
Результат void

DeleteTracking() публичный Метод

public DeleteTracking ( int trackingId ) : void
trackingId int
Результат void

DeleteUrl() публичный Метод

public DeleteUrl ( int id, int portalId ) : void
id int
portalId int
Результат void

GetAllFilters() публичный Метод

public GetAllFilters ( int portalID, int moduleId, int forumId ) : IDataReader
portalID int
moduleId int
forumId int
Результат IDataReader

GetAllSettings() публичный Метод

public GetAllSettings ( ) : IDataReader
Результат IDataReader

GetAllUrls() публичный Метод

public GetAllUrls ( int portalId ) : IDataReader
portalId int
Результат IDataReader

GetFilter() публичный Метод

public GetFilter ( int filterId ) : IDataReader
filterId int
Результат IDataReader

GetForum() публичный Метод

public GetForum ( int forumId ) : IDataReader
forumId int
Результат IDataReader

GetForumTopics() публичный Метод

public GetForumTopics ( int forumId, int pageIndex, int pageSize ) : IDataReader
forumId int
pageIndex int
pageSize int
Результат IDataReader

GetModuleForums() публичный Метод

public GetModuleForums ( int moduleId ) : IDataReader
moduleId int
Результат IDataReader

GetModuleRank() публичный Метод

public GetModuleRank ( int moduleId ) : IDataReader
moduleId int
Результат IDataReader

GetPermission() публичный Метод

public GetPermission ( int permissionId ) : IDataReader
permissionId int
Результат IDataReader

GetPollByTopic() публичный Метод

public GetPollByTopic ( int topicId ) : IDataReader
topicId int
Результат IDataReader

GetPollOptions() публичный Метод

public GetPollOptions ( int pollId ) : IDataReader
pollId int
Результат IDataReader

GetPollResults() публичный Метод

public GetPollResults ( int pollId ) : IDataReader
pollId int
Результат IDataReader

GetPortalPermissions() публичный Метод

public GetPortalPermissions ( int portalID ) : IDataReader
portalID int
Результат IDataReader

GetPost() публичный Метод

public GetPost ( int postId ) : IDataReader
postId int
Результат IDataReader

GetRank() публичный Метод

public GetRank ( int rankId ) : IDataReader
rankId int
Результат IDataReader

GetSetting() публичный Метод

public GetSetting ( int settingId ) : IDataReader
settingId int
Результат IDataReader

GetSubscription() публичный Метод

public GetSubscription ( int subscriptionId ) : IDataReader
subscriptionId int
Результат IDataReader

GetTopic() публичный Метод

public GetTopic ( int topicId ) : IDataReader
topicId int
Результат IDataReader

GetTopicAttachments() публичный Метод

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
Результат IDataReader

GetTopicPosts() публичный Метод

public GetTopicPosts ( int topicId ) : IDataReader
topicId int
Результат IDataReader

GetTopicRatings() публичный Метод

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
Результат IDataReader

GetTopicTrackingByForum() публичный Метод

public GetTopicTrackingByForum ( int forumId ) : IDataReader
forumId int
Результат IDataReader

GetTopicTrackingByTopic() публичный Метод

public GetTopicTrackingByTopic ( int topicId ) : IDataReader
topicId int
Результат IDataReader

GetTopicsSubscribers() публичный Метод

public GetTopicsSubscribers ( int portalId, int moduleId, int forumId, int topicId ) : IDataReader
portalId int
moduleId int
forumId int
topicId int
Результат IDataReader

GetUrl() публичный Метод

public GetUrl ( int id ) : IDataReader
id int
Результат IDataReader

GetUser() публичный Метод

public GetUser ( int portalId, int userId ) : IDataReader
portalId int
userId int
Результат IDataReader

GetUsersSubscriptions() публичный Метод

public GetUsersSubscriptions ( int portalId, int userId ) : IDataReader
portalId int
userId int
Результат IDataReader

GetUsersTrackedForums() публичный Метод

public GetUsersTrackedForums ( int userId ) : IDataReader
userId int
Результат IDataReader

HardDeletePost() публичный Метод

public HardDeletePost ( int postId, int topicId ) : void
postId int
topicId int
Результат void

SaveForum() публичный Метод

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
Результат int

UpdateFilter() публичный Метод

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
Результат void

UpdatePermission() публичный Метод

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
Результат void

UpdatePoll() публичный Метод

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
Результат void

UpdatePollOption() публичный Метод

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
Результат void

UpdatePollResult() публичный Метод

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
Результат void

UpdatePost() публичный Метод

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
Результат void

UpdatePostAttachment() публичный Метод

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
Результат void

UpdatePostRating() публичный Метод

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
Результат void

UpdateRank() публичный Метод

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
Результат void

UpdateSetting() публичный Метод

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
Результат void

UpdateSubscription() публичный Метод

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
Результат void

UpdateTopic() публичный Метод

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
Результат void

UpdateTopicTracking() публичный Метод

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
Результат void

UpdateTracking() публичный Метод

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
Результат void

UpdateUrl() публичный Метод

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
Результат void

UpdateUser() публичный Метод

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
Результат void