<cfset filepath = "/var/www/datafiles/Employee_images/" />
<cfif Application.DEV>
	<cfset filepath = "/var/www/datafiles/Employee_images/" />
</cfif>

<cfif isdefined('Form.ufFile') and Form.ufFile neq ''>
<cfparam name="cffile.serverFile" default="" />
	<cffile action="upload" filefield="Form.ufFile" destination="#filepath##form.empID#.jpg" nameconflict="MakeUnique"  >
	<cffile action="readbinary" variable="fileContent" file="#filepath##File.ServerFile#">
	<cfif File.FileSize gt 40600>	
		<cfset Form.ufFile="" />
		<script language='javascript' type='text/javascript'>
			alert('File size exceeds 40kb');
			window.location.href ="/agencyadmin/index.cfm?page=agency&cat=AgencyManagement&rpt=employee_user&eid=<cfoutput>#form.empID#</cfoutput>";
		</script>
	<cfelse>
	        <cfquery name='getfile_name' datasource='#Application.DataSrc#'>
			SELECT * from #Request.prefix_db_lookup#.Employee_Images where  EmployeeId = '#form.empID#'
			</cfquery>
			
			<cfif getfile_name.Recordcount gt 0>
			 <cfquery name='deletefile' datasource='#Application.DataSrc#'>
			DELETE from #Request.prefix_db_lookup#.Employee_Images where  EmployeeId = '#form.empID#'
			</cfquery>
			<cffile action="delete" file="#filepath##getfile_name.FileName#">
			</cfif>
			
		<cfquery name='uFile' datasource='#Application.DataSrc#'>
			INSERT INTO #Request.prefix_db_lookup#.Employee_Images (
			AgencyId, EmployeeId, Title, FileName, FileType, File, CreatedBy
			) VALUES (
			'#session.AgencyId#'
			,'#form.empID#'
			,'Employee_image'
			,'#File.ServerFile#'
			,'#File.ContentType#/#File.ContentSubType#'
			,<cfqueryparam value="#fileContent#" cfsqltype="cf_sql_blob"/>
			,'#session.AgencyId#'
			)
		</cfquery>
	</cfif>	
	</cfif>


<cflocation url="index.cfm?page=agency&cat=AgencyManagement&rpt=user_profile" addtoken="no">

