/// <summary>
        /// Gets the parent category.
        /// </summary>
        /// <param name="id">The identifier.</param>
        /// <returns></returns>
        public String GetParentCategory(string id)
        {
            LookupSubcategory lkup = new LookupSubcategory();

            using (ISession session = CreateSession())
            {
                lkup = session.Get <LookupSubcategory>(id);
            }
            return(lkup.LookupCategory.Catid);
        }
        /// <summary>
        /// Gets the parent category.
        /// </summary>
        /// <param name="id">The identifier.</param>
        /// <param name="obj">if set to <c>true</c> [object].</param>
        /// <returns></returns>
        public LookupCategory GetParentCategory(string id, bool obj)
        {
            LookupSubcategory lkup = new LookupSubcategory();

            using (ISession session = CreateSession())
            {
                lkup = session.Get <LookupSubcategory>(id);
            }
            NHibernateUtil.Initialize(lkup.LookupCategory);
            return(lkup.LookupCategory);
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="id"></param>
        /// <param name="parent"></param>
        /// <returns></returns>
        public LookupSubcategory GetSubCategory(string id, bool parent = false)
        {
            LookupSubcategory lkup = new LookupSubcategory();

            using (ISession session = CreateSession())
            {
                lkup = session.Get <LookupSubcategory>(id);
                if (parent == true && lkup != null)
                {
                    NHibernateUtil.Initialize(lkup.LookupCategory);
                }
            }

            return(lkup);
        }