Пример #1
0
        public bool Sua(HT_SO_TT obj)
        {
            bool      kq       = true;
            EntityKey key      = null;
            object    original = null;

            try
            {
                using (Entities entities = ContextFactory.GetInstance())
                {
                    key = entities.CreateEntityKey(ENTITY_SET_NAME, obj);
                    if (entities.TryGetObjectByKey(key, out original))
                    {
                        entities.ApplyCurrentValues(key.EntitySetName, obj);
                    }
                    entities.SaveChanges();
                    kq = true;
                }
            }
            catch (System.Exception ex)
            {
                kq = false;
                LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
            }
            return(kq);
        }
Пример #2
0
        public bool SuaSoTiepTheo(HT_SO_TT obj)
        {
            bool kq = true;

            try
            {
                TransactionOptions transOption = new TransactionOptions();
                //transOption.IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted;
                transOption.IsolationLevel = System.Transactions.IsolationLevel.Serializable;
                transOption.Timeout        = TransactionManager.MaximumTimeout;
                using (TransactionScope transaction = new TransactionScope(TransactionScopeOption.Required, transOption))
                {
                    using (Entities entities = ContextFactory.GetInstance())
                    {
                        HT_SO_TT objOriginal = entities.HT_SO_TT.FirstOrDefault(e => e.MA_PHAN_HE.Equals(obj.MA_PHAN_HE) && e.GTRI_TPHAN.Equals(obj.GTRI_TPHAN));
                        objOriginal.SO_TIEP_THEO = obj.SO_TIEP_THEO;
                        entities.SaveChanges();
                        kq = true;
                        transaction.Complete();
                    }
                }
            }
            catch (System.Exception ex)
            {
                kq = false;
                LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
            }
            return(kq);
        }
Пример #3
0
        public HT_SO_TT GetByID(string maPhanHe, string giaTriThanhPhan)
        {
            HT_SO_TT kq = null;

            try
            {
                using (Entities entities = ContextFactory.GetInstance())
                {
                    kq = entities.HT_SO_TT.FirstOrDefault(e => e.MA_PHAN_HE.Equals(maPhanHe) && e.GTRI_TPHAN.Equals(giaTriThanhPhan));
                }
            }
            catch (System.Exception ex)
            {
                kq = null;
                LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
            }
            return(kq);
        }
Пример #4
0
        public bool Xoa(HT_SO_TT obj)
        {
            bool kq = true;

            try
            {
                using (Entities entities = ContextFactory.GetInstance())
                {
                    entities.DeleteObject(obj);
                    entities.SaveChanges();
                }
            }
            catch (System.Exception ex)
            {
                kq = false;
                LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex);
            }
            return(kq);
        }