//internal Models.ParametrizacionDestinoPT Select(Int32 ta212_idorganizacioncomercial, Int32 t001_idficepi_comercial) //{ // OpenDbConn(); // DAL.ParametrizacionDestinoPT cParametrizacionDestinoPT = new DAL.ParametrizacionDestinoPT(cDblib); // return cParametrizacionDestinoPT.Select(ta212_idorganizacioncomercial, t001_idficepi_comercial); //} public void GrabarLista(List <Models.ParametrizacionDestinoPT> Lista) { bool bConTransaccion = false; Guid methodOwnerID = new Guid("E465FE3F-8D65-4169-B50D-886F3C1B10E2"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { bConTransaccion = true; } if (bConTransaccion) { cDblib.beginTransaction(methodOwnerID); } DAL.ParametrizacionDestinoPT bDestinoPT = new DAL.ParametrizacionDestinoPT(cDblib); try { foreach (Models.ParametrizacionDestinoPT oElem in Lista) { switch (oElem.bd) { case "I": bDestinoPT.Insert(oElem); break; case "U": bDestinoPT.Update(oElem); break; case "D": bDestinoPT.Delete(oElem.ta212_idorganizacioncomercial, oElem.t001_idficepi_comercial); break; } } if (bConTransaccion) { cDblib.commitTransaction(methodOwnerID); } } catch (Exception ex) { if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw new Exception(ex.Message); } finally { //bDestinoPT.Dispose(); } }
//public int Update(Models.ParametrizacionDestinoPT oParametrizacionDestinoPT) //{ // Guid methodOwnerID = new Guid("b04e7dda-c769-4161-bb55-77b2bf02e057"); // OpenDbConn(); // if (cDblib.Transaction.ownerID.Equals(new Guid())) cDblib.beginTransaction(methodOwnerID); // try // { // DAL.ParametrizacionDestinoPT cParametrizacionDestinoPT = new DAL.ParametrizacionDestinoPT(cDblib); // int result = cParametrizacionDestinoPT.Update(oParametrizacionDestinoPT); // //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; // } //} internal int Delete(Int32 ta212_idorganizacioncomercial, Int32 t001_idficepi_comercial) { Guid methodOwnerID = new Guid("47203473-5d52-4309-9ce9-445eab498858"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.ParametrizacionDestinoPT cParametrizacionDestinoPT = new DAL.ParametrizacionDestinoPT(cDblib); int result = cParametrizacionDestinoPT.Delete(ta212_idorganizacioncomercial, t001_idficepi_comercial); //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } return(result); } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }