home *** CD-ROM | disk | FTP | other *** search
/ 202.53.64.216 / 202.53.64.216.tar / 202.53.64.216 / janahitha / showboard.asp < prev    next >
Text File  |  2004-11-26  |  6KB  |  198 lines
  1. <!-- #include file="AdsOpenConn.asp" -->
  2. <%
  3.     HoardingId = Request.QueryString("HId")
  4.     set objrs = server.CreateObject("adodb.recordset")
  5.     notthere = false
  6.     objrs.Open "select count(*) from HoardingMaster where HoardingId=" + HoardingId, con, 3, 3
  7.     if objrs(0)=0 then notthere=true
  8.     objrs.Close
  9.     if notthere then
  10. %>
  11. <html>
  12.     <head>
  13.         <title> Janahitha Ads - Welcome </title>
  14.         <meta name="author" content="Jagadish,Gopi">
  15.     </head>
  16.     <body bottommargin=0 topmargin=0 leftmargin=0 rightmargin=0 marginheight=0 marginwidth=0 bgcolor=#ffffff>
  17.         <!-- #include file="AdsTop.asp" --> 
  18.         <center>
  19.         <table width=100% cellpadding=0 cellspacing=0 border=0 height=100%>
  20.         <tr>
  21.             <td width=150 align=center valign=top bgcolor="#f2D197">
  22.                 <!-- #include file="AdsLeft.asp" -->
  23.             </td>
  24.             <td width=630 align=center valign=top bgcolor="#ffffff">
  25.                 <br> <br> <br>
  26.                 <font face=verdana size=2 color=red>
  27.                 <b> No Hoarding Exists - Hit <a href="javascript:history.back();"><font color=red>Back</a> </b>
  28.                 </font>
  29.             </td>
  30.         </tr>
  31.         </table>
  32.         </center>
  33.         <!-- #include file="AdsBottom.asp" -->
  34.     </body>
  35. </html>
  36. <%
  37.         Response.End 
  38.     end if
  39.     'Response.Write  "select a.Location, a.Direction, a.PresentDisplay, a.HoardingStatus, a.Status, b.ZoneName, c.HoardingTypeName, c.HoardingMaterial,a.height,a.width from HoardingMaster a, ZoneMaster b, HoardingTypeMaster c where a.ZoneId=b.ZoneId and a.HoardingTypeId=c.HoardingTypeId and a.HoardingId= " + HoardingId
  40.     objrs.Open "select a.Location,a.hoardimage, a.Direction,a.NearByAreas, a.PresentDisplay, a.HoardingStatus, a.Status,a.bookingfromdate,a.todate, b.ZoneName, c.HoardingTypeName, c.HoardingMaterial,a.height,a.width from HoardingMaster a, ZoneMaster b, HoardingTypeMaster c where a.ZoneId=b.ZoneId and a.HoardingTypeId=c.HoardingTypeId and a.HoardingId= " + HoardingId, con, 3,3
  41.     if objrs("HoardingStatus") then
  42.         HoardingStatus = "Available"
  43.     else
  44.         HoardingStatus = "Not Available"
  45.     end if
  46. %>
  47. <html>
  48.     <head>
  49.         <title> Janahitha Ads - Welcome </title>
  50.         <meta name="author" content="Jagadish,Gopi">
  51.     </head>
  52.     <body bottommargin=0 topmargin=0 leftmargin=0 rightmargin=0 marginheight=0 marginwidth=0 bgcolor=#ffffff>
  53.         <!-- #include file="AdsTop.asp" --> 
  54.         <center>
  55.         <table width=100% cellpadding=0 cellspacing=0 border=0 height=100%>
  56.         <tr>
  57.             <td width=150 align=center valign=top bgcolor="#f2D197">
  58.                 <!-- #include file="AdsLeft.asp" -->
  59.             </td>
  60.             <td width=630 align=center valign=top bgcolor="#f2D197">
  61.                 <br>
  62.                 <font face=verdana color="#8a5b39"> <b> Hoarding Details</b> </font> <br> <br>
  63.                 <table cellpadding=2 cellspacing=0 border=0>
  64.                 <tr> <td bgcolor="#644D37">
  65.                 <table width=300 cellpadding=3 cellspacing=3 border=1  bgcolor="#ffffff" bordercolor=Moccasin>
  66.                 <tr>
  67.                     <td width="25%">
  68.                         <font face=verdana size=2> Height (Ft) </font>
  69.                     </td>
  70.                     <td width="75%">
  71.                         <font face=verdana size=2 color="#0000FF" > <%=objrs("height")%> </font>
  72.                     </td>
  73.                 </tr>
  74.                 
  75.                 <tr>
  76.                     <td width="25%">
  77.                         <font face=verdana size=2> Width (Ft) </font>
  78.                     </td>
  79.                     <td width="75%">
  80.                         <font face=verdana size=2 color="#0000FF"> <%=objrs("Width")%> </font>
  81.                     </td>
  82.                 </tr>
  83.                 <tr>
  84.                     <td width="25%">
  85.                         <font face=verdana size=2> Area (Sqft) </font>
  86.                     </td>
  87.                     <td width="75%">
  88.                         <font face=verdana size=2 color="#0000FF"> <%=(objrs("Width")*objrs("height"))%> </font>
  89.                     </td>
  90.                 </tr>
  91.                 
  92.                 <tr>
  93.                     <td width="35%">
  94.                         <font face=verdana size=2> Hoarding Type </font>
  95.                     </td>
  96.                     <td width="65%">
  97.                         <font face=verdana size=2 color="#0000FF"> <%=objrs("HoardingTypeName")%> </font>
  98.                     </td>
  99.                 </tr>
  100.                 <tr>
  101.                     <td width="25%">
  102.                         <font face=verdana size=2> Zone </font>
  103.                     </td>
  104.                     <td width="75%">
  105.                         <font face=verdana size=2 color="#0000FF"> <%=objrs("ZoneName")%> </font>
  106.                     </td>
  107.                 </tr>
  108.                 <tr>
  109.                     <td width="25%">
  110.                         <font face=verdana size=2> Location </font>
  111.                     </td>
  112.                     <td width="75%">
  113.                         <font face=verdana size=2 color="#0000FF"> <%=objrs("Location")%> </font>
  114.                     </td>
  115.                 </tr>
  116.                 
  117.         
  118.                 <tr>
  119.                     <td width="25%">
  120.                         <font face=verdana size=2> Near By Areas </font>
  121.                     </td>
  122.                     <td width="75%">
  123.                         <font face=verdana size=2 color="#0000FF"> <%=objrs("NearByAreas")%> </font>
  124.                     </td>
  125.                 </tr>
  126.                 <tr>
  127.                     <td width="25%">
  128.                         <font face=verdana size=2> Traffic Coming From </font>
  129.                     </td>
  130.                     <td width="75%">
  131.                         <font face=verdana size=2 color="#0000FF"> <%=objrs("Direction")%> </font>
  132.                     </td>
  133.                 </tr>
  134.  
  135.                         <!--<tr>
  136.                     <td width="25%">
  137.                         <font face=verdana size=2> Material </font>
  138.                     </td>
  139.                     <td width="75%">
  140.                         <font face=verdana size=2 color="#644D37"> <%=objrs("HoardingMaterial")%> </font>
  141.                     </td>
  142.                 </tr>-->
  143.                 <tr>
  144.                     <td width="25%">
  145.                         <font face=verdana size=2><FONT face=verdana size=2>Present Display </FONT> </font>
  146.                     </td>
  147.                     <td width="75%">
  148.                         <font face=verdana size=2 color="#0000FF"> <%=objrs("PresentDisplay")%> </font>
  149.                     </td>
  150.                 </tr>
  151.                 <tr>
  152.                     <td width="25%">
  153.                         <font face=verdana size=2> Status </font>
  154.                     </td>
  155.                     <td width="75%">
  156.                         <font face=verdana size=2 color="#0000FF"> <%=HoardingStatus%> </font>
  157.                     </td>
  158.                 </tr>
  159.                 <%if(HoardingStatus = "Not Available") then%>
  160.                 <tr>
  161.                     <td width="25%">
  162.                         <font face=verdana size=2> Booked From </font>
  163.                     </td>
  164.                     <td width="75%">
  165.                         <font face=verdana size=2 color="#0000FF"> <%=objrs("BookingFromdate")%> </font>
  166.                     </td>
  167.                 </tr>
  168.                 <tr>
  169.                     <td width="25%">
  170.                         <font face=verdana size=2> To </font>
  171.                     </td>
  172.                     <td width="75%">
  173.                         <font face=verdana size=2 color="#0000FF"> <%=objrs("todate")%> </font>
  174.                     </td>
  175.                 </tr>
  176.                 <%end if%>
  177.                 </table>
  178.                 <td> 
  179.                 <image src="hoardimages/<%=objrs("hoardimage")%>" width=290 height=350>
  180.                 </td>
  181.                 </tr>
  182.                 </table>
  183.                 <br>
  184.                 <a href="javascript:history.back();"><font face=verdana size=2 color=#A01640>Back</font></a> <br> <br>
  185.         </tr></table>
  186.                 </table>
  187.                 </td> </tr>
  188.                 
  189.         </table>
  190.         </center>
  191.         <!-- #include file="AdsBottom.asp" -->
  192.     </body>
  193. </html>
  194. <%
  195.     objrs.Close
  196.     set objrs = nothing
  197. %>
  198. <!-- #include file="AdsCloseConn.asp" -->