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