public Types.Post updatePost(Types.Post p) { using (var ctx = new Models.Model()) { Models.Post p1 = ctx.posts.FirstOrDefault(x => x.postId == p.postId); p1.headline = p.headline; p1.time = p.time; p1.description = p.description; p1.upvotes = p.upvotes; ctx.SaveChanges(); return(p); } }
public int addPost(Types.Post p) { using (var ctx = new Models.Model()) { Models.Post p1 = new Models.Post(); p1.headline = p.headline; p1.time = p.time; p1.description = p.description; p1.upvotes = p.upvotes; Models.User u = ctx.users.FirstOrDefault(x => x.userId == p.user.userId); p1.user = u; ctx.posts.Add(p1); ctx.SaveChanges(); return(p1.postId); } }
/********************************************************************************/ public Types.Post getPost(int postId) { using (var ctx = new Models.Model()) { Models.Post p = ctx.posts.FirstOrDefault(x => x.postId == postId); Types.Post p1 = new Types.Post(); p1.postId = p.postId; p1.headline = p.headline; p1.time = p.time; p1.description = p.description; p1.upvotes = p.upvotes; p1.user = new Types.User(); p1.user.userId = p.user.userId; p1.user.username = p.user.username; p1.user.firstName = p.user.firstName; p1.user.lastName = p.user.lastName; p1.user.password = p.user.password; return(p1); } }
public int addComment(Types.Comment c) { using (var ctx = new Models.Model()) { Models.Comment c1 = new Models.Comment(); c1.time = c.time; c1.description = c.description; c1.upvotes = c.upvotes; if (c.replyOfComment != -1) { c1.replyOfComment = ctx.comments.FirstOrDefault(x => x.commentId == c.replyOfComment); } Models.User u = ctx.users.FirstOrDefault(x => x.userId == c.user.userId); c1.user = u; Models.Post p = ctx.posts.FirstOrDefault(x => x.postId == c.post.postId); c1.post = p; ctx.comments.Add(c1); ctx.SaveChanges(); return(c1.commentId); } }