public async Task UpdateStatusDateUtcAsync(int id, TranscriptRequestStatus transcriptStatusId, DateTime statusDateUtc)
{
await _sql.ExecuteAsync(
sql : "[Utility].[TranscriptRequestHistoryStatusDateUTCUpdate]",
param : new
{
TranscriptRequestId = id,
TranscriptStatusId = (int)transcriptStatusId,
StatusDateUTC = statusDateUtc
},
commandType : CommandType.StoredProcedure);
}
public async Task AppendHistoryAsync(int transcriptRequestId, TranscriptRequestStatus status, int modifiedById)
{
var result = await _sql.QueryAsync <int>(
sql : "[ApplicationPlanner].[TranscriptRequestHistoryAppend]",
param : new
{
transcriptRequestId,
statusId = (int)status,
modifiedById
},
commandType : CommandType.StoredProcedure);
}
public async Task <IActionResult> UpdateStatusDate(int id, TranscriptRequestStatus transcriptStatusId, int minusDays)
{
var resetTime = DateTime.UtcNow.AddDays(-minusDays);
TimeSpan utcOffset = TimeZoneInfo.Local.GetUtcOffset(DateTime.Now);
resetTime = resetTime.AddHours(-resetTime.Hour - utcOffset.Hours);
resetTime = resetTime.AddMinutes(-resetTime.Minute);
resetTime = resetTime.AddSeconds(-resetTime.Second);
await _qaRepository.UpdateStatusDateUtcAsync(id, transcriptStatusId, resetTime);
return(Ok());
}
public async Task AppendHistoryAsync(List <int> transcriptRequestIdList, TranscriptRequestStatus status, int modifiedById)
{
var dt = DataConverterHelper.GetDataTableFromListOfInteger(transcriptRequestIdList, "ID");
var result = await _sql.QueryAsync <int>(
sql : "[ApplicationPlanner].[TranscriptRequestHistoryAppendByIdList]",
param : new
{
TranscriptRequestIdList = dt,
statusId = (int)status,
modifiedById
},
commandType : CommandType.StoredProcedure);
}
