//Get Leagues into a list and returns to the page
        public async Task <IActionResult> OnGetAsync()
        {
            string userId = UserManager.GetUserId(User);

            //object GetSomething = this.Context.GetSP("FF_GetLeagues", 1037);
            GetLeagues = await this.Context.GetLeaguesAsync();

            GetJoinedLeagues = await this.Context.GetJoinedLeaguesAsync(userId);

            GetUnJoinedLeagues = GetLeagues.Except(GetJoinedLeagues).ToList();


            if (GetLeagues == null)
            {
                ViewData["ErrorMessage"] = $"No leagues have been found";
            }

            return(Page());
        }
 public object Get(GetLeagues request)
 {
     return Db.Select<League>();
 }