Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <cffunction name="ubaciNovoLice">
- <cfparam name= "form" default = "">
- <cfset var result = StructNew()>
- <cfset result.success = 1>
- <cfset commitIt = "Yes">
- <cflock throwontimeout="No" timeout="10" type="EXCLUSIVE">
- <cftransaction action="BEGIN">
- <cftry>
- <cfstoredproc procedure="MNG_LICE" datasource="#dataSourceName#" username="#dataSourceUserName#" password="#dataSourcePassword#">
- <cfprocparam type="InOut" variable="stanje" value="0" cfsqltype="CF_SQL_INTEGER">
- <cfprocparam type="InOut" variable="vezano_lice_id" value="" null="Yes" cfsqltype="CF_SQL_INTEGER">
- <cfprocparam type="InOut" variable="lice_id" value="" null="Yes" cfsqltype="CF_SQL_INTEGER">
- <cfprocparam type="InOut" variable="validan" value="" null="Yes" cfsqltype="CF_SQL_INTEGER">
- <cfprocparam type="InOut" variable="prezime" value="#form.prezime#" maxlength="255" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="ime" value="#form.ime#" maxlength="255" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="prethodno_prezime" value="#form.prethodno_prezime#" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="rodjeno_prezime" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="ime_u_genitivu" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfif form.pol eq "">
- <cfprocparam type="InOut" variable="pol" value="" null="Yes" cfsqltype="CF_SQL_INTEGER">
- <cfelse>
- <cfprocparam type="InOut" variable="pol" value="#form.pol#" cfsqltype="CF_SQL_INTEGER">
- </cfif>
- <cfprocparam type="InOut" variable="jmbg" value="#form.jmbg#" maxlength="13" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="dat_rodj" value="#form.datepicker#" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="ime_oca" value="#form.ime_oca#" maxlength="255" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="ime_majke" value="#form.ime_majke#" maxlength="255" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="drzava_rodj" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="opstina_rodj" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="mesto_rodj" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="ulica_rodj" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="ulica_br_rodj" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="drzava" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="opstina" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="mesto" value="#form.mesto#" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="posta_br" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="mesna_zajednica" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="ulica" value="#form.adresa#" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="ulica_br" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="ulaz" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="sprat" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="stan" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="drzavljanstvo" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="narod_id" value="" null="Yes" cfsqltype="CF_SQL_INTEGER">
- <cfprocparam type="InOut" variable="vera_id" value="" null="Yes" cfsqltype="CF_SQL_INTEGER">
- <cfprocparam type="InOut" variable="verski_praznik_id" value="" null="Yes" cfsqltype="CF_SQL_INTEGER">
- <cfprocparam type="InOut" variable="biracki_status_id" value="" null="Yes" cfsqltype="CF_SQL_INTEGER">
- <cfprocparam type="InOut" variable="bracno_stanje_id" value="" null="Yes" cfsqltype="CF_SQL_INTEGER">
- <cfprocparam type="InOut" variable="broj_licne_karte" value="#form.broj_licne_karte#" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="licni_broj_osiguranika" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="krvna_grupa" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="vojni_rok" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="sup_id" value="" null="Yes" cfsqltype="CF_SQL_INTEGER">
- <cfprocparam type="InOut" variable="telefon_kucni" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="telefon_mobilni" value="" cfsqltype="CF_SQL_VARCHAR">
- <cfprocparam type="InOut" variable="aplikacija_id" value="" null="Yes" cfsqltype="CF_SQL_INTEGER">
- <cfprocresult name="result.RECORDSET">
- </cfstoredproc>
- <cfcatch type="DATABASE">
- <cftransaction action="ROLLBACK"/>
- <cfset commitIt = "No">
- <cfset result.success = 0>
- </cfcatch>
- </cftry>
- </cftransaction>
- </cflock>
- <cfreturn result>
- </cffunction>
Add Comment
Please, Sign In to add comment