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