//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); }