public void UpdatePost(Post InnPost) { using (var db = new FaqContext()) { Posts post = (from p in db.Posts where p.PostId == InnPost.PostId select p).First(); if (InnPost.Votes == 1) { post.Votes = post.Votes + 1; db.SaveChanges(); } else { post.Answer = InnPost.Answer; post.TimeStamp = DateTime.Now.ToString(); post.IsAnswered = true; db.SaveChanges(); } } }
public void AddPost(Post NewPost) { Debug.WriteLine(NewPost.Category); try { using (var db = new FaqContext()) { var NewPostRow = new Posts(); NewPostRow.PostId = NewPost.PostId; NewPostRow.Question = NewPost.Question; NewPostRow.Answer = NewPost.Answer; if(NewPost.Category == null){ NewPostRow.Category = "Other";} else NewPostRow.Category = NewPost.Category; NewPostRow.UserEmail = NewPost.UserEmail; NewPostRow.TimeStamp = DateTime.Now.ToString(); NewPostRow.IsAnswered = false; db.Posts.Add(NewPostRow); db.SaveChanges(); } } catch(Exception e) { Debug.WriteLine("klikker her"); Debug.WriteLine(e.ToString()); } }
public List<Post> GetAllPosts() { using (var db = new FaqContext()) { var AllPosts = db.Posts.ToList().Select(p => new Post { PostId = p.PostId, Question = p.Question, Answer = p.Answer, TimeStamp = p.TimeStamp, UserEmail = p.UserEmail, IsAnswered = p.IsAnswered, Category = p.Category, Votes = p.Votes }).ToList(); return AllPosts; } }