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