public void AcceptUserEditRequest(string id)
        {
            int            iD   = Convert.ToInt32(id);
            AspNetSpotEdit edit = spotreq_entity.AspNetSpotEdits.FirstOrDefault(x => x.Id == iD);

            if (edit != null)
            {
                edit.active = true;
                spotreq_entity.SaveChanges();
            }
        }
        /// <summary>
        /// Decline User`s Edit Spot Permission by Request ID
        /// </summary>
        /// <param name="request_id"></param>
        public void DeclineSpotEditRequest(string request_id)
        {
            int Id;

            if (request_id != null && int.TryParse(request_id, out Id))
            {
                AspNetSpotEdit model = spotreq_entity.AspNetSpotEdits.First(x => x.Id == Id);
                if (model != null)
                {
                    spotreq_entity.AspNetSpotEdits.Remove(model);
                    spotreq_entity.SaveChanges();
                }
            }
        }
        public void AllowEdit(string id)
        {
            AspNetSpotEdit  edit = new AspNetSpotEdit();
            ApplicationUser user = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>().FindById(System.Web.HttpContext.Current.User.Identity.GetUserId());

            edit.Id       = GetLastEditRequestID() + 1;
            edit.spot_id  = id;
            edit.username = user.UserName;

            edit.active = true;

            spotreq_entity.AspNetSpotEdits.Add(edit);
            spotreq_entity.SaveChanges();
        }
 /// <summary>
 /// Deletes Editor From Specific Spot
 /// </summary>
 /// <param name="username"></param>
 /// <param name="spot_id"></param>
 public void DeleteEditorFromSpot(string username, string spot_id)
 {
     try
     {
         AspNetSpotEdit editor = spotreq_entity.AspNetSpotEdits.Where(x => x.username == username && spot_id == x.spot_id).First();
         if (editor != null)
         {
             spotreq_entity.AspNetSpotEdits.Remove(editor);
             spotreq_entity.SaveChanges();
         }
     }
     catch (Exception ex)
     {
     }
 }
        public int AddEditRequest(string id)
        {
            AspNetSpotEdit        edit = new AspNetSpotEdit();
            ApplicationUser       user = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>().FindById(System.Web.HttpContext.Current.User.Identity.GetUserId());
            List <AspNetSpotEdit> ed   = new List <AspNetSpotEdit>();

            ed = spotreq_entity.AspNetSpotEdits.Where(x => x.username == user.UserName && x.spot_id == id).ToList();
            if (ed.Count > 0)
            {
            }
            else
            {
                edit.Id       = GetLastEditRequestID() + 1;
                edit.spot_id  = id;
                edit.username = user.UserName;

                edit.active = false;

                spotreq_entity.AspNetSpotEdits.Add(edit);
                spotreq_entity.SaveChanges();
            }
            return(ed.Count);
        }