public async Task <IEnumerable <SendTranscriptViewModel> > GetSendTranscriptByTranscriptRequestIdListAsync(List <int> transcriptRequestIdList)
{
var dt = DataConverterHelper.GetDataTableFromListOfInteger(transcriptRequestIdList, "ID");
return(await _sql.QueryAsync <SendTranscriptViewModel>(
sql : "[ApplicationPlanner].[SendTranscriptByTranscriptRequestIdList]",
param : new
{
TranscriptRequestIdList = dt
},
commandType : CommandType.StoredProcedure));
}
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);
}
public void GetDataTableFromListOfInteger_should_return_datatable_with_correct_column_name()
{
// Arrange:
var list = new List <int>()
{
1, 2, 3, 4
};
var columnName = "Id";
// Act:
var result = DataConverterHelper.GetDataTableFromListOfInteger(list, columnName);
// Assert:
Assert.AreEqual(result.Columns.Count, 1);
Assert.AreEqual(result.Columns[0].ColumnName, columnName);
Assert.AreEqual(result.Columns[0].DataType, typeof(int));
Assert.AreEqual(result.Rows.Count, 4);
}
