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