# -*- encoding: utf-8 -*-
from System import *
import xlrd
from System.IO import Path, File



def __getData(graphicOnAirItem, viewBag, momentExecution):
        viewBag.Clear()        
        _fillPlayers(viewBag, momentExecution)
        
        

                
def _fillPlayers(viewBag, momentExecution):
        path = Project.ProjectSettings["ExcelPath"]

        if not File.Exists(path):        
                momentExecution.Message = "Please validate if .xls file exists in configured path!!!"
                momentExecution.Cancel = True
                return

        sheet = xlrd.open_workbook(path).sheet_by_name("AwayTeam")
        startRow = 8
        
        
        for i in range(7):
                numberStr = str(i+1).zfill(2)
                row = startRow - i
                playerNumber = str(int(sheet.cell(row, 2).value))  
                __validatePlayers(playerNumber, momentExecution)
                playerInfo = _getPlayer(playerNumber)
                
                viewBag.SetString("tPlayerNumber%s"%str(numberStr), playerNumber)
                viewBag.SetString("tPlayerName%s"%str(numberStr), playerInfo[0][slice(1)]+"."+playerInfo[1].upper())
        
                
                picPath = "Images/Men/Photos/%s/%s_%s.png" % (AwayTeam.RefName, playerNumber, playerInfo[2])
                viewBag.SetImage("lgPlayerPhoto%s"%str(numberStr), picPath)
                
def _getPlayer(playerNumber):
        for player in AwayTeam.Players:
                if str(player.Number) == playerNumber:
                        return [player.Names.FirstName, player.Names.LastName, player.Names.RefName]
        
        return ["", "", ""]
        
def __validatePlayers(playerNumber, momentExecution):
        count = 0
        for player in AwayTeam.Players:
                if str(player.Number) == playerNumber:
                        count += 1
                        return
        
        if count == 0:
                momentExecution.Message = "Please Confirm Player Numbers in Tactic .xls file!!!"
                momentExecution.Cancel = True
                return