@model KBL.ViewModels.IndexPageViewModel


<section id="standings" class="top-border">

    <div class="input-group">
        <h4>STANDINGS</h4>
        <div class="input-group-btn">
            <button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Event <span class="caret"></span></button>
            <ul class="dropdown-menu">
                <ul class="nav nav-pills nav-stacked">
                    @foreach (var _event in Model.EventsVM.Events)
                    {
                        <li>
                            <a role="presentation" href="#@_event.Id" data-toggle="tab">
                                <h6>@_event.Name</h6>
                            </a>
                        </li>
                    }
                </ul>
            </ul>
        </div><!-- /btn-group -->
    </div><!-- /input-group -->

        <div class="tab-content">
            <!--ACTIVE panel-->
            @{Events active_event = Model.EventsVM.Events.FirstOrDefault(e => e.Id == 9);

                <div role="tabpanel" id="@active_event.Id" class="tab-pane active">
                    <h4>@active_event.Name</h4>
                    <table class="table table-condensed">
                        <thead>
                            <tr>
                                <th></th>
                                <th><abbr title="Wins">W</abbr></th>
                                <th><abbr title="Games Behind">G</abbr></th>
                                <th><abbr title="Winning Percentage" align="center">%</abbr></th>
                                <th><abbr title="Runs In Out">SR</abbr></th>
                            </tr>
                        </thead>
                        <tbody>
                            @{IList<StandingsList> ActiveStandings = new List<StandingsList>();}

                            @{IEnumerable<EventsTeams> eventsTeamsActive = Model.EventsVM.EventsTeams.Where(ent => ent.EventId == active_event.Id);}
                            @foreach (var _teams in eventsTeamsActive)
                            {
                                Teams team = Model.Teams.FirstOrDefault(t => t.Id == _teams.TeamName);

                                IEnumerable<Games> Games = Model.Games.Where(games => games.EventID == active_event.Id);
                                IEnumerable<Games> gamesCountGuest = Games.Where(games => games.GuestTeamID == team.Id && games.WinTeamId != 0);
                                int guestScoreOut = gamesCountGuest.Sum(x => x.GuestRuns);
                                int guestScoreIn = gamesCountGuest.Sum(x => x.HomeRuns);
                                IEnumerable<Games> gamesGuestWin = gamesCountGuest.Where(games => games.WinTeamId == team.Id);
                                IEnumerable<Games> gamesCountHome = Games.Where(games => games.HomeTeamID == team.Id && games.WinTeamId != 0);
                                int homeScoreOut = gamesCountHome.Sum(x => x.HomeRuns);
                                int homeScoreIn = gamesCountHome.Sum(x => x.GuestRuns);
                                IEnumerable<Games> gamesHomeWin = gamesCountHome.Where(games => games.WinTeamId == team.Id);
                                int gamesCount = gamesCountGuest.Count() + gamesCountHome.Count();
                                int gamesWinCount = gamesGuestWin.Count() + gamesHomeWin.Count();
                                int loses = gamesCount - gamesWinCount;
                                double winP = 0;
                                if (gamesWinCount != 0) { winP = Math.Round((double)gamesWinCount / gamesCount, 3); }
                                StandingsList obj = new StandingsList();
                                obj.teamID = team.Id;
                                obj.Name = team.Name;
                                obj.Wins = gamesWinCount;
                                obj.Loses = loses;
                                obj.WinP = winP;
                                obj.GamesCount = gamesCount;
                                obj.RIO = (guestScoreOut + homeScoreOut).ToString() + "-" + (guestScoreIn + homeScoreIn).ToString();
                                obj.RunsMissed = guestScoreIn + homeScoreIn;
                                obj.RunsScored = guestScoreOut + homeScoreOut;
                                obj.logoURL = team.capLogoURL;
                                ActiveStandings.Add(obj);
                            }
                            @foreach (var item in ActiveStandings.OrderByDescending(x => x.WinP).ThenByDescending(x => x.GamesCount).ThenBy(x=>x.RunsMissed).ThenByDescending(x=>x.RunsScored))
                            {
                                <tr class="first">
                                    <td nowrap><a asp-action="Details" asp-controller="Teams" asp-route-id="@item.teamID"><img src="@item.logoURL" width="16" height="16" align="middle" /><font size="2">@item.Name</font></a></td>
                                    <td nowrap>@item.Wins</td>
                                    <td nowrap>@item.GamesCount</td>
                                    <td nowrap>
                                        @if (@item.WinP != 1 && @item.WinP != 0)
                                        {
                                            string s_winP = "." + (@item.WinP * 1000).ToString();
                                            @s_winP.ToString();
                                        }
                                        else
                                        {
                                            @item.WinP;
                                        }
                                    </td>
                                    <td nowrap>@item.RIO</td>
                                </tr>
                            }
                        </tbody>
                    </table>
                </div>
                                }
            <!--end of panels-->
            <!--ALL panels-->
            @foreach (var _event in Model.EventsVM.Events)
            {
                        <div role="tabpanel" id="@_event.Id" class="tab-pane">
                            <h4>@_event.Name</h4>
                            <table class="table table-condensed">
                                <thead>
                                    <tr>
                                        <th></th>
                                        <th><abbr title="Wins">W</abbr></th>
                                        <th><abbr title="Games">G</abbr></th>
                                        <th><abbr title="Winning Percentage" align="center">%</abbr></th>
                                        <th><abbr title="Runs In Out">SR</abbr></th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @{IList<StandingsList> standings = new List<StandingsList>();}

                                    @{IEnumerable<EventsTeams> eventsTeams = Model.EventsVM.EventsTeams.Where(ent => ent.EventId == _event.Id);}
                                    @foreach (var _teams in eventsTeams)
                                    {
                                        Teams team = Model.Teams.FirstOrDefault(t => t.Id == _teams.TeamName);

                                        IEnumerable<Games> Games = Model.Games.Where(games => games.EventID == _event.Id);
                                        IEnumerable<Games> gamesCountGuest = Games.Where(games => games.GuestTeamID == team.Id);
                                        int guestScoreOut = gamesCountGuest.Sum(x => x.GuestRuns);
                                        int guestScoreIn = gamesCountGuest.Sum(x => x.HomeRuns);
                                        IEnumerable<Games> gamesGuestWin = gamesCountGuest.Where(games => games.WinTeamId == team.Id);
                                        IEnumerable<Games> gamesCountHome = Games.Where(games => games.HomeTeamID == team.Id);
                                        int homeScoreOut = gamesCountHome.Sum(x => x.HomeRuns);
                                        int homeScoreIn = gamesCountHome.Sum(x => x.GuestRuns);
                                        IEnumerable<Games> gamesHomeWin = gamesCountHome.Where(games => games.WinTeamId == team.Id);
                                        int gamesCount = gamesCountGuest.Count() + gamesCountHome.Count();
                                        int gamesWinCount = gamesGuestWin.Count() + gamesHomeWin.Count();
                                        int loses = gamesCount - gamesWinCount;
                                        double winP = 0;
                                        if (gamesWinCount != 0) { winP = Math.Round((double)gamesWinCount / gamesCount, 3); }
                                        StandingsList obj = new StandingsList();
                                        obj.Name = team.Name;
                                        obj.Wins = gamesWinCount;
                                        obj.Loses = loses;
                                        obj.WinP = winP;
                                        obj.GamesCount = gamesCount;
                                        obj.RIO = (guestScoreOut + homeScoreOut).ToString() + "-" + (guestScoreIn + homeScoreIn).ToString();
                                        obj.logoURL = team.capLogoURL;
                                        standings.Add(obj);
                                    }
                                    @foreach (var item in standings.OrderByDescending(x => x.WinP).ThenByDescending(x => x.GamesCount))
                                    {
                                        <tr class="first">
                                            <td nowrap><a asp-action="Details" asp-controller="Teams" asp-route-id="@item.teamID"><img src="@item.logoURL" width="16" height="16" align="middle" /><font size="2">@item.Name</font></a></td>
                                            <td nowrap>@item.Wins</td>
                                            <td nowrap>@item.GamesCount</td>
                                            <td nowrap>
                                                @if (@item.WinP != 1 && @item.WinP != 0)
                                                {
                                                    string s_winP = "." + (@item.WinP * 1000).ToString();
                                                    @s_winP.ToString();
                                                }
                                                else
                                                {
                                                    @item.WinP;
                                                }
                                            </td>
                                            <td nowrap>@item.RIO</td>
                                        </tr>
                                    }
                                </tbody>
                            </table>
                        </div>
                        }
                        <!--end of panels-->
                    </div>
</section>