public List <Models.AccionT> Catalogo(int t600_idasunto) { OpenDbConn(); DAL.AccionT cConsulta = new DAL.AccionT(cDblib); return(cConsulta.Catalogo(t600_idasunto)); }
public void BorrarAcciones(List <Models.AccionT> lista) { Guid methodOwnerID = new Guid("3BC30F92-578A-4551-807F-74019A4DE66F"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { cDblib.beginTransaction(methodOwnerID); } try { DAL.AccionT cAccion = new DAL.AccionT(cDblib); foreach (Models.AccionT oAccion in lista) { cAccion.Delete(oAccion.T601_idaccion); } //Finalizar transacción if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.commitTransaction(methodOwnerID); } } catch (Exception ex) {//rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw ex; } }
public Models.AccionT Select(Int32 t601_idaccion) { OpenDbConn(); DAL.AccionT cAccionTarea = new DAL.AccionT(cDblib); return(cAccionTarea.Select(t601_idaccion)); }
public int grabar(Models.AccionT DatosGenerales, List <Models.AccionRecursosT> Integrantes) { int idReferencia; bool bConTransaccion = false; Guid methodOwnerID = new Guid("9BA8A99E-6FE6-41EC-BDA6-1A123F0E7C9A"); OpenDbConn(); if (cDblib.Transaction.ownerID.Equals(new Guid())) { bConTransaccion = true; } if (bConTransaccion) { cDblib.beginTransaction(methodOwnerID); } try { DAL.AccionT oAccion = new DAL.AccionT(cDblib); DAL.AccionRecursosT oRecursoDAL = new DAL.AccionRecursosT(cDblib); if (DatosGenerales.T601_idaccion == -1) { DatosGenerales.T601_fcreacion = System.DateTime.Now; idReferencia = oAccion.Insert(DatosGenerales); } else { oAccion.Update(DatosGenerales); idReferencia = DatosGenerales.T601_idaccion; } foreach (Models.AccionRecursosT oRecurso in Integrantes) { switch (oRecurso.accionBD) { case "I": //Inserción oRecurso.t601_idaccion = idReferencia; oRecursoDAL.Insert(oRecurso); break; case "D": //delete oRecursoDAL.Delete(oRecurso); break; case "U": //update oRecursoDAL.Update(oRecurso); break; } } if (bConTransaccion) { cDblib.commitTransaction(methodOwnerID); } return(idReferencia); } catch (Exception ex) { //rollback if (cDblib.Transaction.ownerID.Equals(methodOwnerID)) { cDblib.rollbackTransaction(methodOwnerID); } throw new Exception(ex.Message); } finally { //nota.Dispose(); } }