Paste Afonso.co

Re: Untitled

From Bistre Kitten, 4 Days ago, written in Plain Text, viewed 2 times. This paste will perish in 3 Weeks. This paste is a reply to Untitled from Gentle Owl - view diff
URL https://paste.afonso.co/view/43254bd2 Embed
Download Paste or View Raw
  1. # -*- encoding: utf-8 -*-
  2. from System import *
  3. import xlrd
  4. from System.IO import Path, File
  5.  
  6.  
  7.  
  8. def __getData(graphicOnAirItem, viewBag, momentExecution):
  9.         viewBag.Clear()
  10.         _fillPlayers(viewBag, momentExecution)
  11.        
  12.        
  13.  
  14.                
  15. def _fillPlayers(viewBag, momentExecution):
  16.         path = Project.ProjectSettings["ExcelPath"]
  17.  
  18.         if not File.Exists(path):      
  19.                 momentExecution.Message = "Please validate if .xls file exists in configured path!!!"
  20.                 momentExecution.Cancel = True
  21.                 return
  22.  
  23.         sheet = xlrd.open_workbook(path).sheet_by_name("AwayTeam")
  24.         startRow = 8
  25.        
  26.        
  27.         for i in range(7):
  28.                 numberStr = str(i+1).zfill(2)
  29.                 row = startRow - i
  30.                 playerNumber = str(int(sheet.cell(row, 2).value))  
  31.                 __validatePlayers(playerNumber, momentExecution)
  32.                 playerInfo = _getPlayer(playerNumber)
  33.                
  34.                 viewBag.SetString("tPlayerNumber%s"%str(numberStr), playerNumber)
  35.                 viewBag.SetString("tPlayerName%s"%str(numberStr), playerInfo[0][slice(1)]+"."+playerInfo[1].upper())
  36.        
  37.                
  38.                 picPath = "Images/Men/Photos/%s/%s_%s.png" % (AwayTeam.RefName, playerNumber, playerInfo[2])
  39.                 viewBag.SetImage("lgPlayerPhoto%s"%str(numberStr), picPath)
  40.                
  41. def _getPlayer(playerNumber):
  42.         for player in AwayTeam.Players:
  43.                 if str(player.Number) == playerNumber:
  44.                         return [player.Names.FirstName, player.Names.LastName, player.Names.RefName]
  45.        
  46.         return ["", "", ""]
  47.        
  48. def __validatePlayers(playerNumber, momentExecution):
  49.         count = 0
  50.         for player in AwayTeam.Players:
  51.                 if str(player.Number) == playerNumber:
  52.                         count += 1
  53.                         return
  54.        
  55.         if count == 0:
  56.                 momentExecution.Message = "Please Confirm Player Numbers in Tactic .xls file!!!"
  57.                 momentExecution.Cancel = True
  58.                 return

Reply to "Re: Untitled"

Here you can reply to the paste above

Powered by Stikked