public Picture FindRandomPicture() { using (HotOrNotContext hotOrNotContext = new HotOrNotContext()) { return(hotOrNotContext.Pictures.OrderBy(o => System.Guid.NewGuid()).First()); } }
public void Create(string MyFileName, string Mytitle, string Mydescription) { Picture picture = new Picture(); using (HotOrNotContext hotOrNotContext = new HotOrNotContext()) { var MaxPictureID = hotOrNotContext.Pictures.OrderByDescending(u => u.PictureId).FirstOrDefault(); int NextID = MaxPictureID.PictureId; hotOrNotContext.Pictures.Add(new Picture { PictureId = NextID + 1, FilePath = MyFileName, Title = Mytitle, Description = Mydescription, LikeCnt = 0, DisLikeCnt = 0, CreateDate = System.DateTime.Now }); hotOrNotContext.SaveChanges(); } }
public void AddLikeOrDislike(int pictureId, bool flag) { using (HotOrNotContext hotOrNotContext = new HotOrNotContext()) { if (flag == true) { var MyPicture = hotOrNotContext.Pictures.Find(pictureId); MyPicture.LikeCnt++; hotOrNotContext.SaveChanges(); } else { var MyPicture = hotOrNotContext.Pictures.Find(pictureId); MyPicture.DisLikeCnt++; hotOrNotContext.SaveChanges(); } } }