public void InsertGame(Game game)
{
Execute(@"
insert into Game
values(@homeTeamId, @awayTeamId, @GameDateTime, @homeScore, @awayScore)",
game);
}
public void UpdateGame(Game game)
{
Execute(@"
update Game
set HomeTeamId = @homeTeamId
, AwayTeamId = @awayTeamId
, GameDateTime = @GameDateTime
, HomeScore = @homeScore
, AwayScore = @awayScore
where GameId = @gameId",
game);
}
private Result CalcResult(Game game)
{
var result = Result.None;
if (game.HomeScore.HasValue)
{
if (game.HomeScore == game.AwayScore)
{
result = Result.Draw;
}
else if (game.HomeScore > game.AwayScore)
{
result = Result.HomeWin;
}
else if (game.HomeScore < game.AwayScore)
{
result = Result.AwayWin;
}
}
return result;
}
private static string CalcScore(Game game)
{
return game.HomeScore.HasValue
? String.Format("{0} - {1}", game.HomeScore, game.AwayScore)
: "";
}
public void SetDomainFromModel(EditGameModel editGameModel, Game game)
{
game.GameId = editGameModel.GameId;
game.HomeTeamId = editGameModel.HomeTeamId;
game.AwayTeamId = editGameModel.AwayTeamId;
game.HomeScore = editGameModel.HomeScore;
game.AwayScore = editGameModel.AwayScore;
game.GameDateTime = editGameModel.GameDate;
}
public void SaveEditGameModel(EditGameModel editGameModel)
{
if (editGameModel.GameId == 0)
{
Game game = new Game
{
HomeTeamId = editGameModel.HomeTeamId,
AwayTeamId = editGameModel.AwayTeamId,
HomeScore = editGameModel.HomeScore,
AwayScore = editGameModel.AwayScore,
GameDateTime = editGameModel.GameDate
};
_gameRepository.InsertGame(game);
}
else
{
Game game = _gameRepository.GetGame(editGameModel.GameId);
_mapper.SetDomainFromModel(editGameModel, game);
_gameRepository.UpdateGame(game);
}
}
