public JsonResult DownVote(string id) { var newid = Int32.Parse(id); ContentSharingEntities1 DB = new ContentSharingEntities1(); var userid = (from a in DB.UserTable where a.EmailAddress == HttpContext.User.Identity.Name select a.Id).First(); bool exist = (from b in DB.ImgVote where b.UserID == userid && b.ImgID == newid select b).Any(); if (exist) { var imgid = (from c in DB.ImgVote where c.UserID == userid && c.ImgID == newid select c.ImgVoteID).First(); int newID = Convert.ToInt32(imgid); ImgVote Img = DB.ImgVote.Find(newID); DB.ImgVote.Remove(Img); DB.SaveChanges(); return(Json("1", JsonRequestBehavior.AllowGet)); } return(Json("0", JsonRequestBehavior.AllowGet)); }
public JsonResult UpVote(string id) { var newid = Int32.Parse(id); ContentSharingEntities1 DB = new ContentSharingEntities1(); ImgVote Img = new ImgVote(); var userid = (from a in DB.UserTable where a.EmailAddress == HttpContext.User.Identity.Name select a.Id).First(); bool exist = (from b in DB.ImgVote where b.UserID == userid && b.ImgID == newid select b).Any(); if (!exist) { Img.ImgID = newid; Img.UserID = userid; DB.ImgVote.Add(Img); DB.SaveChanges(); return(Json("1", JsonRequestBehavior.AllowGet)); } return(Json("0", JsonRequestBehavior.AllowGet)); }