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