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));
}
