<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<%@ Language = VBscript %>
<%
'Grab variables from the querystring.
carID=Request.Querystring("carID")
tranID=Request.Querystring("tranID")
gradeID=Request.Querystring("gradeID")
appID=Request.Querystring("appID")
'Construct and run SQL statment to get car rate information
SQLCARRATE="SELECT carName, szMultiple FROM Cars, Size "
SQLCARRATE=SQLCARRATE & "WHERE Cars.szID = Size.szID and carID=" & carID
set conncarrate = server.createobject("ADODB.Connection")
conncarrate.open "parking"
set carrate=conncarrate.execute(SQLCARRATE)
carname=carrate(0)
carszmultiple=carrate(1)
conncarrate.close
'Construct and run SQL statment to get transmission rate information
SQLTRANRATE="SELECT tranRate, tranType FROM Transmission "
SQLTRANRATE=SQLTRANRATE & "WHERE tranID=" & tranID
set conntranrate = server.createobject("ADODB.Connection")
conntranrate.open "parking"
set tranrate=conntranrate.execute(SQLTRANRATE)
transmultiple=tranrate(0)
transtype=tranrate(1)
conntranrate.close
'Construct and run SQL statment to get transmission rate information
SQLGRADERATE="SELECT gradeMultiple, gradeName FROM Slope "
SQLGRADERATE=SQLGRADERATE & "WHERE gradeID=" & gradeID
set conngraderate = server.createobject("ADODB.Connection")
conngraderate.open "parking"
set graderate=conngraderate.execute(SQLGRADERATE)
grademultiple=graderate(0)
gradename=graderate(1)
conngraderate.close
'Calculate the cost of this appointment
cost = 100 * grademultiple * transmultiple * carszmultiple
%>
<HTML>
<HEAD>
<TITLE>Parking Progress Headquarters</TITLE>
</HEAD>
<BODY bgcolor="black" text="white">
<br><br><br><br><br>
<center>
<table width="250">
<tr>
<td>
<font face="arial" size="6">Okay, that's great.
<p>For a <%= transtype %> transmision <%= carname %> on a <%= gradename %> pitch,
the cost will be $<%= cost %> per hour.</font>
</td>
</tr>
</table>
<br><br><br><br>
<table width="500">
<tr>
<td width="150" valign="top"><font face="arial" size="5">Jay is available for the following two-hour appointments:</font>
<p><font face="arial" size="3">(Click on an available time to book an appointment.)</font>
</td>
<td width="50"></td>
<td width="300" valign="top"><!--#include file="appts.inc"--></td>
</tr>
</table>
</center>
</BODY>
</HTML>