sqldataprovider.cs

SharpNuke源代码

		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetModuleSettings", moduleId));
		}

		public override IDataReader GetModuleSetting(int moduleId, string settingName)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetModuleSetting", moduleId, settingName));
		}

		public override void AddModuleSetting (int moduleId, string settingName, string settingValue)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "AddModuleSetting", moduleId, settingName, settingValue);
		}

		public override void UpdateModuleSetting (int moduleId, string settingName, string settingValue)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateModuleSetting", moduleId, settingName, settingValue);
		}
		
		public override IDataReader GetTabModuleSettings(int tabModuleId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetTabModuleSettings", tabModuleId));
		}

		public override IDataReader GetTabModuleSetting(int tabModuleId, string settingName)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetTabModuleSetting", tabModuleId, settingName));
		}

		public override void AddTabModuleSetting (int tabModuleId, string settingName, string settingValue)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "AddTabModuleSetting", tabModuleId, settingName, settingValue);
		}

		public override void UpdateTabModuleSetting (int tabModuleId, string settingName, string settingValue)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateTabModuleSetting", tabModuleId, settingName, settingValue);
		}
		#endregion
		
		#region module definition
		public override IDataReader GetDesktopModule(int desktopModuleId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetDesktopModule", desktopModuleId));
		}

		public override IDataReader GetDesktopModuleByFriendlyName(string friendlyName)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetDesktopModuleByFriendlyName", friendlyName));
		}

		public override IDataReader GetDesktopModuleByModuleName(string moduleName)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetDesktopModuleByModuleName", moduleName));
		}

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

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

		public override int AddDesktopModule(string moduleName, string folderName, string friendlyName, string Description, 
			string version, bool premium, bool admin, string businessControllerClass, int supportedFeatures)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddDesktopModule", moduleName, 
				folderName, friendlyName, GetNull(Description), GetNull(version), premium, admin, businessControllerClass, supportedFeatures));
		}

		public override void UpdateDesktopModule (int desktopModuleId, string moduleName, string folderName, string friendlyName, 
			string description, string version, bool premium, bool admin, string businessControllerClass, int supportedFeatures)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateDesktopModule", desktopModuleId, 
				moduleName, folderName, friendlyName, GetNull(description), GetNull(version), premium, admin, businessControllerClass, supportedFeatures);
		}

		public override void DeleteDesktopModule (int desktopModuleId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteDesktopModule", desktopModuleId);
		}
		
		public override IDataReader GetPortalDesktopModules(int portalId, int desktopModuleId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetPortalDesktopModules", GetNull(portalId), GetNull(desktopModuleId)));
		}

		public override int AddPortalDesktopModule(int portalId, int desktopModuleId)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddPortalDesktopModule", portalId, desktopModuleId));
		}

		public override void DeletePortalDesktopModules (int portalId, int desktopModuleId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeletePortalDesktopModules", GetNull(portalId), GetNull(desktopModuleId));
		}
		
		public override IDataReader GetModuleDefinitions(int desktopModuleId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetModuleDefinitions", desktopModuleId));
		}

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

		public override IDataReader GetModuleDefinitionByName(int desktopModuleId, string friendlyName)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetModuleDefinitionByName", desktopModuleId, friendlyName));
		}

		public override int AddModuleDefinition(int desktopModuleId, string friendlyName, int defaultCacheTime)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddModuleDefinition", desktopModuleId, friendlyName, defaultCacheTime));
		}
		public override void DeleteModuleDefinition (int moduleDefId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteModuleDefinition", moduleDefId);
		}

		public override void UpdateModuleDefinition (int moduleDefId, string friendlyName, int defaultCacheTime)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateModuleDefinition", moduleDefId, friendlyName, defaultCacheTime);
		}
		
		public override IDataReader GetModuleControl(int moduleControlId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetModuleControl", moduleControlId));
		}

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

		public override IDataReader GetModuleControlsByKey(string controlKey, int moduleDefId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetModuleControlsByKey", GetNull(controlKey), GetNull(moduleDefId)));
		}

		public override IDataReader GetModuleControlByKeyAndSrc(int moduleDefID, string controlKey, string controlSrc)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetModuleControlByKeyAndSrc", 
				GetNull(moduleDefID), GetNull(controlKey), GetNull(controlSrc)));
		}

		public override int AddModuleControl(int moduleDefId, string controlKey, string controlTitle, string ControlSrc, 
			string iconFile, int controlType, int viewOrder, string helpUrl)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddModuleControl", 
				GetNull(moduleDefId), GetNull(controlKey), GetNull(controlTitle), ControlSrc, GetNull(iconFile), controlType, GetNull(viewOrder), GetNull(helpUrl)));
		}

		public override void UpdateModuleControl (int moduleControlId, int moduleDefId, string controlKey, string controlTitle, 
			string controlSrc, string iconFile, int controlType, int viewOrder, string helpUrl)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateModuleControl", moduleControlId, 
				GetNull(moduleDefId), GetNull(controlKey), GetNull(controlTitle), controlSrc, GetNull(iconFile), 
				controlType, GetNull(viewOrder), GetNull(helpUrl));
		}

		public override void DeleteModuleControl (int moduleControlId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteModuleControl", moduleControlId);
		}
		#endregion
		
		#region files
		public override IDataReader GetFiles(int portalId, string folder)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetFiles", GetNull(portalId), folder));
		}

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

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

		public override void DeleteFile (int portalId, string fileName, string folder)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteFile", GetNull(portalId), fileName, folder);
		}

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

		public override int AddFile(int portalId, string fileName, string extension, long size, int width, int height, 
			string contentType, string folder)
		{
			return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddFile", 
				GetNull(portalId), fileName, extension, size, GetNull(width), GetNull(height), contentType, folder));
		}

		public override void UpdateFile (int fileId, string fileName, string extension, long size, 
			int width, int height, string contentType, string Folder)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "UpdateFile", fileId, 
				fileName, extension, size, GetNull(width), GetNull(height), contentType, Folder);
		}

		public override DataTable GetAllFiles()
		{
			return SqlHelper.ExecuteDataset(ConnectionString, DatabaseOwner + ObjectQualifier + "GetAllFiles").Tables[0];
		}

		#endregion
		
		#region site log
		public override void AddSiteLog (DateTime dateTime, int portalId, int userId, string referrer, 
			string url, string userAgent, string userHostAddress, string userHostName, int tabId, int affiliateId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "AddSiteLog", dateTime, 
				portalId, GetNull(userId), GetNull(referrer), GetNull(url), GetNull(userAgent), GetNull(userHostAddress), 
				GetNull(userHostName), GetNull(tabId), GetNull(affiliateId));
		}

		public override IDataReader GetSiteLog(int portalId, string portalAlias, string reportName, 
			DateTime startDate, DateTime endDate)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + reportName, 
				portalId, portalAlias, startDate, endDate));
		}

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

		public override void DeleteSiteLog (DateTime dateTime, int portalId)
		{
			SqlHelper.ExecuteNonQuery(ConnectionString, DatabaseOwner + ObjectQualifier + "DeleteSiteLog", dateTime, portalId);
		}
		#endregion
		
		#region database
		public override IDataReader ExecuteSQL(string sql)
		{
			sql = sql.Replace("{databaseOwner}", DatabaseOwner);
			sql = sql.Replace("{objectQualifier}", ObjectQualifier);
			try
			{
				return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, CommandType.Text, sql));
			}
			catch
			{
				// error in SQL query
				return null;
			}
		}

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

		public override IDataReader GetFields(string tableName)
		{
			string sql = "SELECT * FROM {objectQualifier}" + tableName + " WHERE 1 = 0";
			return ExecuteSQL(sql);
		}
		#endregion

		#region security
		public override IDataReader UserLogin(string username, string password)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "UserLogin", username, password));
		}

		public override IDataReader GetAuthRoles(int portalId, int moduleId)
		{
			return ((IDataReader) SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner + ObjectQualifier + "GetAuthRoles", portalId, moduleId));
		}
		#endregion
		
		#region users
		public override int AddUser(int portalID, string username, string firstName, string lastName, 
			int affiliateId, bool superUser, string email)
		{
			try
			{
				return System.Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, DatabaseOwner + ObjectQualifier + "AddUser", 
					portalID, username, firstName, lastName, GetNull(affiliateId), superUser, email));
			}
			catch // duplicate
			{