public object editTipoAsesoriaEspecial(TipoAsesoriaEspecial asesoria, int id) { object result = null; try { var dyParam = new OracleDynamicParameters(); dyParam.Add("ta_id", OracleDbType.Int32, ParameterDirection.Input, id); dyParam.Add("ta_nombre", OracleDbType.Varchar2, ParameterDirection.Input, asesoria.asesoriaEspecialNomnbre); var conn = this.GetConnection(); if (conn.State == ConnectionState.Closed) { conn.Open(); } if (conn.State == ConnectionState.Open) { var query = "SP_EDITA_TIP_ASE_ESPECIAL"; result = SqlMapper.Query(conn, query, param: dyParam, commandType: CommandType.StoredProcedure); } } catch (Exception ex) { throw ex; } return(asesoria); }
public object obtieneIdPorNombre(TipoAsesoriaEspecial asesoria) { dynamic result = null; try { var dyParam = new OracleDynamicParameters(); dyParam.Add("ta_nombre", OracleDbType.Varchar2, ParameterDirection.Input, asesoria.asesoriaEspecialNomnbre); dyParam.Add("EMPCURSOR", OracleDbType.RefCursor, ParameterDirection.Output); var conn = this.GetConnection(); if (conn.State == ConnectionState.Closed) { conn.Open(); } if (conn.State == ConnectionState.Open) { var query = "SP_OBTIENE_ID_TIPO_AS_ESP"; result = SqlMapper.Query(conn, query, param: dyParam, commandType: CommandType.StoredProcedure).SingleOrDefault(); } } catch (Exception ex) { throw ex; } return(result); }
public ActionResult cierraAsesoria([FromBody] TipoAsesoriaEspecial asesoria, int id) { var result = tipoAsesoriaEspecialRepository.editTipoAsesoriaEspecial(asesoria, id); if (result == null) { return(NotFound()); } return(Ok(result)); }
public ActionResult InsertCapacitacion([FromBody] TipoAsesoriaEspecial asesoria) { var result = tipoAsesoriaEspecialRepository.insertTipoAsesoriaEspecial(asesoria); if (result == null) { return(NotFound()); } return(Ok(result)); }
public ActionResult tipoAsesoriaByNombre([FromBody] TipoAsesoriaEspecial asesoria) { dynamic result = tipoAsesoriaEspecialRepository.obtieneIdPorNombre(asesoria); if (result == null) { return(NotFound(new { StatusCode = 204, data = "Sin registros" })); } return(Ok(new { StatusCode = 200, data = result })); }