public IEnumerable <SelectListItem> RetrieveMagazineCategory()
        {
            BlueprintMediaServisEntity   BMSentity = new BlueprintMediaServisEntity();
            IEnumerable <SelectListItem> enumarableMagazineCategoryList;
            List <SelectListItem>        magazineCategoryList = new List <SelectListItem>();

            foreach (MagazineCategory magazineCategory in BMSentity.MagazineCategory.ToList())
            {
                SelectListItem magazineCategoryItem = new SelectListItem()
                {
                    Text = magazineCategory.text, Value = magazineCategory.id.ToString()
                };
                magazineCategoryList.Add(magazineCategoryItem);
            }
            enumarableMagazineCategoryList = magazineCategoryList;

            return(enumarableMagazineCategoryList);
        }
        public List <MagazineCategory> RetriveMagazineCategory4API()
        {
            BlueprintMediaServisEntity db = new BlueprintMediaServisEntity();
            List <MagazineCategory>    magazineCategoryList = new List <MagazineCategory>();
            MagazineCategory           magazineCategoryTemp;

            foreach (MagazineCategory magazineCategoryItem in db.MagazineCategory)
            {
                magazineCategoryTemp      = new MagazineCategory();
                magazineCategoryTemp.id   = magazineCategoryItem.id;
                magazineCategoryTemp.text = magazineCategoryItem.text;


                magazineCategoryList.Add(magazineCategoryTemp);
            }

            //queryableMagazineCategoryList = (IQueryable<MagazineCategory>)magazineCategoryList;
            return(magazineCategoryList);
        }