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