public Game(string fileName) { using (SpreadsheetDocument document = SpreadsheetDocument.Open(fileName, false)) { // Retrieve a reference to the workbook part. WorkbookPart wbPart = document.WorkbookPart; Sheet theSheet = wbPart.Workbook.Descendants<Sheet>().FirstOrDefault(); // Throw an exception if there is no sheet. if (theSheet == null) { throw new ArgumentException("sheetName Not Found"); } WorksheetPart wsPart = (WorksheetPart)(wbPart.GetPartById(theSheet.Id)); var excelService = new ExcelService(wbPart, wsPart); this.GameTitle = excelService.GetValueFromCell("A1"); this.GameVenue = excelService.GetValueFromCell("A2"); this.GameLocation = excelService.GetValueFromCell("A3"); this._defaultTimerMinutes = excelService.GetValueFromCell("A6").GetInt(); this.Announcer1 = excelService.GetValueFromCell("A11"); this.Announcer2 = excelService.GetValueFromCell("A12"); this.Officials = new List<Official>(); var i = 2; do { try { if (excelService.GetValueFromCell("B" + i.ToString()) != "XXX") { var newOfficial = new Official { Name = excelService.GetValueFromCell("C" + i.ToString()), Title = excelService.GetValueFromCell("B" + i.ToString()), }; this.Officials.Add(newOfficial); } else { i = 10; } i++; } catch (Exception er) { throw new ArgumentException("Problem getting officials information"); } } while (i < 9); } gameClock = new Clock(_defaultTimerMinutes); this.DownInt = 1; this.YardsToGo = "10"; this.QuarterInt = 1; }
public Team(string teamFile) { this.Score = 0; using (SpreadsheetDocument document = SpreadsheetDocument.Open(teamFile, false)) { // Retrieve a reference to the workbook part. WorkbookPart wbPart = document.WorkbookPart; Sheet theSheet = wbPart.Workbook.Descendants<Sheet>().FirstOrDefault(); // Throw an exception if there is no sheet. if (theSheet == null) { throw new ArgumentException("sheetName Not Found"); } WorksheetPart wsPart = (WorksheetPart)(wbPart.GetPartById(theSheet.Id)); var excelService = new ExcelService(wbPart, wsPart); this.Name = excelService.GetValueFromCell("A1"); this.Mascot = excelService.GetValueFromCell("B1"); this.BugName = excelService.GetValueFromCell("C1"); this.Logo = excelService.GetValueFromCell("E1"); this.Record = excelService.GetValueFromCell("F1"); this.ShortName = excelService.GetValueFromCell("G1"); this.CoachName = excelService.GetValueFromCell("A2"); this.CoachInfo = excelService.GetValueFromCell("B2") + " (" + excelService.GetValueFromCell("C2") + ")"; this.Players = new List<Player>(); var i = 3; do { try { if(excelService.GetValueFromCell("A" + i.ToString()) != "XXX") { var newPlayer = new Player { Number = excelService.GetValueFromCell("A" + i.ToString()).GetInt(), Name = excelService.GetValueFromCell("B" + i.ToString()), Position = excelService.GetValueFromCell("C" + i.ToString()), Height = excelService.GetValueFromCell("D" + i.ToString()), Weight = excelService.GetValueFromCell("E" + i.ToString()), Year = excelService.GetValueFromCell("F" + i.ToString()), Hometown = excelService.GetValueFromCell("G" + i.ToString()) }; this.Players.Add(newPlayer); } else { i = 104; } i++; } catch (Exception er) { throw new ArgumentException("Error Getting Players"); } } while (i < 102); } }