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))); }