1 files changed, 107 insertions, 0 deletions
diff --git a/src/DevHive.Data/Repositories/PostRepository.cs b/src/DevHive.Data/Repositories/PostRepository.cs
new file mode 100644
index 0000000..5dfee0b
--- /dev/null
+++ b/src/DevHive.Data/Repositories/PostRepository.cs
@@ -0,0 +1,107 @@
+using System;
+using System.Threading.Tasks;
+using Data.Models.Interfaces.Database;
+using DevHive.Common.Models.Misc;
+using DevHive.Data.Models;
+using Microsoft.EntityFrameworkCore;
+
+namespace DevHive.Data.Repositories
+{
+	public class PostRepository : IRepository<Post>
+	{
+		private readonly DevHiveContext _context;
+
+		public PostRepository(DevHiveContext context)
+		{
+			this._context = context;
+		}
+
+		//Create
+		public async Task<bool> AddAsync(Post post)
+		{
+			await this._context
+				.Set<Post>()
+				.AddAsync(post);
+
+			return await RepositoryMethods.SaveChangesAsync(this._context);
+		}
+
+		public async Task<bool> AddCommentAsync(Comment entity)
+		{
+			await this._context
+				.Set<Comment>()
+				.AddAsync(entity);
+
+			return await RepositoryMethods.SaveChangesAsync(this._context);
+		}
+
+		//Read
+		public async Task<Post> GetByIdAsync(Guid id)
+		{
+			return await this._context
+				.Set<Post>()
+				.FindAsync(id);
+		}
+
+		public async Task<Comment> GetCommentByIdAsync(Guid id)
+		{
+			return await this._context
+				.Set<Comment>()
+				.FindAsync(id);
+		}
+
+		//Update
+		public async Task<bool> EditAsync(Post newPost)
+		{
+				this._context
+				.Set<Post>()
+				.Update(newPost);
+
+			return await RepositoryMethods.SaveChangesAsync(this._context);
+		}
+
+		public async Task<bool> EditCommentAsync(Comment newEntity)
+		{
+			this._context
+				.Set<Comment>()
+				.Update(newEntity);
+
+			return await RepositoryMethods.SaveChangesAsync(this._context);
+		}
+
+		//Delete
+		public async Task<bool> DeleteAsync(Post post)
+		{
+			this._context
+				.Set<Post>()
+				.Remove(post);
+
+			return await RepositoryMethods.SaveChangesAsync(this._context);
+		}
+	
+		public async Task<bool> DeleteCommentAsync(Comment entity)
+		{
+			this._context
+				.Set<Comment>()
+				.Remove(entity);
+
+			return await RepositoryMethods.SaveChangesAsync(this._context);
+		}
+	
+		public async Task<bool> DoesPostExist(Guid postId)
+		{
+			return await this._context
+				.Set<Post>()
+				.AsNoTracking()
+				.AnyAsync(r => r.Id == postId);
+		}
+
+		public async Task<bool> DoesCommentExist(Guid id)
+		{
+			return await this._context
+				.Set<Comment>()
+				.AsNoTracking()
+				.AnyAsync(r => r.Id == id);
+		}
+	}
+}
+\ No newline at end of file