protected string getContent(CarparkInfo carpark) { string content = @"<a href = 'CarparkView.aspx?carparkName=" + carpark.CarparkID + @"' style='text-decoration:none; color: inherit;'> " + carpark.CarparkID + "<br/>" + "<img src='/UI/MallImages/" + carpark.Image + @"' style='width: 300px; height: 300px;'> " + "</a><br/> " + " <p>Carpark Availability: " + carpark.CarparkStatus + "<p/>" // + "<p>Latitude: " + carpark.Latitude + "<p/>" // + "<p>Longitude: " + carpark.Longtitude + "<p/>" + "<p>Starting Hour: " + carpark.StartHour + "<p/>" + "<p>Ending Hour: " + carpark.EndHour + "<p/>" + "<p>Address: " + carpark.CarparkLocation + "<p/>" + "<p>Slots Taken: " + carpark.SlotTaken + "<p/>" + "<p>Total Slots: " + carpark.TotalSlots + "<p/>" // + "<p> Carpark Image URL: "+carpark.Image+"<p/>" + "<a class='button' href = 'Map.aspx?CarparkName=" + carpark.CarparkID + @"&dir=1'>Get directions</a>"; return(content); }
protected void bindData() { string carparkId = Request.QueryString["carparkName"].ToString(); carparkInfo = BllcarparkInfo.getCarpark(carparkId); lblCarparkName.Text = carparkInfo.CarparkName; lblAddr.Text = carparkInfo.CarparkLocation; lblStartHr.Text = carparkInfo.StartHour.Substring(0, 5); lblEndHr.Text = carparkInfo.EndHour.Substring(0, 5); lblSlots.Text = carparkInfo.TotalSlots.ToString(); Image1.ImageUrl = "~\\UI\\MallImages\\" + carparkInfo.Image; if (carparkId == "313@Somerset") { lblLegend.Visible = true; lblAccessibleLots.Visible = true; lblAvailableLots.Visible = true; lblOccupiedLots.Visible = true; myIframe.Visible = true; myIframe.Attributes["src"] = "*****@*****.**"; //aspx locaction need to change } else if (carparkId == "Bugis Junction") { lblLegend.Visible = true; lblAccessibleLots.Visible = true; lblAvailableLots.Visible = true; lblOccupiedLots.Visible = true; myIframe.Visible = true; myIframe.Attributes["src"] = "bugisjunction.aspx"; //aspx location need to change } carparkRatesL = bllCarparkRates.getRate(carparkId); for (int i = 0; i < carparkRatesL.Count(); i++) { lblRates.Text += carparkRatesL[i].RateName + ": <br/>$" + carparkRatesL[i].InitialHrRate + " for 1st " + carparkRatesL[i].InitialTimePeriod + " hour(s), <br/>$" + carparkRatesL[i].FirstSubsequentRate + " for subsequent " + carparkRatesL[i].FirstSubsequentTimePeriod + " hour(s) <br/><br/>"; } }
protected void Page_Load(object sender, EventArgs e) { string username = Session["login"].ToString(); //string username = "******"; string strConnectionString = ConfigurationManager.ConnectionStrings["CPMDatabase"].ConnectionString; SqlConnection myConnect = new SqlConnection(strConnectionString); string strCommandText = "SELECT DISTINCT vehicleNo FROM Vehicle WHERE username = @username"; SqlCommand cmd = new SqlCommand(strCommandText, myConnect); cmd.Parameters.AddWithValue("@username", username); myConnect.Open(); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); ddlUserVehicle.DataSource = reader; ddlUserVehicle.DataTextField = "vehicleNo"; ddlUserVehicle.DataBind(); info = carparkInfo.getCarpark("313@Somerset"); lblClosing.Text = info.EndHour; lblCurrent.Text = DateTime.Now.ToString("HH:mm"); }
protected void bindAll() { string carparkId = ""; if (Request.QueryString.Keys.Count > 0) { carparkId = Request.QueryString["carparkName"].ToString(); CarparkInfo carpark = carparkInfo.getCarpark(carparkId); if (int.Parse(Request.QueryString["dir"]) == 0) { List <CarparkInfo> c = carparkInfo.getAllCarpark(); string content = getContent(carpark); mapjs.Text = @" var map; // Initialize and add the map var geocoder; function initMap() { navigator.geolocation.getCurrentPosition(function(position){ var pos={ lat: " + carpark.Latitude + @", lng: " + carpark.Longtitude + @" }; var mapOptions = { zoom:15, center:pos, disableDefaultUI:true } map = new google.maps.Map(document.getElementById('map'), mapOptions); " + getMapInfo(c) + @" }) }"; carparkjs.Text = @" document.getElementById('direction-panel').innerHTML = """ + content + @"""; "; return; } else { mapjs.Text = @" var map; // Initialize and add the map function initMap() { if(navigator.geolocation){ navigator.geolocation.getCurrentPosition(function(position){ var pos={ lat: position.coords.latitude, lng: position.coords.longitude }; var mapOptions = { zoom:15, center:pos, disableDefaultUI:true } map = new google.maps.Map(document.getElementById('map'), mapOptions); var rendererOptions = { map:map } var directionsDisplay = new google.maps.DirectionsRenderer(rendererOptions) directionsDisplay.setPanel(document.getElementById('direction-panel')); var request ={ origin : pos, destination: {lat:" + carpark.Latitude + @",lng:" + carpark.Longtitude + @"}, travelMode: 'DRIVING' } var directionsService = new google.maps.DirectionsService() directionsService.route(request, function(result, status){ if(status=='OK'){ directionsDisplay.setDirections(result); } }) }); } } "; return; } } List <CarparkInfo> carparks = carparkInfo.getAllCarpark(); initializeMap(getMapInfo(carparks)); }