public object cerrarAsesoria(AsesoriaEspecial asesoria, int asesoria_id) { dynamic result = null; try { var dyParam = new OracleDynamicParameters(); dyParam.Add("a_id", OracleDbType.Int32, ParameterDirection.Input, asesoria_id); dyParam.Add("a_resolucion", OracleDbType.Varchar2, ParameterDirection.Input, asesoria.asesoriaComentarioResolucion); var conn = this.GetConnection(); if (conn.State == ConnectionState.Closed) { conn.Open(); } if (conn.State == ConnectionState.Open) { var query = "SP_EDITA_ASESORIA_ESP_CIERRE"; result = SqlMapper.Query(conn, query, param: dyParam, commandType: CommandType.StoredProcedure); } } catch (Exception ex) { throw ex; } return(result); }
public ActionResult cierraAsesoria([FromBody] AsesoriaEspecial asesoria, int id) { var result = asesoriaEspecialRepository.cerrarAsesoria(asesoria, id); if (result == null) { return(NotFound()); } return(Ok(result)); }
public ActionResult InsertCapacitacion([FromBody] AsesoriaEspecial asesoria) { var result = asesoriaEspecialRepository.insertAsesoria(asesoria); if (result == null) { return(NotFound()); } return(Ok(result)); }
public object insertAsesoria(AsesoriaEspecial asesoria) { dynamic result = null; try { var dyParam = new OracleDynamicParameters(); dyParam.Add("ae_nombre", OracleDbType.Varchar2, ParameterDirection.Input, asesoria.asesoriaEspecialNombre); dyParam.Add("ae_fecha", OracleDbType.Date, ParameterDirection.Input, asesoria.asesoriaEspecialFecha); dyParam.Add("ae_contrato_id", OracleDbType.Int32, ParameterDirection.Input, asesoria.contratoId); dyParam.Add("ae_profesional_id", OracleDbType.Int32, ParameterDirection.Input, asesoria.profesionalId); dyParam.Add("a_tipo_asesoria", OracleDbType.Int32, ParameterDirection.Input, asesoria.tipoAsesoriaEspecialId); var conn = this.GetConnection(); if (conn.State == ConnectionState.Closed) { conn.Open(); } if (conn.State == ConnectionState.Open) { var query = "SP_INSERT_ASESORIA_ESPECIAL"; result = SqlMapper.Query(conn, query, param: dyParam, commandType: CommandType.StoredProcedure); } } catch (Exception ex) { throw ex; } return(result); }