<!--#include file="funcoes.asp"-->

<html>

<head>
<meta http-equiv="Content-Language" content="pt-br">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>CLIENTE BOM DE SORTE</title>
</head>

<%
  Set Database = Server.CreateObject("ADODB.Connection")
  Database.Open session("stringconexaobomdesorte")

wCPF=request.item("CPF")

Set rsConsulta = DataBase.Execute("SELECT * FROM CLIENTES WHERE CPF = " & wCPF )       
  
if rsConsulta.Eof then
   
wCliente=request.item("OutroTicket")
  if wCliente = "" then
      wCliente=Numera("CBS")              
      wNOME=request.item("Nome")               
      wENDERECO=Request.item("Endereco")
      wNUMERO=Request.item("Numero")
      wBAIRRO=request.item("Bairro")
      wCIDADE=request.item("Cidade")
      wESTADO=request.item("Estado")
      wE_MAIL=request.item("E_Mail") 
      wDT_NASCIMENTO=Year(request.item("DATANASCIMENTO")) & "-" & Month(request.item("DATANASCIMENTO")) & "-" & Day(request.item("DATANASCIMENTO"))
      wCEP=request.item("CEP") 
      wTELEFONE=request.item("TELEFONE")
      wSENHA=request.item("SENHA")   
      w_dt_hoje= Day(now()) & "." & Month(now()) & "." & Year(Now())
      wSorteio=request.item("Sorteio")   

      SQL="INSERT INTO CLIENTES(CLIENTE, NOME, CPF, ENDERECO, NUMERO, BAIRRO, CIDADE, ESTADO, E_MAIL, DT_NASCIMENTO, CEP, TELEFONE, SENHA, DT_CADASTRO) values (" & wCliente & ",UPPER('" & wNOME & "'),'" & wCPF & "','" & wENDERECO & "','" & wNUMERO & "','" & wBAIRRO & "','" & wCIDADE & "','" & wESTADO & "','" & wE_MAIL & "','" & wDT_NASCIMENTO & "','" & wCEP & "','" & wTELEFONE & "','" & wSENHA & "','" & w_dt_hoje & "')"
      Set rsCadastro = DataBase.Execute( SQL ) 
   end if       
   
   Set rsCadastro = DataBase.Execute("SELECT * FROM CLIENTES WHERE CLIENTE = " & wCliente )       
%> 


<body topmargin="0" leftmargin="0">

<table border="0" width="595" height="333" id="table1">
	<tr>
		
		<td width="591" valign="top">
		&nbsp;</td>
	</tr>
	
	<tr>
		<td width="591" valign="top">
		<p style="margin: 0"><font size="2" face="Arial"><b><i>CADASTRO
      EFETUADO COM SUCESSO</i></b></font></p>
		<p style="margin: 0"><img border="0" src="images/Barra_Horizontal.bmp"></p>
		<p style="margin: 0">&nbsp;</p>
		<table border="0" cellpadding="0" cellspacing="0" width="590" id="table2">
			<tr>
				<td width="67">
				<p align="left" style="margin: 0"><b>
				<font face="Arial" size="2">Nome</font></b></td>
            <center>
            	<td width="6">
				<p style="margin: 0"><b><font size="2" face="Arial">:</font></b></td>
				<td width="517" colspan="4">
				<font color="#000080" face="Arial" size="2"><b>
            </center>
            	<%=rsCadastro("Nome")%></b></font></td>
			</tr>
			<tr>
				<td width="67"><b><font face="Arial" size="2">CPF</font></b></td>
				<td width="6"><b><font size="2" face="Arial">:</font></b></td>
				<td width="517" colspan="4">
				<div align="left">
					<table border="0" cellpadding="0" cellspacing="0" width="515" id="table3">
						<tr>
							<td width="230"><b>
							<font face="Arial" size="2" color="#000080"><%=rsCadastro("CPF")%></font></b></td>
        </center>
                    		<td width="124">
							<p align="right"><b><font face="Arial" size="2">Dt. de 
                      Nascimento</font></b></p></td>
            <center>
                    		<td width="7"><b><font face="Arial" size="2">:</font></b></td>
							<td width="149"><b>
							<font face="Arial" size="2" color="#000080"><%=rsCadastro("Dt_Nascimento")%></font></b></td>
						</tr>
					</table></div></td>
			</tr>
			<tr>
				<td width="67"><b><font size="2" face="Arial">Endereço</font></b></td>
				<td width="6"><b><font size="2" face="Arial">:</font></b></td>
				<td width="233"><b><font size="2" face="Arial" color="#000080"><%=rsCadastro("Endereco")%></font></b></td>
				<td width="121">
				<p align="right"><b><font size="2" face="Arial">Nº</font></b></td>
				<td width="10"><b><font size="2" face="Arial">:</font></b></td>
				<td width="161"><b><font face="Arial" size="2" color="#000080"><%=rsCadastro("Numero")%></font></b></td>
			</tr>
			<tr>
				<td width="67"><b><font size="2" face="Arial">Bairro</font></b></td>
				<td width="6"><b><font size="2" face="Arial">:</font></b></td>
				<td width="517" colspan="4">
				<div align="left">
					<table border="0" cellpadding="0" cellspacing="0" width="516" id="table4">
						<tr>
							<td width="280"><b>
							<font size="2" face="Arial" color="#000080"><%=rsCadastro("Bairro")%></font></b></td>
							<td width="73">
							<p align="right"><b><font size="2" face="Arial">Cidade</font></b></td>
            <center>
            				<td width="10"><b><font size="2" face="Arial">:</font></b></td>
							<td width="153"><b>
							<font size="2" face="Arial" color="#000080"><%=rsCadastro("Cidade")%></font></b></td>
						</tr>
					</table></div><font color="#000080" face="Arial" size="2">
				<b>
                </center>
              	</b></font></td>
			</tr>
			<tr>
				<td width="67"><b><font size="2" face="Arial">Estado</font></b></td>
				<td width="6"><b><font size="2" face="Arial">:</font></b></td>
				<td width="517" colspan="4">
				<div align="left">
					<table border="0" cellpadding="0" cellspacing="0" width="515" id="table5">
						<tr>
							<td width="307"><b>
							<font size="2" face="Arial" color="#000080"><%=rsCadastro("Estado")%></font></b></td>
							<td width="44">
							<p align="right"><b><font size="2" face="Arial">Cep</font></b></td>
            <center>
            				<td width="9"><b><font size="2" face="Arial">:</font></b></td>
							<td width="153"><b>
							<font size="2" face="Arial" color="#000080"><%=rsCadastro("CEP")%></font></b></td>
						</tr>
					</table></div><font color="#000080" size="2" face="Arial">
				<b>
                </center>
              	</b></font></td>
			</tr>
			<tr>
				<td width="67"><b><font size="2" face="Arial">E-mail</font></b></td>
				<td width="6"><b><font size="2" face="Arial">:</font></b></td>
				<td width="233"><b><font size="2" face="Arial" color="#000080"><%=rsCadastro("e_mail")%></font></b></td>
				<td width="121">
				<p align="right"><b><font face="Arial" size="2">Telefone</font></b></td>
				<td width="10"><b><font size="2" face="Arial">:</font></b></td>
				<td width="161"><b><font size="2" face="Arial" color="#000080"><%=rsCadastro("Telefone")%></font></b></td>
			</tr>
             <tr>
				<td width="67">&nbsp;</td>
				<td width="6">&nbsp;</td>
				<td width="233">&nbsp;</td>
				<td width="121">
				&nbsp;</td>
				<td width="10">&nbsp;</td>
				<td width="161">&nbsp;</td>
			</tr>
			<tr>
				<td width="306" colspan="3" align="center">
				<p align="center">
				<font face="Arial" size="2">Anote sua 
				Senha para ter acesso a seus dados.</font></td>
				<td width="121">
				<p align="right"><b><font face="Arial" size="2" color="#000080">
				Senha</font></b></td>
				<td width="10"><b><font face="Arial" size="2" color="#000080">:</font></b></td>
				<td width="161"><b><font face="Arial" size="2" color="#FF0000">
				<%=rsCadastro("Senha")%></font></b></td>
			</tr>
			<tr>
				<td width="598" colspan="6" align="center">
				&nbsp;</td>
			</tr>
			<tr>
				<td width="598" colspan="6" align="center">
				<b><font face="Arial" size="2">
				<a href="clientes_cadastrados_detalhes.asp?Cliente=<%=wCliente%>">
				Ver meus Tickets Cadastrados</a></font></b></td>
			</tr>
            <% if (rsCadastro("DT_NASCIMENTO") > (Date() - (18*365))) or (rsCadastro("DT_NASCIMENTO") < (Date() - (85*365))) then %>
            <tr>
				<td width="598" colspan="6">
				<p align="justify"><b><font face="Arial" color="#FF0000">Conforme 
              condições gerais da Apólice do Seguro por Morte Acidental, seus 
              Tickets cadastrados não participará das Coberturas do Seguro, mas 
				você estará 
              concorrendo a 4 prêmios mensais.</font></b></td>
			</tr>
            <% end if%>
          </table></td>
	</tr>
	<tr>
		<td width="591" valign="top">
		<p style="margin: 0"><b><i><font face="Arial" size="2">DIGITE
      AQUI SEU CÓDIGO DE CADASTRO, E CLIQUE EM ADICIONAR</font></i></b></p>
		<p style="margin: 0"><img border="0" src="images/Barra_Horizontal.bmp"></p>
		</td>
	</tr>
	<tr>
		<td width="591" valign="top">
		<!--webbot BOT="GeneratedScript" PREVIEW=" " startspan --><script Language="JavaScript" Type="text/javascript"><!--
function FrontPage_Form1_Validator(theForm)
{

  if (theForm.N_TICKET.value == "")
  {
    alert("Digite um valor para o campo \"N_TICKET\".");
    theForm.N_TICKET.focus();
    return (false);
  }

  if (theForm.N_TICKET.value.length < 5)
  {
    alert("Digite pelo menos 5 caracteres no campo \"N_TICKET\".");
    theForm.N_TICKET.focus();
    return (false);
  }

  if (theForm.N_TICKET.value.length > 25)
  {
    alert("Digite no máximo 25 caracteres no campo \"N_TICKET\".");
    theForm.N_TICKET.focus();
    return (false);
  }

  var checkOK = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyzƒŠŒŽšœžŸÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõöøùúûüýþÿ0123456789-";
  var checkStr = theForm.N_TICKET.value;
  var allValid = true;
  var validGroups = true;
  for (i = 0;  i < checkStr.length;  i++)
  {
    ch = checkStr.charAt(i);
    for (j = 0;  j < checkOK.length;  j++)
      if (ch == checkOK.charAt(j))
        break;
    if (j == checkOK.length)
    {
      allValid = false;
      break;
    }
  }
  if (!allValid)
  {
    alert("Digite somente letra e dígito caracteres no campo \"N_TICKET\".");
    theForm.N_TICKET.focus();
    return (false);
  }
  return (true);
}
//--></script><!--webbot BOT="GeneratedScript" endspan --><form method="POST" action="Cliente_Bom_de_Sorte_Confirmacao.asp" onsubmit="return FrontPage_Form1_Validator(this)" name="FrontPage_Form1" language="JavaScript">
			<p style="line-height: 100%; margin: 0" align="center">&nbsp;</p>
			<div align="center"><center>
				<table border="0" cellpadding="0" cellspacing="0" width="555" id="table6">
					<tr>
						<td align="left" width="264">
						<p align="center" style="margin: 0"><b>
						<font face="Arial" size="2" color="#000080">CÓDIGO DE CADASTRO</font></b></td>
						<td width="257">
						<p align="center" style="margin: 0"><b><i>
						<font face="Arial" size="2">&nbsp;</font><font face="Arial" size="2" color="#FFFFFF"><!--webbot bot="Validation" s-data-type="String" b-allow-letters="TRUE" b-allow-digits="TRUE" b-value-required="TRUE" i-minimum-length="5" i-maximum-length="25" --><input type="text" name="N_TICKET" size="24" maxlength="25"></font></i></b></td>
						<td width="114">
						<font color="#FFFFFF">
						<input type="submit" value="Adicionar" name="Botao_ADICIONAR" style="background-color: #FFFFFF; font-size: 12 pt; font-family: Arial; text-transform: uppercase; font-style: italic; font-weight: bold; border: 3 outset #C0C0C0"></font></td>
					</tr>
				</table></center></div>
			<input type="hidden" name="Cliente" value="<%=wCliente%>">
			<input type="hidden" name="Sorteio" value="<%=wSorteio%>">
		</form></td>
	</tr>
<% else %>	
	<tr>
		<td width="591" valign="top">
		<b><font face="Arial" size="2">Erro . . . </font></b>
		<p><b><font size="2" face="Arial" color="#FF0000">CPF já Cadastrado.
		<a href="cliente_bom_de_sorte_cadastrado.asp">Clique Aqui!</a></font></b></td>
	</tr>
<% end if %>	
</table>

</body>
</html>