public List <APlace> GetFoodsData(string input, string input1)
{
//db.Places.clear();
//string url = @"https://maps.googleapis.com/maps/api/place/textsearch/json?query=fitness+center+in+caulfield+east&key=AIzaSyD9LUlNJjOHpdMmBFzYkLpuC91VlO5McLg";
string str1 = "https://maps.googleapis.com/maps/api/place/textsearch/json?query=";
if (String.IsNullOrEmpty(input1))
{
input1 = "Cafe";
}
string type = input1.Replace(' ', '+');
string inornear = "+near+";
if (String.IsNullOrEmpty(input))
{
input = "melbourne";
}
else
{
input = input + " melbourne";
}
string suburb = input.Replace(' ', '+');
string key = "&key=AIzaSyD9LUlNJjOHpdMmBFzYkLpuC91VlO5McLg";
string str = str1 + type + inornear + suburb + key;
string url = @str;
WebRequest request = WebRequest.Create(url);
WebResponse response = request.GetResponse();
Stream data = response.GetResponseStream();
StreamReader reader = new StreamReader(data);
// json-formatted string from maps api
string responseFromServer = reader.ReadToEnd();
var jsonObject = JObject.Parse(responseFromServer);
var json = jsonObject["results"];
dynamic dynJson = JsonConvert.DeserializeObject(json.ToString());
var places = new List <APlace>();
foreach (var item in dynJson)
{
APlace place = new APlace();
place.Id = item["id"];
place.Name = item["name"];
place.Photo_reference = input1;
place.Latitude = item["geometry"]["location"]["lat"];
place.Longitude = item["geometry"]["location"]["lng"];
place.Rating = (decimal)Convert.ToSingle(item.rating);
place.Adress = item.formatted_address;
place.Icon = item.icon;
place.Total_rating_people = Convert.ToInt32(item.user_ratings_total);
place.Field_id = 4;
place.Star = (place.Rating / 5).ToString("0.0%");
if (input1 == "Cafe")
{
place.Label = "C";
}
else if (input1 == "Restaurant")
{
place.Label = "R";
}
else if (input1 == "Pubs")
{
place.Label = "P";
}
places.Add(place);
}
response.Close();
return(places);
}
// GET: Places
public ActionResult Index(string searchString, string searchString1)
{
//GetData(searchString);
//Place place = new Place();
//var places = db.Place.Include(p => p.Field).Where(s => s.Field_id == 1).OrderByDescending(a => a.Rating);
var places = GetSportsData(searchString, searchString1);
var ps = from s in places
select s;
if (!(String.IsNullOrEmpty(searchString)))
{
ps = ps.Where(s => s.Adress.Contains(searchString));
}
APlace pl = ps.FirstOrDefault();
if (pl == null)
{
ViewData["Message"] = "Sorry, there is no club 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/sportsTwitterSearch.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.Take(5);
}
return(View());
}