public async Task <ResponsePostDetail> InsInformacionGeneral(InformacionGeneralQueryFilter informacionGeneralQueryFilter)
{
try
{
var affectedRows = 0;
var dyParam = new OracleDynamicParameters();
dyParam.Add("id_pre_inscripcion", OracleDbType.Int32, ParameterDirection.Input, informacionGeneralQueryFilter.IdPreInscripcion);
dyParam.Add("id_carrera", OracleDbType.Int32, ParameterDirection.Input, informacionGeneralQueryFilter.IdCarrera);
dyParam.Add("id_periodo_academico", OracleDbType.Int32, ParameterDirection.Input, informacionGeneralQueryFilter.IdPeriodoAcademico);
dyParam.Add("fecha_inscripcion", OracleDbType.Date, ParameterDirection.Input, informacionGeneralQueryFilter.FechaInscripcion);
dyParam.Add("observacion", OracleDbType.Varchar2, ParameterDirection.Input, informacionGeneralQueryFilter.Observacion);
dyParam.Add("estado_transaccion", OracleDbType.Varchar2, ParameterDirection.Input, informacionGeneralQueryFilter.EstadoTransaccion);
dyParam.Add("affected_rows", OracleDbType.Int32, ParameterDirection.Output, 0);
var query = "ACADEMICO.PREINSCRIPCION.SP_INSERTAR_INSCRIPCION";
await _coneccion.InsData(dyParam, query);
affectedRows = dyParam.Get("affected_rows");
return(new ResponsePostDetail()
{
Process = "Pre Inscripcion",
AffectedRows = affectedRows
});
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
public async Task <ResponsePostDetail> InsTestAsync(TestInsQueryFilter testInsQueryFilter)
{
try
{
var affectedRows = 0;
var dyParam = new OracleDynamicParameters();
dyParam.Add("valor", OracleDbType.Varchar2, ParameterDirection.Input, testInsQueryFilter.Valor);
dyParam.Add("affected_rows", OracleDbType.Int32, ParameterDirection.Output, 0);
await _coneccion.InsData(dyParam, "TestAcad.SP_INSERTTEST");
affectedRows = dyParam.Get("affected_rows");
return(new ResponsePostDetail()
{
Process = "Test",
AffectedRows = affectedRows
});
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}