Return to act_addUser.cfm CVS log

Up to [Development] / p2rx-programs

*** empty log message ***

<!--- 	Name:  act_addUser.cfm
    	Purpose: This functions as the action file to insert the information of the Initial user who is responsible for entering the 
				organization information accessing the Programadmin forms. Each time this page is called,the OutsideUsers table is 
				updated in the edit mode, else the new user is just added as a new record in the OutsideUsers table in the program database.
				from the dOrgToService table using a query .Fresh records are then inserted for each of the services that the user had 
				selected in the dsp_addservices or dsp_editservices	form. The new "Other" services are also inserted in the dservice 
				table and dorgtoservice table.
		Date created: 02/23/2005
       	Dependancy: URL.URL.Vid - visitor Id - used only in the editing of the initial user.
		Variables: 	
					
		Functions: 
		Date changed: 
					02/24/2005			Prabin & Neena  Created & Documentation
---> 		

<cfset Phone_Number='#form.Phone_Area#-#form.Phone_Prefix#-#form.Phone_Num#'> 

<cfparam name="action" default=""> 
<cfset currdate=DateFormat(Now(),"mm/dd/yyy hh:mm:ss")> 
<cfset userdate = currdate>

<cfif #URL.fuseaction# IS "GetOrganizations">
<cfquery name="UpdateOutsideUser" datasource="#programsdb#">
Update Outsideusers
		Set fname = '#form.fname#',
		    lname = '#form.lname#',
			Phone_Number = '#Phone_Number#', 
			Email ='#form.Email#',
			Orgid = #URL.orgid#,
			Vtime = '#currdate#'
			where visitor_Id = #URL.vid# 
</cfquery>

<cfelse>

<cfquery name="AddOutsideUser" datasource="#programsdb#">
Insert Into Outsideusers
				(fname, lname, Phone_Number, Email, vtime)
		Values	('#form.fname#', 
				 '#form.lname#', 
				 '#Phone_Number#', 
				 '#form.Email#',
				 '#currdate#')
</cfquery>

</cfif>

<cfoutput> <input type="hidden" name="userdate" value="#userdate#"> </cfoutput>