T014: [P] Create ICertificateVerificationRepository interface

[Hemavathi15sg]

Phase 2: Foundational

Task: T014
Status: Not Started
Story: Foundational (blocking all user stories)
Parallelizable: Yes - interface definition only

Description

Create CertificateVerification repository interface for verification audit trail queries.

Acceptance Criteria

• File created: api/CourseRegistration.Infrastructure/Repositories/ICertificateVerificationRepository.cs
• Interface methods defined:
  • Task AddAsync(CertificateVerification verification)
  • Task<List> GetRecentVerificationsAsync(string ip, int minutesBack)
  • Task CountRecentAsync(string ip, int minutesBack)
  • Task<List> GetByCertificateIdAsync(Guid certificateId)
• All methods are async
• Includes soft delete pattern
• Rate limiting queries optimized (IP + timestamp filtering)
• XML documentation

Effort Estimate

1.5 hours

References

• plan.md: Project Structure (Repositories)
• data-model.md: CertificateVerification Entity