Return to act_addcontact.cfm CVS log

Up to [Development] / p2rx-programs

*** empty log message ***

<!--- 	Name:  act_addcontact.cfm
    	Purpose: This functions as the action file to insert the information of the contact(s) for the organization into the
				dcontacts dummy table in the programs database.
			
		Date created: 02/24/2005
       	Dependancy: URL.Orgid 
		Variables: 	FinalworkNumber - work area, work suffix and workphone transformed together into one variable.
					FinalMobileNumber - Mobile suffix,mobile area and mobile number transformed together into one variable.
					FinalfaxNumber - Fax suffix,Fax area and Fax number transformed into one variable.
		Functions: 
		Date changed: 
					02/24/2005			Prabin & Neena  Created
					02/24/2005			Neena		    Documentation
---> 

	<cfparam name="form.Prefix" default="">
	<cfparam name="form.FirstName" default="">
	<cfparam name="form.Middle" default="">
	<cfparam name="form.LastName" default="">
	<cfparam name="form.NameSuffix" default="">
	<cfparam name="form.Title" default="">
	<cfparam name="form.Primary" default="0">
	<cfparam name="form.Address" default="">
	<cfparam name="form.City" default="">
	<cfparam name="form.State" default="">
	<cfparam name="form.Zip" default="">
	<cfparam name="form.WorkPhone_Area" default="">
	<cfparam name="form.WorkPhone_Prefix" default="">
	<cfparam name="form.WorkPhone_Num" default="">	
	<cfparam name="form.WorkExtension" default="">
	<cfparam name="form.MobilePhone_Area" default="">
	<cfparam name="form.MobilePhone_Prefix" default="">
	<cfparam name="form.MobilePhone_Num" default="">
	<cfparam name="form.FaxNumber_Area" default="">
	<cfparam name="form.FaxNumber_Prefix" default="">
	<cfparam name="form.FaxNumber_Num" default="">
	<cfparam name="form.EmailName" default="">
	<cfparam name="form.Primary" default="0">

<cfif 	#form.WorkPhone_Area# EQ "" OR 
	  	#form.WorkPhone_Area# EQ "N/A" OR
		#form.WorkPhone_Prefix# EQ "" OR
		#form.WorkPhone_Prefix# EQ "N/A" OR
		#form.WorkPhone_Num# EQ "" OR
		#form.WorkPhone_Num# EQ "N/A"
>
		<cfset FinalWorkNumber="">

<cfelse>
		<cfset FinalWorkNumber='#form.WorkPhone_Area#-#form.WorkPhone_Prefix#-#form.WorkPhone_Num#'> 
</cfif>


<cfif 	#form.MobilePhone_Area# EQ "" OR 
	  	#form.MobilePhone_Area# EQ "N/A" OR
		#form.MobilePhone_Prefix# EQ "" OR
		#form.MobilePhone_Prefix# EQ "N/A" OR
		#form.MobilePhone_Num# EQ "" OR
		#form.MobilePhone_Num# EQ "N/A"
>
		<cfset FinalMobilePhone="">

<cfelse>
		<cfset FinalMobilePhone='#form.MobilePhone_Area#-#form.MobilePhone_Prefix#-#form.MobilePhone_Num#'> 
</cfif>


<cfif 	#form.FaxNumber_Area# EQ "" OR 
	  	#form.FaxNumber_Area# EQ "N/A" OR
		#form.FaxNumber_Prefix# EQ "" OR
		#form.FaxNumber_Prefix# EQ "N/A" OR
		#form.FaxNumber_Num# EQ "" OR
		#form.FaxNumber_Num# EQ "N/A"
>
		<cfset FinalFaxNumber="">

<cfelse>
		<cfset FinalFaxNumber='#form.FaxNumber_Area#-#form.FaxNumber_Prefix#-#form.FaxNumber_Num#'> 
</cfif>
<!--- <cfoutput>#form.storedate#</cfoutput> --->

<cfquery datasource="#ProgramsDB#">
Insert Into dContacts
				(Prefix, FirstName, Middle, LastName, NameSuffix, Title, Primary, WorkPhone, WorkExtension, MobilePhone, FaxNumber, EmailName, Address, City, State, Zip, OrgID)
		Values	('#form.Prefix#', 
				'#form.FirstName#', 
				'#form.Middle#', 
				'#form.LastName#', 
				'#form.NameSuffix#', 
				'#form.Title#', 
				'#form.Primary#', 
				'#finalWorkNumber#', 				
				'#form.WorkExtension#', 
				'#FinalMobilePhone#', 				
			 	'#finalFaxNumber#', 				
				'#form.EmailName#', 
				'#form.Address#', 
				'#form.City#', 
				'#form.State#', 
				'#form.Zip#', 
				#URL.OrgID#)
</cfquery>