public List <Models.PRIOALERTAS> Catalogo() { OpenDbConn(); DAL.PRIOALERTAS cPRIOALERTAS = new DAL.PRIOALERTAS(cDblib); return(cPRIOALERTAS.Catalogo()); }
public int Update(Models.PRIOALERTAS oPRIOALERTAS) { Guid methodOwnerID = new Guid("1efd6df0-8ebe-42e3-a1e1-ef71b020dc68"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.PRIOALERTAS cPRIOALERTAS = new DAL.PRIOALERTAS(cDblib); int result = cPRIOALERTAS.Update(oPRIOALERTAS); //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); if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }
public int Insert(Models.PRIOALERTAS oPRIOALERTAS) { Guid methodOwnerID = new Guid("afb9ebac-943a-4752-a77c-b7d83c7eee80"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.PRIOALERTAS cPRIOALERTAS = new DAL.PRIOALERTAS(cDblib); int idPRIOALERTAS = cPRIOALERTAS.Insert(oPRIOALERTAS); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(idPRIOALERTAS); } catch (Exception ex) { //rollback //if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.rollbackTransaction(methodOwnerID); if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }