//this action sends all data in the program to the db public ActionResult SendData(finaltable coordinates) { string reported = ""; //assigning values to the new object being passed in coordinates.flagged = "Y"; coordinates.username = User.Identity.GetUserId(); coordinates.datereported = DateTime.Now; coordinates.reportedtimes = 1; //opening the db SquatDBEntities db = new SquatDBEntities(); //adding the object to the DB db.finaltables.Add(coordinates); try { //saving the db db.SaveChanges(); } catch { //same primary key will prevent the new object from being saved, this will alert the user letting them know reported = "Already Reported!"; } //sending the message using temp data TempData["reported"] = reported; //return View(); return(RedirectToAction("Redirect", "Map")); }
public ActionResult DeleteReport(string DeleteName) { //action that allows us to delete reports finaltable ToDelete = db.finaltables.Find(DeleteName); db.finaltables.Remove(ToDelete); db.SaveChanges(); return(RedirectToAction("MyReportsView", "Owner")); }
public ActionResult UnFlag(string UpdateName) { //allows take the url value and fing the correct item to flag finaltable FindItem = db.finaltables.Find(UpdateName); if (FindItem.username == User.Identity.GetUserId()) { return(View("MyReportsView", FindItem)); } return(View("OwnerView", FindItem)); }
public ActionResult TickReport(string ReportCount) { //action that allows us to add a value to the times reported finaltable ReportNumber = db.finaltables.Find(ReportCount); int count = Convert.ToInt32(ReportNumber.reportedtimes); int newcount = (count + 1); ReportNumber.reportedtimes = Convert.ToByte(newcount); db.SaveChanges(); return(RedirectToAction("OwnerView", "Owner")); }
public ActionResult UpdateComments(string ToBeUpdated) { //allows us to update changes made to the comments field and limit access to non owners ViewBag.Name = User.Identity.GetUserName(); finaltable FindItem = db.finaltables.Find(ToBeUpdated); if (FindItem.username == User.Identity.GetUserId()) { return(View("AccountReportsView", FindItem)); } else { return(View("DetailsView", FindItem)); } }
public ActionResult SaveComments(finaltable ToBeUpdated) { //allows us to save changes made to the comments field and limit access to non owners finaltable FindItem = db.finaltables.Find(ToBeUpdated.address); FindItem.comments = ToBeUpdated.comments; db.SaveChanges(); if (FindItem.username == User.Identity.GetUserId()) { return(RedirectToAction("MyReportsView")); } else { return(RedirectToAction("OwnerView")); } }
public ActionResult SaveMyFlag(string flagname) { //changes the flag value in the myreports view and saves changes finaltable FindItem = db.finaltables.Find(flagname); if (FindItem.flagged == "Y") { FindItem.flagged = "N"; } else { FindItem.flagged = "Y"; } db.SaveChanges(); return(RedirectToAction("MyReportsView")); }