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