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