<%
sql="select * from acquisti where id_session = '"&session.SessionID&"' "
set objdbconnection=server.createobject("ADODB.connect ion")
objdbconnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("..\database\db.mdb")
set rs=objdbconnection.execute(sql)
BODY=BODY&"<font color='black' style='font-weight:bold' face='Arial' size='2'>Hai effettuato un ordine dal sito
www.dominio.it
Di seguito ti elenchiamo i prodotti da te acquistati: </font>
"
BODY=BODY&"<table style='font-family:arial; font-size:11px'>"
BODY=BODY&"<tr align=center bgcolor=fec206 width=500>"
BODY=BODY&"<td>
PRODOTTO</td>"
BODY=BODY&"<td>
CODICE</td>"
BODY=BODY&"<td>
QUANTITA</td>"
BODY=BODY&"<td>
PREZZO</td>"
BODY=BODY&"</tr>"
rs.movefirst
do while not rs.eof
tot=rs("prezzo")*rs("quantita")
BODY=BODY&"<tr align=center>"
BODY=BODY&"<td>"&rs("nome")&"</td>"
BODY=BODY&"<td>"&rs("codice")&"</td>"
BODY=BODY&"<td>"&rs("quantita")&"</td>"
BODY=BODY&"<td>"&replace(tot,".",",")&"€</td>"
BODY=BODY&"</tr>"
totale=totale+tot
rs.movenext
loop
rs.close
objdbconnection.close
nome=request.form("nome")
cognome=request.form("cognome")
indirizzo=request.form("indirizzo")
comune=request.form("comune")
provincia=request.form("provincia")
cap=request.form("cap")
telefono=request.form("telefono")
fax=request.form("fax")
email=request.form("email")
set db_connection=server.createobject("ADODB.connectio n")
db_connection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("..\database\db.mdb")
dim objrecordset
set objrecordset=server.createobject("ADODB.recordset" )
objrecordset.open "clienti",db_connection,adOpenKeyset,adLockPessimi stic,adCmdTable
objrecordset.addnew
objrecordset.fields("nome")=nome
objrecordset.fields("cognome")=cognome
objrecordset.fields("indirizzo")=indirizzo
objrecordset.fields("comune")=comune
objrecordset.fields("provincia")=provincia
objrecordset.fields("cap")=cap
objrecordset.fields("telefono")=telefono
objrecordset.fields("fax")=fax
objrecordset.fields("email")=email
objrecordset.update
objrecordset.close
set objrecordset=nothing
' CDONTS Email
Set Mail = Server.CreateObject("CDONTS.NewMail")
BODY=BODY&"</table>
"
BODY=BODY&"<font color='black' style='font-weight:bold' face='Arial' size='2'>Di seguito ti elenchiamo i dati personali da te inseriti: </font>
"
BODY=BODY&"<font color='black' style='font-weight:bold' face='Arial' size='2'>Nome: </font><font color='black' face='Arial' size='2'>"&nome&"</font>
"
BODY=BODY&"<font color='black' style='font-weight:bold' face='Arial' size='2'>Cognome: </font><font color='black' face='Arial' size='2'>"&cognome&"</font>
"
BODY=BODY&"<font color='black' style='font-weight:bold' face='Arial' size='2'>Indirizzo: </font><font color='black' face='Arial' size='2'>"&indirizzo&"</font>
"
BODY=BODY&"<font color='black' style='font-weight:bold' face='Arial' size='2'>Città: </font><font color='black' face='Arial' size='2'>"&comune&"</font>
"
BODY=BODY&"<font color='black' style='font-weight:bold' face='Arial' size='2'>Provincia: </font><font color='black' face='Arial' size='2'>"&provincia&"</font>
"
BODY=BODY&"<font color='black' style='font-weight:bold' face='Arial' size='2'>Cap: </font><font color='black' face='Arial' size='2'>"&cap&"</font>
"
BODY=BODY&"<font color='black' style='font-weight:bold' face='Arial' size='2'>Telefono: </font><font color='black' face='Arial' size='2'>"&telefono&"</font>
"
BODY=BODY&"<font color='black' style='font-weight:bold' face='Arial' size='2'>Email: </font><font color='black' face='Arial' size='2'>"&email&"</font>
"
BODY=BODY&"<font color='black' style='font-weight:bold' face='Arial' size='2'>Riceverete una telefonata da un ns operatore per conferma ordine.
"
BODY=BODY&"<font color='black' face='Arial' size='2'>Questi sono i prodotti da te acquistati pe un costo iva compresa di: <font color=red>
"&totale+spese_spedizione&" Eur</font>
(spese di spedizione non incluse)</font>
"
BODY=BODY&"<font color='red' style='font-weight:bold' face='Arial' size='2'>Ditta
</font>
"
BODY=BODY&"<font color='red' style='font-weight:bold' face='Arial' size='2'>Banca Sella
</font>
"
BODY=BODY&"<font color='red' style='font-weight:bold' face='Arial' size='2'>ABI: 333333
</font>
"
BODY=BODY&"<font color='red' style='font-weight:bold' face='Arial' size='2'>CCAB: 333333
</font>
"
BODY=BODY&"<font color='red' style='font-weight:bold' face='Arial' size='2'>N.C. 333333
</font>
"
BODY=BODY&"<font color='red' style='font-weight:bold' face='Arial' size='2'>CIN:
</font>
"
BODY=BODY&"<font color='red' style='font-weight:bold' face='Arial' size='2'>Inviare la distinta a 1/2 fax al numero 333333 </font>
"
BODY=BODY&"<font color='black' style='font-weight:bold' face='Arial' size='2'>Vi auguriamo buon lavoro.</font>"
If Request("invia") <> "" Then
Set Mail = Server.CreateObject("Persits.MailSender")
Mail.Host = "mail.dominio.it"
Mail.From = "info@dominio.it"
Mail.FromName = "dominio.it"
Mail.AddAddress Request("email")
Mail.Subject = "Nuovo acquisto da
www.dominio.it"
Mail.BODY = BODY
Mail.IsHTML = True
strErr = ""
bSuccess = False
'On Error Resume Next ' catch errors
Mail.Send ' send message
If Err <> 0 Then ' error occurred
strErr = Err.Description
else
bSuccess = True
End If
End If
%>