sqldataprovider.cs

SharpNuke源代码

				return - 1;
			}
		}
		
		public override void DeleteUserPortal(int userId, int portalId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteUserPortal", userId, portalId);
		}
		
		public override void DeleteUser (int userId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteUser", userId);
		}

		public override void UpdateUser (int userId, string firstName, string lastName, string email)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateUser", userId, firstName, lastName, email);
		}

		public override IDataReader GetUser(int portalId, int userId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetUser", portalId, userId));
		}

		public override IDataReader GetUserByUsername(int portalId, string username)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetUserByUsername", 
				GetNull(portalId), username));
		}

		public override IDataReader GetSuperUsers()
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetSuperUsers", null));
		}

		public override IDataReader GetRolesByUser(int userId, int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetRolesByUser", userId, portalId));
		}

		public override IDataReader GetPortalRoles(int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetPortalRoles", portalId));
		}

		public override IDataReader GetRoles()
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetRoles", null));
		}

		public override IDataReader GetRole(int roleId, int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetRole", roleId, portalId));
		}

		public override IDataReader GetRoleByName(int portalId, string roleName)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetRoleByName", portalId, roleName));
		}

		public override int AddRole(int portalId, string roleName, string description, float serviceFee, 
			string billingPeriod, string billingFrequency, float trialFee, int trialPeriod, string trialFrequency, 
			bool isPublic, bool autoAssignment)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddRole", 
				portalId, roleName, description, serviceFee, billingPeriod, GetNull(billingFrequency), trialFee, trialPeriod, GetNull(trialFrequency), isPublic, autoAssignment));
		}

		public override void DeleteRole (int roleId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteRole", roleId);
		}

		public override void UpdateRole (int roleId, string description, float serviceFee, string billingPeriod, 
			string billingFrequency, float trialFee, int trialPeriod, string trialFrequency, bool isPublic, bool autoAssignment)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateRole", roleId, 
				description, serviceFee, billingPeriod, GetNull(billingFrequency), trialFee, trialPeriod, GetNull(trialFrequency), isPublic, autoAssignment);
		}

		public override IDataReader GetUserRole(int portalId, int userId, int roleId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetUserRole", portalId, userId, roleId));
		}

		public override IDataReader GetUserRolesByUsername(int portalID, string username, string rolename)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetUserRolesByUsername", 
				portalID, GetNull(username), GetNull(rolename)));
		}
		
		public override int AddUserRole(int portalId, int userId, int roleId, DateTime expiryDate)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddUserRole", 
				portalId, userId, roleId, GetNull(expiryDate)));
		}

		public override void UpdateUserRole (int userRoleId, DateTime expiryDate)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateUserRole", 
				userRoleId, GetNull(expiryDate));
		}

		public override void DeleteUserRole (int userId, int roleId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteUserRole", userId, roleId);
		}

		public override IDataReader GetServices(int portalId, int userId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetServices", 
				portalId, GetNull(userId)));
		}

		public override IDataReader GetUsers(int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetUsers", GetNull(portalId)));
		}
		#endregion
		
		#region vendors
		public override IDataReader GetVendors(int portalId, bool unAuthorized, int pageIndex, int pageSize)
		{
			return (IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetVendors", 
				GetNull(portalId), unAuthorized, GetNull(pageSize), GetNull(pageIndex)); 
		}

		public override IDataReader GetVendorsByEmail(string filter, int portalId, int pageIndex, int pageSize)
		{
			return (IDataReader)SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetVendorsByEmail", 
				filter, GetNull(portalId), GetNull(pageSize), GetNull(pageIndex));
		}
		
		public override IDataReader GetVendorsByName(string filter, int portalId, int pageIndex, int pageSize)
		{
			return (IDataReader)SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetVendorsByName", 
				filter, GetNull(portalId), GetNull(pageSize), GetNull(pageIndex));
		}

		public override IDataReader GetVendor(int vendorId, int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetVendor", vendorId, GetNull(portalId)));
		}

		public override void DeleteVendor (int vendorId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteVendor", vendorId);
		}

		public override 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)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddVendor", 
				GetNull(portalId), vendorName, unit, street, city, region, country, postalCode, telephone, fax, cell, 
				email, website, firstName, lastName, userName, logoFile, keyWords, bool.Parse(authorized)));
		}

		public override 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)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateVendor", 
				vendorId, vendorName, unit, street, city, region, country, postalCode, telephone, fax, cell, email, website, 
				firstName, lastName, userName, logoFile, keyWords, bool.Parse(authorized));
		}

		public override IDataReader GetVendorClassifications(int vendorId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetVendorClassifications", 
				GetNull(vendorId)));
		}

		public override void DeleteVendorClassifications (int vendorId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteVendorClassifications", vendorId);
		}

		public override int AddVendorClassification(int vendorId, int classificationId)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddVendorClassification", vendorId, classificationId));
		}
		#endregion
		
		#region banners
		public override IDataReader GetBanners(int vendorId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetBanners", vendorId));
		}

		public override IDataReader GetBanner(int bannerId, int vendorId, int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetBanner", bannerId, vendorId, GetNull(portalId)));
		}

		public override void DeleteBanner (int bannerId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteBanner", bannerId);
		}

		public override 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)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddBanner", 
				bannerName, vendorId, GetNull(imageFile), GetNull(url), impressions, cpm, GetNull(startDate), GetNull(endDate), 
				userName, bannerTypeId, GetNull(description), GetNull(groupName), criteria, width, height));
		}

		public override 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)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateBanner", bannerId, 
				bannerName, GetNull(imageFile), GetNull(url), impressions, cpm, GetNull(startDate), GetNull(endDate), 
				userName, bannerTypeId, GetNull(description), GetNull(groupName), criteria, width, height);
		}

		public override IDataReader FindBanners(int portalId, int bannerTypeId, string groupName)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "FindBanners", 
				GetNull(portalId), GetNull(bannerTypeId), GetNull(groupName)));
		}

		public override void UpdateBannerViews (int bannerId, DateTime startDate, DateTime endDate)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateBannerViews", 
				bannerId, GetNull(startDate), GetNull(endDate));
		}
		public override void UpdateBannerClickThrough (int bannerId, int vendorId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateBannerClickThrough", 
				bannerId, vendorId);
		}
		#endregion
		
		#region affiliates
		public override IDataReader GetAffiliates(int vendorId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetAffiliates", vendorId));
		}

		public override IDataReader GetAffiliate(int affiliateId, int vendorId, int portalId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetAffiliate", affiliateId, vendorId, GetNull(portalId)));
		}

		public override void DeleteAffiliate (int affiliateId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteAffiliate", affiliateId);
		}

		public override int AddAffiliate(int vendorId, DateTime startDate, DateTime endDate, double cpc, double cpa)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddAffiliate", 
				vendorId, GetNull(startDate), GetNull(endDate), cpc, cpa));
		}

		public override void UpdateAffiliate (int affiliateId, DateTime startDate, DateTime endDate, double cpc, double cpa)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateAffiliate", 
				affiliateId, GetNull(startDate), GetNull(endDate), cpc, cpa);
		}

		public override void UpdateAffiliateStats (int affiliateId, int clicks, int acquisitions)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateAffiliateStats", 
				affiliateId, clicks, acquisitions);
		}
		#endregion

		#region skins/containers
		public override IDataReader GetSkin(string skinRoot, int portalId, int skinType)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetSkin", skinRoot, GetNull(portalId), skinType));
		}

		public override void DeleteSkin (string skinRoot, int portalId, int skinType)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteSkin", skinRoot, GetNull(portalId), skinType);
		}

		public override int AddSkin(string skinRoot, int portalId, int skinType, string skinSrc)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddSkin", 
				skinRoot, GetNull(portalId), skinType, skinSrc));
		}
		#endregion
		
		#region personalization
		public override IDataReader GetAllProfiles()
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetAllProfiles", null));
		}

		public override IDataReader GetProfile(int userId, int portalId)
		{