public int UpdateRating_lv4(string place_id, int num_lv4)
{
PlaceRatingEntity db = new PlaceRatingEntity();
var db_place = (from place in db.place_rating where place.place_id == place_id select place).FirstOrDefault();
if (db_place != null)
{
db_place.num_lv4 = num_lv4;
db.SaveChanges();
}
return(num_lv4);
}
public ActionResult SearchResult(string keyword)
{
ViewBag.searchKeyWord = keyword;
ViewBag.HasResult = true;
//UpdateDBNow();
//var db = new BuildingContext();
//var query = from b in db.Buildinginfoes select b;
//List<Buildinginfo> buildings = query.ToList();
//Debug.WriteLine("HELLO" + buildings.Count());
/*
* Get the search result from Google Place API
* Centre: Melbourne CBD
* Distance: 7 km
*/
var url = "https://maps.googleapis.com/maps/api/place/textsearch/json?query=" +
keyword + "&location=-37.808163434,144.957829502&radius=7000®ion=au&key=AIzaSyDvXKR7iiGAvHykADgGEOxuurUSr4ukJ08";
var jsonString = Download_JSON(url);
//Debug.WriteLine(jsonString);
var searchResponse = JsonConvert.DeserializeObject <SearchResponse.RootObject>(jsonString);
SearchResponse.Result[] searchResult = searchResponse.results;
if (searchResult.Length == 0)
{
ViewBag.HasResult = false;
}
/*
* For each search result, get the detail from Google Detail API
*/
List <PlaceDetail.Result> place_details = new List <PlaceDetail.Result>();
PlaceRatingEntity db = new PlaceRatingEntity();
foreach (Result r in searchResult)
{
var place_id = r.place_id;
url = "https://maps.googleapis.com/maps/api/place/details/json?placeid=" +
place_id + "&key=AIzaSyDvXKR7iiGAvHykADgGEOxuurUSr4ukJ08";
jsonString = Download_JSON(url);
//Debug.WriteLine(jsonString);
var detailResponse = JsonConvert.DeserializeObject <PlaceDetail.Rootobject>(jsonString);
PlaceDetail.Result detailResult = detailResponse.result;
if (r.photos != null)
{
detailResult.photo_reference = r.photos[0].photo_reference;
}
var db_place = (from place in db.place_rating where place.place_id == place_id select place).FirstOrDefault();
if (db_place == null) // if this place has no record in database
{
place_rating place_Rating = new place_rating
{
place_id = place_id,
num_lv1 = 0,
num_lv2 = 0,
num_lv3 = 0,
num_lv4 = 0
};
db.place_rating.Add(place_Rating);
db.SaveChanges();
;
}
else
{
detailResult.rating_lv1 = (int)db_place.num_lv1;
detailResult.rating_lv2 = (int)db_place.num_lv2;
detailResult.rating_lv3 = (int)db_place.num_lv3;
detailResult.rating_lv4 = (int)db_place.num_lv4;
}
//Debug.WriteLine(detailResult.name);
//foreach (Buildinginfo b in buildings)
//{
// if (b.x_coordinate != null && b.y_coordinate != null)
// {
// if (Has_Accessible_Info(float.Parse(b.y_coordinate), float.Parse(b.x_coordinate),
// detailResult.geometry.location.lat, detailResult.geometry.location.lng))
// {
// detailResult.accessibility_rating = b.accessibility_rating;
// detailResult.accessibility_description = b.accessibility_type_description;
// break;
// }
// else
// {
// detailResult.accessibility_rating = "N/A";
// detailResult.accessibility_description = "N/A";
// }
// }
//}
place_details.Add(detailResult);
}
// sort by accessibility rating first, then sort by rating
place_details = place_details.OrderByDescending(p => p.rating).ToList();
TempData["place_details"] = place_details;
// Uncomment this to enable paged display
// Also need to modify view
//int pageNumber = (page ?? 1);
//int pageSize = 10;
//return View(place_details.ToPagedList(pageNumber, pageSize));
return(View(place_details));
}
public ActionResult ResultDetail(string place_id)
{
//if (id == null)
//{
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
//}
List <PlaceDetail.Result> place_details = (List <PlaceDetail.Result>)TempData["place_details"];
TempData["place_details"] = place_details;
Debug.WriteLine("Passed: " + place_id);
Debug.WriteLine("Compare: " + place_details[0].place_id);
PlaceDetail.Result detail = place_details.Where(d => d.place_id == place_id).First();
if (detail == null)
{
return(HttpNotFound());
}
StreamReader reader = new StreamReader(Server.MapPath("~/GeoJSON/3D Development Activity Model Footprints.geojson"), System.Text.Encoding.Default);
string dev_string = reader.ReadToEnd().ToString();
ViewBag.dev = dev_string;
var time = Stopwatch.StartNew();
using (FileStream fs = System.IO.File.Open(Server.MapPath("~/GeoJSON/Footpath steepness_simplified.geojson"), FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
using (BufferedStream bs = new BufferedStream(fs))
using (StreamReader sr = new StreamReader(bs))
{
string stp_string = sr.ReadToEnd().ToString();
ViewBag.stp = stp_string;
Debug.WriteLine("Takes time: " + time.Elapsed.TotalMilliseconds);
}
//reader = new StreamReader(Server.MapPath("~/GeoJSON/Footpath steepness.geojson"));
//string stp_string = reader.ReadToEnd().ToString();
//ViewBag.stp = stp_string;
//reader = new StreamReader(Server.MapPath("~/GeoJSON/Road segments, with surface type.geojson"));
//string con_string = reader.ReadToEnd().ToString();
//ViewBag.con = con_string;
PlaceRatingEntity db = new PlaceRatingEntity();
var db_place = (from place in db.place_rating where place.place_id == detail.place_id select place).FirstOrDefault();
if (db_place == null) // if this place has no record in database
{
place_rating place_Rating = new place_rating
{
place_id = detail.place_id,
num_lv1 = 0,
num_lv2 = 0,
num_lv3 = 0,
num_lv4 = 0
};
db.place_rating.Add(place_Rating);
db.SaveChanges();
;
}
else
{
detail.rating_lv1 = (int)db_place.num_lv1;
detail.rating_lv2 = (int)db_place.num_lv2;
detail.rating_lv3 = (int)db_place.num_lv3;
detail.rating_lv4 = (int)db_place.num_lv4;
}
return(View(detail));
}