public IEnumerable <tblCategory> GetCategory()
        {
            var context = new subzicartEntities();

            return((from p in context.Set <tblCategory>()
                    //where p.CategoryID == categoryID
                    select new { catId = p.catId, catName = p.catName }).ToList()
                   .Select(x => new tblCategory {
                catId = x.catId, catName = x.catName
            }));
        }
        public IEnumerable <tblBrandPrefix> GetBrand()
        {
            var context = new subzicartEntities();

            return((from p in context.Set <tblBrandPrefix>()
                    //where p.CategoryID == categoryID
                    select new { brand_id = p.brand_id, brand_name = p.brand_name }).ToList()
                   .Select(x => new tblBrandPrefix {
                brand_id = x.brand_id, brand_name = x.brand_name
            }));
        }