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