public AspNetSpot GetSpotDataByID(string id) { AspNetSpot result = new AspNetSpot(); result = spot_entity.AspNetSpots.Find(Convert.ToInt32(id)); return(result); }
public ActionResult RequestSpot(AspNetSpot model, HttpPostedFileBase[] files, string desc) { model.desc = desc; foreach (HttpPostedFileBase file in files) { if (file != null) { string filename = Path.GetFileName(file.FileName); filename = DateTime.Now.ToString("hh.mm.ss.ffffff") + filename; string path = Path.Combine(Server.MapPath("~/Content/SpotImages"), filename); file.SaveAs(path); ViewBag.Message = "File uploaded successfully"; dbcon.AddPhotoPath(Convert.ToString(dbcon.GetLastSpotID() + 1), file.FileName); } } if (files[0] == null) { dbcon.AddPhotoPath(Convert.ToString(dbcon.GetLastSpotID() + 1), "default.png"); } dbcon.AddSpotRequest(model); dbcon.AllowEdit(dbcon.GetLastSpotID().ToString()); dbcon.AddNewAction("Requested new spot with ID = " + dbcon.GetLastSpotID()); return(View()); }
public ActionResult AddSpot(string lon, string lat) { AspNetSpot model = new AspNetSpot(); return(View(model)); }
public void AcceptSpotRequest(string id) { int ID = Convert.ToInt32(id); AspNetSpot spot = spot_entity.AspNetSpots.FirstOrDefault(x => x.Id == ID); spot.added = true; spot.visible = true; spot_entity.SaveChanges(); }
/// <summary> /// Requests Spot Addition to Map /// </summary> /// <param name="model"></param> public void AddSpotRequest(AspNetSpot model)//Make Spot request { ApplicationUser user = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>().FindById(System.Web.HttpContext.Current.User.Identity.GetUserId()); model.author = user.UserName; model.Id = GetLastSpotID() + 1; model.visible = false; model.added = false; spot_entity.AspNetSpots.Add(model); spot_entity.SaveChanges(); }
/// <summary> /// Adds Spot To Map /// </summary> /// <param name="model"></param> public void AddSpot(AspNetSpot model)//Add Spot As Admin or moder { ApplicationUser user = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>().FindById(System.Web.HttpContext.Current.User.Identity.GetUserId()); model.Id = GetLastSpotID() + 1; model.added = true; model.author = user.UserName; spot_entity.AspNetSpots.Add(model); spot_entity.SaveChanges(); }
public void DeleteSpot(string id) { int iD = Convert.ToInt32(id); AspNetSpot spot = spot_entity.AspNetSpots.Find(iD); if (spot != null) { DeleteSpotPhotos(id); DeleteSpotEditors(id); DeleteSpotComments(id); DeleteSpotRatings(id); DeleteSpotFromFavoriteTable(id); spot_entity.AspNetSpots.Remove(spot); spot_entity.SaveChanges(); } }
public ActionResult UpdateSpot(string id) { AspNetSpot spot = new AspNetSpot(); spot = dbcon.GetSpotDataByID(id); ViewBag.spotid = id; ViewBag.photos = dbcon.GetAllSpotPhotosByID(id); if (spot == null || spot.author != user.UserName && spot.@public == false) { return(View("Error")); } return(View(spot)); }
public void UpdateSpot(AspNetSpot model) { AspNetSpot spot = spot_entity.AspNetSpots.FirstOrDefault(x => x.Id == model.Id); spot.title = model.title; spot.desc = model.desc; spot.lat = model.lat; spot.lon = model.lon; if (model.visible != null) { spot.visible = model.visible; } if (model.@public != null) { spot.@public = model.@public; } spot.added = true; if (model.author != null) { spot.author = model.author; } spot_entity.SaveChanges(); }
public ActionResult UpdateSpot(AspNetSpot model, HttpPostedFileBase[] files, string desc) { model.desc = desc; if (files[0] != null) { foreach (HttpPostedFileBase file in files) { if (file != null) { string path = Path.Combine(Server.MapPath("~/Content/SpotImages"), Path.GetFileName(file.FileName)); file.SaveAs(path); ViewBag.Message = "File uploaded successfully"; dbcon.AddPhotoPath(Convert.ToString(model.Id), file.FileName); } } } dbcon.UpdateSpot(model); dbcon.AddNewAction("Updated spot with ID = " + model.Id); return(RedirectToAction("Map", "Home")); }
public ActionResult Details(string id) //View Spot Details By Id { ViewBag.Username = user.UserName; AspNetSpot spot = new AspNetSpot(); spot = dbcon.GetSpotDataByID(id); if (spot == null || spot.author != user.UserName && spot.@public == false) { return(View("Error")); } det_view_model.SpotData = spot; det_view_model.SpotComments = dbcon.GetSpotCommentsByID(id); det_view_model.Usernames = dbcon.GetCommentUsernameByID(id); det_view_model.Date = dbcon.GetSpotCommentDateByID(id); det_view_model.Rating = Convert.ToString(dbcon.GetSpotRatingValueByID(id)); det_view_model.editor = dbcon.CheckUserEditor(id); det_view_model.photos = dbcon.GetAllSpotPhotosByID(id); det_view_model.favorite = dbcon.CheckInFavoriteByID(id); det_view_model.SpotComments.Reverse(); det_view_model.Usernames.Reverse(); det_view_model.Date.Reverse(); return(View(det_view_model)); }