public async Task <IEnumerable <DistributionReult> > GetDistributions(DistributionsParameter data)
{
// Procedure name: GetDistributions
// use dapper
string connectionString = configuration.GetConnectionString("Default");
var commandText = "GetDistributions";
var command = new CommandDefinition(commandText, data, commandType: CommandType.StoredProcedure);
IEnumerable <DistributionReult> result;
try
{
using SqlConnection connection = new SqlConnection(connectionString);
result = await connection.QueryAsync <DistributionReult>(command);
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessage());
return(null);
}
return(result);
}
public async Task <IEnumerable <DistributionDatailsReult> > GetDistributionDetails(DistributionsParameter data)
{
var q = context.Distributions.Where(a => a.PharmacyId == data.PharmacyId.Value && a.MedicineId == data.MedicineId.Value);
if (data.DateFrom.HasValue)
{
q = q.Where(a => a.DateTime >= data.DateFrom.Value.Date);
}
if (data.DateTo.HasValue)
{
var to = data.DateTo.Value.Date.AddDays(1);
q = q.Where(a => a.DateTime <= to);
}
return(await q.Select(a => new DistributionDatailsReult()
{
Amount = a.Amount,
DateTime = a.DateTime,
PrescriptionId = a.PrescriptionId,
Stock = a.Stock
}).ToListAsync());
}
public async Task <IActionResult> DistributionDetails(DistributionsParameter data)
{
return(Ok(await repo.GetDistributionDetails(data)));
}
