/// <summary>
        /// Adds a New Category
        /// Level: Logic
        /// </summary>
        /// <param name="Category">The category</param>
        /// <param name="ImageURL">The image url</param>
        /// <param name="CategoryFK">The Parent ID</param>
        /// <returns>Category Result Enum</returns>
        public CategoryResult AddCategory(string Category, string ImageURL, int CategoryFK)
        {
            try
            {
                CategoriesRepository myRepository = new CategoriesRepository();

                if (CategoryFK > 0)
                {
                    //is child

                    if(!myRepository.ChildCategoryExists(Category, CategoryFK))
                    {
                        Common.Category myCategory = new Category();

                        myCategory.Category1 = Category;
                        myCategory.ImageURL = ImageURL;

                        myCategory.CategoryFK = CategoryFK;

                        myRepository.AddCategory(myCategory);

                        return CategoryResult.Successful;
                    }
                    else
                    {
                        return CategoryResult.Exists;
                    }
                }
                else if (CategoryFK == 0)
                {
                    //is parent
                    if (!myRepository.ParentCategoryExists(Category))
                    {
                        Common.Category myCategory = new Category();

                        myCategory.Category1 = Category;
                        myCategory.ImageURL = ImageURL;

                        myCategory.CategoryFK = null;

                        myRepository.AddCategory(myCategory);

                        return CategoryResult.Successful;
                    }
                    else
                    {
                        return CategoryResult.Exists;
                    }
                }
                else
                {
                    return CategoryResult.Exists;
                }
            }
            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;
            }
        }