public static PlayerRating getPlayerRating(string pid)
{
PlayerRating p = null;
foreach (PlayerRating playerRating in playersRatings)
{
if (playerRating.Id.Equals(pid))
{
return(playerRating);
}
}
return(p);
}
private void parseExcelFile()
{
Excel.Application xlApp = new Excel.Application();
string file = "C:\\fantabz\\voti" + day + ".xls";
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(file);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
//int colCount = xlRange.Columns.Count;
for (int i = 5; i <= rowCount; i++)
{
PlayerRating pr = new PlayerRating();
string id = xlRange.Cells[i, 1].Value2.ToString();
if (!id.Equals("ALL."))
{
pr.Id = id;
string test = xlRange.Cells[i, 7].Value2 + "";
if (test.Equals("s,v,"))
{
pr.VotoGazzetta = 0;
}
else
{
pr.VotoGazzetta = Math.Round((double)xlRange.Cells[i, 7].Value2, 1);
}
pr.GolFattiGazzetta = xlRange.Cells[i, 8].Value2;
pr.GolSubitiGazzetta = xlRange.Cells[i, 9].Value2;
pr.AutoRetiGazzetta = xlRange.Cells[i, 10].Value2;
pr.AssistGazzetta = xlRange.Cells[i, 11].Value2;
test = xlRange.Cells[i, 12].Value2 + "";
if (test.Equals("s,v,"))
{
pr.VotoCorriere = 0;
}
else
{
pr.VotoCorriere = Math.Round((double)xlRange.Cells[i, 12].Value2, 1);
}
pr.GolFattiCorriere = xlRange.Cells[i, 13].Value2;
pr.GolSubitiCorriere = xlRange.Cells[i, 14].Value2;
pr.AutoRetiCorriere = xlRange.Cells[i, 15].Value2;
pr.AssistCorriere = xlRange.Cells[i, 16].Value2;
pr.Ammonizione = xlRange.Cells[i, 24].Value2;
pr.Esplusione = xlRange.Cells[i, 25].Value2;
pr.GolVittoria = xlRange.Cells[i, 26].Value2;
pr.GolPareggio = xlRange.Cells[i, 27].Value2;
pr.RigoreSbagliato = xlRange.Cells[i, 28].Value2;
pr.RigoreParato = xlRange.Cells[i, 29].Value2;;
pr.RigoreTrasformato = xlRange.Cells[i, 30].Value2;
PlayerRatingsList.addPlayerRating(pr);
}
//Console.Out.WriteLine(pr.toString());
}
//cleanup
GC.Collect();
GC.WaitForPendingFinalizers();
Marshal.ReleaseComObject(xlRange);
Marshal.ReleaseComObject(xlWorksheet);
xlWorkbook.Close();
Marshal.ReleaseComObject(xlWorkbook);
xlApp.Quit();
Marshal.ReleaseComObject(xlApp);
}
public static void addPlayerRating(PlayerRating p)
{
playersRatings.Add(p);
}