public string Insert(IB.Progress.Models.TRAMITACIONCAMBIOROL_INS oTRAMITACIONCAMBIOROL)
        {
            Guid methodOwnerID = new Guid("fcdd9d71-5b97-4b47-b221-0287c3d0b499");

            OpenDbConn();

            if (cDblib.Transaction.ownerID.Equals(new Guid()))
            {
                cDblib.beginTransaction(methodOwnerID);
            }

            try{
                IB.Progress.DAL.TramitacionCambioRol cTRAMITACIONCAMBIOROL = new IB.Progress.DAL.TramitacionCambioRol(cDblib);

                string idTRAMITACIONCAMBIOROL = cTRAMITACIONCAMBIOROL.Insert(oTRAMITACIONCAMBIOROL);

                //Finalizar transacción
                if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
                {
                    cDblib.commitTransaction(methodOwnerID);
                }

                return(idTRAMITACIONCAMBIOROL);
            }
            catch (Exception ex) {
                //rollback
                if (cDblib.Transaction.ownerID.Equals(new Guid()))
                {
                    cDblib.rollbackTransaction(methodOwnerID);
                }

                throw ex;
            }
        }
        public int NoAceptacion(int t940_idtramitacambiorol, string t940_motivorechazo, int t001_idficepi_aprobador)
        {
            Guid methodOwnerID = new Guid("3bf109fe-8e69-4e33-a303-42b8046ebc0d");

            OpenDbConn();

            if (cDblib.Transaction.ownerID.Equals(new Guid()))
            {
                cDblib.beginTransaction(methodOwnerID);
            }

            try{
                IB.Progress.DAL.TramitacionCambioRol cTRAMITACIONCAMBIOROL = new IB.Progress.DAL.TramitacionCambioRol(cDblib);

                int result = cTRAMITACIONCAMBIOROL.NoAceptacion(t940_idtramitacambiorol, t940_motivorechazo, t001_idficepi_aprobador);

                //Finalizar transacción
                if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
                {
                    cDblib.commitTransaction(methodOwnerID);
                }

                return(result);
            }
            catch (Exception ex) {
                //rollback
                if (cDblib.Transaction.ownerID.Equals(new Guid()))
                {
                    cDblib.rollbackTransaction(methodOwnerID);
                }

                throw ex;
            }
        }
        public int Delete(int t940_idtramitacambiorol)
        {
            Guid methodOwnerID = new Guid("c71bd9f3-10ed-43e1-9e24-cbcce10e8c43");

            OpenDbConn();

            if (cDblib.Transaction.ownerID.Equals(new Guid()))
            {
                cDblib.beginTransaction(methodOwnerID);
            }

            try
            {
                IB.Progress.DAL.TramitacionCambioRol cTRAMITACIONCAMBIOROL = new IB.Progress.DAL.TramitacionCambioRol(cDblib);

                int result = cTRAMITACIONCAMBIOROL.Delete(t940_idtramitacambiorol);

                //Finalizar transacción
                if (cDblib.Transaction.ownerID.Equals(methodOwnerID))
                {
                    cDblib.commitTransaction(methodOwnerID);
                }

                return(result);
            }
            catch (Exception ex)
            {
                //rollback
                if (cDblib.Transaction.ownerID.Equals(new Guid()))
                {
                    cDblib.rollbackTransaction(methodOwnerID);
                }

                throw ex;
            }
        }