<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001" LCID=1040 %>
<!--#INCLUDE FILE="ajax\check.asp"-->
<!--#INCLUDE FILE="ajax\funzioni.asp"-->


<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
Dim dbConn 
dbConn = "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = OZ; User Id = sa; Password=roma"
conn.Open dbConn
%>


<% 
If Request("hValore") = "1" Then
   
   Set rsZ = Server.CreateObject("ADODB.Recordset")
   rsZ.CursorLocation = 3
   rsZ.Open "select * from utente where utente_nome='"  & Session("utente_nome") & "'", conn, 1, 2
   
   '--- sezione campi
   rsZ("nome") = zNoStr (request("modal_nome"))
   rsZ("cognome") = zNoStr (request("modal_cognome"))
   rsZ("nazionalita") = zNoStr(request("modal_nazionalita"))
   rsZ("telefono") = zNoStr(request("modal_telefono"))
   rsZ("eta") = zNoStr(request("modal_eta"))
   rsZ("id_professione") = zNoStr(request("modal_professione"))
   '---
   
   rsZ.Update
   rsZ.Close
	
End If
%>




<%
on error resume next
Set rs= conn.Execute("select * from UTENTE where utente_nome='"  & Session("utente_nome") & "'")

if rs.eof=false then 
	x_NOME = rs("nome")
	x_COGNOME=rs("COGNOME")
	x_TELEFONO = rs("telefono")
	
	x_ETA = rs("eta")
	x_ID_PROFESSIONE = rs("id_professione")
end if

%>
<!DOCTYPE html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 
    <!-- Bootstrap Icons-->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.5.0/font/bootstrap-icons.css" rel="stylesheet" />
    <!-- Google fonts-->
    <link href="https://fonts.googleapis.com/css?family=Raleway" rel="stylesheet" />
    <link href="https://fonts.googleapis.com/css?family=Raleway:400,300,300italic,400italic,700,700italic,900,900italic" rel="stylesheet" type="text/css">
    <!-- SimpleLightbox plugin CSS-->
    <link href="https://cdnjs.cloudflare.com/ajax/libs/SimpleLightbox/2.1.0/simpleLightbox.min.css" rel="stylesheet" />
    <!-- Core theme CSS (includes Bootstrap)-->
    <link href="css/styles.css" rel="stylesheet" />
</head>
<body>
<div>

<form id="frm_Anagrafica" name="frm_Anagrafica" method="post">

<div class="form-group row" style="margin:0;text-align:justify">
    <label for="inputEmail3" class="col-sm-4 col-form-label"><b>Utente</b></label>
    <div class="col-sm-8">
      <input type="text" class="form-control" name="modal_utente_nome_anagrafica" id="modal_utente_nome_anagrafica" value="<%=Session("utente_nome")%>" readonly disabled>
    </div>
  </div>
  <br />
  <div class="form-group row" style="margin:0;text-align:justify">
    <label class="col-sm-4 col-form-label"><b>Nome</b></label>
    <div class="col-sm-8">
      <input type="text" class="form-control" id="modal_nome" name="modal_nome" maxlength="255" value="<%=x_NOME%>" required>
    </div>
  </div>
    <br />
  <div class="form-group row" style="margin:0;text-align:justify">
    <label class="col-sm-4 col-form-label"><b>Cognome</b></label>
    <div class="col-sm-8">
      <input type="text" class="form-control" id="modal_cognome" name="modal_cognome" value="<%=x_COGNOME%>" maxlength="255" required>
    </div>
  </div>
  <br />
  <div class="form-group row" style="margin:0;text-align:justify">
    <label class="col-sm-4 col-form-label"><b>Nazionalit&agrave;</b></label>
    <div class="col-sm-8">
					<select id="modal_nazionalita" name="modal_nazionalita" class="form-select" style="text-transform:capitalize;" required>
							<option value=""></option>
							<option value="afghanistan">afghanistan</option>
							<option value="albania">albania</option>
							<option value="algeria">algeria</option>
							<option value="andorra">andorra</option>
							<option value="angola">angola</option>
							<option value="antarctica">antartico</option>
							<option value="antigua and barbuda">antigua e barbuda</option>
							<option value="saudi arabia">arabia saudita</option>
							<option value="argentina">argentina</option>
							<option value="armenia">armenia</option>
							<option value="australia">australia</option>
							<option value="australia christmas island">australia - isola christmas</option>
							<option value="australia norfolk island">australia - isola norfolk</option>
							<option value="australia cocos keeling islands">australia - isole cocos</option>
							<option value="heard and mc donald islands">australia - isole heard e mcdonald</option>
							<option value="austria">austria</option>
							<option value="azerbaijan">azerbaijan</option>
							<option value="bahamas">bahamas</option>
							<option value="bahrain">bahrain</option>
							<option value="bangladesh">bangladesh</option>
							<option value="barbados">barbados</option>
							<option value="belgium">belgio</option>
							<option value="belize">belize</option>
							<option value="benin">benin</option>
							<option value="bhutan">bhutan</option>
							<option value="belarus">bielorussia</option>
							<option value="bolivia">bolivia</option>
							<option value="bosnia herzegovina">bosnia erzegovina</option>
							<option value="botswana">botswana</option>
							<option value="brazil">brasile</option>
							<option value="brunei">brunei</option>
							<option value="bulgaria">bulgaria</option>
							<option value="burkina faso">burkina faso</option>
							<option value="burundi">burundi</option>
							<option value="cambodia">cambogia</option>
							<option value="cameroon">camerun</option>
							<option value="canada">canada</option>
							<option value="cape verde">capo verde</option>
							<option value="chad">ciad</option>
							<option value="chile">cile</option>
							<option value="china">cina</option>
							<option value="china hong kong">cina - hong kong</option>
							<option value="china macau">cina - macao</option>
							<option value="cyprus">cipro</option>
							<option value="holy see">citta' del vaticano</option>
							<option value="colombia">colombia</option>
							<option value="comoros">comore</option>
							<option value="north korea">corea del nord</option>
							<option value="south korea">corea del sud</option>
							<option value="cote divoire">costa d'avorio</option>
							<option value="costa rica">costa rica</option>
							<option value="croatia">croazia</option>
							<option value="cuba">cuba</option>
							<option value="denmark">danimarca</option>
							<option value="denmark faroe islands">danimarca - isole faroe</option>
							<option value="dominica">dominica</option>
							<option value="ecuador">ecuador</option>
							<option value="egypt">egitto</option>
							<option value="el salvador">el salvador</option>
							<option value="united arab emirates">emirati arabi uniti</option>
							<option value="eritrea">eritrea</option>
							<option value="estonia">estonia</option>
							<option value="ethiopia">etiopia</option>
							<option value="fiji">figi</option>
							<option value="philippines">filippine</option>
							<option value="finland">finlandia</option>
							<option value="finland aland islands">finlandia - isole aland</option>
							<option value="france">francia</option>
							<option value="france guadeloupe">francia - guadalupa</option>
							<option value="france french guiana">francia - guyana francese</option>
							<option value="france martinique">francia - martinica</option>
							<option value="france mayotte">francia - mayotte</option>
							<option value="france new caledonia">francia - nuova caledonia</option>
							<option value="france french polynesia">francia - polinesia francese</option>
							<option value="france reunion">francia - reunion</option>
							<option value="france saint pierre and miquelon">francia - saint pierre e miquelon</option>
							<option value="france french southern territories">francia - territori francesi meridionali</option>
							<option value="france wallis and futuna islands">francia - wallis e futuna</option>
							<option value="gabon">gabon</option>
							<option value="gambia">gambia</option>
							<option value="georgia">georgia</option>
							<option value="germany">germania</option>
							<option value="ghana">ghana</option>
							<option value="jamaica">giamaica</option>
							<option value="japan">giappone</option>
							<option value="djibouti">gibuti</option>
							<option value="jordan">giordania</option>
							<option value="greece">grecia</option>
							<option value="grenada">grenada</option>
							<option value="greenland">groenlandia</option>
							<option value="guatemala">guatemala</option>
							<option value="guinea">guinea</option>
							<option value="equatorial guinea">guinea equatoriale</option>
							<option value="guinea bissau">guinea-bissau</option>
							<option value="guyana">guyana</option>
							<option value="haiti">haiti</option>
							<option value="honduras">honduras</option>
							<option value="india">india</option>
							<option value="indonesia">indonesia</option>
							<option value="iran">iran</option>
							<option value="iraq">iraq</option>
							<option value="ireland">irlanda</option>
							<option value="iceland">islanda</option>
							<option value="marshall islands">isole marshall</option>
							<option value="solomon islands">isole salomone</option>
							<option value="israel">israele</option>
							<option value="italy">italia</option>
							<option value="kazakhstan">kazakistan</option>
							<option value="kenya">kenya</option>
							<option value="kyrgyzstan">kirghizistan</option>
							<option value="kiribati">kiribati</option>
							<option value="kuwait">kuwait</option>
							<option value="laos">laos</option>
							<option value="lesotho">lesotho</option>
							<option value="latvia">lettonia</option>
							<option value="lebanon">libano</option>
							<option value="liberia">liberia</option>
							<option value="libya">libia</option>
							<option value="liechtenstein">liechtenstein</option>
							<option value="lithuania">lituania</option>
							<option value="luxembourg">lussemburgo</option>
							<option value="macedonia">macedonia</option>
							<option value="madagascar">madagascar</option>
							<option value="malawi">malawi</option>
							<option value="maldives">maldive</option>
							<option value="malaysia">malesia</option>
							<option value="mali">mali</option>
							<option value="malta">malta</option>
							<option value="morocco">marocco</option>
							<option value="mauritania">mauritania</option>
							<option value="mauritius">mauritius</option>
							<option value="mexico">messico</option>
							<option value="micronesia">micronesia</option>
							<option value="moldova">moldavia</option>
							<option value="mongolia">mongolia</option>
							<option value="montenegro">montenegro</option>
							<option value="mozambique">mozambico</option>
							<option value="myanmar">myanmar</option>
							<option value="namibia">namibia</option>
							<option value="nauru">nauru</option>
							<option value="nepal">nepal</option>
							<option value="nicaragua">nicaragua</option>
							<option value="niger">niger</option>
							<option value="nigeria">nigeria</option>
							<option value="norway">norvegia</option>
							<option value="norway bouvet island">norvegia - isola bouvet</option>
							<option value="norway svalbard and jan mayen islands">norvegia - svalbard</option>
							<option value="new zealand">nuova zelanda</option>
							<option value="new zealand cook islands">nuova zelanda - isole cook</option>
							<option value="new zealand niue">nuova zelanda - niue</option>
							<option value="new zealand tokelau">nuova zelanda - tokelau</option>
							<option value="holland">olanda</option>
							<option value="oman">oman</option>
							<option value="netherlands">paesi bassi</option>
							<option value="netherlands netherlands antilles">paesi bassi - antille olandesi</option>
							<option value="netherlands aruba">paesi bassi - aruba</option>
							<option value="pakistan">pakistan</option>
							<option value="palau">palau</option>
							<option value="palestine">palestina</option>
							<option value="panama">panama</option>
							<option value="papua new guinea">papua nuova guinea</option>
							<option value="paraguay">paraguay</option>
							<option value="peru">peru'</option>
							<option value="poland">polonia</option>
							<option value="puerto rico">porto rico</option>
							<option value="portugal">portogallo</option>
							<option value="principality of monaco">principato di monaco</option>
							<option value="qatar">qatar</option>
							<option value="united kingdom">regno unito</option>
							<option value="united kingdom anguilla">regno unito - anguilla</option>
							<option value="united kingdom bermuda">regno unito - bermuda</option>
							<option value="united kingdom gibraltar">regno unito - gibilterra</option>
							<option value="united kingdom guernsey">regno unito - guernsey</option>
							<option value="united kingdom isle of man">regno unito - isola di man</option>
							<option value="united kingdom cayman islands">regno unito - isole cayman</option>
							<option value="united kingdom falkland islands">regno unito - isole falkland</option>
							<option value="united kingdom pitcairn">regno unito - isole pitcairn</option>
							<option value="united kingdom south sandwich islands">regno unito - isole sandwich meridionali</option>
							<option value="united kingdom turks and caicos islands">regno unito - isole turks e caicos</option>
							<option value="united kingdom british virgin islands">regno unito - isole vergini britanniche</option>
							<option value="united kingdom jersey">regno unito - jersey</option>
							<option value="united kingdom monttserrat">regno unito - montserrat</option>
							<option value="united kingdom saint helena">regno unito - sant'elena</option>
							<option value="united kingdom british indian ocean territory">regno unito - terr. britannico dell'oceano indiano</option>
							<option value="czech republic">repubblica ceca</option>
							<option value="central african republic">repubblica centrafricana</option>
							<option value="republic of the congo">repubblica del congo</option>
							<option value="democratic republic of the congo">repubblica democratica del congo (ex zaire)</option>
							<option value="republic of san marino">repubblica di san marino</option>
							<option value="dominican republic">repubblica dominicana</option>
							<option value="romania">romania</option>
							<option value="rwanda">ruanda</option>
							<option value="russia">russia</option>
							<option value="western sahara">sahara occidentale</option>
							<option value="saint vincent and the grenadines">saint vincent e grenadines</option>
							<option value="samoa">samoa</option>
							<option value="saint kitts and nevis">san kitts e nevis</option>
							<option value="saint lucia">santa lucia</option>
							<option value="sao tome and principe">sao tome e principe</option>
							<option value="senegal">senegal</option>
							<option value="serbia">serbia</option>
							<option value="seyschelles">seychelles</option>
							<option value="sierra leone">sierra leone</option>
							<option value="singapore">singapore</option>
							<option value="syria">siria</option>
							<option value="slovakia">slovacchia</option>
							<option value="slovenia">slovenia</option>
							<option value="somalia">somalia</option>
							<option value="spain">spagna</option>
							<option value="sri lanka">sri lanka</option>
							<option value="united states of america">stati uniti d'america</option>
							<option value="united states of america guam">stati uniti d'america - guam</option>
							<option value="united states of america northern mariana islands">stati uniti d'america - isole marianne settentrionali</option>
							<option value="united states of america minor outlyng islands">stati uniti d'america - isole periferiche secondarie</option>
							<option value="united states of america virgin islands">stati uniti d'america - isole vergini statunitensi</option>
							<option value="united states of america american samoa">stati uniti d'america - samoa americane</option>
							<option value="south africa">sud africa</option>
							<option value="sudan">sudan</option>
							<option value="suriname">suriname</option>
							<option value="sweden">svezia</option>
							<option value="switzerland">svizzera</option>
							<option value="swaziland">swaziland</option>
							<option value="tajikistan">tagikistan</option>
							<option value="thailand">tailandia</option>
							<option value="taiwan">taiwan</option>
							<option value="tanzania">tanzania</option>
							<option value="east timor">timor dell'est</option>
							<option value="togo">togo</option>
							<option value="tonga">tonga</option>
							<option value="trinidad and tobago">trinidad e tobago</option>
							<option value="tunisia">tunisia</option>
							<option value="turkey">turchia</option>
							<option value="turkmenistan">turkmenistan</option>
							<option value="tuvalu">tuvalu</option>
							<option value="ukraine">ucraina</option>
							<option value="uganda">uganda</option>
							<option value="hungary">ungheria</option>
							<option value="uruguay">uruguay</option>
							<option value="uzbekistan">uzbekistan</option>
							<option value="vanuatu">vanuatu</option>
							<option value="venezuela">venezuela</option>
							<option value="vietnam">vietnam</option>
							<option value="yemen">yemen</option>
							<option value="zambia">zambia</option>
							<option value="zimbabwe">zimbabwe</option>
							</select>

	
	
      
    </div>
  </div>
  <br />
  <div class="form-group row" style="margin:0;text-align:justify">
    <label class="col-sm-4 col-form-label"><b>Telefono mobile</b></label>
    <div class="col-sm-8">
      <input type="text" class="form-control" id="modal_telefono" name="modal_telefono" maxlength="255" value="<%=x_TELEFONO%>" required>
    </div>
  </div>
  <br />
   <div class="form-group row" style="margin:0;text-align:justify">
    <label class="col-sm-4 col-form-label"><b>Et&agrave;</b></label>
    <div class="col-sm-8" style="width:auto;">
		<select class="form-select" id="modal_eta" name="modal_eta" required >
			<option value=""></option>
			<% for j=18 to 99%>
			<option  <% If j=x_ETA then response.write " selected " End If %>  value="<%=j%>"><%=j%></option>
			<% next %>
		</select>
    </div>
  </div>
  <br />
   <div class="form-group row" style="margin:0;text-align:justify">
    <label class="col-sm-4 col-form-label"><b>Professione</b></label>
    <div class="col-sm-8">
		
     <select class="form-select" id="modal_professione" name="modal_professione" required >
			<option value=""></option>
			<% 
				Set rProf =  conn.Execute("select * from PROFESSIONE order by descrizione") 
				do while not rProf.eof 
			%>
					<option  <% If rProf("id_professione")=x_ID_PROFESSIONE then response.write " selected " End If %> value="<%=rProf("id_professione")%>"><%=rProf("descrizione")%></option>
			<%
				rProf.moveNext
				loop 
			%>
		</select>
    </div>
  </div>
  <br />
  <input type="hidden" value="<%=Session("utente_nome")%>" name="h_utente_nome" id="h_utente_nome">
  <input type="hidden" value="1" name="hValore" id="hValore">
</form>
</div>
  <!-- JQuery -->
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
  
  
 <script src="js/funzioni.js"></script>
 <script type="text/javascript">
  
    $(function () {
	
		$("#t_areaQ1aC").trigger( "keyup" );
		$("#t_areaQ3aC").trigger( "keyup" );
		$("#t_areaQ4aC").trigger( "keyup" );
	
	
			
	});
  </script>
</body>
<%
rs.close
set rs=nothing

conn.close
set conn=Nothing
%>

</html>
