public object insertPagoContratoDetalle(PagoContratoDetalle pago)
        {
            object result = null;

            try
            {
                var dyParam = new OracleDynamicParameters();

                dyParam.Add("pcd_desc", OracleDbType.Varchar2, ParameterDirection.Input, pago.pagoContratoDetalleDes);
                dyParam.Add("pcd_pago_id", OracleDbType.Varchar2, ParameterDirection.Input, pago.pagoContratoId);



                var conn = this.GetConnection();
                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }

                if (conn.State == ConnectionState.Open)
                {
                    var query = "SP_INS_PAGO_CONTRATO_DET_BY_ID";

                    result = SqlMapper.Query(conn, query, param: dyParam, commandType: CommandType.StoredProcedure);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(pago);
        }
コード例 #2
0
        public ActionResult InsertContrato([FromBody] PagoContratoDetalle pagoContrato)
        {
            var response = pagoContratoDetalleRepository.insertPagoContratoDetalle(pagoContrato);

            return(Ok());
        }