//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 List <finaltable> PrintData()
{
SquatDBEntities db = new SquatDBEntities();
List <finaltable> PinList = db.finaltables.ToList();
return(PinList);
}
