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