public ActionResult DeleteConfirmed(string id)
{
RPlace rPlace = db.RPlace.Find(id);
db.RPlace.Remove(rPlace);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Name,Adress,Rating,latitude,longitude,Total_rating_people,Photo_reference,Field_id")] RPlace rPlace)
{
if (ModelState.IsValid)
{
db.Entry(rPlace).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Field_id = new SelectList(db.Field, "Id", "FieldName", rPlace.Field_id);
return(View(rPlace));
}
// GET: RPlaces/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RPlace rPlace = db.RPlace.Find(id);
if (rPlace == null)
{
return(HttpNotFound());
}
return(View(rPlace));
}
// GET: RPlaces/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RPlace rPlace = db.RPlace.Find(id);
if (rPlace == null)
{
return(HttpNotFound());
}
ViewBag.Field_id = new SelectList(db.Field, "Id", "FieldName", rPlace.Field_id);
return(View(rPlace));
}
public void GetData(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 = "Church";
}
string type = input1.Replace(' ', '+');
string inornear = "+near+";
if (String.IsNullOrEmpty(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());
foreach (var item in dynJson)
{
RPlace place = new RPlace();
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.Total_rating_people = Convert.ToInt32(item.user_ratings_total);
place.Field_id = 2;
RPlace place2 = db.RPlace.FirstOrDefault(m => m.Id == place.Id /*&& m.Name == place.Name && m.Adress == place.Adress*/);
if (place2 == null)
{
db.RPlace.Add(place);
db.SaveChanges();
}
}
response.Close();
}
// GET: RPlaces
public ActionResult Index(string searchString, string searchString1)
{
GetData(searchString, searchString1);
RPlace rplace = new RPlace();
var rplaces = db.RPlace.Include(p => p.Field).OrderByDescending(a => a.Rating);
var ps = from s in rplaces
select s;
if (!(String.IsNullOrEmpty(searchString) && String.IsNullOrEmpty(searchString1)))
{
ps = ps.Where(s => s.Adress.Contains(searchString) && s.Photo_reference.Contains(searchString1));
}
RPlace 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/ReligionTwitterSearch.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());
}