DisplaytypeDAO.cfc | searchcode

/com/meldsolutions/MeldForums/core/displaytype/DisplaytypeDAO.cfc

http://github.com/meldsolutions/Meld-Forums
ColdFusion CFScript | 193 lines | 161 code | 32 blank | 0 comment | 2 complexity | 626b90f7494d35b02a22b7016673b97f MD5 | raw file
Possible License(s): GPL-2.0

<!---This file is part of the Meld Forums application.



Meld Forums is licensed under the GPL 2.0 license

Copyright (C) 2010 2011 Meld Solutions Inc. http://www.meldsolutions.com/



This program is free software; you can redistribute it and/or

modify it under the terms of the GNU General Public License

as published by the Free Software Foundation, version 2 of that license..



This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

GNU General Public License for more details.



You should have received a copy of the GNU General Public License

along with this program; if not, write to the Free Software

Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

--->

<cfcomponent displayname="DisplaytypeDAO" output="false" extends="MeldForums.com.meldsolutions.core.MeldDAO">

<!---^^GENERATEDSTART^^--->

	<cfset variables.instance = StructNew() />

	<cffunction name="init" access="public" output="false" returntype="DisplaytypeDAO">

		<cfargument name="MeldConfig" type="any" required="true">



		<cfset variables.MeldConfig = arguments.MeldConfig />

		

		<cfset structAppend(variables.instance,structCopy(variables.MeldConfig.getAllValues()),true) />

		<cfset structAppend(variables,structCopy(variables.MeldConfig.getAllValues()),true) />



		<cfreturn this>

	</cffunction>

	

	<cffunction name="save" access="public" output="false" returntype="boolean">

		<cfargument name="DisplaytypeBean" type="any" required="true" />



		<cfset var qCreate = "" />

		<cfquery name="qCreate" datasource="#variables.dsn#" username="#variables.dsnusername#" password="#variables.dsnpassword#">

			INSERT INTO

				#variables.dsnprefix#mf_displaytype

				(

				<!---^^SAVECOLUMNS-START^^--->

				Displaytypeid,

				ObjectID,

				Package,

				Name,

				Description,

				Settings,

				IsConfigurable,

				IsActive,

				Version,

				Defaults,

				ModuleID,

				DateCreate,

				DateLastUpdate

				<!---^^SAVECOLUMNS-END^^--->

				)

			VALUES

				(

				<!---^^SAVEVALUES-START^^--->

				<cfqueryparam value="#arguments.DisplaytypeBean.getDisplaytypeid()#" CFSQLType="cf_sql_char" maxlength="35" />,

				<cfqueryparam value="#arguments.DisplaytypeBean.getObjectID()#" CFSQLType="cf_sql_char" null="#(not len(arguments.DisplaytypeBean.getObjectID()))#" maxlength="35" />,

				<cfqueryparam value="#arguments.DisplaytypeBean.getPackage()#" CFSQLType="cf_sql_varchar" maxlength="45" />,

				<cfqueryparam value="#arguments.DisplaytypeBean.getName()#" CFSQLType="cf_sql_varchar" maxlength="45" />,

				<cfqueryparam value="#arguments.DisplaytypeBean.getDescription()#" CFSQLType="cf_sql_longvarchar" null="#(not len(arguments.DisplaytypeBean.getDescription()))#" />,

				<cfqueryparam value="#arguments.DisplaytypeBean.getSettings()#" CFSQLType="cf_sql_longvarchar" null="#(not len(arguments.DisplaytypeBean.getSettings()))#" />,

				<cfqueryparam value="#arguments.DisplaytypeBean.getIsConfigurable()#" CFSQLType="cf_sql_tinyint" />,

				<cfqueryparam value="#arguments.DisplaytypeBean.getIsActive()#" CFSQLType="cf_sql_tinyint" />,

				<cfqueryparam value="#arguments.DisplaytypeBean.getVersion()#" CFSQLType="cf_sql_varchar" maxlength="12" />,

				<cfqueryparam value="#arguments.DisplaytypeBean.getDefaults()#" CFSQLType="cf_sql_longvarchar" null="#(not len(arguments.DisplaytypeBean.getDefaults()))#" />,

				<cfqueryparam value="#arguments.DisplaytypeBean.getModuleID()#" CFSQLType="cf_sql_char" null="#(not len(arguments.DisplaytypeBean.getModuleID()))#" maxlength="35" />,

				<cfqueryparam value="#CreateODBCDateTime(now())#" CFSQLType="cf_sql_timestamp" />,

				<cfqueryparam value="#CreateODBCDateTime(now())#" CFSQLType="cf_sql_timestamp" />

				<!---^^SAVEVALUES-END^^--->

				)

		</cfquery>

		

		<cfset arguments.DisplaytypeBean.setBeanExists( 1 ) />

		<cfset arguments.DisplaytypeBean.setDateCreate( CreateODBCDateTime(now()) ) />

		<cfset arguments.DisplaytypeBean.setDateLastUpdate( CreateODBCDateTime(now()) ) />



		<cfreturn true />

	</cffunction>



	<cffunction name="read" access="public" output="false" returntype="void">

		<cfargument name="DisplaytypeBean" type="any" required="true" />



		<cfset var qRead = "" />

		<cfset var strReturn = structNew() />

		<cfquery name="qRead" datasource="#variables.dsn#" username="#variables.dsnusername#" password="#variables.dsnpassword#">

			SELECT

				*,1 AS BeanExists

			FROM

				#variables.dsnprefix#mf_displaytype

			WHERE

			0=0

			<!---^^PRIMARYKEYS-START^^--->

				AND Displaytypeid = <cfqueryparam value="#arguments.DisplaytypeBean.getDisplaytypeid()#" CFSQLType="cf_sql_char" maxlength="35" />

			<!---^^PRIMARYKEYS-END^^--->

		</cfquery>



		<cfif qRead.recordCount>

			<cfset strReturn = queryRowToStruct(qRead)>

			<cfset arguments.DisplaytypeBean.init(argumentCollection=strReturn)>

		</cfif>

	</cffunction>



	<cffunction name="update" access="public" output="false" returntype="boolean">

		<cfargument name="DisplaytypeBean" type="any" required="true" />



		<cfset var qUpdate = "" />

		<cfquery name="qUpdate" datasource="#variables.dsn#" username="#variables.dsnusername#" password="#variables.dsnpassword#">

			UPDATE

				#variables.dsnprefix#mf_displaytype

			SET

				<!---^^UPDATEVALUES-START^^--->

				ObjectID = <cfqueryparam value="#arguments.DisplaytypeBean.getObjectID()#" CFSQLType="cf_sql_char" null="#(not len(arguments.DisplaytypeBean.getObjectID()))#" maxlength="35" />,

				Package = <cfqueryparam value="#arguments.DisplaytypeBean.getPackage()#" CFSQLType="cf_sql_varchar" maxlength="45" />,

				Name = <cfqueryparam value="#arguments.DisplaytypeBean.getName()#" CFSQLType="cf_sql_varchar" maxlength="45" />,

				Description = <cfqueryparam value="#arguments.DisplaytypeBean.getDescription()#" CFSQLType="cf_sql_longvarchar" null="#(not len(arguments.DisplaytypeBean.getDescription()))#" />,

				Settings = <cfqueryparam value="#arguments.DisplaytypeBean.getSettings()#" CFSQLType="cf_sql_longvarchar" null="#(not len(arguments.DisplaytypeBean.getSettings()))#" />,

				IsConfigurable = <cfqueryparam value="#arguments.DisplaytypeBean.getIsConfigurable()#" CFSQLType="cf_sql_tinyint" />,

				IsActive = <cfqueryparam value="#arguments.DisplaytypeBean.getIsActive()#" CFSQLType="cf_sql_tinyint" />,

				Version = <cfqueryparam value="#arguments.DisplaytypeBean.getVersion()#" CFSQLType="cf_sql_varchar" maxlength="12" />,

				Defaults = <cfqueryparam value="#arguments.DisplaytypeBean.getDefaults()#" CFSQLType="cf_sql_longvarchar" null="#(not len(arguments.DisplaytypeBean.getDefaults()))#" />,

				ModuleID = <cfqueryparam value="#arguments.DisplaytypeBean.getModuleID()#" CFSQLType="cf_sql_char" null="#(not len(arguments.DisplaytypeBean.getModuleID()))#" maxlength="35" />,

				DateLastUpdate = <cfqueryparam value="#CreateODBCDateTime(now())#" CFSQLType="cf_sql_timestamp" />

				<!---^^UPDATEVALUES-END^^--->

		WHERE

			0=0

			<!---^^PRIMARYKEYS-START^^--->

				AND Displaytypeid = <cfqueryparam value="#arguments.DisplaytypeBean.getDisplaytypeid()#" CFSQLType="cf_sql_char" maxlength="35" />

			<!---^^PRIMARYKEYS-END^^--->

		</cfquery>



		<cfset arguments.DisplaytypeBean.setDateLastUpdate( CreateODBCDateTime(now()) ) />



		<cfreturn true />

	</cffunction>

	

	<cffunction name="delete" access="public" output="false" returntype="boolean">

		<cfargument name="DisplaytypeBean" type="any" required="true" />



		<cfset var qDelete = "">

		<cfquery name="qDelete" datasource="#variables.dsn#" username="#variables.dsnusername#" password="#variables.dsnpassword#">

			DELETE FROM

					#variables.dsnprefix#mf_displaytype

			WHERE

				0=0

			<!---^^PRIMARYKEYS-START^^--->

				AND Displaytypeid = <cfqueryparam value="#arguments.DisplaytypeBean.getDisplaytypeid()#" CFSQLType="cf_sql_char" maxlength="35" />

			<!---^^PRIMARYKEYS-END^^--->

		</cfquery>



		<cfset arguments.DisplaytypeBean.setBeanExists( 0 ) />



		<cfreturn true />

	</cffunction>



	<cffunction name="exists" access="public" output="false" returntype="boolean">

		<cfargument name="DisplaytypeBean" type="any" required="true" />



		<cfset var qExists = "">

		<cfquery name="qExists" datasource="#variables.dsn#" username="#variables.dsnusername#" password="#variables.dsnpassword#">

			SELECT

				count(1) as idexists

			FROM

				#variables.dsnprefix#mf_displaytype

			WHERE

				0=0

			<!---^^PRIMARYKEYS-START^^--->

				AND Displaytypeid = <cfqueryparam value="#arguments.DisplaytypeBean.getDisplaytypeid()#" CFSQLType="cf_sql_char" maxlength="35" />

			<!---^^PRIMARYKEYS-END^^--->

		</cfquery>



		<cfif qExists.idexists>

			<cfset arguments.DisplaytypeBean.setBeanExists( 1 ) />

			<cfreturn true />

		<cfelse>

			<cfset arguments.DisplaytypeBean.setBeanExists( 0 ) />

			<cfreturn false />

		</cfif>

	</cffunction>



<!---^^GENERATEDEND^^--->

<!---^^CUSTOMSTART^^--->

<!---^^CUSTOMEND^^--->

</cfcomponent>