Esempio n. 1
0
        internal Models.EjecutorTareaPreventa Select(Int32 ta207_idtareapreventa, Int32 t001_idficepi_ejecutor)
        {
            OpenDbConn();

            DAL.EjecutorTareaPreventa cEjecutorTareaPreventa = new DAL.EjecutorTareaPreventa(cDblib);
            return(cEjecutorTareaPreventa.Select(ta207_idtareapreventa, t001_idficepi_ejecutor));
        }
Esempio n. 2
0
        internal List <Models.EjecutorTareaPreventa> Catalogo(Models.EjecutorTareaPreventa oEjecutorTareaPreventaFilter)
        {
            OpenDbConn();

            DAL.EjecutorTareaPreventa cEjecutorTareaPreventa = new DAL.EjecutorTareaPreventa(cDblib);
            return(cEjecutorTareaPreventa.Catalogo(oEjecutorTareaPreventaFilter));
        }
Esempio n. 3
0
        internal int Update(Models.EjecutorTareaPreventa oEjecutorTareaPreventa)
        {
            Guid methodOwnerID = new Guid("2b6e2ba1-fe0f-4bff-a3ae-d03595b16f5b");

            OpenDbConn();

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

            try
            {
                DAL.EjecutorTareaPreventa cEjecutorTareaPreventa = new DAL.EjecutorTareaPreventa(cDblib);

                int result = cEjecutorTareaPreventa.Update(oEjecutorTareaPreventa);

                //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;
            }
        }
Esempio n. 4
0
        internal int Insert(Models.EjecutorTareaPreventa oEjecutorTareaPreventa)
        {
            Guid methodOwnerID = new Guid("521885ca-75bf-471c-af33-813d4b5dc803");

            OpenDbConn();

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

            try
            {
                DAL.EjecutorTareaPreventa cEjecutorTareaPreventa = new DAL.EjecutorTareaPreventa(cDblib);

                int idEjecutorTareaPreventa = cEjecutorTareaPreventa.Insert(oEjecutorTareaPreventa);

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

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

                throw ex;
            }
        }
Esempio n. 5
0
        internal int Delete(Int32 ta207_idtareapreventa, Int32 t001_idficepi_ejecutor)
        {
            Guid methodOwnerID = new Guid("1207c024-c823-4158-8b84-9dc7c4bce1fe");

            OpenDbConn();

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

            try
            {
                DAL.EjecutorTareaPreventa cEjecutorTareaPreventa = new DAL.EjecutorTareaPreventa(cDblib);

                int result = cEjecutorTareaPreventa.Delete(ta207_idtareapreventa, t001_idficepi_ejecutor);

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