Imports System.Collections.Generic
Imports System.ComponentModel
Imports System.Drawing
Imports System.Data
Imports System.Linq
Imports System.Text
Imports System.Threading.Tasks
Imports System.Windows.Forms
Imports FarPoint.Win.Spread
Imports FarPoint.Win
Imports FarPoint.Win.Spread.CellType
Imports GrapeCity.PointTable.SparkLines
Imports FarPoint.Win.Spread.Chart
Imports FarPoint.Win.Spread.Data

Imports Spread.Common.DataStore.Models
Imports Spread.Common.DataStore
Imports Spread.Common.Features.Spread.Common.Features.Sample

Partial Public Class GCPointTableControl
    Inherits BaseSampleControl
#Region "PrivateMembers"
    Private fpSpread As FpSpread

    Private teamList As List(Of Team)
    Private matchListCurrent As List(Of Match)
    Private matchListPrevious As List(Of Match)
    Private pointTableListCurrent As List(Of MatchPointTable)
    Private PointTanbleListPrevious As List(Of MatchPointTable)
    Private selectedYr As String = ""
    Private year As List(Of String) = Nothing
    Private _dataService As DataService
#End Region

#Region "ctor"
    Public Sub New()
        InitializeComponent()

        AddUIControls()

        AddHandler Load, AddressOf GCPointTableControl_Load
    End Sub
#End Region

#Region "Events"
    Private Sub GCPointTableControl_Load(sender As Object, e As EventArgs)
        _dataService = New DataService()

        SetRowColCount()
        AddEventHandlers()
        SetCellType()
        teamList = _dataService.JsonDataSource.GetAllTeams()
        Dim selectedYrs As String() = selectedYr.Split("-"c)
        Dim currentAndPreviousMatches As List(Of Match)() = _dataService.JsonDataSource.GetCurrentAndPreviousMatches(If(selectedYrs.Count() < 2, Convert.ToInt32(selectedYrs(0)), Convert.ToInt32(selectedYrs(1))), selectedYr)
        matchListCurrent = currentAndPreviousMatches(0)
        matchListPrevious = currentAndPreviousMatches(1)
        pointTableListCurrent = CreatePointTable(matchListCurrent)
        PointTanbleListPrevious = CreatePointTable(matchListPrevious)
        UpdateRank(pointTableListCurrent, PointTanbleListPrevious)
        UpdateDataOnSpread()
        CreateSparkLineForWinLoss()
        SetColor()
        SetColumnsRowsVisibility()
        SetFont()
        SetColWidth()
        SetHeaderAndText()
    End Sub

    Private Sub FpSpread_ComboSelChange(sender As Object, e As EditorNotifyEventArgs)
        Dim _ctrlTxt As String = TryCast(e.EditingControl, FpCombo).SelectedItem.ToString()
        selectedYr = If(year.IndexOf(_ctrlTxt) >= 0, year(year.IndexOf(_ctrlTxt)), selectedYr)
        Dim pf As New ProgressForm()
        Task.Factory.StartNew(Sub()

                                  Me.BeginInvoke(DirectCast(Sub()
                                                                fpSpread.Sheets(0).Cells(1, 4).Text = selectedYr.ToString()
                                                                pf.Location = PointToScreen(pnlMain.Location)
                                                                pf.Size = pnlMain.Size
                                                                pf.Opacity = 0.6
                                                                pf._progressBar.Width = pf.Width \ 2
                                                                pf._progressBar.Height = 30
                                                                pf._progressBar.Location = New Point(pf.Width \ 2 - pf.Width \ 4, pf.Height \ 2 - 15)
                                                                pf.ShowDialog()

                                                            End Sub, System.Action))
                                  fpSpread.SuspendLayout()
                                  Dim selectedYrs As String() = selectedYr.Split("-"c)
                                  Dim currentAndPreviousMatches As List(Of Match)() = _dataService.JsonDataSource.GetCurrentAndPreviousMatches(If(selectedYrs.Count() < 2, Convert.ToInt32(selectedYrs(0)), Convert.ToInt32(selectedYrs(1))), selectedYr)
                                  matchListCurrent = currentAndPreviousMatches(0)
                                  matchListPrevious = currentAndPreviousMatches(1)
                                  pointTableListCurrent = CreatePointTable(matchListCurrent)
                                  PointTanbleListPrevious = CreatePointTable(matchListPrevious)
                                  UpdateRank(pointTableListCurrent, PointTanbleListPrevious)
                                  UpdateDataOnSpread()
                                  CreateSparkLineForWinLoss()
                                  Me.BeginInvoke(DirectCast(Sub()
                                                                pf.Dispose()

                                                            End Sub, System.Action))
                                  fpSpread.ResumeLayout()

                              End Sub)
    End Sub

    Private Sub FpSpread_EditChange(sender As Object, e As EditorNotifyEventArgs)
        If e.Column >= 5 AndAlso e.Column <= 8 Then
            Dim total As Integer = Convert.ToInt32(fpSpread.Sheets(0).Cells(e.Row, 5).Text)
            Dim win As Integer = Convert.ToInt32(fpSpread.Sheets(0).Cells(e.Row, 6).Text)
            Dim loss As Integer = Convert.ToInt32(fpSpread.Sheets(0).Cells(e.Row, 7).Text)
            Dim draw As Integer = Convert.ToInt32(fpSpread.Sheets(0).Cells(e.Row, 8).Text)
            If total < (win + loss + draw) Then
                fpSpread.CancelCellEditing()
                MessageBox.Show("Total match (M) must be greater or equal to Won(W)+L(Loss)+D(Draw).")
            End If
        End If
    End Sub
#End Region

#Region "Methods"
    Private Sub AddUIControls()
        fpSpread = New FpSpread()
        fpSpread.Sheets.Clear()
        fpSpread.Sheets.Add(New SheetView())
        fpSpread.Dock = DockStyle.Fill

        pnlMain.Controls.Add(fpSpread)
    End Sub

    Private Sub SetRowColCount()
        fpSpread.Sheets(0).Rows.Count = 18
        fpSpread.Sheets(0).Columns.Count = 15
    End Sub
    Private Sub SetRowHeight(rowCnt As Integer)
        For i As Integer = 3 To rowCnt + 2
            fpSpread.Sheets(0).SetRowHeight(i, 35)
        Next
    End Sub
    Private Sub SetColWidth()

        For i As Integer = 0 To 8
            fpSpread.Sheets(0).Columns(i).Width = 35
        Next
        fpSpread.Sheets(0).Columns(4).Width = 200
        For i As Integer = 9 To 14
            fpSpread.Sheets(0).Columns(i).Width = 130
        Next
    End Sub
    Private Sub SetFont()
        'Set font
        fpSpread.Font = New Font("MS Sans Serif", 9, FontStyle.Regular)
        fpSpread.Sheets(0).Rows(0).Font = New Font("MS Sans Serif", 18, FontStyle.Bold)
        fpSpread.Sheets(0).Columns(4).Font = New Font("MS Sans Serif", 10, FontStyle.Regular)
        fpSpread.Sheets(0).Rows(1, 2).Font = New Font("MS Sans Serif", 9, FontStyle.Bold)
        fpSpread.Sheets(0).Rows(0).HorizontalAlignment = CellHorizontalAlignment.Center
        fpSpread.Sheets(0).Rows(2).HorizontalAlignment = CellHorizontalAlignment.Center
        fpSpread.Sheets(0).Rows(0, fpSpread.Sheets(0).Rows.Count - 1).VerticalAlignment = CellVerticalAlignment.Center
        fpSpread.Sheets(0).Cells(1, 0).HorizontalAlignment = CellHorizontalAlignment.Right
        fpSpread.Sheets(0).Columns(1, 2).HorizontalAlignment = CellHorizontalAlignment.Right
    End Sub
    Private Sub SetCellType()

        Dim numberCellType As New NumberCellType()
        numberCellType.NullDisplay = "0"
        numberCellType.DecimalPlaces = 2
        numberCellType.MinimumValue = 0
        fpSpread.Sheets(0).Columns(10).CellType = numberCellType
        fpSpread.Sheets(0).Columns(11).CellType = numberCellType
        Dim textCellType As New TextCellType()
        fpSpread.Sheets(0).Cells(1, 10, 2, 10).CellType = textCellType
        fpSpread.Sheets(0).Cells(1, 11, 2, 11).CellType = textCellType
        fpSpread.Sheets(0).Cells(2, 5).CellType = textCellType
        fpSpread.Sheets(0).Cells(2, 6).CellType = textCellType
        fpSpread.Sheets(0).Cells(2, 7).CellType = textCellType
        fpSpread.Sheets(0).Cells(2, 8).CellType = textCellType
        fpSpread.Sheets(0).Cells(1, 0).Text = "Select Year : "
        Dim comboBoxCellType As New ComboBoxCellType()
        year = New List(Of String)()
        year.AddRange(New String() {(DateTime.Now.Year - 1) & "-" & DateTime.Now.Year, (DateTime.Now.Year - 2) & "-" & (DateTime.Now.Year - 1), (DateTime.Now.Year - 3) & "-" & (DateTime.Now.Year - 2), (DateTime.Now.Year - 4) & ""})
        comboBoxCellType.Items = year.ToArray()
        fpSpread.Sheets(0).Cells(1, 4).CellType = comboBoxCellType
        selectedYr = year(0)
        comboBoxCellType.Editable = False
        comboBoxCellType.MaxDrop = 4
        fpSpread.Sheets(0).Cells(1, 4).Text = (DateTime.Now.Year - 1) & "-" & DateTime.Now.Year
        fpSpread.Sheets(0).Columns(3).Locked = True

    End Sub
    Private Sub AddEventHandlers()
        AddHandler fpSpread.ComboSelChange, AddressOf FpSpread_ComboSelChange
        AddHandler fpSpread.EditChange, AddressOf FpSpread_EditChange
    End Sub

    Private Sub SetHeaderAndText()
        fpSpread.Sheets(0).Columns(3).Locked = True
        fpSpread.Sheets(0).Rows(0, 2).Locked = True
        fpSpread.Sheets(0).Cells(1, 4, 1, 4).Locked = False
        fpSpread.Sheets(0).SetRowHeight(2, 25)
        fpSpread.Sheets(0).Rows(2).BackColor = Color.Gray
        fpSpread.Sheets(0).Rows(1).BackColor = Color.FromArgb(187, 189, 178)
        fpSpread.Sheets(0).Rows(1).ForeColor = Color.DarkRed
        fpSpread.Sheets(0).Rows(2).ForeColor = Color.White
        fpSpread.Sheets(0).Columns(9, fpSpread.Sheets(0).Columns.Count - 1).Locked = True
        fpSpread.Sheets(0).Cells(0, 0).Text = "MSC Point Table"
        fpSpread.Sheets(0).AddSpanCell(0, 0, 1, 15)
        fpSpread.Sheets(0).AddSpanCell(1, 0, 1, 4)
        fpSpread.Sheets(0).Rows(0).Height = 50
        fpSpread.Sheets(0).Cells(2, 0).Text = "#"
        fpSpread.Sheets(0).Cells(2, 1).Text = "CR"
        fpSpread.Sheets(0).Cells(2, 2).Text = "PR"
        fpSpread.Sheets(0).Cells(2, 3).Text = "T"
        fpSpread.Sheets(0).Cells(2, 4).Text = "Team"
        fpSpread.Sheets(0).Cells(2, 5).Text = "M"
        fpSpread.Sheets(0).Cells(2, 6).Text = "W"
        fpSpread.Sheets(0).Cells(2, 7).Text = "L"
        fpSpread.Sheets(0).Cells(2, 8).Text = "D"
        fpSpread.Sheets(0).Cells(2, 9).Text = "W%L%D%"
        fpSpread.Sheets(0).Cells(2, 10).Text = "Avg W%"
        fpSpread.Sheets(0).Cells(2, 11).Text = "Avg L%"
        fpSpread.Sheets(0).Cells(2, 12).Text = "Points"
        fpSpread.Sheets(0).Cells(2, 13).Text = "Last 5 Matches"
        fpSpread.Sheets(0).Cells(2, 14).Text = "% vs Target"
        fpSpread.Sheets(0).FrozenRowCount = 3
    End Sub
    Private Sub AddAverageDatabarFormatting(rowCnt As Integer, col As Integer, maxValue As Integer, fillcolor As Color)
        Dim databarConditionalFormattingRule1 As New FarPoint.Win.Spread.DatabarConditionalFormattingRule()
        databarConditionalFormattingRule1.BorderColor = fillcolor
        databarConditionalFormattingRule1.FillColor = fillcolor
        databarConditionalFormattingRule1.Maximum = New FarPoint.Win.Spread.ConditionalFormattingValue(maxValue, FarPoint.Win.Spread.ConditionalFormattingValueType.Number)
        databarConditionalFormattingRule1.Priority = 3

        databarConditionalFormattingRule1.ShowBorder = True
        Me.fpSpread.Sheets(0).SetConditionalFormatting(New FarPoint.Win.Spread.Model.CellRange() {New FarPoint.Win.Spread.Model.CellRange(3, col, rowCnt, 1)}, New FarPoint.Win.Spread.IConditionalFormattingRule() {databarConditionalFormattingRule1})
    End Sub
    Private Sub SetColumnsRowsVisibility()
        'Set visibility of headers and columns
        fpSpread.Sheets(0).ColumnHeader.Visible = False
        fpSpread.Sheets(0).RowHeader.Visible = False
        '  fpSpread.Sheets[0].Columns[0].Visible = false;
    End Sub
    Private Sub SetColor()
        'Set alternative row color
        fpSpread.Sheets(0).AlternatingRows.Count = 2
        fpSpread.Sheets(0).AlternatingRows(0).BackColor = Color.FromArgb(246, 246, 246)
        fpSpread.Sheets(0).AlternatingRows(1).BackColor = Color.FromArgb(228, 228, 228)
    End Sub
    Private Sub CreateSparkLineForWinLoss()
        Dim count As Integer = pointTableListCurrent.Count()
        For i As Integer = 3 To count + 2
            Me.BindSparklineInRow(i, 9, False)
            SetSerialCount(i)
        Next

        'Add percentage vs targate sparkline
        _bullGroup = Nothing
        For i As Integer = 3 To count + 2
            Me.BindSparklineInRow(i, 14, True)
        Next

        'add win/loss sparkline
        _bullGroup = Nothing
        For i As Integer = 3 To count + 2
            Me.BindExcelSparklineInRow(i, 13, WinLossStatusOfLast5Match(pointTableListCurrent(i - 3).TeamId))
        Next

        'add up/down sparkline
        Dim referenceStyle As FarPoint.Win.Spread.Model.ReferenceStyle = fpSpread.ActiveSheet.ReferenceStyle
        fpSpread.ActiveSheet.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
        _bullGroup = Nothing
        For i As Integer = 3 To count + 2
            Me.BindUpDownSparklineInRow(i, 3)
        Next
        fpSpread.ActiveSheet.ReferenceStyle = referenceStyle
  End Sub
    Private Sub SetSerialCount(row As Integer)
        fpSpread.Sheets(0).Cells(row, 0).Text = (row - 1).ToString()
    End Sub
    Private Sub BindUpDownSparklineInRow(row As Integer, col As Integer)
        Dim excelSparklineGroup3 As New FarPoint.Win.Spread.ExcelSparklineGroup()
        Dim excelSparklineSetting3 As New FarPoint.Win.Spread.ExcelSparklineSetting()
        Dim excelSparkline3 As New FarPoint.Win.Spread.ExcelSparkline()
        Me.fpSpread.ActiveSheet.SparklineContainer.Add(excelSparklineGroup3)
        excelSparklineGroup3.Renderer = New CustomUpDownSparkline(Color.FromArgb(19, 122, 24), Color.FromArgb(250, 34, 14), Color.FromArgb(249, 191, 39))
        excelSparklineGroup3.Setting = excelSparklineSetting3
    excelSparkline3.Formula = "RC[-2]:RC[-1]"
    excelSparklineSetting3.ShowNegative = True
    excelSparkline3.Column = col
        excelSparkline3.Row = row
        excelSparklineGroup3.Add(excelSparkline3)
    End Sub
    Private Sub BindExcelSparklineInRow(row As Integer, col As Integer, data As Integer())
        Dim result As Integer = 0
        If Int32.TryParse(fpSpread.Sheets(0).Cells(row, 5).Text, result) AndAlso fpSpread.Sheets(0).Cells(row, 5).Text <> "0" Then
            Dim excelSparklineGroup3 As New FarPoint.Win.Spread.ExcelSparklineGroup()
            Dim excelSparklineSetting3 As New FarPoint.Win.Spread.ExcelSparklineSetting()
            Dim excelSparkline3 As New FarPoint.Win.Spread.ExcelSparkline()
            Me.fpSpread.ActiveSheet.SparklineContainer.Add(excelSparklineGroup3)
            excelSparklineGroup3.Renderer = New CustomWinLossSparklineRenderer(data, Color.FromArgb(19, 122, 24), Color.FromArgb(250, 34, 14), Color.FromArgb(249, 191, 39))
            excelSparklineGroup3.Setting = excelSparklineSetting3
            excelSparklineSetting3.ShowNegative = True
            excelSparkline3.Column = col
            excelSparkline3.Row = row
            excelSparklineGroup3.Add(excelSparkline3)
        Else
            Dim excelSparklineGroup3 As New FarPoint.Win.Spread.ExcelSparklineGroup()
            Dim excelSparklineSetting3 As New FarPoint.Win.Spread.ExcelSparklineSetting()
            Dim excelSparkline3 As New FarPoint.Win.Spread.ExcelSparkline()
            Me.fpSpread.ActiveSheet.SparklineContainer.Add(excelSparklineGroup3)
            excelSparklineGroup3.Renderer = New CustomWinLossSparklineRenderer(data, Color.Transparent, Color.Transparent, Color.Transparent)
            excelSparklineGroup3.Setting = excelSparklineSetting3
            excelSparklineSetting3.ShowNegative = True
            excelSparkline3.Column = col
            excelSparkline3.Row = row
            excelSparklineGroup3.Add(excelSparkline3)
        End If
    End Sub
    Private _bullGroup As BulletChartSparklineGroup = Nothing

    Private Sub BindSparklineInRow(row As Integer, col As Integer, percentageVsTarget As Boolean)
        Dim bulletSetting As New BulletChartSparklineSetting(Color.FromArgb(19, 122, 24), Color.FromArgb(250, 34, 14), Color.FromArgb(249, 191, 39), percentageVsTarget, 10.0)
        Dim bulletGroup As New BulletChartSparklineGroup()
        bulletGroup.Setting = bulletSetting
        Dim a1 As New SheetCellRange(Me.fpSpread.Sheets(0), row, 5, 1, 1)
        Dim a2 As New SheetCellRange(Me.fpSpread.Sheets(0), row, 6, 1, 1)
        Dim a3 As New SheetCellRange(Me.fpSpread.Sheets(0), row, 7, 1, 1)
        Dim a4 As New SheetCellRange(Me.fpSpread.Sheets(0), row, 8, 1, 1)
        Dim bulletSparkline As New BulletChartSparkline(Me.fpSpread.Sheets(0), row, col, a1, a2, a3,
            a4)
        If _bullGroup Is Nothing Then
            _bullGroup = New BulletChartSparklineGroup()
            _bullGroup.Setting = bulletSetting
            _bullGroup.Add(bulletSparkline)
            Me.fpSpread.ActiveSheet.SparklineContainer.Add(_bullGroup)
        Else
            _bullGroup.Add(bulletSparkline)
        End If

    End Sub


    Private Sub UpdateDataOnSpread()
        Dim _rowCnt As Integer = fpSpread.Sheets(0).Rows.Count

        If pointTableListCurrent.Count > 0 Then
            ' for point table               
            Dim data As New SpreadDataBindingAdapter()
            ' Assign the datasource to a point table list
            data.DataSource = pointTableListCurrent
            data.Spread = fpSpread
            data.SheetName = "Sheet1"
            data.MapperInfo = New MapperInfo(3, 0, pointTableListCurrent.Count, 8)
            data.FillSpreadDataByDataSource()
            AddDrawMatchFormula(pointTableListCurrent.Count())
            AddAverageDatabarFormatting(pointTableListCurrent.Count(), 10, 100, Color.FromArgb(19, 122, 24))
            AddAverageDatabarFormatting(pointTableListCurrent.Count(), 11, 100, Color.FromArgb(250, 34, 14))
            AddAverageDatabarFormatting(pointTableListCurrent.Count(), 12, pointTableListCurrent(0).TotalMatch * 2, Color.FromArgb(198, 198, 198))

            SetRowHeight(pointTableListCurrent.Count())
        Else
            fpSpread.Sheets(0).AddSpanCell(3, 0, fpSpread.Sheets(0).RowCount, fpSpread.Sheets(0).ColumnCount)
            fpSpread.Sheets(0).Cells(3, 0).Text = "No record found."
        End If
        UpdateDataCellType()
    End Sub
    Private Sub UpdateDataCellType()
        Dim numberCellType As New NumberCellType()
        numberCellType.NullDisplay = "0"
        numberCellType.DecimalPlaces = 0
        numberCellType.MinimumValue = 0
        fpSpread.Sheets(0).Cells(3, 3, fpSpread.Sheets(0).RowCount - 1, 3).Locked = True
        fpSpread.Sheets(0).Cells(3, 5, fpSpread.Sheets(0).RowCount - 1, 5).Locked = True
        fpSpread.Sheets(0).Cells(3, 5, fpSpread.Sheets(0).RowCount - 1, 8).CellType = numberCellType


    End Sub
    Private Sub AddDrawMatchFormula(countrow As Integer)
        For i As Integer = 3 To countrow + 2
            fpSpread.Sheets(0).Cells(i, 8).Formula = "F" & (i + 1) & "-G" & (i + 1) & "-H" & (i + 1)
            fpSpread.Sheets(0).Cells(i, 10).Formula = "(G" & (i + 1) & "*100)/F" & (i + 1)
            fpSpread.Sheets(0).Cells(i, 11).Formula = "(H" & (i + 1) & "*100)/F" & (i + 1)
            fpSpread.Sheets(0).Cells(i, 12).Formula = "(G" & (i + 1) & "*2)+(I" & (i + 1) & "*1)"
        Next
    End Sub

    Private Function CreatePointTable(ByVal matchList As List(Of Match)) As List(Of MatchPointTable)
        Dim pointTable As List(Of MatchPointTable) = New List(Of MatchPointTable)()

        If matchList.Count < 1 OrElse teamList Is Nothing Then
            Return pointTable
        End If

        '    For Each f In teamList.OrderBy(Function(f) f.TeamId) _
        '        Dim p As New MatchPointTable() With { _
        '    .TeamId = t.TeamId,
        '    .TeamName = t.Name,
        '    .TotalLoss = matchList.Where(Function(m) (m.Team1Id Is t.TeamId OrElse m.Team2Id Is t.TeamId) AndAlso m.WinnerTeamId IsNot t.TeamId AndAlso m.WinnerTeamId > 0).Count(),
        '    .TotalWin = matchList.Where(Function(m) (m.Team1Id Is t.TeamId OrElse m.Team2Id Is t.TeamId) AndAlso m.WinnerTeamId Is t.TeamId).Count(),
        '    .TotalMatch = matchList.Where(Function(m) (m.Team1Id Is t.TeamId OrElse m.Team2Id Is t.TeamId)).Count()
        '}
        '        pointTable.Add(p)
        '    Next
        For Each t As Object In teamList.OrderBy(Function(s) s.TeamId)
            Dim p As New MatchPointTable() With {
                .TeamId = t.TeamId,
                .TeamName = t.Name,
                .TotalLoss = matchList.Where(Function(m) (m.Team1Id = t.TeamId OrElse m.Team2Id = t.TeamId) AndAlso m.WinnerTeamId <> t.TeamId AndAlso m.WinnerTeamId > 0).Count(),
                .TotalWin = matchList.Where(Function(m) (m.Team1Id = t.TeamId OrElse m.Team2Id = t.TeamId) AndAlso m.WinnerTeamId = t.TeamId).Count(),
                .TotalMatch = matchList.Where(Function(m) (m.Team1Id = t.TeamId OrElse m.Team2Id = t.TeamId)).Count()
            }
            pointTable.Add(p)

        Next


        Return pointTable
    End Function
    Private Sub UpdateRank(pointTableCurrent As List(Of MatchPointTable), pointTablePrevious As List(Of MatchPointTable))
        pointTableCurrent.Sort(Function(X, Y) (Y.TotalWin * 2 + ((Y.TotalWin - Y.TotalLoss) * 1)).CompareTo((X.TotalWin * 2 + ((X.TotalWin - X.TotalLoss) * 1))))
        pointTablePrevious.Sort(Function(X, Y) (Y.TotalWin * 2 + ((Y.TotalWin - Y.TotalLoss) * 1)).CompareTo((X.TotalWin * 2 + ((X.TotalWin - X.TotalLoss) * 1))))
        'Update Rank
        For i As Integer = 0 To pointTableCurrent.Count() - 1
            pointTableCurrent(i).CurrentRank = If(pointTableCurrent(i).TotalMatch = 0, "-", (i + 1) & "")
            pointTableCurrent(i).PreviousRank = If(pointTablePrevious.Count > 0, (pointTablePrevious.IndexOf(pointTablePrevious.SingleOrDefault(Function(t) t.TeamId = pointTableCurrent(i).TeamId)) + 1).ToString(), "-")
        Next
        If pointTablePrevious.Count < 1 Then
            Return
        End If

        For i As Integer = 0 To pointTableCurrent.Count() - 1
            pointTableCurrent(i).PreviousRank = If(pointTableCurrent(i).PreviousRank = "0", "-", If((pointTablePrevious(Convert.ToInt32(pointTableCurrent(i).PreviousRank) - 1).TotalMatch = 0), "-", pointTableCurrent(i).PreviousRank))
        Next
    End Sub
    Private Function WinLossStatusOfLast5Match(teamId As Integer) As Integer()
        Dim matchStatus As Integer() = New Integer(4) {}

        Dim matches As Match() = matchListCurrent.OrderBy(Function(m) m.MatchDate).Reverse().Where(Function(m) m.Team1Id = teamId OrElse m.Team2Id = teamId).Take(5).ToArray()
        Dim i As Integer = 0
        For Each match As Match In matches
            matchStatus(i) = If(match.WinnerTeamId = teamId, 1, If((match.WinnerTeamId <> teamId AndAlso (match.WinnerTeamId = match.Team1Id OrElse match.WinnerTeamId = match.Team2Id)), -1, 0))
            i += 1
        Next
        Return matchStatus
    End Function

#End Region
End Class
