public TypeConsultationRightItem InsertRight(TypeConsultationRightItem item)
        {
            try
            {
                TmpTypeConsultationRight entity = new TmpTypeConsultationRight
                {
                    TypeConsultationRightID = 0,
                    TypeConsultationID      = item.TypeConsultationID,
                    HumanRightID            = item.HumanRightID,
                    GUID = item.GUID
                };

                db.TmpTypeConsultationRights.Add(entity);

                db.SaveChanges();

                item.ID = entity.ID;
                item.TypeConsultationRightID = entity.TypeConsultationRightID;
                HumanRight humanRight = db.HumanRights.Find(item.HumanRightID);
                item.HumanRightName = humanRight.HumanRightName;

                return(item);
            }
            catch (Exception ex)
            {
                exception = ex;
                return(null);
            }
        }
        public TypeConsultationRightItem UpdateRight(TypeConsultationRightItem item)
        {
            try
            {
                TmpTypeConsultationRight entity = new TmpTypeConsultationRight
                {
                    ID = item.ID,
                    TypeConsultationRightID = item.TypeConsultationRightID,
                    TypeConsultationID      = item.TypeConsultationID,
                    HumanRightID            = item.HumanRightID,
                    GUID = item.GUID
                };

                db.TmpTypeConsultationRights.Attach(entity);
                db.Entry(entity).State = EntityState.Modified;

                db.SaveChanges();

                HumanRight humanRight = db.HumanRights.Find(item.HumanRightID);
                item.HumanRightName = humanRight.HumanRightName;
                return(item);
            }
            catch (Exception ex)
            {
                exception = ex;
                return(null);
            }
        }
        public TypeConsultationRightItem DeleteRight(TypeConsultationRightItem item)
        {
            try
            {
                TmpTypeConsultationRight entity = new TmpTypeConsultationRight
                {
                    ID = item.ID,
                    TypeConsultationRightID = item.TypeConsultationRightID,
                    TypeConsultationID      = item.TypeConsultationID,
                    HumanRightID            = item.HumanRightID,
                    GUID = item.GUID
                };

                db.TmpTypeConsultationRights.Attach(entity);
                db.TmpTypeConsultationRights.Remove(entity);

                db.SaveChanges();
                return(item);
            }
            catch (Exception ex)
            {
                exception = ex;
                return(null);
            }
        }