/*****************************************************************************/
public Types.Comment getComment(int commentId)
{
using (var ctx = new Models.Model())
{
Models.Comment c = ctx.comments.FirstOrDefault(x => x.commentId == commentId);
Types.Comment c1 = new Types.Comment();
c1.commentId = c.commentId;
c1.time = c.time;
c1.description = c.description;
c1.upvotes = c.upvotes;
c1.user = new Types.User();
c1.user.userId = c.user.userId;
c1.user.username = c.user.username;
c1.user.firstName = c.user.firstName;
c1.user.lastName = c.user.lastName;
c1.user.password = c.user.password;
c1.post = new Types.Post();
c1.post.postId = c.post.postId;
c1.post.headline = c.post.headline;
c1.post.time = c.post.time;
c1.post.description = c.post.description;
c1.post.upvotes = c.post.upvotes;
c1.post.user = new Types.User();
c1.post.user.userId = c.post.user.userId;
c1.post.user.username = c.post.user.username;
c1.post.user.firstName = c.post.user.firstName;
c1.post.user.lastName = c.post.user.lastName;
c1.post.user.password = c.post.user.password;
c1.replyOfComment = c.replyOfComment == null ? -1 : c.replyOfComment.commentId;
return(c1);
}
}
public void removeUser(int userId)
{
using (var ctx = new Models.Model())
{
ctx.users.Remove(ctx.users.FirstOrDefault(x => x.userId == userId));
ctx.SaveChanges();
}
}
public void removeComment(int commentId)
{
using (var ctx = new Models.Model())
{
ctx.comments.Remove(ctx.comments.FirstOrDefault(x => x.commentId == commentId));
ctx.SaveChanges();
}
}
public void removePost(int postId)
{
using (var ctx = new Models.Model())
{
ctx.posts.Remove(ctx.posts.FirstOrDefault(x => x.postId == postId));
ctx.SaveChanges();
}
}
public List <Types.Post> filterPosts(
int page,
int?userId = null,
string headline = null,
DateTime?date = null)
{
using (var ctx = new Models.Model())
{
List <Types.Post> result = new List <Types.Post>();
var posts = ctx.posts.AsQueryable();
try
{
if (userId != null)
{
posts = posts.Where(x => x.user.userId == userId);
}
if (headline != null)
{
posts = posts.Where(x => x.headline.Contains(headline));
}
if (date != null)
{
posts = posts.Where(x => (DateTime.Compare((DateTime)date, x.time) <= 0));
}
posts = posts.OrderByDescending(p => p.time).Skip((page - 1) * 10).Take(10);
foreach (var p in posts.ToList())
{
var 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;
result.Add(p1);
}
}
catch (Exception ex)
{
Debug.WriteLine("he");
Debug.WriteLine(ex);
Debug.WriteLine("he");
}
return(result);
}
}
public Types.Comment updateComment(Types.Comment c)
{
using (var ctx = new Models.Model())
{
Models.Comment c1 = ctx.comments.FirstOrDefault(x => x.commentId == c.commentId);
c1.time = c.time;
c1.description = c.description;
c1.upvotes = c.upvotes;
ctx.SaveChanges();
return(c);
}
}
public Types.User updateUser(Types.User u)
{
using (var ctx = new Models.Model())
{
Models.User u1 = ctx.users.FirstOrDefault(x => x.userId == u.userId);
u1.username = u.username;
u1.firstName = u.firstName;
u1.lastName = u.lastName;
u1.password = u.password;
ctx.SaveChanges();
return(u);
}
}
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 addUser(Types.User u)
{
using (var ctx = new Models.Model())
{
Models.User u1 = new Models.User();
u1.username = u.username;
u1.firstName = u.firstName;
u1.lastName = u.lastName;
u1.password = u.password;
ctx.users.Add(u1);
ctx.SaveChanges();
return(u1.userId);
}
}
public Types.User verify(string username, string password)
{
using (var ctx = new Models.Model())
{
Models.User u = ctx.users.FirstOrDefault(x => x.username == username && x.password == password);
Types.User u1 = new Types.User();
u1.userId = u.userId;
u1.username = u.username;
u1.firstName = u.firstName;
u1.lastName = u.lastName;
u1.password = u.password;
return(u1);
}
}
public Types.User getUser(int userId)
{
using (var ctx = new Models.Model())
{
Models.User u = ctx.users.FirstOrDefault(x => x.userId == userId);
Types.User u1 = new Types.User();
u1.userId = u.userId;
u1.username = u.username;
u1.firstName = u.firstName;
u1.lastName = u.lastName;
u1.password = u.password;
return(u1);
}
}
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);
}
}
public List <Types.Comment> filterComments(
int?userId = null,
int?postId = null,
DateTime?date = null)
{
using (var ctx = new Models.Model())
{
var comments = ctx.comments.AsQueryable();
List <Types.Comment> result = new List <Types.Comment>();
try
{
if (userId != null)
{
comments = comments.Where(x => x.user.userId == userId);
}
if (postId != null)
{
comments = comments.Where(x => x.post.postId == postId);
}
if (date != null)
{
comments = comments.Where(x => (DateTime.Compare((DateTime)date, x.time) <= 0));
}
comments = comments.OrderBy(c => c.time);
foreach (var c in comments.ToList())
{
Types.Comment c1 = new Types.Comment();
c1.commentId = c.commentId;
c1.time = c.time;
c1.description = c.description;
c1.upvotes = c.upvotes;
c1.user = new Types.User();
c1.user.userId = c.user.userId;
c1.user.username = c.user.username;
c1.user.firstName = c.user.firstName;
c1.user.lastName = c.user.lastName;
c1.user.password = c.user.password;
c1.post = new Types.Post();
c1.post.postId = c.post.postId;
c1.post.headline = c.post.headline;
c1.post.time = c.post.time;
c1.post.description = c.post.description;
c1.post.upvotes = c.post.upvotes;
c1.post.user = new Types.User();
c1.post.user.userId = c.post.user.userId;
c1.post.user.username = c.post.user.username;
c1.post.user.firstName = c.post.user.firstName;
c1.post.user.lastName = c.post.user.lastName;
c1.post.user.password = c.post.user.password;
c1.replyOfComment = c.replyOfComment == null ? -1 : c.replyOfComment.commentId;
result.Add(c1);
}
}
catch (Exception ex)
{
Debug.WriteLine("he");
Debug.WriteLine(ex);
Debug.WriteLine("he");
}
return(result);
}
}
