public async Task <IActionResult> GetUserLeagues()
{
AllUserLeaguesViewModel LUVM = new AllUserLeaguesViewModel();
List <AllUserLeaguesViewModel> LUVMList = new List <AllUserLeaguesViewModel>();
List <League> leagues = _context.Leagues.ToList();
List <Team> teams = _context.Teams.ToList();
List <AppUser> users = _context.AppUser.ToList();
List <UserLeague> userLeagues = _context.UserLeagues.ToList();
foreach (UserLeague UL in userLeagues)
{
foreach (League L in leagues)
{
if (L.LeagueId == UL.LeagueForeignKey)
{
LUVM.leagueName = L.LeagueName;
}
}
foreach (AppUser AU in users)
{
if (AU.Id == UL.AppUserForeignKey)
{
LUVM.userName = AU.FullName;
LUVM.userID = AU.Id;
}
}
foreach (Team T in teams)
{
if (T.TeamID == UL.TeamForeignKey)
{
LUVM.teamName = T.TeamName;
}
}
LUVMList.Add(LUVM);
LUVMList = LUVMList.OrderBy(id => id.userID).ToList();
LUVM = new AllUserLeaguesViewModel();
}
return(Ok(LUVMList));
}
public async Task <IActionResult> Get()
{
//HttpContext.User
var userId = _caller.Claims.Single(c => c.Type == "id");
var appuser = await _context.AppUser.Include(c => c.IdentityUser).SingleAsync(c => c.IdentityUser.Id == userId.Value);
var uLeagues = _context.UserLeagues.ToList();
var Leagues = _context.Leagues.ToList();
var Teams = _context.Teams.ToList();
AllUserLeaguesViewModel AULVM = new AllUserLeaguesViewModel();
List <AllUserLeaguesViewModel> userLeagues = new List <AllUserLeaguesViewModel>();
foreach (UserLeague UL in uLeagues)
{
if (UL.AppUserForeignKey == appuser.Id)
{
AULVM.userID = UL.UserLeagueID;
foreach (Team T in Teams)
{
if (T.TeamID == UL.TeamForeignKey)
{
AULVM.teamName = T.TeamName;
}
}
foreach (League L in Leagues)
{
if (UL.LeagueForeignKey == L.LeagueId)
{
AULVM.leagueName = L.LeagueName;
}
}
userLeagues.Add(AULVM);
AULVM = new AllUserLeaguesViewModel();
}
}
return(Ok(userLeagues));
}
