public void TestUpdateBoxScoreEntry() { BoxScoreEntry entry = new BoxScoreEntry() { Id = 1, Ot = 0, Quarter1 = 15, Quarter2 = 20, Quarter3 = 15, Quarter4 = 20, TeamId = 2, Total = 70, ScheduleId = 3 }; repo.Insert(entry); BoxScoreEntry entry2 = new BoxScoreEntry() { Id = 1, Ot = 0, Quarter1 = 15, Quarter2 = 25, Quarter3 = 15, Quarter4 = 20, TeamId = 2, Total = 70, ScheduleId = 3 }; repo.Update(entry2); Assert.IsNotNull(ctx.BoxScoreEntries.Where(c => c.Id == 1 && c.Quarter2 == 25).FirstOrDefault()); Assert.AreEqual(1, ctx.BoxScoreEntries.Count()); }
public void TestGetBoxScoreEntries() { BoxScoreEntry entry = new BoxScoreEntry() { Id = 1, Ot = 0, Quarter1 = 15, Quarter2 = 20, Quarter3 = 15, Quarter4 = 20, TeamId = 2, Total = 70, ScheduleId = 3 }; repo.Insert(entry); BoxScoreEntry entry2 = new BoxScoreEntry() { Id = 2, Ot = 0, Quarter1 = 15, Quarter2 = 20, Quarter3 = 15, Quarter4 = 20, TeamId = 2, Total = 70, ScheduleId = 4 }; repo.Insert(entry2); Assert.AreEqual(2, repo.GetBoxScoreEntries().Count()); }
public void TestBoxScoreEntryNotExists() { BoxScoreEntry entry = new BoxScoreEntry() { Id = 1, Ot = 0, Quarter1 = 15, Quarter2 = 20, Quarter3 = 15, Quarter4 = 20, TeamId = 2, Total = 70, ScheduleId = 3 }; repo.Insert(entry); BoxScoreEntry entry2 = new BoxScoreEntry() { Id = 1, Ot = 0, Quarter1 = 15, Quarter2 = 20, Quarter3 = 15, Quarter4 = 20, TeamId = 2, Total = 70, ScheduleId = 4 }; Assert.IsFalse(repo.Exists(entry2)); }
public PlayByPlayWindow( Dictionary <int, TeamStats> tst, Dictionary <int, PlayerStats> pst, BoxScoreEntry bse, int t1ID, int t2ID) : this() { _tst = tst; _pst = pst; _bse = bse; _t1ID = t1ID; _t2ID = t2ID; Plays = new ObservableCollection <PlayByPlayEntry>(bse.PBPEList); Height = Tools.GetRegistrySetting("PBPHeight", MinHeight); Width = Tools.GetRegistrySetting("PBPWidth", MinWidth); Left = Tools.GetRegistrySetting("PBPX", Left); Top = Tools.GetRegistrySetting("PBPY", Top); }
public void Setup() { ctx = new SqlContext(); engine = new BoxScoreEngine(ctx); entry = new BoxScoreEntry() { Id = 1, Ot = 0, Quarter1 = 15, Quarter2 = 20, Quarter3 = 15, Quarter4 = 20, TeamId = 2, Total = 70, ScheduleId = 3 }; }
public void TestGetBoxScoreEntry() { BoxScoreEntry entry = new BoxScoreEntry() { Id = 1, Ot = 0, Quarter1 = 15, Quarter2 = 20, Quarter3 = 15, Quarter4 = 20, TeamId = 2, Total = 70, ScheduleId = 3 }; repo.Insert(entry); Assert.IsNotNull(repo.GetBoxScoreEntry(1)); }
public void TestInsertBoxScoreEntry() { BoxScoreEntry entry = new BoxScoreEntry() { Id = 1, Ot = 0, Quarter1 = 15, Quarter2 = 20, Quarter3 = 15, Quarter4 = 20, TeamId = 2, Total = 70, ScheduleId = 3 }; repo.Insert(entry); Assert.IsTrue(ctx.BoxScoreEntries.Any(c => c.Id == 1)); }
public void TestExists() { engine.Save(entry); BoxScoreEntry entry2 = new BoxScoreEntry() { Id = 1, Ot = 0, Quarter1 = 15, Quarter2 = 20, Quarter3 = 30, Quarter4 = 10, TeamId = 2, Total = 70, ScheduleId = 3 }; Assert.IsTrue(engine.Exists(entry2)); }
/// <summary>Creates a team box score and all the required player box score instances using data from the downloaded DataSet.</summary> /// <param name="ds">The DataSet.</param> /// <param name="parts">The parts of the split date string.</param> /// <param name="bse">The resulting BoxScoreEntry.</param> /// <returns>0 if every required player was found in the database; otherwise, -1.</returns> private static int boxScoreFromDataSet(DataSet ds, string[] parts, out BoxScoreEntry bse) { var awayDT = ds.Tables[0]; var homeDT = ds.Tables[1]; var bs = new TeamBoxScore(ds, parts); bse = new BoxScoreEntry(bs) { PBSList = new List <PlayerBoxScore>() }; var result = 0; for (var i = 0; i < awayDT.Rows.Count - 1; i++) { if (i == 5) { continue; } var pbs = new PlayerBoxScore(awayDT.Rows[i], bs.Team1ID, bs.ID, (i < 5), MainWindow.PST); if (pbs.PlayerID == -1) { result = -1; continue; } bse.PBSList.Add(pbs); } for (var i = 0; i < homeDT.Rows.Count - 1; i++) { if (i == 5) { continue; } var pbs = new PlayerBoxScore(homeDT.Rows[i], bs.Team2ID, bs.ID, (i < 5), MainWindow.PST); if (pbs.PlayerID == -1) { result = -1; continue; } bse.PBSList.Add(pbs); } return(result); }
public PlayByPlayEntry(DataRow row, BoxScoreEntry bse, Dictionary <int, TeamStats> tst, Dictionary <int, PlayerStats> pst) : this() { ID = ParseCell.GetUInt32(row, "ID"); GameID = ParseCell.GetInt32(row, "GameID"); Quarter = ParseCell.GetInt32(row, "Quarter"); TimeLeft = ParseCell.GetDouble(row, "TimeLeft"); ShotClockLeft = ParseCell.GetDouble(row, "ShotClockLeft"); Player1ID = ParseCell.GetInt32(row, "P1ID"); Player2ID = ParseCell.GetInt32(row, "P2ID"); T1PTS = ParseCell.GetInt32(row, "T1CurPTS"); T2PTS = ParseCell.GetInt32(row, "T2CurPTS"); Team1PlayerIDs.Clear(); Team1PlayerIDs.Add(ParseCell.GetInt32(row, "T1P1ID")); Team1PlayerIDs.Add(ParseCell.GetInt32(row, "T1P2ID")); Team1PlayerIDs.Add(ParseCell.GetInt32(row, "T1P3ID")); Team1PlayerIDs.Add(ParseCell.GetInt32(row, "T1P4ID")); Team1PlayerIDs.Add(ParseCell.GetInt32(row, "T1P5ID")); Team2PlayerIDs.Clear(); Team2PlayerIDs.Add(ParseCell.GetInt32(row, "T2P1ID")); Team2PlayerIDs.Add(ParseCell.GetInt32(row, "T2P2ID")); Team2PlayerIDs.Add(ParseCell.GetInt32(row, "T2P3ID")); Team2PlayerIDs.Add(ParseCell.GetInt32(row, "T2P4ID")); Team2PlayerIDs.Add(ParseCell.GetInt32(row, "T2P5ID")); EventType = ParseCell.GetInt32(row, "EventType"); EventDesc = ParseCell.GetString(row, "EventDesc"); Location = ParseCell.GetInt32(row, "Location"); LocationDesc = ParseCell.GetString(row, "LocationDesc"); DisplayTeam = Team1PlayerIDs.Contains(Player1ID) ? tst[bse.BS.Team1ID].DisplayName : tst[bse.BS.Team2ID].DisplayName; DisplayPlayer1 = pst[Player1ID].FullName; DisplayPlayer2 = pst[Player2ID].FullName; if (EventType == ShotAttemptEventType) { ShotEntry = new ShotEntry(row); } }
public void TestDeleteBoxScoreEntry() { BoxScoreEntry entry = new BoxScoreEntry() { Id = 1, Ot = 0, Quarter1 = 15, Quarter2 = 20, Quarter3 = 15, Quarter4 = 20, TeamId = 2, Total = 70, ScheduleId = 3 }; repo.Insert(entry); repo.Delete(entry); Assert.AreEqual(0, ctx.BoxScoreEntries.Count()); }
public void TestSaveBoxScoreUpdateNoId() { engine.Save(entry); BoxScoreEntry entry2 = new BoxScoreEntry() { Id = 0, Ot = 0, Quarter1 = 15, Quarter2 = 25, Quarter3 = 15, Quarter4 = 20, TeamId = 2, Total = 70, ScheduleId = 3 }; engine.Save(entry2); Assert.IsNotNull(ctx.BoxScoreEntries.Where(c => c.Id == 1 && c.Quarter2 == 25).FirstOrDefault()); }
public PlayByPlayEntry(DataRow row, BoxScoreEntry bse, Dictionary<int, TeamStats> tst, Dictionary<int, PlayerStats> pst) : this() { ID = ParseCell.GetUInt32(row, "ID"); GameID = ParseCell.GetInt32(row, "GameID"); Quarter = ParseCell.GetInt32(row, "Quarter"); TimeLeft = ParseCell.GetDouble(row, "TimeLeft"); ShotClockLeft = ParseCell.GetDouble(row, "ShotClockLeft"); Player1ID = ParseCell.GetInt32(row, "P1ID"); Player2ID = ParseCell.GetInt32(row, "P2ID"); T1PTS = ParseCell.GetInt32(row, "T1CurPTS"); T2PTS = ParseCell.GetInt32(row, "T2CurPTS"); Team1PlayerIDs.Clear(); Team1PlayerIDs.Add(ParseCell.GetInt32(row, "T1P1ID")); Team1PlayerIDs.Add(ParseCell.GetInt32(row, "T1P2ID")); Team1PlayerIDs.Add(ParseCell.GetInt32(row, "T1P3ID")); Team1PlayerIDs.Add(ParseCell.GetInt32(row, "T1P4ID")); Team1PlayerIDs.Add(ParseCell.GetInt32(row, "T1P5ID")); Team2PlayerIDs.Clear(); Team2PlayerIDs.Add(ParseCell.GetInt32(row, "T2P1ID")); Team2PlayerIDs.Add(ParseCell.GetInt32(row, "T2P2ID")); Team2PlayerIDs.Add(ParseCell.GetInt32(row, "T2P3ID")); Team2PlayerIDs.Add(ParseCell.GetInt32(row, "T2P4ID")); Team2PlayerIDs.Add(ParseCell.GetInt32(row, "T2P5ID")); EventType = ParseCell.GetInt32(row, "EventType"); EventDesc = ParseCell.GetString(row, "EventDesc"); Location = ParseCell.GetInt32(row, "Location"); LocationDesc = ParseCell.GetString(row, "LocationDesc"); DisplayTeam = Team1PlayerIDs.Contains(Player1ID) ? tst[bse.BS.Team1ID].DisplayName : tst[bse.BS.Team2ID].DisplayName; DisplayPlayer1 = pst[Player1ID].FullName; DisplayPlayer2 = pst[Player2ID].FullName; if (EventType == ShotAttemptEventType) { ShotEntry = new ShotEntry(row); } }
/// <summary>Calculates the box score entry in order to transfer the stats to the Box Score Window for further editing and saving.</summary> /// <returns></returns> private BoxScoreEntry calculateBoxScoreEntry() { var bs = new TeamBoxScore { REB1 = 0, AST1 = 0, STL1 = 0, TOS1 = 0, BLK1 = 0, FGM1 = 0, TPM1 = 0, FTM1 = 0, OREB1 = 0, FOUL1 = 0, PTS1 = 0, MINS1 = (ushort)MainWindow.GameLength, REB2 = 0, AST2 = 0, STL2 = 0, TOS2 = 0, BLK2 = 0, FGM2 = 0, TPM2 = 0, FTM2 = 0, OREB2 = 0, FOUL2 = 0, PTS2 = 0, MINS2 = (ushort)MainWindow.GameLength }; foreach (var pbs in _lpbsAwayList) { bs.PTS1 += pbs.PTS; bs.REB1 += pbs.REB; bs.AST1 += pbs.AST; bs.STL1 += pbs.STL; bs.TOS1 += pbs.TOS; bs.BLK1 += pbs.BLK; bs.FGM1 += pbs.FGM; bs.TPM1 += pbs.TPM; bs.FTM1 += pbs.FTM; bs.OREB1 += pbs.OREB; bs.FOUL1 += pbs.FOUL; } foreach (var pbs in _lpbsHomeList) { bs.PTS2 += pbs.PTS; bs.REB2 += pbs.REB; bs.AST2 += pbs.AST; bs.STL2 += pbs.STL; bs.TOS2 += pbs.TOS; bs.BLK2 += pbs.BLK; bs.FGM2 += pbs.FGM; bs.TPM2 += pbs.TPM; bs.FTM2 += pbs.FTM; bs.OREB2 += pbs.OREB; bs.FOUL2 += pbs.FOUL; } bs.Team1ID = Misc.GetTeamIDFromDisplayName(MainWindow.TST, cmbTeam1.SelectedItem.ToString()); bs.Team2ID = Misc.GetTeamIDFromDisplayName(MainWindow.TST, cmbTeam2.SelectedItem.ToString()); bs.GameDate = DateTime.Today; bs.SeasonNum = MainWindow.CurSeason; bs.Done = false; var bse = new BoxScoreEntry(bs) { PBSList = new List <PlayerBoxScore>() }; foreach (var lpbs in _lpbsAwayList) { lpbs.TeamID = bs.Team1ID; bse.PBSList.Add(lpbs); } foreach (var lpbs in _lpbsHomeList) { lpbs.TeamID = bs.Team2ID; bse.PBSList.Add(lpbs); } /* * * foreach (LivePlayerBoxScore lpbs in _lpbsAwayList) * { * var pbs = new PlayerBoxScore(lpbs) {TeamID = bs.Team1ID}; * bse.PBSList.Add(pbs); * } * foreach (LivePlayerBoxScore lpbs in _lpbsHomeList) * { * var pbs = new PlayerBoxScore(lpbs) {TeamID = bs.Team2ID}; * bse.PBSList.Add(pbs); * } */ bse.Team1Display = cmbTeam1.SelectedItem.ToString(); bse.Team2Display = cmbTeam2.SelectedItem.ToString(); return(bse); }
public bool Exists(BoxScoreEntry entry) { Expression <Func <BoxScoreEntry, bool> > doesExist = c => c.ScheduleId == entry.ScheduleId && c.TeamId == entry.TeamId; return(Query(doesExist).Count() > 0); }
public void Delete(BoxScoreEntry entry) { base.Delete(entry); }
public BoxScoreEntry Update(BoxScoreEntry entry) { return(base.Update(entry)); }
public BoxScoreEntry Insert(BoxScoreEntry entry) { return(Add(entry)); }