public async Task <List <KeyDocto> > CheckDocumento(KeyDocto key) { using (SqlConnection connection = new SqlConnection( _connectionString)) { SqlCommand command = new SqlCommand("CheckDocto", connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@Empresa", key.Empresa)); command.Parameters.Add(new SqlParameter("@TipoDocto", key.Tipodocto)); command.Parameters.Add(new SqlParameter("@Correlativo", key.Correlativo)); var response = new List <KeyDocto>(); await connection.OpenAsync(); using (var reader = await command.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { response.Add(MapToValue(reader)); } } return(response); } }
public async Task <ActionResult <List <KeyDocto> > > Post([FromBody] KeyDocto Key) { try { _logger.LogInformation($"POST con id {Key.Correlativo}"); return(Ok(new { KeyDoctos = await _repository.CheckDocumento(Key) })); } catch (Exception ex) { _logger.LogWarning($"Error en POST con id {Key.Correlativo}"); return(BadRequest(ex.Message)); } }