public bool deleteCategory(CategoryList category)
        {
            Lup_Category cat = db.Lup_Category.Select(x => x)
                               .Where(x => x.CategoryId == category.CategoryId)
                               .FirstOrDefault();

            cat.IsActive = !cat.IsActive;
            cat.LADate   = DateTime.Now;
            bool isSuccess = (db.SaveChanges() > 0 ? true : false);

            return(isSuccess);
        }
        public bool updateCategory(CategoryList category)
        {
            Lup_Category cat = db.Lup_Category.Select(x => x)
                               .Where(x => x.CategoryId == category.CategoryId)
                               .FirstOrDefault();

            cat.CategoryImage = category.CategoryImage;
            cat.LADate        = DateTime.Now;
            var catT = cat.Lup_CategoryTranslation.Select(x => x).FirstOrDefault();

            catT.CategoryTitle = category.CategoryTitle;
            catT.LADate        = DateTime.Now;
            //catT.LanguageId = category.LanguageId;

            bool isSuccess = (db.SaveChanges() > 0 ? true : false);

            return(isSuccess);
        }
        public bool createCategory(CategoryList category)
        {
            var cat = new Lup_Category();

            cat.CategoryImage = category.CategoryImage;
            cat.IsActive      = true;
            cat.RCDate        = DateTime.Now;

            var catT = new Lup_CategoryTranslation();

            catT.CategoryTitle = category.CategoryTitle;
            catT.LanguageId    = 1;
            catT.RCDate        = DateTime.Now;
            cat.Lup_CategoryTranslation.Add(catT);
            db.Lup_Category.Add(cat);
            bool isSuccess = (db.SaveChanges() > 0 ? true : false);

            return(isSuccess);
        }