Пример #1
0
        internal List <Models.ParticipanteTareaPreventa> Catalogo(Models.ParticipanteTareaPreventa oParticipanteTareaPreventaFilter)
        {
            OpenDbConn();

            DAL.ParticipanteTareaPreventa cParticipanteTareaPreventa = new DAL.ParticipanteTareaPreventa(cDblib);
            return(cParticipanteTareaPreventa.Catalogo(oParticipanteTareaPreventaFilter));
        }
Пример #2
0
        internal Models.ParticipanteTareaPreventa Select(Int32 ta207_idtareapreventa, Int32 t001_idficepi_participante)
        {
            OpenDbConn();

            DAL.ParticipanteTareaPreventa cParticipanteTareaPreventa = new DAL.ParticipanteTareaPreventa(cDblib);
            return(cParticipanteTareaPreventa.Select(ta207_idtareapreventa, t001_idficepi_participante));
        }
Пример #3
0
        public List <Models.TareaCatRequestFilter> CatalogoHistoricoParticipante(TareaCatHistoricoFilter rf)
        {
            OpenDbConn();


            DAL.ParticipanteTareaPreventa cAccionPreventa = new DAL.ParticipanteTareaPreventa(cDblib);
            return(cAccionPreventa.CatParticipanteTareaPreventa((int)HttpContext.Current.Session["IDFICEPI_PC_ACTUAL"], rf));
        }
Пример #4
0
        public int Update(Models.ParticipanteTareaPreventa oParticipanteTareaPreventa)
        {
            Guid methodOwnerID = new Guid("2b6e2ba1-fe0f-4bff-a3ae-d03595b16f5b");

            OpenDbConn();

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

            try
            {
                DAL.ParticipanteTareaPreventa cParticipanteTareaPreventa = new DAL.ParticipanteTareaPreventa(cDblib);

                int result = cParticipanteTareaPreventa.Update(oParticipanteTareaPreventa);

                //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;
            }
        }
Пример #5
0
        internal int Insert(Models.ParticipanteTareaPreventa oParticipanteTareaPreventa)
        {
            Guid methodOwnerID = new Guid("521885ca-75bf-471c-af33-813d4b5dc803");

            OpenDbConn();

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

            try
            {
                DAL.ParticipanteTareaPreventa cParticipanteTareaPreventa = new DAL.ParticipanteTareaPreventa(cDblib);

                int idParticipanteTareaPreventa = cParticipanteTareaPreventa.Insert(oParticipanteTareaPreventa);

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

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

                throw ex;
            }
        }
Пример #6
0
        internal int Delete(Int32 ta207_idtareapreventa, Int32 t001_idficepi_participante)
        {
            Guid methodOwnerID = new Guid("1207c024-c823-4158-8b84-9dc7c4bce1fe");

            OpenDbConn();

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

            try
            {
                DAL.ParticipanteTareaPreventa cParticipanteTareaPreventa = new DAL.ParticipanteTareaPreventa(cDblib);

                int result = cParticipanteTareaPreventa.Delete(ta207_idtareapreventa, t001_idficepi_participante);

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