%@ 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