<%@ page language="java" import ="java.sql.*, java.util.Date,java.text.*" errorPage="errorPage.jsp?errPage=make_your_trip/hotel-reservation/CancellationPolicy" %> <% response.sendRedirect("planyourtrip.jsp"); response.setHeader("Cache-Control","no-store"); response.setHeader("Pragma","no-cache"); //HTTP 1.0 response.setDateHeader ("Expires", 0); String msg = request.getParameter("msg") == null ? "" : request.getParameter("msg"); DecimalFormat df = new DecimalFormat("###.00"); java.util.Date currentDate = new java.util.Date(); String dtChk = (currentDate.getYear()+1900)+"-"+(currentDate.getMonth()+1)+"-"+(currentDate.getDate()); String keycode_cash = request.getParameter("keycode")==null?"00000":request.getParameter("keycode"); //-------- TESTING CODE --------// /*long curdate = new java.util.GregorianCalendar((currentDate.getYear()+1900), (currentDate.getMonth()+1), (currentDate.getDate()+1)).getTime().getTime(); //Current Date long visitdate = new java.util.GregorianCalendar(2006, 11, 28).getTime().getTime(); double difference = visitdate - curdate; long days = Math.round((difference/(1000*60*60*24))); System.out.println("TOTAL NO OF DAYS : " + days); SimpleDateFormat exp_formatter = new SimpleDateFormat("HH"); String HourTime = exp_formatter.format(new java.util.Date()); SimpleDateFormat exp_formatter1 = new SimpleDateFormat("mm"); String MinuteTime = exp_formatter1.format(new java.util.Date()); System.out.println("Railway Hour Time : " + HourTime + " Minute Time : " + MinuteTime); //---- Getting Time From Data base -----// String qry1 = "select releseqota_time from user_info where lower(isadmin) = lower('yes')"; String dbtime =""; String dbHrTime =""; String dbMinTime =""; int AddCutBookingSeat =0; ResultSet rs = dbconn.FetchRecordset(qry1); if (rs.next()) { dbtime = rs.getString("releseqota_time"); } dbHrTime = dbtime.substring(0,dbtime.indexOf(":")); dbMinTime = dbtime.substring(dbtime.indexOf(":")+1); System.out.println("Railway Time From DB Hour Time : " + dbHrTime + " Minute Time : " + dbMinTime); if (Integer.parseInt(HourTime)>Integer.parseInt(dbHrTime)) { AddCutBookingSeat = 1; } else if (Integer.parseInt(HourTime)==Integer.parseInt(dbHrTime)) { if (Integer.parseInt(MinuteTime)>Integer.parseInt(dbMinTime)) { AddCutBookingSeat = 1; } } System.out.println("AddCutBookingSeat : " + AddCutBookingSeat); */ %> Rajasthan Wildlife,Wild Life Rajasthan,Rajasthan Wildlife Sanctuary
<% try{ %>
<% //session.setAttribute("bookingtype",bookingType); //session.setAttribute("cash_username",cash_username); session.setAttribute("keycode_cash",keycode_cash); ResultSet rsVh =null; ResultSet rsTu = null; ResultSet rsCost = null; int vhcode =0; int tucode =0; String tcost ="0"; String vn =""; String qry ="select vehicletypemastercode, vehicletypemastername from vehicletypemaster where lower(vip_flag)='n'"; rsVh = dbconn.FetchRecordset(qry); if (rsVh.next()) { do { vn = rsVh.getString("vehicletypemastername"); vhcode = rsVh.getInt("vehicletypemastercode"); %> <% qry ="select touristtypemastercode ,touristtypemastername from touristtypemaster"; rsTu = dbconn.FetchRecordset(qry); while(rsTu.next()) { vn= rsTu.getString("touristtypemastername"); tucode = rsTu.getInt("touristtypemastercode"); qry ="select vehicletypemastercode, touristtypemastercode, " + "(vehiclerent + touristentryfees + vehicleentryfees + guidefee + mgtfee) as tcost " + " from chargesmaster where vehicletypemastercode = "+ vhcode + " and " + " touristtypemastercode =" + tucode + " and to_date('" + dtChk + "','yyyy-mm-dd') >= to_date(tranfromdate,'yyyy-mm-dd') " + " and to_date('" + dtChk + "','yyyy-mm-dd') <= to_date(trantodate,'yyyy-mm-dd')"; rsCost = dbconn.FetchRecordset(qry); if(rsCost.next()) { do { tcost = rsCost.getString("tcost"); %> <% }while(rsCost.next()); } else { %> <% } rsCost.close(); } }while(rsVh.next()); rsVh.close(); } rsVh.close(); %>
Tariff Per Seat in Rs.
Park Visit Charges For <%=vn%>
<%=vn%> <%=df.format(Float.parseFloat(tcost))%>
<%=vn%>  
  My Bookings   Edit Profile
 
<%if(!msg.equals("")) { %> <% } %>

 

<%= msg%>

Plan Your Trip
No of Person :-
Vehicle:-
Date:-
PARK IS CLOSED
At Present Online Ticket Booking is Closed
Will be Made LIVE Soon !!
    

If you have any query , please feel free to contact  ranthambhore@rajasthanwildlife.in

[footer.htm]
<% } catch(Exception e) { e.printStackTrace(); } finally { try { dbconn.Closeallconnection(); } catch(Exception ec) { ec.printStackTrace(); } } %>