home *** CD-ROM | disk | FTP | other *** search
/ 202.53.64.216 / 202.53.64.216.tar / 202.53.64.216 / janahitha / Admin / AdsAdminHoardingDetails.asp < prev    next >
Text File  |  2004-11-26  |  10KB  |  235 lines
  1. <!-- #include file="AdsAdminConstants.asp" -->
  2. <!-- #include file="../AdsOpenConn.asp" -->
  3. <%
  4.     HoardingId = Request.QueryString("HId")
  5.     set objrs = server.CreateObject("adodb.recordset")
  6.     msg = ""
  7.     objrs.Open "select count(*) from HoardingMaster where HoardingId=" + HoardingId, con, 3, 3
  8.     if objrs(0)=0 then msg = "No Hoarding Exists"
  9.     objrs.Close
  10.     if msg<>"" then
  11. %>
  12. <html>
  13.     <head>
  14.         <title> <%=SiteName%> - Welcome </title>
  15.         <meta name="author" content="Jagadish">
  16.     </head>
  17.     <body bottommargin=0 topmargin=0 leftmargin=0 rightmargin=0 marginheight=0 marginwidth=0 bgcolor=#ffffff>
  18.         <table cellpadding=0 cellspacing=0 border=0 width=780 height=450>
  19.         <tr height=1>
  20.             <td width="100" bgcolor="<%=LeftColor%>"><font face=verdana size=1> </font></td>
  21.             <td width="290" bgcolor="<%=LeftColor%>"><font face=verdana size=1> </font></td>
  22.             <td width="290" bgcolor="<%=RightColor%>"><font face=verdana size=1> </font></td>
  23.             <td width="100" bgcolor="<%=RightColor%>"><font face=verdana size=1> </font></td>
  24.         </tr>
  25.         <tr>
  26.             <td bgcolor="<%=LeftColor%>" colspan=2 valign=top > <font face="courier new" size=6 color="<%=SiteNameColor%>"> <b>   <%=SiteName%> </b> </font> </td>
  27.             <td bgcolor="<%=RightColor%>" colspan=2 align=right valign=top> <font face=verdana size=2> <a href="AdsAdminHome.asp"><font color="<%=TopLinksColor%>">Home</font></a>     <a href="AdsAdminHome.asp?lo"><font color="<%=TopLinksColor%>">Logout</font></a>   </font> </td>
  28.         </tr>
  29.         <tr>
  30.             <td bgcolor="<%=LeftColor%>">   </td>
  31.             <td colspan=2 align=center height=200 bgcolor="<%=OuterTblBGColor%>">
  32.                 <table cellpadding=2 cellspacing=0 border=0>
  33.                 <tr> <td bgcolor="<%=OuterTblBorderColor%>">
  34.                 <table width="576" bgcolor=<%=OuterTblBGColor%> height=200 border=0 cellpadding=0 cellspacing=0>
  35.                 <tr>
  36.                     <th>
  37.                         <br>
  38.                         <font face=verdana size=2 color="<%=ErrMsgColor%>">
  39.                             <%=msg%> <br> <br>
  40.                             <a href="javascript:history.back();"><font color="<%=ErrMsgColor%>">Back</font></a>
  41.                         </font>
  42.                     </th>
  43.                 </tr>
  44.                 </table>
  45.                 </td> </tr>
  46.                 </table>
  47.             </td>
  48.             <td bgcolor="<%=RightColor%>">   </td>
  49.         </tr>
  50.         <tr>
  51.             <td colspan=2 bgcolor="<%=LeftColor%>">   </td>
  52.             <td colspan=2 bgcolor="<%=RightColor%>">   </td>
  53.         </tr>
  54.         </table>
  55.     </body>
  56. </html>
  57. <%
  58.         Response.End 
  59.     end if
  60.     
  61.     objrs.Open "select a.Location,a.NearByAreas,a.hoardimage, a.Direction, a.PresentDisplay, a.HoardingStatus, a.Status,a.bookingfromdate,a.todate, b.ZoneName, c.HoardingTypeName, a.Height, a.Width, c.HoardingMaterial from HoardingMaster a, ZoneMaster b, HoardingTypeMaster c where a.ZoneId=b.ZoneId and a.HoardingTypeId=c.HoardingTypeId and a.HoardingId= " + HoardingId, con, 3,3
  62.     if objrs("HoardingStatus") then
  63.         HoardingStatus = "Available"
  64.     else
  65.         HoardingStatus = "Not Available"
  66.     end if
  67. %>
  68. <html>
  69.     <head>
  70.         <title> <%=SiteName%> - Welcome </title>
  71.         <meta name="author" content="Jagadish">
  72.     </head>
  73.     <body bottommargin=0 topmargin=0 leftmargin=0 rightmargin=0 marginheight=0 marginwidth=0 bgcolor=#ffffff>
  74.         <table cellpadding=0 cellspacing=0 border=0 width=780 height=450>
  75.         <tr height=1>
  76.             <td width="100" bgcolor="<%=LeftColor%>"><font face=verdana size=1> </font></td>
  77.             <td width="290" bgcolor="<%=LeftColor%>"><font face=verdana size=1> </font></td>
  78.             <td width="290" bgcolor="<%=RightColor%>"><font face=verdana size=1> </font></td>
  79.             <td width="100" bgcolor="<%=RightColor%>"><font face=verdana size=1> </font></td>
  80.         </tr>
  81.         <tr>
  82.             <td bgcolor="<%=LeftColor%>" colspan=2 valign=top > <font face="courier new" size=6 color="<%=SiteNameColor%>"> <b>   <%=SiteName%> </b> </font> </td>
  83.             <td bgcolor="<%=RightColor%>" colspan=2 align=right valign=top> <font face=verdana size=2> <a href="AdsAdminHome.asp"><font color="<%=TopLinksColor%>">Home</font></a>     <a href="AdsAdminHome.asp?lo"><font color="<%=TopLinksColor%>">Logout</font></a>   </font> </td>
  84.         </tr>
  85.         <tr>
  86.             <td bgcolor="<%=LeftColor%>">   </td>
  87.             <td colspan=2 align=center height=200 bgcolor="<%=OuterTblBGColor%>">
  88.                 <table cellpadding=2 cellspacing=0 border=0>
  89.                 <tr> <td bgcolor="<%=OuterTblBorderColor%>">
  90.                 <table width="576" bgcolor=<%=OuterTblBGColor%> height=200 border=0 cellpadding=0 cellspacing=0>
  91.                 <tr>
  92.                     <td align=center>
  93.                         <br>
  94.                         <table width=450 cellpadding=2 cellspacing=1 border=0 bgcolor="<%=TblBGColor%>">
  95.                         <tr>
  96.                             <th colspan=3 bgcolor="<%=TblHeadBGColor%>">
  97.                                 <font face=verdana color="<%=TblHeadFGColor%>"> Hoarding Details (Id - <%=HoardingId%>)</font>
  98.                             </th>
  99.                         </tr>
  100.                         <tr bgcolor="<%=TblBGColor%>">
  101.                             <td width="35%">
  102.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> Hoarding Type </font>
  103.                             </td>
  104.                             <td width="65%">
  105.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <%=objrs("HoardingTypeName")%> </font>
  106.                             </td>
  107.                         </tr>
  108.                         <tr bgcolor="<%=TblBGColor%>">
  109.                             <td width="25%">
  110.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> Zone </font>
  111.                             </td>
  112.                             <td width="75%">
  113.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <%=objrs("ZoneName")%> </font>
  114.                             </td>
  115.                         </tr>
  116.                         <tr bgcolor="<%=TblBGColor%>">
  117.                             <td width="25%">
  118.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> Location </font>
  119.                             </td>
  120.                             <td width="75%">
  121.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <%=objrs("Location")%> </font>
  122.                             </td>
  123.                         </tr>
  124.                         <tr bgcolor="<%=TblBGColor%>">
  125.                             <td width="25%">
  126.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> Near By Areas </font>
  127.                             </td>
  128.                             <td width="75%">
  129.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <%=objrs("NearByAreas")%> </font>
  130.                             </td>
  131.                         </tr>
  132.                         <tr bgcolor="<%=TblBGColor%>">
  133.                             <td width="25%">
  134.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> Traffic Coming From </font>
  135.                             </td>
  136.                             <td width="75%">
  137.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <%=objrs("Direction")%> </font>
  138.                             </td>
  139.                         </tr>
  140.                         <tr bgcolor="<%=TblBGColor%>">
  141.                             <td width="25%">
  142.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> Height (Ft) </font>
  143.                             </td>
  144.                             <td width="75%">
  145.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <%=objrs("Height")%> </font>
  146.                             </td>
  147.                         </tr>
  148.                         <tr bgcolor="<%=TblBGColor%>">
  149.                             <td width="25%">
  150.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> Width (Ft) </font>
  151.                             </td>
  152.                             <td width="75%">
  153.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <%=objrs("Width")%> </font>
  154.                             </td>
  155.                         </tr>
  156.                         <tr bgcolor="<%=TblBGColor%>">
  157.                             <td width="25%">
  158.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> Material </font>
  159.                             </td>
  160.                             <td width="75%">
  161.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <%=objrs("HoardingMaterial")%> </font>
  162.                             </td>
  163.                         </tr>
  164.                         <tr bgcolor="<%=TblBGColor%>">
  165.                             <td width="25%">
  166.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> Present Display </font>
  167.                             </td>
  168.                             <td width="75%">
  169.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <%=objrs("PresentDisplay")%> </font>
  170.                             </td>
  171.                         </tr>
  172.                         <tr bgcolor="<%=TblBGColor%>">
  173.                             <td width="25%">
  174.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> Status </font>
  175.                             </td>
  176.                             <td width="75%">
  177.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <%=HoardingStatus%> </font>
  178.                             </td>
  179.                         </tr>
  180.                         <% if (HoardingStatus="Available") then%>
  181.                                 <tr bgcolor="<%=TblBGColor%>">
  182.                             <td width="25%">
  183.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> Booked From </font>
  184.                             </td>
  185.                             <td width="75%">
  186.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <%=objrs("Bookingfromdate")%> </font>
  187.                             </td>
  188.                         </tr>
  189.                         <tr bgcolor="<%=TblBGColor%>">
  190.                             <td width="25%">
  191.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> To </font>
  192.                             </td>
  193.                             <td width="75%">
  194.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <%=objrs("todate")%> </font>
  195.                             </td>
  196.                         </tr>
  197.                         <%end if%>
  198.             
  199.                         <tr bgcolor="<%=TblBGColor%>">
  200.                             <td width="25%">
  201.                                 <font face=verdana size=2 color="<%=TblFGColor%>"> Hoard Image </font>
  202.                             </td>
  203.                             <td width="75%">
  204.                                 <font face=verdana size=2 color="<%=ContentColor%>"> <image src="../hoardimages/<%=objrs("hoardimage")%>" width=200 height=200> </font>
  205.                                 </td>
  206.                         </tr>
  207.                         </table>
  208.                         <br>
  209.                         <font face=verdana size=2 color="<%=ContentColor%>"> Do you want to update the image </br>
  210.                         <form enctype="multipart/form-data" name="addhoardingform" method=post action="AdsAdminUpdateHoardingimage.asp">
  211.                         Select The Image</font> <input type=file name=YourFile>
  212.                         <input type=hidden name=hid value=<%=HoardingId%>><br>
  213.                         <input type=submit value="Upload">
  214.                         
  215.                         </form>
  216.                         
  217.                         </td>
  218.                 </table>
  219.                 </td> </tr>
  220.                 </table>
  221.             </td>
  222.             <td bgcolor="<%=RightColor%>">   </td>
  223.         </tr>
  224.         <tr>
  225.             <td colspan=2 bgcolor="<%=LeftColor%>">   </td>
  226.             <td colspan=2 bgcolor="<%=RightColor%>">   </td>
  227.         </tr>
  228.         </table>
  229.     </body>
  230. </html>
  231. <%
  232.     objrs.Close
  233.     set objrs = nothing
  234. %>
  235. <!-- #include file="../AdsCloseConn.asp" -->