Clean Architecture Demo
Loading...
Searching...
No Matches
TaskReadRepository.cs
Go to the documentation of this file.
1// TaskManagement.Infrastructure/Persistence/Repositories/TaskReadRepository.cs
2using System.Data.Common;
3using Dapper;
8
10
11#pragma warning disable CS1570 // XML comment has badly formed XML
57#pragma warning restore CS1570 // XML comment has badly formed XML
59{
60 private readonly Func<DbConnection> _createConnection;
61
66 public TaskReadRepository(Func<DbConnection> createConnection)
67 {
68 _createConnection = createConnection;
69 }
70
71 public async Task<TaskDto?> GetByIdAsync(
72 Guid id,
73 CancellationToken cancellationToken = default)
74 {
75 const string sql = @"
76 SELECT
77 t.Id,
78 t.Title,
79 t.Description,
80 t.Status,
81 t.Priority,
82 t.DueDate,
83 t.CreatedAt,
84 t.CreatedBy as CreatedBy,
85 t.AssignedTo as AssignedTo
86 FROM Tasks t
87 WHERE t.Id = @Id";
88
89 using var connection = _createConnection();
90 var command = new CommandDefinition(
91 sql,
92 new {
93 Id = id
94 },
95 cancellationToken: cancellationToken);
96
97 return await connection.QueryFirstOrDefaultAsync<TaskDto>(command).ConfigureAwait(false);
98 }
99
100 public async Task<PagedResult<TaskDto>> SearchAsync(
101 TaskSearchRequest request,
102 CancellationToken cancellationToken = default)
103 {
104 ArgumentNullException.ThrowIfNull(request);
105
106 const string selectSql = @"
107 SELECT
108 t.Id, t.Title, t.Description, t.Status, t.Priority,
109 t.DueDate, t.CreatedAt, t.CreatedBy as CreatedBy,
110 t.AssignedTo as AssignedTo
111 FROM Tasks t";
112 const string countSql = "SELECT COUNT(*) FROM Tasks t";
113 var whereClause = BuildWhereClause(request);
114 var orderClause = $"ORDER BY {request.SortBy} {request.SortDirection}";
115 var pagedSql = $"{selectSql} {whereClause} {orderClause} LIMIT @PageSize OFFSET @Offset";
116 var parameters = new DynamicParameters(request);
117 parameters.Add("Offset", (request.Page - 1) * request.PageSize);
118
119 using var connection = _createConnection();
120 var command = new CommandDefinition(
121 $"{pagedSql}; {countSql} {whereClause}",
122 parameters,
123 cancellationToken: cancellationToken);
124
125 var multi = await connection.QueryMultipleAsync(command).ConfigureAwait(false);
126 var items = (await multi.ReadAsync<TaskDto>().ConfigureAwait(false)).ToList();
127 var totalCount = await multi.ReadSingleAsync<int>().ConfigureAwait(false);
128 return new PagedResult<TaskDto>(items, totalCount, request.Page, request.PageSize);
129 }
130
131 private static string BuildWhereClause(TaskSearchRequest request)
132 {
133 var filters = new List<string>();
134
135 if (!string.IsNullOrWhiteSpace(request.Title))
136 {
137 filters.Add("t.Title LIKE '%' || @Title || '%'");
138 }
139
140 if (!string.IsNullOrWhiteSpace(request.Status))
141 {
142 filters.Add("t.Status = @Status");
143 }
144
145 if (!string.IsNullOrWhiteSpace(request.Priority))
146 {
147 filters.Add("t.Priority = @Priority");
148 }
149
150 if (request.AssignedTo.HasValue)
151 {
152 filters.Add("t.AssignedTo = @AssignedTo");
153 }
154
155 return filters.Count == 0 ? string.Empty : $"WHERE {string.Join(" AND ", filters)}";
156 }
157}
TaskDto es el DTO de salida del caso de uso de consultar una tarea.
Definition TaskDto.cs:11
async Task< PagedResult< TaskDto > > SearchAsync(TaskSearchRequest request, CancellationToken cancellationToken=default)
async Task< TaskDto?> GetByIdAsync(Guid id, CancellationToken cancellationToken=default)
ITaskReadRepository es la abstracción para consultas de sólo lectura de tareas.
record TaskSearchRequest(string? Title=null, string? Status=null, string? Priority=null, Guid? AssignedTo=null, int Page=1, int PageSize=20, string SortBy="CreatedAt", string SortDirection="DESC")
TaskSearchRequest es el DTO de entrada para operaciones avanzadas de búsqueda de tareas.