public async Task <IEnumerable <PatientDetailsResult> > PatientDetailsReport(PatientCumulativeResult data)
{
// Procedure name: GetPatientDetails
// use dapper
string connectionString = configuration.GetConnectionString("Default");
var commandText = "GetPatientDetails";
var command = new CommandDefinition(commandText, new { data.MedicineId, data.PharmacyId, data.PatientId, data.MinDate, data.MaxDate }, commandType: CommandType.StoredProcedure);
IEnumerable <PatientDetailsResult> result;
try
{
using SqlConnection connection = new SqlConnection(connectionString);
result = await connection.QueryAsync <PatientDetailsResult>(command);
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessage());
return(null);
}
return(result);
}
public async Task <IActionResult> DetailtsReport(PatientCumulativeResult data)
{
return(Ok(await repository.PatientDetailsReport(data)));
}
