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