/// <summary>
        /// Deletes a category
        /// Level: Logic
        /// </summary>
        /// <param name="CategoryID">The category id</param>
        /// <returns>True if deleted, false if not deleted</returns>
        public bool DeleteCategory(int CategoryID)
        {
            try
            {
                CategoriesRepository myRepository = new CategoriesRepository();

                if ((!myRepository.CheckForSubCategories(CategoryID)) &&
                    (!myRepository.CheckForAssignedProducts(CategoryID)))
                {
                    myRepository.DeleteCategory(CategoryID);
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (Exception Exception)
            {
                throw Exception;
            }
        }
        /// <summary>
        /// Assigns a Category as a Child Category
        /// Level: Logic
        /// </summary>
        /// <param name="CategoryID">The category id</param>
        /// <param name="Category">The category</param>
        /// <param name="ImageURL">The image url</param>
        /// <param name="ParentID">The parent id</param>
        /// <returns>If successful return true, else return false</returns>
        public bool AssignCategoryAsChild(int CategoryID, string Category, string ImageURL, int ParentID)
        {
            try
            {
                CategoriesRepository myRepository = new CategoriesRepository();

                Category myCategoryToUpdate = RetrieveCategoryByID(CategoryID);
                Category myCategoryToCompare = myRepository.Entities.Categories.SingleOrDefault(c => c.Category1 == Category);

                bool isSameLocation = false;

                if ((myCategoryToUpdate != null) && (myCategoryToCompare != null))
                {
                    if ((myCategoryToUpdate.Id == myCategoryToCompare.Id) && (myCategoryToUpdate.CategoryFK == myCategoryToUpdate.CategoryFK))
                    {
                        isSameLocation = true;
                    }
                }

                if (isSameLocation)
                {
                    if (!myRepository.CheckForSubCategories(CategoryID))
                    {
                        myRepository.AssignCategoryAsChild(CategoryID, Category, ImageURL, ParentID);
                        return true;
                    }
                    else
                    {
                        return false;
                    }
                }
                else
                {
                    if ((!myRepository.CheckForSubCategories(CategoryID)) &&
                        (!myRepository.ChildCategoryExists(Category, ParentID)))
                    {
                        myRepository.AssignCategoryAsChild(CategoryID, Category, ImageURL, ParentID);
                        return true;
                    }
                    else
                    {
                        return false;
                    }
                }
            }
            catch (Exception Exception)
            {
                throw Exception;
            }
        }