private bool Save()
        {
            bool result = false;

            using (var ctx = new EF6.RT2020Entities())
            {
                var item = ctx.SmartTag4Member.Find(_SmartTagId);

                if (item == null)
                {
                    item         = new EF6.SmartTag4Member();
                    item.TagId   = Guid.NewGuid();
                    item.TagCode = txtTagCode.Text;

                    ctx.SmartTag4Member.Add(item);
                }
                item.TagName     = txtTagName.Text;
                item.TagName_Chs = txtTagNameAlt1.Text;
                item.TagName_Cht = txtTagNameAlt2.Text;
                item.Priority    = Convert.ToInt32(txtPriority.Text);

                ctx.SaveChanges();
                result = true;
            }

            return(result);
        }
示例#2
0
        /// <summary>
        /// Get a EF6.SmartTag4Member object from the database using the given TagId
        /// </summary>
        /// <param name="tagId">The primary key value</param>
        /// <returns>A EF6.SmartTag4Member object</returns>
        public static EF6.SmartTag4Member Get(Guid tagId)
        {
            EF6.SmartTag4Member result = null;

            using (var ctx = new EF6.RT2020Entities())
            {
                result = ctx.SmartTag4Member.Where(x => x.TagId == tagId).AsNoTracking().FirstOrDefault();
            }

            return(result);
        }
示例#3
0
        public static EF6.SmartTag4Member GetByTagCode(string code)
        {
            EF6.SmartTag4Member result = null;

            using (var ctx = new EF6.RT2020Entities())
            {
                result = ctx.SmartTag4Member.Where(x => x.TagCode == code).FirstOrDefault();
            }

            return(result);
        }
示例#4
0
        /// <summary>
        /// Get a EF6.SmartTag4Member object from the database using the given QueryString
        /// </summary>
        /// <param name="tagId">The primary key value</param>
        /// <returns>A EF6.SmartTag4Member object</returns>
        public static EF6.SmartTag4Member Get(string whereClause)
        {
            EF6.SmartTag4Member result = null;

            using (var ctx = new EF6.RT2020Entities())
            {
                result = ctx.SmartTag4Member
                         .SqlQuery(string.Format("Select * from SmartTag4Member Where {0}", whereClause))
                         .AsNoTracking()
                         .FirstOrDefault();
            }

            return(result);
        }