
<cfcomponent displayname="Get_Perspective_user"   hint="ColdFusion Component for  Perspective user functionality">
<!---<cfinclude template='/__Security-Block.cfm' /> --->       					


<cffunction name="Perspective_User_validation"  access="remote" output="Yes" returnFormat= "JSON"> 	
								   
	<cfif arguments.Contact_Email  neq ''>	
		
		<cfif arguments.ID  eq '' or arguments.ID eq 0>
			<cfquery name="Get_User_details" datasource="#Application.DataSrc#">
				SELECT * FROM #Request.prefix_db_lookup#.Perspective_Client 
				WHERE 
					User_Contact_Email=<cfqueryparam value = "#arguments.Contact_Email#" CFSQLType ="CF_SQL_VARCHAR">	
			</cfquery>			
			<cfif Get_User_details.RecordCount> 
				<cfset Return_statement="Email_Exist" />
				<cfreturn Return_statement />		
			<cfelse>
				<cfset Return_statement="Email_Not_Exist" />
				<cfreturn Return_statement />
			</cfif>			
		<cfelse>
			<cfquery name="Get_User_details_edit" datasource="#Application.DataSrc#">
				SELECT * FROM #Request.prefix_db_lookup#.Perspective_Client 
				WHERE 
					User_Contact_Email=<cfqueryparam value = "#arguments.Contact_Email#" CFSQLType ="CF_SQL_VARCHAR">	
					AND ID <> <cfqueryparam value="#arguments.ID#" cfsqltype="CF_SQL_INTEGER">
			</cfquery>			
			<cfif Get_User_details_edit.RecordCount> 
				<cfset Return_statement="Email_Exist" />
				<cfreturn Return_statement />		
			<cfelse>
				<cfset Return_statement="Email_Not_Exist" />
				<cfreturn Return_statement />
			</cfif>		
		</cfif>
		
	</cfif>	
</cffunction>




<cffunction name="Perspective_User_phone_validation"  access="remote" output="Yes" returnFormat= "JSON"> 	
						  
	<cfif arguments.Contact_phone  neq ''>		
		
		<cfif arguments.ID  eq '' or arguments.ID eq 0>	
			<cfquery name="Get_User_phone_nos" datasource="#Application.DataSrc#">
				SELECT * FROM #Request.prefix_db_lookup#.Perspective_Client 
				WHERE 
					User_Contact_Phone=<cfqueryparam value = "#arguments.Contact_phone#" CFSQLType ="CF_SQL_VARCHAR">	
			</cfquery>			
			<cfif Get_User_phone_nos.RecordCount> 
				<cfset Return_statement="Phoneno_Exist" />					
			<cfelse>
				<cfset Return_statement="Phoneno_Not_Exist" />			
			</cfif>	
			<cfreturn Return_statement />
		<cfelse>		
			<cfquery name="Get_User_phone_no_edit" datasource="#Application.DataSrc#">
				SELECT * FROM #Request.prefix_db_lookup#.Perspective_Client 
				WHERE 
					User_Contact_Phone=<cfqueryparam value = "#arguments.Contact_phone#" CFSQLType ="CF_SQL_VARCHAR"> 
					AND ID <> <cfqueryparam value="#arguments.ID#" cfsqltype="CF_SQL_INTEGER">
			</cfquery>
			<cfif Get_User_phone_no_edit.RecordCount> 
				<cfset Return_statement="Phoneno_Exist" />					
			<cfelse>
				<cfset Return_statement="Phoneno_Not_Exist" />			
			</cfif>	
			<cfreturn Return_statement />
		</cfif>
		
	</cfif>	
</cffunction>





	
</cfcomponent>