private void AssertThatEachElementIsEqualWithPlayerValues(Batting batting, BattingStats battingStats)
{
Assert.That(battingStats.NameFirst, Is.EqualTo(batting.Player.NameFirst));
Assert.That(battingStats.NameGiven, Is.EqualTo(batting.Player.NameGiven));
Assert.That(battingStats.NameLast, Is.EqualTo(batting.Player.NameLast));
Assert.That(battingStats.PlayerId, Is.EqualTo(batting.PlayerId));
Assert.That(battingStats.YearId, Is.EqualTo(batting.YearId));
Assert.That(battingStats.Stint, Is.EqualTo(batting.Stint));
Assert.That(battingStats.TeamId, Is.EqualTo(batting.TeamId));
Assert.That(battingStats.LgId, Is.EqualTo(batting.LgId));
Assert.That(battingStats.G, Is.EqualTo(batting.G));
Assert.That(battingStats.GBatting, Is.EqualTo(batting.GBatting));
Assert.That(battingStats.Ab, Is.EqualTo(batting.Ab));
Assert.That(battingStats.R, Is.EqualTo(batting.R));
Assert.That(battingStats.H, Is.EqualTo(batting.H));
Assert.That(battingStats.X2b, Is.EqualTo(batting.X2b));
Assert.That(battingStats.X3b, Is.EqualTo(batting.X3b));
Assert.That(battingStats.Hr, Is.EqualTo(batting.Hr));
Assert.That(battingStats.Rbi, Is.EqualTo(batting.Rbi));
Assert.That(battingStats.Sb, Is.EqualTo(batting.Sb));
Assert.That(battingStats.Cs, Is.EqualTo(batting.Cs));
Assert.That(battingStats.Bb, Is.EqualTo(batting.Bb));
Assert.That(battingStats.So, Is.EqualTo(batting.So));
Assert.That(battingStats.Ibb, Is.EqualTo(batting.Ibb));
Assert.That(battingStats.Hbp, Is.EqualTo(batting.Hbp));
Assert.That(battingStats.Sh, Is.EqualTo(batting.Sh));
Assert.That(battingStats.Sf, Is.EqualTo(batting.Sf));
Assert.That(battingStats.Gidp, Is.EqualTo(batting.Gidp));
}
private void DeserializeAndAddBatting(string json, BarStoolLeagueContext context)
{
var batting = new Batting();
JsonConvert.PopulateObject(json, batting);
context.Batting.Add(batting);
}
public void MapYearCopiesDataFromBattingAndPlayerToBattingLeagueStats()
{
Batting batting = GenerateBattingWithPlayer();
BattingStats battingStats = _mapper.Map(batting);
AssertThatEachElementIsEqualWithPlayerValues(batting, battingStats);
}
public void BallBowled(string outcome, int runs)
{
if (outcome != "Wide" && outcome != "No Ball")
{
OnStrike.FaceBall();
Bowler.BallBowled();
Overs += 0.1;
OversConverter();
}
if (outcome == "Runs")
{
Runs(runs);
}
if (outcome == "Byes")
{
Batting.AddByes(runs);
if (runs % 2 != 0)
{
BatsmenSwap();
}
}
if (outcome == "Leg Byes")
{
Batting.AddLegByes(runs);
if (runs % 2 != 0)
{
BatsmenSwap();
}
}
if (outcome == "Wide")
{
Batting.AddWides(runs);
if (runs - 1 % 2 != 0)
{
BatsmenSwap();
}
Bowler.ConcedeRuns(runs);
}
if (outcome == "No Ball")
{
if (runs > 1)
{
int batRuns = runs - 1;
Batting.AddNoBalls(1);
OnStrike.ScoreRuns(batRuns);
if (batRuns % 2 != 0)
{
BatsmenSwap();
}
}
else
{
Batting.AddNoBalls(runs);
}
Bowler.ConcedeRuns(runs);
}
Batting.CalcRuns();
EndOfOverCheck();
InEndCheck();
}
private void ReduceBatting(Season season, FileStore dataStore)
{
List <BattingRecord> records =
dataStore.Load <List <BattingRecord> >(IndividualBattingMap.GenerateId(season.Name));
Batting.Reduce(records, dataStore);
}
public void Wicket(string method)
{
OnStrike.IsOut = true;
OnStrike.MethodOut = method;
Bowler.GetWicket();
SetBatsmen();
Batting.CalcWickets();
}
private void CopyPlayerDataIfPlayerExists(Batting batting, BattingStats battingStats)
{
if (batting.Player != null)
{
battingStats.NameFirst = batting.Player.NameFirst;
battingStats.NameLast = batting.Player.NameLast;
battingStats.NameGiven = batting.Player.NameGiven;
}
}
public void AssertGetBattingStatsReturnsStats(Batting expectedBatting)
{
var expectedBattingStats = new BattingStats();
_mockMapper.Setup(mockBattingMapper => mockBattingMapper.Map(expectedBatting)).Returns(expectedBattingStats);
var actualBatting = _service.GetBattingStats(expectedBatting.PlayerId);
Assert.That(actualBatting.ElementAt(0), Is.EqualTo(expectedBattingStats));
}
private void AssertGetBattingStatsByYearReturnsStats(Batting expectedBatting)
{
var expectedBattingStatsByYear = new BattingStats();
_mockMapper.Setup(mockBattingMapper => mockBattingMapper.Map(expectedBatting)).Returns(expectedBattingStatsByYear);
var actualBattingLeaderboardStats = _service.GetBattingStatsByYear(expectedBatting.YearId);
Assert.That(actualBattingLeaderboardStats.ElementAt(0), Is.EqualTo(expectedBattingStatsByYear));
}
public void Wicket(string method, Player player)
{
player.IsOut = true;
player.MethodOut = method;
if (method != "Run out")
{
Bowler.GetWicket();
}
SetBatsmen();
Batting.CalcWickets();
}
public void MapCopiesDataFromBattingToBattingStats()
{
Batting batting = GenerateBattingWithoutNullValues();
BattingStats battingStats = _mapper.Map(batting);
AssertThatEachElementIsEqual(batting, battingStats);
Batting battingWithNull = GenerateBattingWithNullValues();
BattingStats battingStatsWithNull = _mapper.Map(battingWithNull);
AssertThatEachElementIsEqual(battingWithNull, battingStatsWithNull);
}
public void AssertGetBattingStatsReturnsStatsWithDuplicateId(Batting firstEntry, Batting secondEntry)
{
var firstEntryStats = new BattingStats();
var secondEntryStats = new BattingStats();
_mockMapper.Setup(mockBattingMapper => mockBattingMapper.Map(firstEntry)).Returns(firstEntryStats);
_mockMapper.Setup(mockBattingMapper => mockBattingMapper.Map(secondEntry)).Returns(secondEntryStats);
var actualBatting = _service.GetBattingStats(firstEntry.PlayerId);
Assert.That(actualBatting.ElementAt(0), Is.EqualTo(firstEntryStats));
Assert.That(actualBatting.ElementAt(1), Is.EqualTo(secondEntryStats));
}
private void AssertGetBattingStatsByTeamReturnsStats(Batting firstPerson, Batting secondPerson)
{
var firstBattingStats = new BattingStats();
var secondBattingStats = new BattingStats();
_mockMapper.Setup(mockBattingMapper => mockBattingMapper.Map(firstPerson)).Returns(firstBattingStats);
_mockMapper.Setup(mockBattingMapper => mockBattingMapper.Map(secondPerson)).Returns(secondBattingStats);
var actualBattingStats = _service.GetBattingStatsByTeam(firstPerson.TeamId, firstPerson.YearId);
Assert.That(actualBattingStats.ElementAt(0), Is.EqualTo(firstBattingStats));
//Assert.That(actualBattingStats.ElementAt(1), Is.EqualTo(secondBattingStats));
}
public void InEndCheck()
{
if ((Overs >= InLength || Batting.Wickets == Batting.NumPlayers() - 1) && Batting == Team1)
{
FirstInScore = Batting.Runs;
Overs = 0;
Batting = Team2;
}
else if (Overs >= InLength || Batting.Wickets == Batting.NumPlayers() - 1 || Batting.Runs > FirstInScore)
{
WinCheck();
}
}
public BattingStats Map(Batting batting)
{
var battingStats = new BattingStats()
{
PlayerId = batting.PlayerId,
YearId = batting.YearId,
Stint = batting.Stint,
TeamId = batting.TeamId,
LgId = batting.LgId,
};
CopyPlayerDataIfPlayerExists(batting, battingStats);
CopyNullableStats(batting, battingStats);
_calculator.CalculateStats(battingStats);
return(battingStats);
}
private void CopyNullableStats(Batting batting, BattingStats battingStats)
{
battingStats.G = batting.G;
battingStats.GBatting = batting.GBatting;
battingStats.Ab = batting.Ab;
battingStats.R = batting.R;
battingStats.H = batting.H;
battingStats.X2b = batting.X2b;
battingStats.X3b = batting.X3b;
battingStats.Hr = batting.Hr;
battingStats.Rbi = batting.Rbi;
battingStats.Sb = batting.Sb;
battingStats.Cs = batting.Cs;
battingStats.Bb = batting.Bb;
battingStats.So = batting.So;
battingStats.Ibb = batting.Ibb;
battingStats.Hbp = batting.Hbp;
battingStats.Sh = batting.Sh;
battingStats.Sf = batting.Sf;
battingStats.Gidp = batting.Gidp;
}
private string GetBestBatting()
{
if (Batting == null || Batting.Count == 0)
{
return(null);
}
List <BatsmanInnings> fifties = Batting.Where(i => i.Runs >= 50).OrderByDescending(i => i.Runs).ToList();
List <BatsmanInnings> scoresUnder50 = Batting.Where(i => i.Runs > 0 && i.Runs < 50).OrderByDescending(i => i.Runs).ToList();
if (fifties.Count > 0)
{
return(string.Join(", ", fifties.Select(i => i.ToShortString())));
}
if (scoresUnder50.Count > 0)
{
return(scoresUnder50[0].ToShortString());
}
return(null);
}
public void AddToBattings(Batting batting)
{
base.AddObject("Battings", batting);
}
public static Batting CreateBatting(string playerID, short yearID, short stint)
{
Batting batting = new Batting();
batting.playerID = playerID;
batting.yearID = yearID;
batting.stint = stint;
return batting;
}
private void loadButton_Click(object sender, RoutedEventArgs e)
{
errorMessage.Content = null;
try
{
using (SessionNoServer session = new SessionNoServer(s_systemDir))
{
Console.WriteLine($"Running with databases in directory: {session.SystemDirectory}");
session.BeginUpdate();
File.Copy(s_licenseDbFile, System.IO.Path.Combine(session.SystemDirectory, "4.odb"), true);
string line;
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Allstar.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AllStar allStar = new AllStar(line);
session.Persist(allStar);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AllstarFull.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AllStarFull allStar = new AllStarFull(line);
session.Persist(allStar);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Appearances.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Appearances a = new Appearances(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AwardsManagers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AwardsManagers a = new AwardsManagers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AwardsPlayers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AwardsPlayers a = new AwardsPlayers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AwardsShareManagers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AwardsShareManagers a = new AwardsShareManagers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\AwardsSharePlayers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
AwardsSharePlayers a = new AwardsSharePlayers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Batting.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Batting a = new Batting(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\BattingPost.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
BattingPost a = new BattingPost(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Fielding.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Fielding a = new Fielding(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\FieldingOF.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
FieldingOF a = new FieldingOF(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\FieldingPost.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
FieldingPost a = new FieldingPost(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\HallOfFame.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
HallOfFame a = new HallOfFame(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\HOFold.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
HOFold a = new HOFold(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Managers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Managers a = new Managers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\ManagersHalf.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
ManagersHalf a = new ManagersHalf(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Master.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Master a = new Master(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Pitching.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Pitching a = new Pitching(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\PitchingPost.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
PitchingPost a = new PitchingPost(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Salaries.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Salaries a = new Salaries(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Schools.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Schools a = new Schools(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\SchoolsPlayers.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
SchoolsPlayers a = new SchoolsPlayers(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\SeriesPost.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
SeriesPost a = new SeriesPost(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Teams.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Teams a = new Teams(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\TeamsFranchises.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
TeamsFranchises a = new TeamsFranchises(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\TeamsHalf.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
TeamsHalf a = new TeamsHalf(line);
session.Persist(a);
}
}
using (StreamReader stream = new StreamReader(lahman58db.Text + "\\Xref_Stats.csv", true))
{
line = stream.ReadLine(); // heading title line
while ((line = stream.ReadLine()) != null)
{
Xref_Stats a = new Xref_Stats(line);
session.Persist(a);
}
}
session.Commit();
errorMessage.Content = "Done, databases located in: " + session.SystemDirectory + " View objects using VelocityDBBrowser";
}
}
catch (Exception ex)
{
errorMessage.Content = ex.Message == null?ex.ToString() : ex.Message;
}
}
public void CreateFakeData()
{
_firstPerson = new Batting()
{
YearId = 2000,
Hr = 20,
Ab = 100,
PlayerId = "id",
TeamId = "SEA"
};
_secondPerson = new Batting()
{
YearId = 2000,
Hr = 10,
Ab = 200,
PlayerId = "anotherId",
TeamId = "SEA"
};
_thirdPerson = new Batting()
{
YearId = 1999,
Hr = 18,
Ab = 99,
PlayerId = "id",
TeamId = "SEA"
};
_fourthPerson = new Batting
{
YearId = 1998,
Hr = 18,
Ab = 101,
PlayerId = "fourthId",
Player = new People()
{
PlayerId = "fourthId",
NameFirst = "first",
NameGiven = "first middle",
NameLast = "last"
},
TeamId = "NYA"
};
_fifthPerson = new Batting
{
YearId = 1998,
Hr = 18,
Ab = 101,
PlayerId = "fifthId",
Player = new People()
{
PlayerId = "fifthId",
NameFirst = "fifth",
NameGiven = "fifth middle",
NameLast = "last"
},
TeamId = "NYA"
};
_database.Add(_firstPerson);
_database.Add(_secondPerson);
_database.Add(_thirdPerson);
_database.Add(_fourthPerson);
_database.SaveChanges();
}
