home *** CD-ROM | disk | FTP | other *** search
/ 202.53.64.216 / 202.53.64.216.tar / 202.53.64.216 / janahitha / AdsHoardingDetail.asp < prev    next >
Text File  |  2004-11-26  |  6KB  |  182 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="#FFFFFF">
  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.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.         <meta name="author" content="Gopi Tanguturi">        
  52.     </head>
  53.     <body bottommargin=0 topmargin=0 leftmargin=0 rightmargin=0 marginheight=0 marginwidth=0 bgcolor=#ffffff>
  54.         <!-- #include file="AdsTop.asp" --> 
  55.         <center>
  56.         <table width=100% cellpadding=0 cellspacing=0 border=0 height=100%>
  57.         <tr>
  58.             <td width=150 align=center valign=top bgcolor="#FFFFFF">
  59.                 <!-- #include file="AdsLeft.asp" -->
  60.             </td>
  61.             <td width=630 align=center valign=top bgcolor="#ffffff">
  62.                 <br>
  63.                 <font face=verdana color="#8a5b39"> <b> Hoarding Details</b> </font> <br> <br>
  64.                 <table cellpadding=2 cellspacing=0 border=0>
  65.                 <tr> <td bgcolor="#644D37">
  66.                 <table width=400 cellpadding=3 cellspacing=3 border=0 bgcolor="#ffffff">
  67.                 <tr>
  68.                     <td width="35%">
  69.                         <font face=verdana size=2> Hoarding Type </font>
  70.                     </td>
  71.                     <td width="65%">
  72.                         <font face=verdana size=2 color="#644D37"> <%=objrs("HoardingTypeName")%> </font>
  73.                     </td>
  74.                 </tr>
  75.                 <tr>
  76.                     <td width="25%">
  77.                         <font face=verdana size=2> Zone </font>
  78.                     </td>
  79.                     <td width="75%">
  80.                         <font face=verdana size=2 color="#644D37"> <%=objrs("ZoneName")%> </font>
  81.                     </td>
  82.                 </tr>
  83.                 <tr>
  84.                     <td width="25%">
  85.                         <font face=verdana size=2> Location </font>
  86.                     </td>
  87.                     <td width="75%">
  88.                         <font face=verdana size=2 color="#644D37"> <%=objrs("Location")%> </font>
  89.                     </td>
  90.                 </tr>
  91.                 <tr>
  92.                     <td width="25%">
  93.                         <font face=verdana size=2> Near By Areas </font>
  94.                     </td>
  95.                     <td width="75%">
  96.                         <font face=verdana size=2 color="#644D37"> <%=objrs("NearByAreas")%> </font>
  97.                     </td>
  98.                 </tr>
  99.                 <tr>
  100.                     <td width="25%">
  101.                         <font face=verdana size=2> Traffic Coming From </font>
  102.                     </td>
  103.                     <td width="75%">
  104.                         <font face=verdana size=2 color="#644D37"> <%=objrs("Direction")%> </font>
  105.                     </td>
  106.                 </tr>
  107.  
  108.                 <tr>
  109.                     <td width="25%">
  110.                         <font face=verdana size=2> Height (Ft) </font>
  111.                     </td>
  112.                     <td width="75%">
  113.                         <font face=verdana size=2 color="#644D37"> <%=objrs("height")%> </font>
  114.                     </td>
  115.                 </tr>
  116.                 <tr>
  117.                     <td width="25%">
  118.                         <font face=verdana size=2> Width (Ft) </font>
  119.                     </td>
  120.                     <td width="75%">
  121.                         <font face=verdana size=2 color="#644D37"> <%=objrs("Width")%> </font>
  122.                     </td>
  123.                 </tr>
  124.                 <!--<tr>
  125.                     <td width="25%">
  126.                         <font face=verdana size=2> Material </font>
  127.                     </td>
  128.                     <td width="75%">
  129.                         <font face=verdana size=2 color="#644D37"> <%=objrs("HoardingMaterial")%> </font>
  130.                     </td>
  131.                 </tr>-->
  132.                 <tr>
  133.                     <td width="25%">
  134.                         <font face=verdana size=2><FONT face=verdana size=2>Present Display </FONT> </font>
  135.                     </td>
  136.                     <td width="75%">
  137.                         <font face=verdana size=2 color="#644D37"> <%=objrs("PresentDisplay")%> </font>
  138.                     </td>
  139.                 </tr>
  140.                 <tr>
  141.                     <td width="25%">
  142.                         <font face=verdana size=2> Status </font>
  143.                     </td>
  144.                     <td width="75%">
  145.                         <font face=verdana size=2 color="#644D37"> <%=HoardingStatus%> </font>
  146.                     </td>
  147.                 </tr>
  148.                 <%if(HoardingStatus = "Not Available") then%>
  149.                 <tr>
  150.                     <td width="25%">
  151.                         <font face=verdana size=2> Booked From </font>
  152.                     </td>
  153.                     <td width="75%">
  154.                         <font face=verdana size=2 color="#644D37"> <%=objrs("BookingFromdate")%> </font>
  155.                     </td>
  156.                 </tr>
  157.                 <tr>
  158.                     <td width="25%">
  159.                         <font face=verdana size=2> To </font>
  160.                     </td>
  161.                     <td width="75%">
  162.                         <font face=verdana size=2 color="#644D37"> <%=objrs("todate")%> </font>
  163.                     </td>
  164.                 </tr>
  165.                 <%end if%>
  166.                 </table>
  167.                 </td> </tr>
  168.                 </table>
  169.                 <br>
  170.                 <a href="javascript:history.back();"><font face=verdana size=2 color=#A01640>Back</font></a> <br> <br>
  171.             </td>
  172.         </tr>
  173.         </table>
  174.         </center>
  175.         <!-- #include file="AdsBottom.asp" -->
  176.     </body>
  177. </html>
  178. <%
  179.     objrs.Close
  180.     set objrs = nothing
  181. %>
  182. <!-- #include file="AdsCloseConn.asp" -->