public void Add(Shot shot)
{
using (var context = new BolfTrackerContext())
{
context.Shots.Attach(shot);
context.Entry(shot).State = EntityState.Added;
context.SaveChanges();
}
}
public void Update(Shot shot)
{
using (var connection = BolfTrackerDbConnection.GetProfiledConnection())
{
connection.Open();
connection.Execute("UPDATE Shot SET Points = @Points, ShotTypeId = @ShotTypeId WHERE Id = @Id", new { Id = shot.Id, Points = shot.Points, ShotTypeId = shot.ShotType.Id });
}
}
public void Create(int gameId, int playerId, int holeId, int attempts, bool shotMade)
{
var game = _gameRepository.GetById(gameId);
var player = _playerRepository.GetById(playerId);
var hole = _holeRepository.GetById(holeId);
var allHoles = _holeRepository.All();
var allShotTypes = _shotTypeRepository.All();
int playerCurrentPoints = game.Shots.Where(s => s.Player.Id == player.Id).Sum(s => s.Points);
int totalPoints = allHoles.Where(h => h.Id <= hole.Id).Sum(h => h.Par);
int totalPointsTaken = game.Shots.Sum(s => s.Points);
int pointsAvailable = totalPoints - totalPointsTaken;
var currentShot = new Shot
{
Game = game,
Player = player,
Hole = hole,
Attempts = attempts,
ShotMade = shotMade
};
// If first shot of the game, logic is easy
if (!game.Shots.Any())
{
if (currentShot.ShotMade)
{
currentShot.ShotType = allShotTypes.Single(st => st.Id == ShotTypeMake);
currentShot.Points = hole.Par;
}
else
{
currentShot.ShotType = allShotTypes.Single(st => st.Id == ShotTypeMiss);
}
}
else
{
// If not the first shot, stuff starts getting a little complicated
// If the shot was made, start the logic, else just put in a missed shot
if (currentShot.ShotMade)
{
// First lets check if it is the first shot of the current hole
if (game.Shots.Any(s => s.Hole.Id == currentShot.Hole.Id && s.ShotMade == true))
{
// If it's not the first shot, figure out if it is a push
var currentLowestShotMade = game.Shots.Where(s => s.Hole.Id == currentShot.Hole.Id && s.ShotMade == true).OrderBy(s => s.Attempts).First();
if (currentLowestShotMade.Attempts == currentShot.Attempts)
{
// This is a push
currentShot.ShotType = allShotTypes.Single(st => st.Id == ShotTypePush);
// Zero out other player's points that this player pushed.
Update(currentLowestShotMade.Id, 0, allShotTypes.Single(st => st.Id == ShotTypeMake));
}
else
{
// Then it is a steal (because someone has already made it if we got to this point)
// First figure out if the hole had been pushed, because then it will be a "Sugar-Free Steal"
if (game.Shots.Any(s => s.Hole.Id == currentShot.Hole.Id && s.ShotType.Id == ShotTypePush))
{
// This is a sugar-free steal
currentShot.ShotType = allShotTypes.Single(st => st.Id == ShotTypeSugarFreeSteal);
currentShot.Points = pointsAvailable;
// Reset the person who had a push to just be a "Make" now
var playerWithPush = game.Shots.Single(s => s.Hole.Id == currentShot.Hole.Id && s.ShotType.Id == ShotTypePush);
Update(playerWithPush.Id, 0, allShotTypes.Single(st => st.Id == ShotTypeMake));
}
else
{
var playerWithPoints = game.Shots.Single(s => s.Hole.Id == currentShot.Hole.Id && s.Points > 0);
// This is a regular steal
currentShot.ShotType = allShotTypes.Single(st => st.Id == ShotTypeSteal);
currentShot.Points = playerWithPoints.Points;
// Reset the score to zero for the player who previously had the points
Update(playerWithPoints.Id, 0, allShotTypes.Single(st => st.Id == ShotTypeMake));
}
}
}
else
{
// If it is the first shot on the hole, set type and sum points
if (currentShot.ShotMade)
{
currentShot.ShotType = allShotTypes.Single(st => st.Id == ShotTypeMake);
currentShot.Points = pointsAvailable;
}
else
{
currentShot.ShotType = allShotTypes.Single(st => st.Id == ShotTypeMiss);
}
}
}
else
{
currentShot.ShotType = allShotTypes.Single(st => st.Id == ShotTypeMiss);
}
}
_shotRepository.Add(currentShot);
_unitOfWork.Commit();
}
