<%@ Language=VBScript %> <%Option Explicit%> <% Dim RS2 : Set RS2 = Server.CreateObject("ADODB.Recordset") Dim sesid ConnectRS select case Request.Form("action") case "login": if Request.Form("username") <> "" then 'Prise de l'information de l'acheteur selon son nom d'utilisateur (..., (SELECT COUNT(ID_Transaction) FROM tblTransaction WHERE ID_ach = a.ID_ach) AS [transac]...) strSQL = "SELECT a.ID_Ach, 0 AS [ID_Assistant], webActif, webPassword, webDateFin, (SELECT COUNT(ID_CCach) FROM tblCCAch WHERE ID_ach = a.ID_ach) AS [CCACH] FROM tblSUBAcheteur AS a WHERE webUsername = '" & replace(lcase(Request.Form("username")), "'", "''") & "'" & _ " UNION SELECT ID_Ach, ID_Assistant, webActif, webPassword, webDateFin, 0 FROM tblAssistant WHERE webUsername = '" & replace(lcase(Request.Form("username")), "'", "''") & "'" 'Response.Write "" RS.Open strSQL, CNRS 'ouverture de la requête if RS.EOF then 'vérification qu'un nom a été trouvé vMess = "Nom d'utilisateur inconnu" else if RS.Fields("webPassword") <> Request.form("password") then 'vérification du mot de passe vMess = "Mot de passe incorrect" else Session("user") = UCase(Request.Form("username")) 'l'utilisateur est identifié Session("Userid") = RS.Fields("ID_Ach") Session("Assistid") = RS.Fields("ID_Assistant") Session("CCACH") = RS.Fields("CCACH") 'Session("Transac") = RS.Fields("transac") if Session("CCACH") > 0 then dim RScc: Set RScc = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT MAX(Date_CCAch) FROM tblCCach WHERE ID_ach = " & Session("Userid") & " AND ID_EtapeCCach = 1" RScc.Open strSQL, CNRS Response.Write "" if RScc.EOF then Session("CCACH") = 0 else if DateDiff("m", RScc.Fields(0), Date) > 12 then Session("CCACH") = 0 end if end if end if if not RS.Fields("webActif") then 'vérification de l'état de son accès vMess = "Vous êtes identifié mais votre accès a été révoqué" else if datediff("d", RS.Fields("webDateFin"), date) > 0 then 'vérification de la fin de son accès vMess = "Vous êtes identifié mais votre accès a prit fin le " & RS.Fields("webDateFin") else Session("perm") = 1 strSQL = " SELECT d.Nom_dos" & _ " FROM tblDossier AS d INNER JOIN tblSUBAcheteur AS a ON d.ID_dos = a.ID_dos" & _ " WHERE a.ID_Ach = " & Session("Userid") RS2.Open strSQL, CNRS sesid = RS2.Fields(0) RS2.Close() if Session("Userid") <> 1 then SendEMail EMAIL_FROM, EMAIL_TO, "","L'ach. #"& Session("Userid") & " : " & sesid & " vient de se connecter sur le site immobilier !!! ", " " end if end if end if end if end if RS.Close end if case "logout": Session.Abandon Response.Redirect "index.asp" end select %> <% Dim ShowContent 'As Boolean 'Should the form be Displayed ShowContent = True 'The form should be displayed if Request.Form <> "" then 'If there is data in the request.form dim vSubject dim vContent dim vData dim vName dim vLocs dim vLocsID dim vTab vMess = "" vName = Trim(Request.Form("txtPrenom") & " " & Request.Form("txtNom")) vSubject = "-- Achat -- " & vName & " " & FormatDate(Now, "dd-mmm-yyyy") vContent = "" vData = Now & chr(20) vContent = vContent & "

" & vbcrlf vContent = vContent & "
" & vbcrlf if Request.Form("txtTelephone") <> "" then vContent = vContent & "Domicile : " & Request.Form("txtTelephone") & "
" & vbcrlf end if vData = vData & Request.Form("txtTelephone") & chr(20) if Request.Form("txtTravail") <> "" then vContent = vContent & "Travail : " & Request.Form("txtTravail") & "
" & vbcrlf end if vData = vData & Request.Form("txtTravail") & chr(20) if Request.Form("txtCellulaire") <> "" then vContent = vContent & "Cél. : " & Request.Form("txtCellulaire") & "
" & vbcrlf end if vData = vData & Request.Form("txtCellulaire") & chr(20) if Request.Form("txtEmail") <> "" then if trim(Request.Form("txtEmail")) = trim(Request.Form("txtEmailCF")) then vContent = vContent & "" & Request.Form("txtEmail") & "
" & vbcrlf vData = vData & Request.Form("txtEmail") & chr(20) else vMess = vMess & "txtEmailCF;" end if else vMess = vMess & "txtEmail;" end if vContent = vContent & "

" & vbcrlf vContent = vContent & "
" & vbcrlf if Request.Form("txtAdresse") <> "" then vContent = vContent & vName & "
" & vbcrlf vContent = vContent & Request.Form("txtAdresse") & "
" & vbcrlf if Request.Form("txtVille") <> "" then vContent = vContent & Request.Form("txtVille") if Request.Form("txtProvince") = "" then vContent = vContent & "
" & vbcrlf end if else vMess = vMess & "txtVille;" end if if Request.Form("txtProvince") <> "" then if Request.Form("txtVille") <> "" then vContent = vContent & ", " else vMess = vMess & "txtVille;" end if vContent = vContent & Request.Form("txtProvince") & "
" & vbcrlf else vMess = vMess & "txtProvince;" end if if Request.Form("txtCodepostal") <> "" then vContent = vContent & Request.Form("txtCodepostal") & "
" & vbcrlf else vMess = vMess & "txtCodepostal;" end if end if vContent = vContent & "
" & vbcrlf if Request.Form("txtAdresse") <> "" then vData = vData & Request.Form("txtAdresse") & chr(20) else vMess = vMess & "txtAdresse;" end if if Request.Form("txtVille") <> "" then vData = vData & Request.Form("txtVille") & chr(20) else vMess = vMess & "txtVille;" end if if Request.Form("txtProvince") <> "" then vData = vData & Request.Form("txtProvince") & chr(20) else vMess = vMess & "txtProvince;" end if if Request.Form("txtCodepostal") <> "" then vData = vData & Request.Form("txtCodepostal") & chr(20) else vMess = vMess & "txtCodepostal;" end if vLocs = "" vLocsID = "" for I = 1 to Request.Form.Count if left(Request.Form.key(I), 3) = "chk" then vLocs = vLocs & Request.Form(I) vLocsID = vLocsID & right(Request.Form.key(I), len(Request.Form.key(I)) - 6) if right(Request.Form.key(I), len(Request.Form.key(I)) - 6) = "0" then vLocs = vLocs & " (" & Request.form("txtLoc0") & ")" vLocsID = vLocsID & "~" & MAJ(Request.form("txtLoc0")) else vLocsID = vLocsID & "~" & MAJ(Request.Form(I)) end if vLocs = vLocs & ", " vLocsID = vLocsID & chr(18) end if next if len(vLocs) > 1 then vLocs = left(vLocs, len(vLocs) - 2) end if vContent = vContent & replace(vLocs, "_", " ") & "

" & vbcrlf vData = vData & vLocsID & chr(20) vContent = vContent & "De " & Request.Form("cmbLow") & " à " & Request.Form("cmbHigh") & " .
" vData = vData & Request.Form("cmbLow") & chr(20) vData = vData & Request.Form("cmbHigh") & chr(20) vContent = vContent & "
" & vbcrlf vContent = vContent & "Mise de fond.
" & vbcrlf vContent = vContent & """" & Request.Form("txtMiseDeFond") & "$""

" & vbcrlf vData = vData & Request.Form("txtMiseDeFond") & chr(20) vContent = vContent & "
" & vbcrlf vContent = vContent & "Critère d'acquisition.
" & vbcrlf vContent = vContent & """" & Request.Form("txtquestion1") & """

" & vbcrlf vData = vData & Request.Form("txtquestion1") & chr(20) vContent = vContent & "
" & vbcrlf vContent = vContent & "Chiffre d'affaires.
" & vbcrlf vContent = vContent & """" & Request.Form("txtquestion2") & "$""

" & vbcrlf vData = vData & Request.Form("txtquestion2") & chr(20) vContent = vContent & "
" & vbcrlf vContent = vContent & "Comment avez-vous entendu parlé de nous:
" & vbcrlf vContent = vContent & """" & Request.Form("txtquestion3") & """

" & vbcrlf vData = vData & Request.Form("txtquestion3") & chr(20) if Request.Form("txtComments") <> "" then vContent = vContent & "Commentaires
" & vbcrlf vContent = vContent & Request.Form("txtComments") end if vData = vData & Request.Form("txtComments") & chr(20) if left(Request.Form("lstAch"), 1) = "3" then '********* pour les courtiers dim vNameC vNameC = Trim(Request.Form("ctxtPrenom") & " " & Request.Form("ctxtNom")) vData = vData & Request.Form("ctxtPrenom") & chr(20) vData = vData & Request.Form("ctxtNom") & chr(20) vContent = vContent & "

INFORMATIONS SUR LE COURTIER
" & vbcrlf vContent = vContent & "Coordonnées :
" & vbcrlf vContent = vContent & "
" & vbcrlf if Request.Form("ctxtTelephone") <> "" then vContent = vContent & "Téléphone à la maison : " & Request.Form("ctxtTelephone") & "
" & vbcrlf end if vData = vData & Request.Form("ctxtTelephone") & chr(20) if Request.Form("ctxtTravail") <> "" then vContent = vContent & "Téléphone au travail : " & Request.Form("ctxtTravail") & "
" & vbcrlf end if vData = vData & Request.Form("ctxtTravail") & chr(20) if Request.Form("ctxtCellulaire") <> "" then vContent = vContent & "Téléphone céllulaire : " & Request.Form("ctxtCellulaire") & "
" & vbcrlf end if vData = vData & Request.Form("ctxtCellulaire") & chr(20) if Request.Form("ctxtEmail") <> "" then vContent = vContent & "Courriel : " & Request.Form("ctxtEmail") & "
" & vbcrlf end if vData = vData & Request.Form("ctxtEmail") & chr(20) vContent = vContent & "

" & vbcrlf vContent = vContent & "
" & vbcrlf if Request.Form("ctxtAdresse") <> "" then vContent = vContent & vName & "
" & vbcrlf vContent = vContent & Request.Form("ctxtAdresse") & "
" & vbcrlf if Request.Form("ctxtVille") <> "" then vContent = vContent & Request.Form("ctxtVille") if Request.Form("ctxtProvince") = "" then vContent = vContent & "
" end if end if if Request.Form("ctxtProvince") <> "" then if Request.Form("ctxtVille") <> "" then vContent = vContent & ", " end if vContent = vContent & Request.Form("ctxtProvince") & "
" & vbcrlf end if vContent = vContent & Request.Form("ctxtCodepostal") & "
" & vbcrlf end if vData = vData & Request.Form("ctxtAdresse") & chr(20) vData = vData & Request.Form("ctxtVille") & chr(20) vData = vData & Request.Form("ctxtProvince") & chr(20) vData = vData & Request.Form("ctxtCodepostal") & chr(20) vContent = vContent & "
" & vbcrlf vContent = vContent & "Numéro de permis: " & Request.Form("txtPermis") vContent = vContent & "
" & vbcrlf vData = vData & Request.Form("txtPermis") & chr(20) end if vContent = vContent & "" if vMess = "" then 'Response.Write vContent SendEMail EMAIL_FROM, EMAIL_TO, "", vSubject, vContent showContent = false end if end if %> Richard Perreault
<% Dim noBrp strSQL = " SELECT Last_brp FROM tblBrp" RS2.Open strSQL, CNRS noBrp = RS2.Fields(0) RS2.Close noBrp = noBrp & "Web.html"%>

Acheteur / Vendeur

  • <%if Request.QueryString("p") = "mandats" then Response.Write "

    Liste des mandats

    " else Response.Write "Liste des mandats" end if %>
  • <% if Session("Perm") = 1 then %>
  • " target="_blank"> Comparez mandats
  • <%else %>
  • Comparez mandats
  • <% end if%>
  • <% if Request.QueryString("p") = "motdepasse" then Response.Write "

    Achat / mot de passe

    " else Response.Write "Achat / mot de passe" end if %>
  • <% if Request.QueryString("p") = "faq" then Response.Write "

    F.A.Q.- mandat acheteur

    " else Response.Write "F.A.Q.- mandat acheteur" end if %>
  • <% if Request.QueryString("p") = "vente" then Response.Write "

    Vente de résidence

    " else Response.Write "Vente de résidence" end if %>
  • <% if Request.QueryString("p") = "loyers" then Response.Write "

    Types d'hebergement

    " else Response.Write "Types d'hebergement" end if %>

Chercher Mandat

Calculez

<%if session("user") <> "" then%>

Identification

Vous êtes connecté
en tant que : <%=Session("user")%>

<%=vMess%>

<%else%>

Identification

Utilisateur : " size="20" />

Mot de passe :

<%=vMess%>

< S'INSCRIRE >

<%if vMess = "" then%> <%end if%> <%end if%>
<%if ShowContent then %>
Achat / Mot de passe

Pour obtenir un nom d'utilisateur ainsi qu'un mot de passe, vous devez remplir ce formulaire.

<% ShowFields %>

ÉTAPE #3

A. Dans quel secteur désirez-vous acquérir une résidence d'aînès?
Vous pouvez sélectionner plus d'une région
<% strSQL = "SELECT -1, COUNT(ID_Lieu), '1' FROM tblLieu UNION SELECT ID_Lieu, Nom_Lieu, Type_Lieu FROM tblLieu where ID_Lieu not in (36,25,21,31,30,23) UNION SELECT 0, 'Autre', 'E' FROM tblLieu ORDER BY 3 ASC" RS.Open strSQL, CNRS dim vCount,typeL vCount = cint(RS.Fields(1)) RS.MoveNext I = 0 typeL = "A) MONTREAL" do while not RS.EOF if I mod 3 = 0 then %> <% end if %> <%if typeL<>RS.Fields(2) then %> <% end if if (I + 1) mod 3 = 0 then %> <% end if RS.MoveNext I = I + 1 loop RS.Close %>
colspan=<%=(3 - (vCount mod 3))%><% end if %>><%end if %> <%if typeL<>RS.Fields(2) or I=0 then %>
onclick="chkLocAutre_onclick()" <% end if if Request.Form("chkLoc" & RS.Fields(0)) <> "" then Response.Write " checked" %>><%end if %><%if typeL=RS.Fields(2) and I<>0 then %>
   <%end if %> <% if I = vCount then %>><% end if %><%if typeL<>RS.Fields(2) then %>
B. Grandeur

De unités à unités

C. Quel type d'acquéreur êtes-vous?
D. Quelle mise de fonds seriez-vous prêt à investir ?
">$
E. Pourquoi voulez-vous acquérir une résidence d'aînès ?
F. Chiffre d'affaires annuel désiré?
">$
G. Comment avez-vous entendu parler de nous?
">
>

Informations sur le courtier

ÉTAPE #1

">
">
">
">
">

ÉTAPE #2

">
">
">
">
# de permis:
">
Commentaires et autres informations.
<%else %>

Vous recevrez une réponse par courriel d'ici 24 heures contenant votre mot de passe pour consulter les fiches de mandats.

Merci.

<%end if %>
<% EndConnect %>