C# Class Engage.Dnn.Publish.Data.SqlDataProvider

Inheritance: DataProvider

Mostrar archivo Open project: EngageSoftware/Engage-Publish

Public Methods

Method	Description
AddArticleVersion ( IDbTransaction trans, int itemVersionId, int itemId, string versionNumber, string versionDescription, string articleText, string referenceNumber ) : void
AddArticleVersion ( int itemVersionId, int itemId, string versionNumber, string versionDescription, string articleText, string referenceNumber ) : void
AddCategoryVersion ( IDbTransaction trans, int itemVersionId, int itemId, int sortOrder, int childDisplayTabId ) : void
AddCategoryVersion ( int itemVersionId, int itemId, int sortOrder, int childDisplayTabId ) : void
AddItem ( IDbTransaction trans, int itemTypeId, int portalId, int moduleId, System.Guid itemIdentifier ) : int
AddItemRelationship ( IDbTransaction trans, int childItemId, int childItemVersionId, int parentItemId, int relationshipTypeId, string startDate, string endDate, int sortOrder ) : void
AddItemRelationship ( int childItemId, int childItemVersionId, int parentItemId, int relationshipTypeId, string startDate, string endDate, int sortOrder ) : void
AddItemRelationshipWithOriginalSortOrder ( IDbTransaction trans, int childItemId, int childItemVersionId, int parentItemId, int relationshipTypeId, string startDate, string endDate, int originalItemVersionId ) : void
AddItemTag ( IDbTransaction trans, int itemVersionId, int tagId ) : void
AddItemTag ( int itemVersionId, int tagId ) : void
AddItemVersion ( IDbTransaction trans, int itemId, int originalItemVersionId, string name, string description, string startDate, string endDate, int languageId, int authorUserId, string metaKeywords, string metaDescription, string metaTitle, int displayTabId, bool disabled, string thumbnail, System.Guid itemVersionIdentifier, string url, bool newWindow, int revisingUserId ) : int
AddItemVersion ( int itemId, int originalItemVersionId, string name, string description, string startDate, string endDate, int languageId, int authorUserId, string metaKeywords, string metaDescription, string metaTitle, int displayTabId, bool disabled, string thumbnail, System.Guid itemVersionIdentifier, string url, bool newWindow, int revisingUserId ) : int
AddItemVersionSetting ( IDbTransaction trans, int itemVersionId, string controlName, string propertyName, string propertyValue ) : void
AddItemVersionSetting ( int itemVersionId, string controlName, string propertyName, string propertyValue ) : void
AddTag ( IDbTransaction trans, Tag tag ) : int
AddTag ( Tag tag ) : int
CheckItemTag ( IDbTransaction trans, int itemId, int tagId ) : int
CheckItemTag ( int itemId, int tagId ) : int
ClearItemsCommentCount ( int portalId ) : void
ClearItemsViewCount ( int portalId ) : void
CommentsWaitingForApprovalCount ( int portalId, int authorUserId ) : int
ConvertTagsToXml ( ArrayList tagIds ) : object
DeleteItem ( int itemId ) : void
DeleteItems ( ) : void
DeletePermissions ( int categoryId ) : void
FindItemId ( string name, int authorUserId ) : int
FindItemId ( string name, int authorUserId, int categoryId ) : int
GetAdminCommentListing ( int categoryId, int approvalStatusId, int portalId, int authorUserId, string articleSearch ) : DataSet
GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int approvalStatusId, int portalId ) : DataSet
GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int otherRelationshipTypeId, int approvalStatusId, int portalId ) : DataSet
GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int otherRelationshipTypeId, int approvalStatusId, string orderBy, int portalId ) : DataSet
GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int approvalStatusId, string orderBy, int portalId ) : DataSet
GetAdminItemListingSearchKey ( int parentItemId, int itemTypeId, int relationshipTypeId, int otherRelationshipTypeId, int approvalStatusId, string orderBy, string searchKey, int portalId ) : DataSet
GetAdminKeywordSearch ( string searchString, int itemTypeId, int portalId ) : DataSet
GetAdminKeywordSearch ( string searchString, int itemTypeId, int approvalStatusId, int portalId ) : DataSet
GetAllChildCategories ( int parentItemId, int portalId ) : DataTable
GetAllChildren ( int parentId, int relationshipTypeId, int portalId ) : DataSet
GetAllChildren ( int itemTypeId, int parentId, int relationshipTypeId, int portalId ) : DataSet
GetAllChildren ( int itemTypeId, int parentId, int relationshipTypeId, int otherRelationshipTypeId, int portalId ) : DataSet
GetAllChildrenAsDataReader ( int itemTypeId, int parentId, int relationshipTypeId, int otherRelationshipTypeId, int portalId ) : IDataReader
GetAllChildrenNLevels ( int parentCategoryId, int nLevels, int mItems, int portalId ) : DataTable
GetAllRelationships ( int moduleId ) : IDataReader	This currently returns all rows in the item relationship table. We may/could filter to only active at some point.
GetAllRelationshipsByPortalId ( int portalId ) : IDataReader
GetApprovalStatusId ( string itemName ) : IDataReader
GetApprovalStatusTypeName ( int approvalStatusId ) : string
GetApprovalStatusTypes ( int portalId ) : DataSet
GetApprovalStatusTypesForAuthors ( int portalId ) : DataSet
GetArticle ( int itemId ) : IDataReader
GetArticle ( int itemId, int portalId ) : IDataReader
GetArticleVersion ( int itemVersionId, int portalId ) : IDataReader
GetArticles ( int portalId ) : DataTable
GetArticles ( int parentItemId, int portalId ) : DataTable
GetArticlesByModuleId ( int moduleId ) : DataTable
GetArticlesByModuleIdCurrent ( int moduleId ) : DataTable
GetArticlesByPortalId ( int portalId ) : DataTable
GetArticlesSearchIndexingNew ( int portalId, int displayTabId ) : DataTable
GetArticlesSearchIndexingUpdated ( int portalId, int moduleDefId, int displayTabId ) : DataTable
GetAssignedRoles ( int categoryId ) : DataTable
GetCategories ( int portalId ) : DataTable
GetCategoriesByModuleId ( int moduleId ) : DataTable
GetCategoriesByPortalId ( int portalId ) : DataTable
GetCategoriesHierarchy ( int portalId ) : DataTable
GetCategory ( int itemId ) : IDataReader
GetCategory ( int itemId, int portalId ) : IDataReader
GetCategoryItemId ( string categoryName, int portalId ) : int
GetCategoryItems ( int categoryId, int itemTypeId ) : DataSet
GetCategoryItems ( int categoryId, int itemTypeId, int approvalStatusId ) : DataSet
GetCategoryItems ( int categoryId, int itemTypeId, int approvalStatusId, SearchSortOption sort ) : DataSet
GetCategoryListing ( int parentItemId, int portalId ) : IDataReader
GetCategoryVersion ( int itemVersionId, int portalId ) : IDataReader
GetChildCategories ( int parentItemId, int portalId ) : DataTable
GetChildCategories ( int parentItemId, int portalId, int itemTypeId ) : DataTable
GetChildrenInCategory ( int categoryId, int childTypeId, int maxItems, int portalId ) : DataTable
GetChildrenInCategory ( int categoryId, int childTypeId, int maxItems, int portalId, string sortOrder ) : DataTable
GetChildrenInCategoryPaging ( int categoryId, int childTypeId, int maxItems, int portalId, bool customSort, bool customSortDirection, string sortOrder, int index, int pageSize ) : DataTable
GetComments ( int itemId, int approvalStatusId ) : IDataReader
GetDataTable ( string sql, int portalId ) : DataTable
GetItem ( int itemId, int portalId, bool isCurrent ) : IDataReader
GetItemChildRelationships ( int parentItemId, int relationshipTypeId ) : IDataReader
GetItemIdFromVersion ( int itemVersionId ) : int
GetItemIdFromVersion ( int itemVersionId, int portalId ) : int
GetItemName ( int itemId ) : string
GetItemRelationshipByIdentifiers ( System.Guid parentItemIdentifier, System.Guid childItemVersionIdentifier, int currentPortalId ) : IDataReader
GetItemRelationshipByItemRelationshipId ( int itemRelationshipId ) : DataSet
GetItemRelationships ( int childItemId, int childItemVersionId, bool isActive ) : IDataReader
GetItemRelationships ( int childItemId, int childItemVersionId, int relationshipTypeId, bool isActive ) : IDataReader
GetItemTags ( int itemVersionId ) : IDataReader
GetItemType ( string itemName ) : IDataReader
GetItemType ( int itemId ) : string
GetItemTypeFromVersion ( int itemVersionId ) : string
GetItemTypeId ( int itemId ) : int
GetItemTypeName ( int itemTypeId ) : string
GetItemTypeName ( int itemTypeId, bool useCache, int portalId, int cacheTime ) : string
GetItemTypes ( ) : DataTable
GetItemVersion ( System.Guid guid, int portalId ) : IDataReader
GetItemVersionInfo ( int itemVersionId ) : IDataReader
GetItemVersionSettings ( int itemVersionId ) : IDataReader
GetItemVersionSettings ( int itemVersionId, string controlName ) : IDataReader
GetItemVersionSettingsByModuleId ( int moduleId ) : IDataReader
GetItemVersionSettingsByPortalId ( int portalId ) : IDataReader
GetItemVersions ( int itemId, int portalId ) : DataSet
GetItemViewPaging ( int itemTypeId, int categoryId, int pageIndex, int pageSize, string sortOrder, string startDate, string endDate, int portalId ) : DataTable
GetItems ( int parentItemId, int portalId, int relationshipTypeId ) : DataSet
GetItems ( int parentItemId, int portalId, int relationshipTypeId, int itemTypeId ) : DataSet
GetItems ( int parentItemId, int portalId, int relationshipTypeId, int otherRelationshipTypeId, int itemTypeId ) : DataSet
GetItems ( int itemTypeId, int portalId ) : IDataReader
GetItemsFromTags ( int portalId, ArrayList tagList ) : DataTable
GetItemsFromTagsPaging ( int portalId, ArrayList tagList, int maxItems, int pageId, string sortOrder ) : DataTable
GetModuleInfo ( int moduleId ) : IDataReader
GetMostPopular ( int categoryId, int childTypeId, int maxItems, int portalId ) : DataTable
GetMostRecent ( int childTypeId, int maxItems, int portalId ) : DataTable
GetMostRecentByCategoryId ( int categoryId, int childTypeId, int maxItems, int portalId ) : DataTable
GetOldArticleId ( int itemId ) : int
GetOldCategoryId ( int itemId ) : int
GetParentCategories ( int articleId, int portalId ) : DataTable
GetParentCategory ( int childItemId, int portalId ) : int
GetParentItems ( int itemId, int portalId, int relationshipTypeId ) : DataSet
GetPermissionType ( string permissionName ) : IDataReader
GetPopularTags ( int portalId, ArrayList tagList, bool selectTop ) : DataTable
GetPopularTagsCount ( int portalId, ArrayList tagList, bool selectTop ) : int
GetPublishModuleId ( string moduleTitle, int portalId ) : IDataReader
GetPublishTabId ( string tabName, int portalId ) : IDataReader
GetPublishTabName ( int tabId, int portalId ) : IDataReader
GetRelationshipType ( string relationshipName ) : IDataReader
GetSimpleGalleryAlbums ( int moduleId ) : IDataReader
GetSimpleGalleryPhotos ( int albumId, int maxCount ) : DataTable
GetTag ( int tagId ) : DataTable
GetTag ( string tag, int portalId ) : DataTable
GetTags ( int portalId ) : DataTable
GetTagsByString ( string partialTag, int portalId ) : DataTable
GetTopLevelCategories ( int portalId ) : DataSet
GetTopLevelCategoryItem ( string itemName ) : IDataReader
GetUltraMediaGalleryAlbums ( int moduleId ) : IDataReader
GetUltraMediaGalleryPhotos ( int albumId, int maxCount ) : DataTable
GetViewableArticleIds ( int permissionId ) : IDictionary
GetViewableCategoryIds ( int permissionId ) : IDictionary
InsertPermission ( int categoryId, int roleId, int permissionId, int userId ) : void
RunPublishStats ( ) : void
SqlDataProvider ( ) : System
UpdateDescription ( int itemVersionId, string description, string metaDescription ) : void
UpdateItem ( IDbTransaction trans, int itemId, int moduleId ) : void
UpdateItemRelationship ( int itemRelationshipId, int sortOrder ) : void
UpdateItemVersion ( IDbTransaction trans, int itemId, int itemVersionId, int approvalStatusId, int userId, string approvalComments ) : void
UpdateTag ( IDbTransaction trans, Tag tag ) : void
UpdateTag ( Tag tag ) : void
UpdateVenexusBraindump ( int itemId, string indexTitle, string indexContent, string indexWashedContent, int portalId, string indexUrl ) : void
WaitingForApprovalCount ( int portalId ) : int

Private Methods

Method	Description
AddItemView ( int itemId, int itemVersionId, int userId, int tabId, string ipAddress, string userAgent, string httpReferrer, string siteUrl ) : void
EnforceMaxCount ( int maxCount, DataTable photos ) : void
GetAllChildrenFromTwoParents ( int itemTypeId, int parentId, int relationshipTypeId, int otherParentId, int otherRelationshipTypeId, int portalId ) : DataSet
GetCategories ( int itemTypeId, int portalId ) : IDataReader
GetChildren ( int parentId, int relationshipTypeId, int portalId ) : DataSet
GetConnection ( ) : IDbConnection
GetItemVersionSetting ( int itemVersionId, string controlName, string propertyName ) : IDataReader
GetModulesByModuleId ( int moduleId ) : IDataReader
GetSimpleGalleryAlbum ( int albumId ) : IDataReader
GetSimpleGalleryVersion ( ) : string
GetUltraMediaGalleryAlbum ( int albumId ) : IDataReader
GetUserRoles ( ) : string
LimitRows ( int maxItems, DataTable dt ) : void

Method Details

AddArticleVersion() public method

public AddArticleVersion ( IDbTransaction trans, int itemVersionId, int itemId, string versionNumber, string versionDescription, string articleText, string referenceNumber ) : void
trans	IDbTransaction
itemVersionId	int
itemId	int
versionNumber	string
versionDescription	string
articleText	string
referenceNumber	string
return	void

AddArticleVersion() public method

public AddArticleVersion ( int itemVersionId, int itemId, string versionNumber, string versionDescription, string articleText, string referenceNumber ) : void
itemVersionId	int
itemId	int
versionNumber	string
versionDescription	string
articleText	string
referenceNumber	string
return	void

AddCategoryVersion() public method

public AddCategoryVersion ( IDbTransaction trans, int itemVersionId, int itemId, int sortOrder, int childDisplayTabId ) : void
trans	IDbTransaction
itemVersionId	int
itemId	int
sortOrder	int
childDisplayTabId	int
return	void

AddCategoryVersion() public method

public AddCategoryVersion ( int itemVersionId, int itemId, int sortOrder, int childDisplayTabId ) : void
itemVersionId	int
itemId	int
sortOrder	int
childDisplayTabId	int
return	void

AddItem() public method

public AddItem ( IDbTransaction trans, int itemTypeId, int portalId, int moduleId, System.Guid itemIdentifier ) : int
trans	IDbTransaction
itemTypeId	int
portalId	int
moduleId	int
itemIdentifier	System.Guid
return	int

AddItemRelationship() public method

public AddItemRelationship ( IDbTransaction trans, int childItemId, int childItemVersionId, int parentItemId, int relationshipTypeId, string startDate, string endDate, int sortOrder ) : void
trans	IDbTransaction
childItemId	int
childItemVersionId	int
parentItemId	int
relationshipTypeId	int
startDate	string
endDate	string
sortOrder	int
return	void

AddItemRelationship() public method

public AddItemRelationship ( int childItemId, int childItemVersionId, int parentItemId, int relationshipTypeId, string startDate, string endDate, int sortOrder ) : void
childItemId	int
childItemVersionId	int
parentItemId	int
relationshipTypeId	int
startDate	string
endDate	string
sortOrder	int
return	void

AddItemRelationshipWithOriginalSortOrder() public method

public AddItemRelationshipWithOriginalSortOrder ( IDbTransaction trans, int childItemId, int childItemVersionId, int parentItemId, int relationshipTypeId, string startDate, string endDate, int originalItemVersionId ) : void
trans	IDbTransaction
childItemId	int
childItemVersionId	int
parentItemId	int
relationshipTypeId	int
startDate	string
endDate	string
originalItemVersionId	int
return	void

AddItemTag() public method

public AddItemTag ( IDbTransaction trans, int itemVersionId, int tagId ) : void
trans	IDbTransaction
itemVersionId	int
tagId	int
return	void

AddItemTag() public method

public AddItemTag ( int itemVersionId, int tagId ) : void
itemVersionId	int
tagId	int
return	void

AddItemVersion() public method

public AddItemVersion ( IDbTransaction trans, int itemId, int originalItemVersionId, string name, string description, string startDate, string endDate, int languageId, int authorUserId, string metaKeywords, string metaDescription, string metaTitle, int displayTabId, bool disabled, string thumbnail, System.Guid itemVersionIdentifier, string url, bool newWindow, int revisingUserId ) : int
trans	IDbTransaction
itemId	int
originalItemVersionId	int
name	string
description	string
startDate	string
endDate	string
languageId	int
authorUserId	int
metaKeywords	string
metaDescription	string
metaTitle	string
displayTabId	int
disabled	bool
thumbnail	string
itemVersionIdentifier	System.Guid
url	string
newWindow	bool
revisingUserId	int
return	int

AddItemVersion() public method

public AddItemVersion ( int itemId, int originalItemVersionId, string name, string description, string startDate, string endDate, int languageId, int authorUserId, string metaKeywords, string metaDescription, string metaTitle, int displayTabId, bool disabled, string thumbnail, System.Guid itemVersionIdentifier, string url, bool newWindow, int revisingUserId ) : int
itemId	int
originalItemVersionId	int
name	string
description	string
startDate	string
endDate	string
languageId	int
authorUserId	int
metaKeywords	string
metaDescription	string
metaTitle	string
displayTabId	int
disabled	bool
thumbnail	string
itemVersionIdentifier	System.Guid
url	string
newWindow	bool
revisingUserId	int
return	int

AddItemVersionSetting() public method

public AddItemVersionSetting ( IDbTransaction trans, int itemVersionId, string controlName, string propertyName, string propertyValue ) : void
trans	IDbTransaction
itemVersionId	int
controlName	string
propertyName	string
propertyValue	string
return	void

AddItemVersionSetting() public method

public AddItemVersionSetting ( int itemVersionId, string controlName, string propertyName, string propertyValue ) : void
itemVersionId	int
controlName	string
propertyName	string
propertyValue	string
return	void

AddTag() public method

public AddTag ( IDbTransaction trans, Tag tag ) : int
trans	IDbTransaction
tag	Tag
return	int

AddTag() public method

public AddTag ( Tag tag ) : int
tag	Tag
return	int

CheckItemTag() public method

public CheckItemTag ( IDbTransaction trans, int itemId, int tagId ) : int
trans	IDbTransaction
itemId	int
tagId	int
return	int

CheckItemTag() public method

public CheckItemTag ( int itemId, int tagId ) : int
itemId	int
tagId	int
return	int

ClearItemsCommentCount() public method

public ClearItemsCommentCount ( int portalId ) : void
portalId	int
return	void

ClearItemsViewCount() public method

public ClearItemsViewCount ( int portalId ) : void
portalId	int
return	void

CommentsWaitingForApprovalCount() public method

public CommentsWaitingForApprovalCount ( int portalId, int authorUserId ) : int
portalId	int
authorUserId	int
return	int

ConvertTagsToXml() public static method

public static ConvertTagsToXml ( ArrayList tagIds ) : object
tagIds	System.Collections.ArrayList
return	object

DeleteItem() public method

public DeleteItem ( int itemId ) : void
itemId	int
return	void

DeleteItems() public method

public DeleteItems ( ) : void
return	void

DeletePermissions() public method

public DeletePermissions ( int categoryId ) : void
categoryId	int
return	void

FindItemId() public method

public FindItemId ( string name, int authorUserId ) : int
name	string
authorUserId	int
return	int

FindItemId() public method

public FindItemId ( string name, int authorUserId, int categoryId ) : int
name	string
authorUserId	int
categoryId	int
return	int

GetAdminCommentListing() public method

public GetAdminCommentListing ( int categoryId, int approvalStatusId, int portalId, int authorUserId, string articleSearch ) : DataSet
categoryId	int
approvalStatusId	int
portalId	int
authorUserId	int
articleSearch	string
return	System.Data.DataSet

GetAdminItemListing() public method

public GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int approvalStatusId, int portalId ) : DataSet
parentItemId	int
itemTypeId	int
relationshipTypeId	int
approvalStatusId	int
portalId	int
return	System.Data.DataSet

GetAdminItemListing() public method

public GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int otherRelationshipTypeId, int approvalStatusId, int portalId ) : DataSet
parentItemId	int
itemTypeId	int
relationshipTypeId	int
otherRelationshipTypeId	int
approvalStatusId	int
portalId	int
return	System.Data.DataSet

GetAdminItemListing() public method

public GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int otherRelationshipTypeId, int approvalStatusId, string orderBy, int portalId ) : DataSet
parentItemId	int
itemTypeId	int
relationshipTypeId	int
otherRelationshipTypeId	int
approvalStatusId	int
orderBy	string
portalId	int
return	System.Data.DataSet

GetAdminItemListing() public method

public GetAdminItemListing ( int parentItemId, int itemTypeId, int relationshipTypeId, int approvalStatusId, string orderBy, int portalId ) : DataSet
parentItemId	int
itemTypeId	int
relationshipTypeId	int
approvalStatusId	int
orderBy	string
portalId	int
return	System.Data.DataSet

GetAdminItemListingSearchKey() public method

public GetAdminItemListingSearchKey ( int parentItemId, int itemTypeId, int relationshipTypeId, int otherRelationshipTypeId, int approvalStatusId, string orderBy, string searchKey, int portalId ) : DataSet
parentItemId	int
itemTypeId	int
relationshipTypeId	int
otherRelationshipTypeId	int
approvalStatusId	int
orderBy	string
searchKey	string
portalId	int
return	System.Data.DataSet

GetAdminKeywordSearch() public method

public GetAdminKeywordSearch ( string searchString, int itemTypeId, int portalId ) : DataSet
searchString	string
itemTypeId	int
portalId	int
return	System.Data.DataSet

GetAdminKeywordSearch() public method

public GetAdminKeywordSearch ( string searchString, int itemTypeId, int approvalStatusId, int portalId ) : DataSet
searchString	string
itemTypeId	int
approvalStatusId	int
portalId	int
return	System.Data.DataSet

GetAllChildCategories() public method

public GetAllChildCategories ( int parentItemId, int portalId ) : DataTable
parentItemId	int
portalId	int
return	System.Data.DataTable

GetAllChildren() public method

public GetAllChildren ( int parentId, int relationshipTypeId, int portalId ) : DataSet
parentId	int
relationshipTypeId	int
portalId	int
return	System.Data.DataSet

GetAllChildren() public method

public GetAllChildren ( int itemTypeId, int parentId, int relationshipTypeId, int portalId ) : DataSet
itemTypeId	int
parentId	int
relationshipTypeId	int
portalId	int
return	System.Data.DataSet

GetAllChildren() public method

public GetAllChildren ( int itemTypeId, int parentId, int relationshipTypeId, int otherRelationshipTypeId, int portalId ) : DataSet
itemTypeId	int
parentId	int
relationshipTypeId	int
otherRelationshipTypeId	int
portalId	int
return	System.Data.DataSet

GetAllChildrenAsDataReader() public method

public GetAllChildrenAsDataReader ( int itemTypeId, int parentId, int relationshipTypeId, int otherRelationshipTypeId, int portalId ) : IDataReader
itemTypeId	int
parentId	int
relationshipTypeId	int
otherRelationshipTypeId	int
portalId	int
return	IDataReader

GetAllChildrenNLevels() public method

public GetAllChildrenNLevels ( int parentCategoryId, int nLevels, int mItems, int portalId ) : DataTable
parentCategoryId	int
nLevels	int
mItems	int
portalId	int
return	System.Data.DataTable

GetAllRelationships() public method

This currently returns all rows in the item relationship table. We may/could filter to only active at some point.

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

GetAllRelationshipsByPortalId() public method

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

GetApprovalStatusId() public method

public GetApprovalStatusId ( string itemName ) : IDataReader
itemName	string
return	IDataReader

GetApprovalStatusTypeName() public method

public GetApprovalStatusTypeName ( int approvalStatusId ) : string
approvalStatusId	int
return	string

GetApprovalStatusTypes() public method

public GetApprovalStatusTypes ( int portalId ) : DataSet
portalId	int
return	System.Data.DataSet

GetApprovalStatusTypesForAuthors() public method

public GetApprovalStatusTypesForAuthors ( int portalId ) : DataSet
portalId	int
return	System.Data.DataSet

GetArticle() public method

public GetArticle ( int itemId ) : IDataReader
itemId	int
return	IDataReader

GetArticle() public method

public GetArticle ( int itemId, int portalId ) : IDataReader
itemId	int
portalId	int
return	IDataReader

GetArticleVersion() public method

public GetArticleVersion ( int itemVersionId, int portalId ) : IDataReader
itemVersionId	int
portalId	int
return	IDataReader

GetArticles() public method

public GetArticles ( int portalId ) : DataTable
portalId	int
return	System.Data.DataTable

GetArticles() public method

public GetArticles ( int parentItemId, int portalId ) : DataTable
parentItemId	int
portalId	int
return	System.Data.DataTable

GetArticlesByModuleId() public method

public GetArticlesByModuleId ( int moduleId ) : DataTable
moduleId	int
return	System.Data.DataTable

GetArticlesByModuleIdCurrent() public method

public GetArticlesByModuleIdCurrent ( int moduleId ) : DataTable
moduleId	int
return	System.Data.DataTable

GetArticlesByPortalId() public method

public GetArticlesByPortalId ( int portalId ) : DataTable
portalId	int
return	System.Data.DataTable

GetArticlesSearchIndexingNew() public method

public GetArticlesSearchIndexingNew ( int portalId, int displayTabId ) : DataTable
portalId	int
displayTabId	int
return	System.Data.DataTable

GetArticlesSearchIndexingUpdated() public method

public GetArticlesSearchIndexingUpdated ( int portalId, int moduleDefId, int displayTabId ) : DataTable
portalId	int
moduleDefId	int
displayTabId	int
return	System.Data.DataTable

GetAssignedRoles() public method

public GetAssignedRoles ( int categoryId ) : DataTable
categoryId	int
return	System.Data.DataTable

GetCategories() public method

public GetCategories ( int portalId ) : DataTable
portalId	int
return	System.Data.DataTable

GetCategoriesByModuleId() public method

public GetCategoriesByModuleId ( int moduleId ) : DataTable
moduleId	int
return	System.Data.DataTable

GetCategoriesByPortalId() public method

public GetCategoriesByPortalId ( int portalId ) : DataTable
portalId	int
return	System.Data.DataTable

GetCategoriesHierarchy() public method

public GetCategoriesHierarchy ( int portalId ) : DataTable
portalId	int
return	System.Data.DataTable

GetCategory() public method

public GetCategory ( int itemId ) : IDataReader
itemId	int
return	IDataReader

GetCategory() public method

public GetCategory ( int itemId, int portalId ) : IDataReader
itemId	int
portalId	int
return	IDataReader

GetCategoryItemId() public method

public GetCategoryItemId ( string categoryName, int portalId ) : int
categoryName	string
portalId	int
return	int

GetCategoryItems() public method

public GetCategoryItems ( int categoryId, int itemTypeId ) : DataSet
categoryId	int
itemTypeId	int
return	System.Data.DataSet

GetCategoryItems() public method

public GetCategoryItems ( int categoryId, int itemTypeId, int approvalStatusId ) : DataSet
categoryId	int
itemTypeId	int
approvalStatusId	int
return	System.Data.DataSet

GetCategoryItems() public method

public GetCategoryItems ( int categoryId, int itemTypeId, int approvalStatusId, SearchSortOption sort ) : DataSet
categoryId	int
itemTypeId	int
approvalStatusId	int
sort	SearchSortOption
return	System.Data.DataSet

GetCategoryListing() public method

public GetCategoryListing ( int parentItemId, int portalId ) : IDataReader
parentItemId	int
portalId	int
return	IDataReader

GetCategoryVersion() public method

public GetCategoryVersion ( int itemVersionId, int portalId ) : IDataReader
itemVersionId	int
portalId	int
return	IDataReader

GetChildCategories() public method

public GetChildCategories ( int parentItemId, int portalId ) : DataTable
parentItemId	int
portalId	int
return	System.Data.DataTable

GetChildCategories() public method

public GetChildCategories ( int parentItemId, int portalId, int itemTypeId ) : DataTable
parentItemId	int
portalId	int
itemTypeId	int
return	System.Data.DataTable

GetChildrenInCategory() public method

public GetChildrenInCategory ( int categoryId, int childTypeId, int maxItems, int portalId ) : DataTable
categoryId	int
childTypeId	int
maxItems	int
portalId	int
return	System.Data.DataTable

GetChildrenInCategory() public method

public GetChildrenInCategory ( int categoryId, int childTypeId, int maxItems, int portalId, string sortOrder ) : DataTable
categoryId	int
childTypeId	int
maxItems	int
portalId	int
sortOrder	string
return	System.Data.DataTable

GetChildrenInCategoryPaging() public method

public GetChildrenInCategoryPaging ( int categoryId, int childTypeId, int maxItems, int portalId, bool customSort, bool customSortDirection, string sortOrder, int index, int pageSize ) : DataTable
categoryId	int
childTypeId	int
maxItems	int
portalId	int
customSort	bool
customSortDirection	bool
sortOrder	string
index	int
pageSize	int
return	System.Data.DataTable

GetComments() public method

public GetComments ( int itemId, int approvalStatusId ) : IDataReader
itemId	int
approvalStatusId	int
return	IDataReader

GetDataTable() public method

public GetDataTable ( string sql, int portalId ) : DataTable
sql	string
portalId	int
return	System.Data.DataTable

GetItem() public method

public GetItem ( int itemId, int portalId, bool isCurrent ) : IDataReader
itemId	int
portalId	int
isCurrent	bool
return	IDataReader

GetItemChildRelationships() public method

public GetItemChildRelationships ( int parentItemId, int relationshipTypeId ) : IDataReader
parentItemId	int
relationshipTypeId	int
return	IDataReader

GetItemIdFromVersion() public method

public GetItemIdFromVersion ( int itemVersionId ) : int
itemVersionId	int
return	int

GetItemIdFromVersion() public method

public GetItemIdFromVersion ( int itemVersionId, int portalId ) : int
itemVersionId	int
portalId	int
return	int

GetItemName() public method

public GetItemName ( int itemId ) : string
itemId	int
return	string

GetItemRelationshipByIdentifiers() public method

public GetItemRelationshipByIdentifiers ( System.Guid parentItemIdentifier, System.Guid childItemVersionIdentifier, int currentPortalId ) : IDataReader
parentItemIdentifier	System.Guid
childItemVersionIdentifier	System.Guid
currentPortalId	int
return	IDataReader

GetItemRelationshipByItemRelationshipId() public method

public GetItemRelationshipByItemRelationshipId ( int itemRelationshipId ) : DataSet
itemRelationshipId	int
return	System.Data.DataSet

GetItemRelationships() public method

public GetItemRelationships ( int childItemId, int childItemVersionId, bool isActive ) : IDataReader
childItemId	int
childItemVersionId	int
isActive	bool
return	IDataReader

GetItemRelationships() public method

public GetItemRelationships ( int childItemId, int childItemVersionId, int relationshipTypeId, bool isActive ) : IDataReader
childItemId	int
childItemVersionId	int
relationshipTypeId	int
isActive	bool
return	IDataReader

GetItemTags() public method

public GetItemTags ( int itemVersionId ) : IDataReader
itemVersionId	int
return	IDataReader

GetItemType() public method

public GetItemType ( string itemName ) : IDataReader
itemName	string
return	IDataReader

GetItemType() public method

public GetItemType ( int itemId ) : string
itemId	int
return	string

GetItemTypeFromVersion() public method

public GetItemTypeFromVersion ( int itemVersionId ) : string
itemVersionId	int
return	string

GetItemTypeId() public method

public GetItemTypeId ( int itemId ) : int
itemId	int
return	int

GetItemTypeName() public method

public GetItemTypeName ( int itemTypeId ) : string
itemTypeId	int
return	string

GetItemTypeName() public method

public GetItemTypeName ( int itemTypeId, bool useCache, int portalId, int cacheTime ) : string
itemTypeId	int
useCache	bool
portalId	int
cacheTime	int
return	string

GetItemTypes() public method

public GetItemTypes ( ) : DataTable
return	System.Data.DataTable

GetItemVersion() public method

public GetItemVersion ( System.Guid guid, int portalId ) : IDataReader
guid	System.Guid
portalId	int
return	IDataReader

GetItemVersionInfo() public method

public GetItemVersionInfo ( int itemVersionId ) : IDataReader
itemVersionId	int
return	IDataReader

GetItemVersionSettings() public method

public GetItemVersionSettings ( int itemVersionId ) : IDataReader
itemVersionId	int
return	IDataReader

GetItemVersionSettings() public method

public GetItemVersionSettings ( int itemVersionId, string controlName ) : IDataReader
itemVersionId	int
controlName	string
return	IDataReader

GetItemVersionSettingsByModuleId() public method

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

GetItemVersionSettingsByPortalId() public method

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

GetItemVersions() public method

public GetItemVersions ( int itemId, int portalId ) : DataSet
itemId	int
portalId	int
return	System.Data.DataSet

GetItemViewPaging() public method

public GetItemViewPaging ( int itemTypeId, int categoryId, int pageIndex, int pageSize, string sortOrder, string startDate, string endDate, int portalId ) : DataTable
itemTypeId	int
categoryId	int
pageIndex	int
pageSize	int
sortOrder	string
startDate	string
endDate	string
portalId	int
return	System.Data.DataTable

GetItems() public method

public GetItems ( int parentItemId, int portalId, int relationshipTypeId ) : DataSet
parentItemId	int
portalId	int
relationshipTypeId	int
return	System.Data.DataSet

GetItems() public method

public GetItems ( int parentItemId, int portalId, int relationshipTypeId, int itemTypeId ) : DataSet
parentItemId	int
portalId	int
relationshipTypeId	int
itemTypeId	int
return	System.Data.DataSet

GetItems() public method

public GetItems ( int parentItemId, int portalId, int relationshipTypeId, int otherRelationshipTypeId, int itemTypeId ) : DataSet
parentItemId	int
portalId	int
relationshipTypeId	int
otherRelationshipTypeId	int
itemTypeId	int
return	System.Data.DataSet

GetItems() public method

public GetItems ( int itemTypeId, int portalId ) : IDataReader
itemTypeId	int
portalId	int
return	IDataReader

GetItemsFromTags() public method

public GetItemsFromTags ( int portalId, ArrayList tagList ) : DataTable
portalId	int
tagList	System.Collections.ArrayList
return	System.Data.DataTable

GetItemsFromTagsPaging() public method

public GetItemsFromTagsPaging ( int portalId, ArrayList tagList, int maxItems, int pageId, string sortOrder ) : DataTable
portalId	int
tagList	System.Collections.ArrayList
maxItems	int
pageId	int
sortOrder	string
return	System.Data.DataTable

GetModuleInfo() public method

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

GetMostPopular() public method

public GetMostPopular ( int categoryId, int childTypeId, int maxItems, int portalId ) : DataTable
categoryId	int
childTypeId	int
maxItems	int
portalId	int
return	System.Data.DataTable

GetMostRecent() public method

public GetMostRecent ( int childTypeId, int maxItems, int portalId ) : DataTable
childTypeId	int
maxItems	int
portalId	int
return	System.Data.DataTable

GetMostRecentByCategoryId() public method

public GetMostRecentByCategoryId ( int categoryId, int childTypeId, int maxItems, int portalId ) : DataTable
categoryId	int
childTypeId	int
maxItems	int
portalId	int
return	System.Data.DataTable

GetOldArticleId() public method

public GetOldArticleId ( int itemId ) : int
itemId	int
return	int

GetOldCategoryId() public method

public GetOldCategoryId ( int itemId ) : int
itemId	int
return	int

GetParentCategories() public method

public GetParentCategories ( int articleId, int portalId ) : DataTable
articleId	int
portalId	int
return	System.Data.DataTable

GetParentCategory() public method

public GetParentCategory ( int childItemId, int portalId ) : int
childItemId	int
portalId	int
return	int

GetParentItems() public method

public GetParentItems ( int itemId, int portalId, int relationshipTypeId ) : DataSet
itemId	int
portalId	int
relationshipTypeId	int
return	System.Data.DataSet

GetPermissionType() public method

public GetPermissionType ( string permissionName ) : IDataReader
permissionName	string
return	IDataReader

GetPopularTags() public method

public GetPopularTags ( int portalId, ArrayList tagList, bool selectTop ) : DataTable
portalId	int
tagList	System.Collections.ArrayList
selectTop	bool
return	System.Data.DataTable

GetPopularTagsCount() public method

public GetPopularTagsCount ( int portalId, ArrayList tagList, bool selectTop ) : int
portalId	int
tagList	System.Collections.ArrayList
selectTop	bool
return	int

GetPublishModuleId() public method

public GetPublishModuleId ( string moduleTitle, int portalId ) : IDataReader
moduleTitle	string
portalId	int
return	IDataReader

GetPublishTabId() public method

public GetPublishTabId ( string tabName, int portalId ) : IDataReader
tabName	string
portalId	int
return	IDataReader

GetPublishTabName() public method

public GetPublishTabName ( int tabId, int portalId ) : IDataReader
tabId	int
portalId	int
return	IDataReader

GetRelationshipType() public method

public GetRelationshipType ( string relationshipName ) : IDataReader
relationshipName	string
return	IDataReader

GetSimpleGalleryAlbums() public method

Could not retrieve the module's version to determine which stored procedure to use

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

GetSimpleGalleryPhotos() public method

Could not retrieve the module's version to determine which stored procedure to use

public GetSimpleGalleryPhotos ( int albumId, int maxCount ) : DataTable
albumId	int
maxCount	int
return	System.Data.DataTable

GetTag() public method

public GetTag ( int tagId ) : DataTable
tagId	int
return	System.Data.DataTable

GetTag() public method

public GetTag ( string tag, int portalId ) : DataTable
tag	string
portalId	int
return	System.Data.DataTable

GetTags() public method

public GetTags ( int portalId ) : DataTable
portalId	int
return	System.Data.DataTable

GetTagsByString() public method

public GetTagsByString ( string partialTag, int portalId ) : DataTable
partialTag	string
portalId	int
return	System.Data.DataTable

GetTopLevelCategories() public method

public GetTopLevelCategories ( int portalId ) : DataSet
portalId	int
return	System.Data.DataSet

GetTopLevelCategoryItem() public method

public GetTopLevelCategoryItem ( string itemName ) : IDataReader
itemName	string
return	IDataReader

GetUltraMediaGalleryAlbums() public method

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

GetUltraMediaGalleryPhotos() public method

public GetUltraMediaGalleryPhotos ( int albumId, int maxCount ) : DataTable
albumId	int
maxCount	int
return	System.Data.DataTable

GetViewableArticleIds() public method

public GetViewableArticleIds ( int permissionId ) : IDictionary
permissionId	int
return	IDictionary

GetViewableCategoryIds() public method

public GetViewableCategoryIds ( int permissionId ) : IDictionary
permissionId	int
return	IDictionary

InsertPermission() public method

public InsertPermission ( int categoryId, int roleId, int permissionId, int userId ) : void
categoryId	int
roleId	int
permissionId	int
userId	int
return	void

RunPublishStats() public method

public RunPublishStats ( ) : void
return	void

SqlDataProvider() public method

public SqlDataProvider ( ) : System
return	System

UpdateDescription() public method

public UpdateDescription ( int itemVersionId, string description, string metaDescription ) : void
itemVersionId	int
description	string
metaDescription	string
return	void

UpdateItem() public method

public UpdateItem ( IDbTransaction trans, int itemId, int moduleId ) : void
trans	IDbTransaction
itemId	int
moduleId	int
return	void

UpdateItemRelationship() public method

public UpdateItemRelationship ( int itemRelationshipId, int sortOrder ) : void
itemRelationshipId	int
sortOrder	int
return	void

UpdateItemVersion() public method

public UpdateItemVersion ( IDbTransaction trans, int itemId, int itemVersionId, int approvalStatusId, int userId, string approvalComments ) : void
trans	IDbTransaction
itemId	int
itemVersionId	int
approvalStatusId	int
userId	int
approvalComments	string
return	void

UpdateTag() public method

public UpdateTag ( IDbTransaction trans, Tag tag ) : void
trans	IDbTransaction
tag	Tag
return	void

UpdateTag() public method

public UpdateTag ( Tag tag ) : void
tag	Tag
return	void

UpdateVenexusBraindump() public method

public UpdateVenexusBraindump ( int itemId, string indexTitle, string indexContent, string indexWashedContent, int portalId, string indexUrl ) : void
itemId	int
indexTitle	string
indexContent	string
indexWashedContent	string
portalId	int
indexUrl	string
return	void

WaitingForApprovalCount() public method

public WaitingForApprovalCount ( int portalId ) : int
portalId	int
return	int