dataprovider.cs

SharpNuke源代码

		
		// security
		public abstract IDataReader UserLogin(string userName, string password);
		public abstract IDataReader GetAuthRoles(int portalId, int moduleId);
		
		// users
		public abstract IDataReader GetUsers(int portalId);
		public abstract IDataReader GetUser(int portalId, int userId);
		public abstract IDataReader GetUserByUsername(int portalID, string userName);
		public abstract IDataReader GetSuperUsers();
		public abstract int AddUser(int portalID, string userName, string firstName, string lastName, int affiliateId, 
			bool isSuperUser, string email);
		public abstract void DeleteUserPortal(int userId, int portalId);
		public abstract void DeleteUser (int userId);
		public abstract void UpdateUser (int userId, string firstName, string lastName, string email);
		public abstract IDataReader GetPortalRoles(int portalId);
		public abstract IDataReader GetRoles();
		public abstract IDataReader GetRole(int roleID, int portalID);
		public abstract IDataReader GetRoleByName(int portalId, string roleName);
		public abstract int AddRole(int portalId, string roleName, string description, 
			float serviceFee, string billingPeriod, string billingFrequency, float trialFee, int trialPeriod, 
			string trialFrequency, bool isPublic, bool autoAssignment);
		public abstract void DeleteRole (int roleId);
		public abstract void UpdateRole (int roleId, string description, float serviceFee, string billingPeriod, 
			string billingFrequency, float trialFee, int trialPeriod, string trialFrequency, bool isPublic, bool autoAssignment);
		public abstract IDataReader GetRolesByUser(int userId, int portalId);
		public abstract IDataReader GetUserRole(int portalID, int userId, int roleId);
		public abstract IDataReader GetUserRolesByUsername(int portalID, string userName, string roleName);
		public abstract int AddUserRole(int portalID, int userId, int roleId, DateTime expiryDate);
		public abstract void UpdateUserRole (int userRoleId, DateTime expiryDate);
		public abstract void DeleteUserRole (int userId, int roleId);
		public abstract IDataReader GetServices(int portalId, int userId);
		
		// vendors
		public abstract IDataReader GetVendors(int portalId, bool unAuthorized, int pageIndex, int pageSize);
		public abstract IDataReader GetVendorsByEmail(string filter, int portalId, int pageIndex, int pageSize);
		public abstract IDataReader GetVendorsByName(string filter, int portalId, int pageIndex, int pageSize);
		public abstract IDataReader GetVendor(int vendorID, int portalID);
		public abstract void DeleteVendor (int vendorID);
		public abstract int AddVendor(int portalID, string vendorName, string unit, string street, 
			string city, string region, string country, string postalCode, string telephone, string fax, string cell,
			string email, string website, string firstName, string lastName, string userName, string logoFile, string keyWords, string authorized);
		public abstract void UpdateVendor (int vendorID, string vendorName, string unit, string street, string city, 
			string region, string country, string postalCode, string telephone, string fax, string cell, string email, 
			string website, string firstName, string lastName, string userName, string logoFile, string keyWords, string authorized);
		public abstract IDataReader GetVendorClassifications(int vendorId);
		public abstract void DeleteVendorClassifications (int vendorId);
		public abstract int AddVendorClassification(int vendorId, int classificationId);
		
		// banners
		public abstract IDataReader GetBanners(int vendorId);
		public abstract IDataReader GetBanner(int bannerId, int vendorId, int portalID);
		public abstract void DeleteBanner (int bannerId);
		public abstract int AddBanner(string bannerName, int vendorId, string imageFile, string url, int impressions, double cpm, 
			DateTime startDate, DateTime endDate, string userName, int bannerTypeId, string description, string groupName, 
			int criteria, int width, int height);
		public abstract void UpdateBanner (int bannerId, string bannerName, string imageFile, string url, 
			int impressions, double cpm, DateTime startDate, DateTime endDate, string userName, int bannerTypeId, 
			string description, string groupName, int criteria, int width, int height);
		public abstract IDataReader FindBanners(int portalId, int bannerTypeId, string groupName);
		public abstract void UpdateBannerViews (int bannerId, DateTime startDate, DateTime endDate);
		public abstract void UpdateBannerClickThrough (int bannerId, int vendorId);
		
		// affiliates
		public abstract IDataReader GetAffiliates(int vendorId);
		public abstract IDataReader GetAffiliate(int affiliateId, int vendorId, int portalID);
		public abstract void DeleteAffiliate (int affiliateId);
		public abstract int AddAffiliate(int vendorId, DateTime startDate, DateTime endDate, 
			double cpc, double cpa);
		public abstract void UpdateAffiliate (int affiliateId, DateTime startDate, DateTime endDate, 
			double cpc, double cpa);
		public abstract void UpdateAffiliateStats (int affiliateId, int clicks, int acquisitions);
		
		// skins/containers
		public abstract IDataReader GetSkin(string skinRoot, int portalId, int skinType);
		public abstract void DeleteSkin (string skinRoot, int portalId, int skinType);
		public abstract int AddSkin(string skinRoot, int portalId, int skinType, string skinSrc);
		
		// personalization
		public abstract IDataReader GetAllProfiles();
		public abstract IDataReader GetProfile(int userId, int portalId);
		public abstract void AddProfile (int userId, int portalId);
		public abstract void UpdateProfile (int userId, int portalId, string profileData);
		
		// users online
		public abstract void UpdateUsersOnline (Hashtable userList);
		public abstract void DeleteUsersOnline (int timeWindow);
		
		// urls
		public abstract IDataReader GetUrls(int portalID);
		public abstract IDataReader GetUrl(int portalID, string url);
		public abstract void AddUrl (int portalID, string url);
		public abstract void DeleteUrl (int portalID, string url);
		public abstract IDataReader GetUrlTracking(int portalID, string url, int moduleId);
		public abstract void AddUrlTracking (int portalID, string url, string urlType, bool logActivity, 
			bool trackClicks, int moduleId, bool newWindow);
		public abstract void UpdateUrlTracking (int portalID, string url, bool logActivity, bool trackClicks, 
			int moduleId, bool newWindow);
		public abstract void DeleteUrlTracking (int portalID, string url, int moduleId);
		public abstract void UpdateUrlTrackingStats (int portalID, string url, int moduleId);
		public abstract IDataReader GetUrlLog(int urlTrackingID, DateTime startDate, DateTime endDate);
		public abstract void AddUrlLog (int urlTrackingID, int userID);
		
		//Folders
		public abstract IDataReader GetFoldersByPortal(int portalID);
		public abstract IDataReader GetFolder(int portalID, int folderID);
		public abstract IDataReader GetFolder(int portalID, string folderPath);
		public abstract int AddFolder(int portalID, string folderPath);
		public abstract void UpdateFolder (int portalID, int folderID, string folderPath);
		public abstract void DeleteFolder (int portalID, string folderPath);
		
		//Permission
		public abstract IDataReader GetPermission(int permissionID);
		public abstract IDataReader GetPermissionsByModuleID(int moduleID);
		public abstract IDataReader GetPermissionsByFolderPath(int portalID, string folder);
		public abstract IDataReader GetPermissionByCodeAndKey(string permissionCode, string permissionKey);
		public abstract IDataReader GetPermissionsByTabID(int tabID);
		public abstract void DeletePermission (int permissionID);
		public abstract int AddPermission(string permissionCode, int moduleDefID, string permissionKey, string permissionName);
		public abstract void UpdatePermission (int permissionID, string permissionCode, int moduleDefID, 
			string permissionKey, string permissionName);
		
		//ModulePermission
		public abstract IDataReader GetModulePermission(int modulePermissionID);
		public abstract IDataReader GetModulePermissionsByModuleID(int moduleID, int permissionID);
		public abstract IDataReader GetModulePermissionsByPortal(int portalID);
		public abstract void DeleteModulePermissionsByModuleID (int moduleID);
		public abstract void DeleteModulePermission (int modulePermissionID);
		public abstract int AddModulePermission(int moduleID, int permissionID, int roleID, bool allowAccess);
		public abstract void UpdateModulePermission (int modulePermissionID, int moduleID, int permissionID, int roleID, bool allowAccess);
		
		//TabPermission
		public abstract IDataReader GetTabPermissionsByPortal(int portalID);
		public abstract IDataReader GetTabPermissionsByTabID(int tabID, int permissionID);
		public abstract void DeleteTabPermissionsByTabID (int tabID);
		public abstract void DeleteTabPermission (int tabPermissionID);
		public abstract int AddTabPermission(int tabID, int permissionID, int roleID, bool allowAccess);
		public abstract void UpdateTabPermission (int tabPermissionID, int tabID, int permissionID, 
			int roleID, bool allowAccess);
		
		//FolderPermission
		public abstract IDataReader GetFolderPermission(int folderPermissionID);
		public abstract IDataReader GetFolderPermissionsByFolderPath(int portalID, string folderPath, int permissionID);
		public abstract void DeleteFolderPermissionsByFolderPath (int portalID, string folderPath);
		public abstract void DeleteFolderPermission (int folderPermissionID);
		public abstract int AddFolderPermission(int folderID, int permissionID, int roleID, bool allowAccess);
		public abstract void UpdateFolderPermission (int folderPermissionID, int folderID, int permissionID, int roleID, bool allowAccess);
		
		// search engine
		public abstract IDataReader GetSearchIndexers();
		
		// content search datastore
		public abstract void DeleteSearchItems (int moduleID);
		public abstract void DeleteSearchItem (int searchItemId);
		public abstract void DeleteSearchItemWords (int searchItemId);
		public abstract int AddSearchItem(string title, string description, int author, DateTime pubDate, 
			int moduleId, string key, string guid, int imageFileId);
		public abstract IDataReader GetSearchCommonWordsByLocale(string locale);
		public abstract IDataReader GetDefaultLanguageByModule(string moduleList);
		public abstract IDataReader GetSearchSettings(int moduleId);
		public abstract IDataReader GetSearchWords();
		public abstract int AddSearchWord(string word);
		public abstract int AddSearchItemWord(int searchItemId, int searchWordsID, int occurrences);
		public abstract void AddSearchItemWordPosition (int searchItemWordID, string contentPositions);
		public abstract IDataReader GetSearchResults(int portalID, string word);
		public abstract IDataReader GetSearchItems(int portalID, int tabID, int moduleID);
		public abstract IDataReader GetSearchItem(int moduleID, string searchKey);
		public abstract void UpdateSearchItem (int searchItemId, string title, string description, 
			int author, DateTime pubDate, int moduleId, string key, string guid, int hitCount, int imageFileId);
		
		//Lists
		public abstract IDataReader GetListGroup();
		public abstract IDataReader GetList(string listName, string parentKey, int definitionID);
		public abstract IDataReader GetListEntries(string listName, string parentKey, int entryID, int definitionID);
		public abstract IDataReader GetListEntriesByListName(string listName, string value, string parentKey);
		public abstract int AddListEntry(string listName, string value, string text, string parentKey, bool enableSortOrder, 
			int definitionID, string description);
		public abstract void UpdateListEntry (int entryID, string listName, string value, string text, string description);
		public abstract void DeleteListEntryByID (int entryID, bool deleteChild);
		public abstract void DeleteList (string listName, string parentKey);
		public abstract void DeleteListEntryByListName (string listName, string value, bool deleteChild);
		public abstract void UpdateListSortOrder (int entryID, bool moveUp);
		
		//portal alias
		public abstract IDataReader GetPortalAlias(string portalAlias, int portalID);
		public abstract IDataReader GetPortalAliasByPortalID(int portalID);
		public abstract IDataReader GetPortalAliasByPortalAliasID(int portalAliasID);
		public abstract IDataReader GetPortalByPortalAliasID(int portalAliasId);
		public abstract void UpdatePortalAlias (string portalAlias);
		public abstract void UpdatePortalAliasInfo (int portalAliasID, int portalID, string httpAlias);
		public abstract int AddPortalAlias(int portalID, string httpAlias);
		public abstract void DeletePortalAlias (int portalAliasID);
		#endregion
		
	}
	
}