public async Task <ProductRateResult> RateProduct(ProductRateParam data) { string connectionString = configuration.GetConnectionString("Default"); var commandText = "RateProduct"; var command = new CommandDefinition(commandText, data, commandType: CommandType.StoredProcedure); ProductRateResult p; try { using SqlConnection connection = new SqlConnection(connectionString); p = await connection.QueryFirstAsync <ProductRateResult>(command); } catch (Exception ex) { logger.LogError(ex.GetExceptionMessage()); p = null; } return(p); }
public async Task <IActionResult> RateProduct(ProductRateParam data) { var result = await repository.RateProduct(data); return(Ok(result)); }