Website Summary Files Commits Branches @commit @diff @stats
path: root / src / DevHive.Data / Repositories / FeedRepository.cs
diff options
context:
space:
mode:
Commit498af41f38b14372bd2f5eb9a0add7af95c40168 (patch)
Author
 Syndamia <kamen.d.mladenov@protonmail.com>
2021-01-30 13:07:54 +0200
Committer
 Syndamia <kamen.d.mladenov@protonmail.com>
2021-01-30 13:07:54 +0200
Files31c00985399ee352c1a09f4d650f62696e117350 /src/DevHive.Data/Repositories/FeedRepository.cs
DevHive-498af41f38b14372bd2f5eb9a0add7af95c40168.tar
DevHive-498af41f38b14372bd2f5eb9a0add7af95c40168.tar.gz
DevHive-498af41f38b14372bd2f5eb9a0add7af95c40168.zip
Parenta8cc808396a24f0a5e4262d07e3edae1a4e5fc1d (diff)
Fixed GetUserPosts implementation
1 files changed, 13 insertions, 0 deletions
-rw-r--r--src/DevHive.Data/Repositories/FeedRepository.cs13
diff --git a/src/DevHive.Data/Repositories/FeedRepository.cs b/src/DevHive.Data/Repositories/FeedRepository.cs
index efcb8e0..7ab9a91 100644
--- a/src/DevHive.Data/Repositories/FeedRepository.cs
+++ b/src/DevHive.Data/Repositories/FeedRepository.cs
@@ -32,5 +32,18 @@ namespace DevHive.Data.Repositories
return posts;
}
+
+ public async Task<List<Post>> GetUsersPosts(User user, DateTime firstRequestIssued, int pageNumber, int pageSize)
+ {
+ List<Post> posts = await this._context.Posts
+ .Where(post => post.TimeCreated < firstRequestIssued)
+ .Where(p => p.Creator.Id == user.Id)
+ .OrderByDescending(x => x.TimeCreated)
+ .Skip((pageNumber - 1) * pageSize)
+ .Take(pageSize)
+ .ToListAsync();
+
+ return posts;
+ }
}
}