public GetResponse <IList <IDocumentHistory> > GetDocumentHistory(DocumentHistoryRequest request) { return(GetDocumentHistoryAsync(request).Result); }
public async Task <GetResponse <IList <IDocumentHistory> > > GetDocumentHistoryAsync(DocumentHistoryRequest request) { var response = new GetResponse <IList <IDocumentHistory> >(); try { using (var connection = ConnectionFactory.GetConnection()) { var conditions = new List <string>(); if (request.PeriodStart.HasValue) { conditions.Add($@"CreatedOn BETWEEN {request.PeriodStart:d} AND {request.PeriodEnd:d};"); } if (request.AuditId > 0) { conditions.Add($@"AuditId = {request.AuditId}"); } var condition = string.Join(" AND ", conditions); var sql = string.IsNullOrEmpty(condition) ? $@"{GetDocumentHistorySelectStatement()}" : $@"{GetDocumentHistorySelectStatement()} AND {condition};"; var results = await connection.QueryAsync <DocumentHistoryDto>(sql); response.Content = results .Select(d => d.ToModel()) .AsList(); } } catch (Exception e) { var message = $@"Unable to retrieve document records for request: {request}"; response.AddError(e); LogManager.LogError(e, message); Console.WriteLine(e); } return(response); }
public async Task <GetResponse <IList <IDocumentHistory> > > GetDocumentHistoryAsync(DocumentHistoryRequest request) { var response = new GetResponse <IList <IDocumentHistory> >(); try { response = await _documentRepository.GetDocumentHistoryAsync(request); } catch (Exception e) { _logManager.LogError(e, "DocumentApplicationService.GetDocumentHistoryAsync"); response.AddError(e); } return(response); }