<%@ LANGUAGE="VBSCRIPT" %> <% error=false action = Request.Querystring("action") strID = Request.Querystring("id") if strID = Empty Then strID = Request.Form("id") End If If action = "edit" and strID = "" then action = "create" End If If action = "" Then action = "create" End If '----------------------------------------------- 'Create common connection object and set values Set cmdTemp.ActiveConnection = objDataConn cmdTemp.CommandType = adCmdStoredProc If action = "delete" or action = "add" or action = "save" or action = "confirm" Then Set cmdTmp = Server.CreateObject("ADODB.Command") Set cmdTmp.ActiveConnection = objDataConn cmdTmp.CommandType = adCmdStoredProc End If If action = "delete" Then intEntryID = Request.Querystring("EntryID") If intEntryID = Empty Then Response.Redirect ("_club_guestlist.asp") End If cmdTmp.CommandText = "prc_DeleteGuestlistEntry" Set s_objParam = cmdTmp.CreateParameter("@EntryID", adInteger , adParamInput, , intEntryID) cmdTmp.Parameters.Append s_objParam Set objDeleteEntry = Server.CreateObject("ADODB.RecordSet") set objDeleteEntry.Source = cmdTmp objDeleteEntry.Open Set objDeleteEntry = Nothing action = "edit" ElseIf action = "add" Then strEntryEmail = Request.Form("Email_Entry") If Request.Form("yyyy_Entry") <> "" and Request.Form("mm_Entry") <> "" and Request.Form("dd_Entry") <> "" Then dtmEntryDOB = DateSerial(Request.Form("yyyy_Entry"), Request.Form("mm_Entry"), Request.Form("dd_Entry")) Else dtmEntryDOB = "" End If strEntryFirstName = Request.Form("FirstName_Entry") strEntryLastName = Request.Form("LastName_Entry") cmdTmp.CommandText = "prc_AddGuestlistEntry" Set s_objParam = cmdTmp.CreateParameter("@RequestID", adInteger , adParamInput, , strID) cmdTmp.Parameters.Append s_objParam Set s_objParam = cmdTmp.CreateParameter("@firstname", adVarChar , adParamInput, len(strEntryFirstName), strEntryFirstName) cmdTmp.Parameters.Append s_objParam Set s_objParam = cmdTmp.CreateParameter("@lastname", adVarChar , adParamInput, len(strEntryLastName), strEntryLastName) cmdTmp.Parameters.Append s_objParam If strEntryEmail <> "" then Set s_objParam = cmdTmp.CreateParameter("@email", adVarChar , adParamInput, len(strEntryEmail), strEntryEmail) cmdTmp.Parameters.Append s_objParam Else Set s_objParam = cmdTmp.CreateParameter("@email", adVarChar , adParamInput, 1, NULL) cmdTmp.Parameters.Append s_objParam End If If dtmEntryDOB <> "" then Set s_objParam = cmdTmp.CreateParameter("@DOB", adDBTimeStamp , adParamInput, 8, dtmEntryDOB) cmdTmp.Parameters.Append s_objParam Else Set s_objParam = cmdTmp.CreateParameter("@DOB", adDBTimeStamp , adParamInput, 1, NULL) cmdTmp.Parameters.Append s_objParam End If Set objAddEntry = Server.CreateObject("ADODB.RecordSet") set objAddEntry.Source = cmdTmp objAddEntry.Open Set objAddEntry = Nothing action = "edit" End If If action = "create" Then dtmRequestedDate = Now strFirstName = Empty strLastName = Empty dtmDOB = null strOccasion = Empty chrGender = "U" strHouse = Empty strStreet = Empty strTown = Empty strCity = Empty strCounty = Empty strPostcode = Empty strTelephone = Empty strFacsimile = Empty strMobile = Empty boolPhoneBooking = false intGuestNumber = Empty strComments = Empty End If If action = "save" or action = "confirm" Then dtmRequestedDate = DateSerial(Request.Form("yyyy"), Request.Form("mm"), Request.Form("dd")) strFirstName = Request.Form("NameFirst") strLastName = Request.Form("NameLast") If Request.Form("yyyy_DOB") <> Empty and Request.Form("mm_DOB") <> Empty and Request.Form("dd_DOB") <> Empty Then dtmDOB = DateSerial(Request.Form("yyyy_DOB"), Request.Form("mm_DOB"), Request.Form("dd_DOB")) Else dtmDOB = null End If strOccasion = Request.Form("Occasion") chrGender = Request.Form("gender") strEmail = Request.Form("Email") strHouse = Request.Form("House") strStreet = Request.Form("Street") strTown = Request.Form("Town") strCity = Request.Form("City") strCounty = Request.Form("County") strPostcode = Request.Form("Postcode") strTelephone = Request.Form("Telephone") strFacsimile = Request.Form("Facsimile") strMobile = Request.Form("Mobile") boolPhoneBooking = Request.Form("PhoneBooking") intGuestNumber = Request.Form("GuestsNumber") strComments = Request.Form("Comments") isnew = Request.Form("isnew") If isnew Then cmdTmp.CommandText = "prc_AddGuestlist" Else cmdTmp.CommandText = "prc_EditGuestlist" Set s_objParam = cmdTmp.CreateParameter("@RequestID", adInteger , adParamInput, , strID) cmdTmp.Parameters.Append s_objParam End If Set s_objParam = cmdTmp.CreateParameter("@firstname", adVarChar , adParamInput, len(strFirstName), strFirstName) cmdTmp.Parameters.Append s_objParam Set s_objParam = cmdTmp.CreateParameter("@lastname", adVarChar , adParamInput, len(strLastName), strLastName) cmdTmp.Parameters.Append s_objParam Set s_objParam = cmdTmp.CreateParameter("@email", adVarChar , adParamInput, len(strEmail), strEmail) cmdTmp.Parameters.Append s_objParam Set s_objParam = cmdTmp.CreateParameter("@reqdate", adDBTimeStamp , adParamInput, 8, dtmRequestedDate) cmdTmp.Parameters.Append s_objParam If strHouse <> "" then Set s_objParam = cmdTmp.CreateParameter("@house", adVarChar , adParamInput, len(strHouse), strHouse) Else Set s_objParam = cmdTmp.CreateParameter("@house", adVarChar , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam If strStreet <> "" then Set s_objParam = cmdTmp.CreateParameter("@street", adVarChar , adParamInput, len(strStreet), strStreet) Else Set s_objParam = cmdTmp.CreateParameter("@street", adVarChar , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam If strTown <> "" then Set s_objParam = cmdTmp.CreateParameter("@town", adVarChar , adParamInput, len(strTown), strTown) Else Set s_objParam = cmdTmp.CreateParameter("@town", adVarChar , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam If strCity <> "" then Set s_objParam = cmdTmp.CreateParameter("@city", adVarChar , adParamInput, len(strCity), strCity) Else Set s_objParam = cmdTmp.CreateParameter("@city", adVarChar , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam If strCounty <> "" then Set s_objParam = cmdTmp.CreateParameter("@county", adVarChar , adParamInput, len(strCounty), strCounty) Else Set s_objParam = cmdTmp.CreateParameter("@county", adVarChar , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam If strPostcode <> "" then Set s_objParam = cmdTmp.CreateParameter("@postcode", adVarChar , adParamInput, len(strPostcode), strPostcode) Else Set s_objParam = cmdTmp.CreateParameter("@postcode", adVarChar , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam If not isNull(dtmDOB) then Set s_objParam = cmdTmp.CreateParameter("@DOB", adDBTimeStamp , adParamInput, 4, dtmDOB) Else Set s_objParam = cmdTmp.CreateParameter("@DOB", adDBTimeStamp , adParamInput, 4, NULL) End If cmdTmp.Parameters.Append s_objParam If chrGender <> "" then Set s_objParam = cmdTmp.CreateParameter("@gender", adChar , adParamInput, 1, chrGender) Else Set s_objParam = cmdTmp.CreateParameter("@gender", adChar , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam If strTelephone <> "" then Set s_objParam = cmdTmp.CreateParameter("@tel", adVarChar , adParamInput, len(strTelephone), strTelephone) Else Set s_objParam = cmdTmp.CreateParameter("@tel", adVarChar , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam If strFacsimile <> "" then Set s_objParam = cmdTmp.CreateParameter("@fax", adVarChar , adParamInput, len(strFacsimile), strFacsimile) Else Set s_objParam = cmdTmp.CreateParameter("@fax", adVarChar , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam If strMobile <> "" then Set s_objParam = cmdTmp.CreateParameter("@mobile", adVarChar , adParamInput, len(strMobile), strMobile) Else Set s_objParam = cmdTmp.CreateParameter("@mobile", adVarChar , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam If strOccasion <> "" then Set s_objParam = cmdTmp.CreateParameter("@occasion", adVarChar , adParamInput, len(strOccasion), strOccasion) Else Set s_objParam = cmdTmp.CreateParameter("@occasion", adVarChar , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam If strComments <> "" then Set s_objParam = cmdTmp.CreateParameter("@comments", adVarChar , adParamInput, len(strComments), strComments) Else Set s_objParam = cmdTmp.CreateParameter("@comments", adVarChar , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam If isnew Then If intGuestNumber <> "" then Set s_objParam = cmdTmp.CreateParameter("@guests", adInteger , adParamInput, , CInt(intGuestNumber)) Else Set s_objParam = cmdTmp.CreateParameter("@guests", adInteger , adParamInput, 1, NULL) End If cmdTmp.Parameters.Append s_objParam Set s_objParam = cmdTmp.CreateParameter("@PhoneBooking", adBoolean , adParamInput, 1, false) cmdTmp.Parameters.Append s_objParam End If Set objRstGuestlist = Server.CreateObject("ADODB.RecordSet") set objRstGuestlist.Source = cmdTmp objRstGuestlist.Open result = objRstGuestlist.Fields("RequestID") objRstGuestlist.Close If isnew Then strID = result End If If CInt(result) = -1 Then If isnew Then action = "create" Else action = "edit" End If error=true Else If action <> "confirm" Then action = "edit" End If End If Set objRstGuestlist = Nothing End If if action = "edit" or action = "confirm" then cmdTemp.CommandText = "prc_GetGuestlistRequest" Set s_objParam = cmdTemp.CreateParameter("@RequestID", adInteger, adParamInput, , strID) cmdTemp.Parameters.Append s_objParam Set objRstGuestlist = Server.CreateObject("ADODB.RecordSet") set objRstGuestlist.Source = cmdTemp objRstGuestlist.Open dtmRequestedDate = objRstGuestlist.Fields("RequestedDate") If isNull(dtmRequestedDate) Then dtmRequestedDate = Now End If strFirstName = objRstGuestlist.Fields("NameFirst") strLastName = objRstGuestlist.Fields("NameLast") strEmail = objRstGuestlist.Fields("Email") strOccasion = objRstGuestlist.Fields("Occasion") chrGender = Trim(objRstGuestlist.Fields("Gender")) strHouse = objRstGuestlist.Fields("HouseNameNum") strStreet = objRstGuestlist.Fields("Street") strTown = objRstGuestlist.Fields("Town") strCity = objRstGuestlist.Fields("City") strCounty = objRstGuestlist.Fields("County") strPostcode = objRstGuestlist.Fields("Postcode") strTelephone = objRstGuestlist.Fields("Tel") strFacsimile = objRstGuestlist.Fields("Fax") strMobile = objRstGuestlist.Fields("Mobile") dtmDOB = objRstGuestlist.Fields("DOB") strComments = objRstGuestlist.Fields("Comments") intGuestNumber = objRstGuestlist.Fields("Guests") boolPhoneBooking = CBool(objRstGuestlist.Fields("PhoneBooking")) objRstGuestlist.Close Set objRstGuestlist = Nothing if action = "confirm" then strSQL = "SELECT COUNT(*) FROM ClubPeople WHERE Email = '"&strEmail&"'" Set rsCheckPeople = objDataConn.execute(strSQL) iCheckPeople = rsCheckPeople(0) Set rsCHeckPeople = Nothing if iCheckPeople = 0 then strSQL = "INSERT INTO ClubPeople" strSQL = strSQL + " (PeopleTypeId, PeopleStatusID, Email, NameFirst, NameLast, DOB, Gender, Tel, Mobile, Fax, HouseNameNum, Street, City, Town, County, PostCode, OptEmail, OptSms, DateAdded, DateLastChanged)" strSQL = strSQL + " VALUES" strSQL = strSQL + " (1, 1, '"&strEmail&"', '"&strFirstName&"', '"&strLastName&"', '"&dtmDOB&"', '"&chrGender&"', '"&strTelephone&"', '"&strMobile&"', '"&strFacsimile&"', '"&strHouse&"', '"&strStreet&"', '"&strTown&"', '"&strCity&"', '"&strCounty&"', '"&strPostcode&"', 1, 0, GetDate(), GetDate())" Set rsInsertPeople = objDataConn.execute(strSQL) Set rsInsertPeople = Nothing end if end if cmdTemp.CommandText = "prc_GetGuestlistEntries" Set objRstEntries = Server.CreateObject("ADODB.RecordSet") set objRstEntries.Source = cmdTemp objRstEntries.Open end if %> Club195 - Epping - Guestlist
<%If action="confirm" Then %>
<% If action="confirm" Then %>
Thank You <%=strFirstName%> <%=strLastName%> for your guestlist booking for yourself and the list below on <%=dtmRequestedDate%> for <%=Request.Form("EntriesCount")+1%> guest. We hope you have a great night at Club 195.

<%Else%>
Using the form below, you fill out the boxes in the left hand column
with information about yourself (items marked * must be completed). In
the right hand column, add the names, date of birth and email addresses
(if available) of additional guests. <%If error Then%>
Dear <%=strFirstName%> <%=strLastName%>!
A guestlist for this email address and date has been already requested.
Please enter different email address or change requested date.
<%End If%>

<%End If 'action="confirm"%>
<% If action = "create" Then%> <%Else%> <%End If%>
Date *  
Occasion  
First Name * 
Last Name * 
Guests  "create" Then%>disabled="disabled"<%End If%> maxlength="2" class="blue" name="GuestsNumber" ID="GuestsNumber" value="<%=intGuestNumber%>">
Email * 
DOB  
Gender  
House  
Street  
Town  
City  
County  
Postcode  
Telephone  
Facsimile  
Mobile  
Add guest
Email
DOB  
First name *
Last name *
alert('Please save created Guestlist Request before adding Entries.');<%Else%>addgEntry(document.EditGuestlist)<%End If%>">add event booker
Comments
<% num1 = 0 If action <> "create" Then Do While Not objRstEntries.BOF and not objRstEntries.EOF num1 = num1 + 1 dtmDOB = objRstEntries.Fields("DOB") If isNull(dtmDOB) Then strDOB = "" Else strDOB = FormatDateTime(dtmDOB,vbShortDate) End IF strEmail = objRstEntries.Fields("Email") If isNull(strEmail) Then strEmail = "" End IF %> <%If action<>"confirm" Then%> <%Else%> <%End If 'action="confirm"%> <% objRstEntries.MoveNext Loop objRstEntries.Close Set objRstEntries = Nothing End If 'action <> "create" %>
Guest List
Name DOB Email
<%=Server.HTMLEncode(objRstEntries("FullName"))%> <%=strDOB%> <%=Server.HTMLEncode(strEmail)%> );">delete
Your provisional booking has been accepted.

The management reserve the right to refuse admission <%ElseIf action <> "create" Then%>
<%End If 'action="confirm"%>