public async Task <IActionResult> Delete([FromBody] AreaFasePreguntas value)
{
try
{
await _repository.Delete(value);
}
catch (Exception ex)
{
// Guardar Excepción
return(BadRequest(ex));
}
return(Ok());
}
public async Task <IActionResult> Put([FromBody] AreaFasePreguntas value)
{
try
{
await _repository.Update(value);
}
catch (Exception ex)
{
// Guardar Excepción
return(BadRequest(ex.Message.ToString()));
}
return(Ok());
}
public async Task Delete(AreaFasePreguntas value)
{
using (SqlConnection conn = new SqlConnection(_cnx))
{
using (SqlCommand cmd = new SqlCommand("Wsp_EliminaAreaFasePreguntas", conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@pIdAreaPreguntaFase", value.IdAreaPreguntaFase));
await conn.OpenAsync();
await cmd.ExecuteNonQueryAsync();
return;
}
}
}
public async Task Insert(AreaFasePreguntas value)
{
using (SqlConnection conn = new SqlConnection(_cnx))
{
using (SqlCommand cmd = new SqlCommand("Wsp_InsertaAreaFasePreguntas", conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@pIdArea", value.IdArea));
cmd.Parameters.Add(new SqlParameter("@pIdFase", value.IdFase));
cmd.Parameters.Add(new SqlParameter("@pIdPregunta", value.IdPregunta));
cmd.Parameters.Add(new SqlParameter("@@pRegCreateIdUsuario", value.RegCreateIdUsuario));
await conn.OpenAsync();
await cmd.ExecuteNonQueryAsync();
return;
}
}
}
