public ActionResult InsertCapacitacion([FromBody] RegistroAccidente registro) { var result = registroAccidenteRepository.insertRegistroAccidente(registro); if (result == null) { return(NotFound()); } return(Ok(result)); }
public object insertRegistroAccidente(RegistroAccidente registro) { object result = null; try { var dyParam = new OracleDynamicParameters(); dyParam.Add("r_nombre", OracleDbType.Varchar2, ParameterDirection.Input, registro.regigstroAccidenteNombre); dyParam.Add("r_fecha", OracleDbType.Date, ParameterDirection.Input, registro.registroAccidenteFecha); dyParam.Add("p_id", OracleDbType.Int32, ParameterDirection.Input, registro.profesionalId); dyParam.Add("c_id", OracleDbType.Int32, ParameterDirection.Input, registro.contratoId); dyParam.Add("a_id", OracleDbType.Int32, ParameterDirection.Input, registro.asesoriaId); var conn = this.GetConnection(); if (conn.State == ConnectionState.Closed) { conn.Open(); } if (conn.State == ConnectionState.Open) { var query = "SP_INSERT_REGISTRO_ACCIDENTE"; result = SqlMapper.Query(conn, query, param: dyParam, commandType: CommandType.StoredProcedure); } } catch (Exception ex) { throw ex; } return(registro); }