Changeset 6165fd0 for src/FinkiChattery

Timestamp:

11/09/21 17:06:21 (3 years ago)

Author:

Стојков Марко <mst@…>

Branches:

dev

Children:

e071d30

Parents:

53bebc0

Message:

Delete answer and answer response

Location:

src/FinkiChattery

Files:

• FinkiChattery.Api/Controllers/v1/AnswerResponsesController.cs (modified) (1 diff)
• FinkiChattery.Api/Controllers/v1/AnswersController.cs (modified) (1 diff)
• FinkiChattery.Commands/Questioning/DeleteAnswer/DeleteAnswerCommand.cs (added)
• FinkiChattery.Commands/Questioning/DeleteAnswer/DeleteAnswerValidator.cs (added)
• FinkiChattery.Commands/Questioning/DeleteAnswerResponse/DeleteAnswerResponseCommand.cs (added)
• FinkiChattery.Commands/Questioning/DeleteAnswerResponse/DeleteAnswerResponseValidator.cs (added)
• FinkiChattery.Database/dbo/Tables/AnswerResponse/AnswerResponse.sql (modified) (1 diff)
• FinkiChattery.Database/dbo/Tables/Vote/Vote.sql (modified) (1 diff)
• FinkiChattery.Persistence/Configurations/AnswerResponseConfig.cs (modified) (1 diff)
• FinkiChattery.Persistence/Configurations/VoteConfig.cs (modified) (1 diff)
• FinkiChattery.Persistence/Repositories/Base/IRepository.cs (modified) (1 diff)
• FinkiChattery.Persistence/Repositories/Base/Repository.cs (modified) (1 diff)

src/FinkiChattery/FinkiChattery.Api/Controllers/v1/AnswerResponsesController.cs

@@ -39 +39 @@
             return Ok(answerResponse.ToAnswerResponseQuestionStateResponse());
         }
+
+        [HttpDelete("{answerResponseUid:Guid}")]
+        [Authorize(AuthenticationSchemes = IdentityServerAuthenticationDefaults.AuthenticationScheme, Policy = AuthenticationPolicy.Student)]
+        public async Task<IActionResult> DeleteAnswerResponse([FromRoute] Guid questionUid, [FromRoute] Guid answerUid, [FromRoute] Guid answerResponseUid)
+        {
+            var uid = await MediatorService.SendAsync(new DeleteAnswerResponseCommand(questionUid, answerUid, answerResponseUid));
+            return Ok(uid);
+        }
     }
 }

src/FinkiChattery/FinkiChattery.Api/Controllers/v1/AnswersController.cs

@@ -40 +40 @@
         }
 
+        [HttpDelete("{answerUid:Guid}")]
+        [Authorize(AuthenticationSchemes = IdentityServerAuthenticationDefaults.AuthenticationScheme, Policy = AuthenticationPolicy.Student)]
+        public async Task<IActionResult> DeleteAnswer([FromRoute] Guid questionUid, [FromRoute] Guid answerUid)
+        {
+            var uid = await MediatorService.SendAsync(new DeleteAnswerCommand(questionUid, answerUid));
+            return Ok(uid);
+        }
+
         [HttpPut("{answerUid:Guid}/correct")]
         [Authorize(AuthenticationSchemes = IdentityServerAuthenticationDefaults.AuthenticationScheme, Policy = AuthenticationPolicy.Student)]

src/FinkiChattery/FinkiChattery.Database/dbo/Tables/AnswerResponse/AnswerResponse.sql

@@ -7 +7 @@
     [CreatedOn] SMALLDATETIME    NOT NULL,
     CONSTRAINT [PK_AnswerResponse] PRIMARY KEY CLUSTERED ([Id] ASC),
-    CONSTRAINT [FK_AnswerResponse_Answer_AnswerFk] FOREIGN KEY ([AnswerFk]) REFERENCES [dbo].[Answer] ([Id]),
+    CONSTRAINT [FK_AnswerResponse_Answer_AnswerFk] FOREIGN KEY ([AnswerFk]) REFERENCES [dbo].[Answer] ([Id]) ON DELETE CASCADE,
     CONSTRAINT [FK_AnswerResponse_Student_AnswerFk] FOREIGN KEY ([StudentFk]) REFERENCES [dbo].[Student] ([Id])
 );

src/FinkiChattery/FinkiChattery.Database/dbo/Tables/Vote/Vote.sql

@@ -6 +6 @@
     [VoteType] TINYINT           NOT NULL, 
     CONSTRAINT [PK_Vote] PRIMARY KEY CLUSTERED ([Id] ASC),
-    CONSTRAINT [FK_Vote_Answer_AnswerFk] FOREIGN KEY ([AnswerFk]) REFERENCES [dbo].[Answer] ([Id]),
+    CONSTRAINT [FK_Vote_Answer_AnswerFk] FOREIGN KEY ([AnswerFk]) REFERENCES [dbo].[Answer] ([Id]) ON DELETE CASCADE,
     CONSTRAINT [FK_Vote_Student_StudentFk] FOREIGN KEY ([StudentFk]) REFERENCES [dbo].[Student] ([Id])
 );

src/FinkiChattery/FinkiChattery.Persistence/Configurations/AnswerResponseConfig.cs

@@ -27 +27 @@
             builder.Property(x => x.CreatedOn).HasColumnName(@"CreatedOn").HasColumnType("smalldatetime").IsRequired();
 
-            builder.HasOne(x => x.Answer).WithMany(x => x.AnswerResponses).HasForeignKey(x => x.AnswerFk).OnDelete(DeleteBehavior.Restrict);
+            builder.HasOne(x => x.Answer).WithMany(x => x.AnswerResponses).HasForeignKey(x => x.AnswerFk).OnDelete(DeleteBehavior.Cascade);
             builder.HasOne(x => x.Student).WithMany().HasForeignKey(x => x.StudentFk).OnDelete(DeleteBehavior.Restrict);
         }

src/FinkiChattery/FinkiChattery.Persistence/Configurations/VoteConfig.cs

@@ -22 +22 @@
 
             builder.HasOne(x => x.Student).WithMany().HasForeignKey(x => x.StudentFk).OnDelete(DeleteBehavior.Restrict);
-            builder.HasOne(x => x.Answer).WithMany(x => x.Votes).HasForeignKey(x => x.AnswerFk).OnDelete(DeleteBehavior.Restrict);
+            builder.HasOne(x => x.Answer).WithMany(x => x.Votes).HasForeignKey(x => x.AnswerFk).OnDelete(DeleteBehavior.Cascade);
         }
     }

src/FinkiChattery/FinkiChattery.Persistence/Repositories/Base/IRepository.cs

@@ -13 +13 @@
         Task<T> GetByIdAsync(int id);
 
+        void Delete(T entity);
+
         void Add(T entity);
     }

src/FinkiChattery/FinkiChattery.Persistence/Repositories/Base/Repository.cs

@@ -38 +38 @@
             return await All().FirstOrDefaultAsync(f => f.Uid == uid);
         }
+
+        public void Delete(T entity)
+        {
+            DbSet.Remove(entity);
+        }
     }
 }