public ActionResult DeleteConfirmed(int id)
{
MadeActivites madeActivites = db.MadeActivites.Find(id);
db.MadeActivites.Remove(madeActivites);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "NameOfActivity,LocationOfActivity,Latitude,Longitude,City,State,TimeOfActivity,HowManyMembersInvolved,EstimatedCostOfActivity")] MadeActivites madeActivites)
{
if (ModelState.IsValid)
{
db.Entry(madeActivites).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(madeActivites));
}
public ActionResult Edit(MadeActivites madeActivites)
{
if (ModelState.IsValid)
{
db.Entry(madeActivites).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
//ViewBag.EventId = new SelectList(db.CreateEvents, "Id", "EventsName", madeActivites.EventId);
return(View(madeActivites));
}
public ActivitesInfo AddDataPoint(MadeActivites madeActivites)
{
ActivitesInfo activitesInfo = new ActivitesInfo();
activitesInfo.ActivityName = madeActivites.NameOfActivity;
activitesInfo.CostOfActivity = madeActivites.EstimatedCostOfActivity;
activitesInfo.InfoId = madeActivites.MadeActivitesId;
db.ActivitesInfos.Add(activitesInfo);
db.SaveChanges();
return(activitesInfo);
}
public ActionResult AddingCost(MadeActivites madeActivites)
{
var madeActivitesMaxCost = db.MadeActivites.Select(a => a.EstimatedCostOfActivity).FirstOrDefault();
var madeActivitesMinCost = db.MadeActivites.Select(m => m.EstimatedMinimumCostOfActivity).FirstOrDefault();
madeActivites.EstimatedCostOfActivity = madeActivitesMaxCost;
madeActivites.EstimatedMinimumCostOfActivity = madeActivitesMinCost;
ViewBag.MaxCost = madeActivitesMaxCost;
ViewBag.MinCost = madeActivitesMinCost;
return(View());
}
// GET: MadeActivites/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MadeActivites madeActivites = db.MadeActivites.Find(id);
if (madeActivites == null)
{
return(HttpNotFound());
}
return(View(madeActivites));
}
// GET: Home
public ActionResult FoodBreakDown(int?id)
{
MadeActivites currentUser = context.MadeActivites.Where(x => x.PlannerId == id).FirstOrDefault();
//var typeOfActivity = context.MadeActivites.Select(t => t.TypeOfActivity).ToList();
//var foodDrink = typeOfActivity.Where(f => f.Contains("Food/Drink")).ToList();
string nameOfActivity = currentUser.NameOfActivity;
double estimatedCost = currentUser.EstimatedCostOfActivity;
double minCost = currentUser.EstimatedMinimumCostOfActivity;
//var typeOfActivity = currentUser.Select(d => d.Contains("Food/Drink")).ToLIst();
//ViewBag.typeofActivity = JsonConvert.SerializeObject(foodDrink);
ViewBag.nameOfActivity = nameOfActivity;
ViewBag.estimatedCost = JsonConvert.SerializeObject(estimatedCost);
ViewBag.minCost = JsonConvert.SerializeObject(minCost);
return(View());
////this matches the PlannerId of the current user
//MadeActivites currentUser = context.MadeActivites.Where(x => x.PlannerId == id).FirstOrDefault();
////declaring local variables
//double estimatedCost = currentUser.EstimatedCostOfActivity;
//var typeOfActivity = currentUser.TypeOfActivity;
////query for typeofActivity
//var foodDrink = context.MadeActivites.Where(x => x.TypeOfActivity.Contains("Food/Drink")).Distinct();
//var leisure = context.MadeActivites.Where(x => x.TypeOfActivity.Contains("Leisure")).First();
//var entertainment = context.MadeActivites.Where(x => x.TypeOfActivity.Contains("Entertainment")).First();
////this sends the variables to the view
//ViewBag.foodDrink =foodDrink;
//ViewBag.leisure = JsonConvert.SerializeObject(leisure);
//ViewBag.entertainment = JsonConvert.SerializeObject(entertainment);
//ViewBag.estimatedCost = JsonConvert.SerializeObject(estimatedCost);
//return View();
////this matches the PlannerId of the current user
//MadeActivites currentUser = context.MadeActivites.Where(x => x.PlannerId == id).FirstOrDefault();
////declaring variables
//double estimatedCost = currentUser.EstimatedCostOfActivity;
//var typeOfActivity = currentUser.TypeOfActivity;
//var foodDrinkActivity = "Food/Drink";
////query for typeOfActivity
//var foodDrink = context.MadeActivites.Where(x => typeOfActivity.Contains("Food/Drink")).Select(x => foodDrinkActivity);
////this sends the variables to the view
//ViewBag.foodDrink = JsonConvert.SerializeObject(foodDrink);
//ViewBag.estimatedCost = JsonConvert.SerializeObject(estimatedCost);
//return View();
}
// GET: MadeActivites/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MadeActivites madeActivites = db.MadeActivites.Find(id);
if (madeActivites == null)
{
return(HttpNotFound());
}
//ViewBag.EventId = new SelectList(db.CreateEvents, "Id", "EventsName", madeActivites.EventId);
return(View(madeActivites));
}
public ActionResult EntertainmentBreakDown(int?id)
{
MadeActivites currentUser = context.MadeActivites.Where(x => x.PlannerId == id).FirstOrDefault();
//var typeOfActivity = context.MadeActivites.Select(t => t.TypeOfActivity).ToList();
//var entertainment = typeOfActivity.Where(f => f.Contains("Entertainment")).ToList();
string nameOfActivity = currentUser.NameOfActivity;
double estimatedCost = currentUser.EstimatedCostOfActivity;
double minCost = currentUser.EstimatedMinimumCostOfActivity;
//var typeOfActivity = currentUser.Select(d => d.Contains("Food/Drink")).ToLIst();
//ViewBag.typeofActivity = JsonConvert.SerializeObject(entertainment);
ViewBag.nameOfActivity = nameOfActivity;
ViewBag.estimatedCost = JsonConvert.SerializeObject(estimatedCost);
ViewBag.minCost = JsonConvert.SerializeObject(minCost);
return(View());
}
public ActionResult ActivitiesBreakdown(int?id)
{
MadeActivites currentUser = context.MadeActivites.Where(x => x.PlannerId == id).FirstOrDefault();
//var typeofActivity = context.MadeActivites.Select(d => d.TypeOfActivity).ToList();
// var foodDrink = typeofActivity.Where(f => f.Contains("Food/Drink")).ToList();
//int foodDrinkCount = foodDrink.Count();
//ViewBag.foodDrink = JsonConvert.SerializeObject(foodDrinkCount);
//var entertainment = typeofActivity.Where(e => e.Contains("Entertainment")).ToList();
//int entertainmentCount = entertainment.Count();
//ViewBag.entertainment = JsonConvert.SerializeObject(entertainmentCount);
//var leisure = typeofActivity.Where(l => l.Contains("Leisure")).ToList();
//int leisureCount = leisure.Count();
//ViewBag.leisure = JsonConvert.SerializeObject(leisureCount);
return(View());
}
public async Task <ActionResult> Create([Bind(Include = "NameOfActivity,LocationOfActivity,Latitude,Longitude,City,State,TimeOfActivity,HowManyMembersInvolved,EstimatedCostOfActivity")] MadeActivites madeActivites)
{
if (ModelState.IsValid)
{
string apiCall = "https://maps.googleapis.com/maps/api/geocode/json?address=" + AddPluses(madeActivites.LocationOfActivity) + ",+" + AddPluses(madeActivites.City) + ",+" + AddPluses(madeActivites.State) + "&key=AIzaSyBeWLVk14n3OzLLKLvDvUyWspH929EcEaY";
HttpClient client = new HttpClient();
//make a request for api call set up base address url
client.BaseAddress = new Uri(apiCall);
HttpResponseMessage response = await client.GetAsync(apiCall);
LocationInfo location = JsonConvert.DeserializeObject <LocationInfo>(await response.Content.ReadAsStringAsync());
madeActivites.Latitude = location.Results[0].Geometry.Location.Lat.ToString();
madeActivites.Longitude = location.Results[0].Geometry.Location.Lng.ToString();
db.MadeActivites.Add(madeActivites);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(madeActivites));
}
public ActionResult Create(MadeActivites madeActivites)
{
if (ModelState.IsValid)
{
//db.MadeActivites.Add(madeActivites);
//db.SaveChanges();
var plannerId = db.Planners.Select(x => x.Id).FirstOrDefault();
//int createEventId = db.CreateEvents.Select(x => x.PlannerId).FirstOrDefault();
madeActivites.PlannerId = plannerId;
madeActivites.Country = "USA";
var addressConvert = ConvertAddressToGoogleFormat(madeActivites);
var geolocateInfo = GeoLocate(addressConvert);
madeActivites.Latitude = geolocateInfo.results[0].geometry.location.lat;
madeActivites.Longitude = geolocateInfo.results[0].geometry.location.lng;
db.MadeActivites.Add(madeActivites);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//ViewBag.EventId = new SelectList(db.CreateEvents, "Id", "EventsName", madeActivites.EventId);
return(View(madeActivites));
}
public string ConvertAddressToGoogleFormat(MadeActivites madeActivites)
{
string googleFormatAddress = AddPluses(madeActivites.StreetAddress) + "," + AddPluses(madeActivites.City) + "," + AddPluses(madeActivites.StateAbbreviation) + "," + AddPluses(madeActivites.ZipCode) + "," + AddPluses(madeActivites.Country);
return(googleFormatAddress);
}
// GET: MadeActivites/Create
public ActionResult Create()
{
MadeActivites madeActivites = new MadeActivites();
return(View());
}
