// GET: Places/Delete/5 public ActionResult Delete() { using (StreamReader reader = new StreamReader(Server.MapPath("~/Content/sportsTwitterSearch.json"))) { string result = reader.ReadToEnd(); var json = JObject.Parse(result); var trend = json["statuses"]; var stwitters = new List <Stwitter>(); dynamic dynJson = JsonConvert.DeserializeObject(trend.ToString()); foreach (var item in dynJson) { Stwitter stwitter = new Stwitter(); stwitter.Screen_name = item["user"]["screen_name"]; stwitter.Created_at = item["created_at"]; stwitter.Url = item["user"]["url"]; stwitter.Text = item["text"]; stwitter.User_description = item["user"]["description"]; stwitter.Followers_count = item["user"]["followers_count"]; stwitter.Friends_count = item["user"]["friends_count"]; stwitter.Profile_image_url = item["user"]["profile_image_url"]; if (item["user"]["url"] == "None") { stwitter.Url = "https://twitter.com"; } stwitters.Add(stwitter); } //var trends = JsonConvert.DeserializeObject<List<Trend>>(trend).Take(12); ViewData["sportsTwitter"] = stwitters.Take(3); } return(View()); }
// GET: Places/Details/5 //Get food type data public ActionResult Details(string searchString, string searchString1) { GetFoodData(searchString, searchString1); Place place = new Place(); var places = db.Place.Include(p => p.Field).Where(s => s.Field_id == 4).OrderByDescending(a => a.Rating); var ps = from s in places select s; if (!(String.IsNullOrEmpty(searchString) && String.IsNullOrEmpty(searchString1))) { ps = ps.Where(s => s.Adress.Contains(searchString) && s.Photo_reference.Contains(searchString1)); } Place pl = ps.FirstOrDefault(); if (pl == null) { ViewData["Message"] = "Sorry, there is no clubs in your suburb!You can select Melbourne to see all"; } else { ViewData["Message"] = null; } ViewData["Places"] = ps; using (StreamReader reader = new StreamReader(Server.MapPath("~/Content/foodTwitterSearch.json"))) { string result = reader.ReadToEnd(); //var json = JObject.Parse(result); var json = JObject.Parse(result); var trend = json["statuses"]; var stwitters = new List <Stwitter>(); dynamic dynJson = JsonConvert.DeserializeObject(trend.ToString()); foreach (var item in dynJson) { Stwitter stwitter = new Stwitter(); stwitter.Screen_name = item["user"]["screen_name"]; stwitter.Created_at = item["created_at"]; stwitter.Url = item["user"]["url"]; stwitter.Text = item["text"]; stwitter.User_description = item["user"]["description"]; stwitter.Followers_count = item["user"]["followers_count"]; stwitter.Friends_count = item["user"]["friends_count"]; stwitter.Profile_image_url = item["user"]["profile_image_url"]; if (item["user"]["url"] == "None") { stwitter.Url = "https://twitter.com"; } stwitters.Add(stwitter); } //var trends = JsonConvert.DeserializeObject<List<Trend>>(trend).Take(12); ViewData["sportsTwitter"] = stwitters; } return(View()); }