public async Task <IEnumerable <Document> > GetDocumentsByPapmiRowIdAsync(long papmiRowId)
{
using (var connection = new OdbcConnection(_connectionStrings.Cache))
{
var result = await connection.QueryAsync <Document>(MedicalRecordQuery.GetDocumentsByPapmiRowId(), new { PAPMI_RowId1 = papmiRowId });
return(result);
}
}
public async Task <DocumentBinary> GetDocumentBinaryByPapmiNoAndPathAsync(string papmiNo, string path, bool isDocData)
{
var query = isDocData ? MedicalRecordQuery.GetDocumentByPapmiNoAndPath() : MedicalRecordQuery.GetDocumentTypeByPapmiNoAndPath();
using (var connection = new OdbcConnection(_connectionStrings.Cache))
{
var result = await connection.QueryFirstOrDefaultAsync <DocumentBinary>(query, new { PAPMI_No = papmiNo, PIC_Path = path });
return(result);
}
}
