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);
}
