/// <summary>
/// data layer will determine add vs update
/// </summary>
/// <param name="league"></param>
public void Save(GameTeamDto playerTeam)
{
if (ExistsInDb(playerTeam))
{
Update(playerTeam);
}
else
{
AddNew(playerTeam);
}
}
private void UpdateGameTeam(GameTeamDto gameTeam)
{
string updateQuery = @"UPDATE GameTeam
SET GameTeamId = @GameTeamId,
DeleteDate = @DeleteDate
WHERE GameId = @GameId AND TeamId = @TeamId";
Connection.BeginTransaction();
Connection.Execute(updateQuery, gameTeam);
Connection.Commit();
}
public void InvalidTeamIdTest()
{
GameTeamDto dto = new GameTeamDto()
{
GameId = Guid.NewGuid(),
};
var result = GameTeam.AddNew(dto);
Assert.IsFalse(result.IsSuccess);
}
public bool ExistsInDb(GameTeamDto gameTeam)
{
Connection.BeginTransaction();
var rows = Connection.Query <int>(@"SELECT COUNT(1) as 'Count' FROM GameTeam
WHERE GameId = @GameId AND TeamId = @TeamId",
new { gameTeam.GameId, gameTeam.TeamId });
Connection.Commit();
return(rows.First() > 0);
}
public void AddUpdateGameTeamTest()
{
Guid seedGameId = SeedGame();
Guid seedTeamId = SeedTeam();
GameTeamDto dto = new GameTeamDto()
{
GameId = seedGameId,
TeamId = seedTeamId
};
var addResult = GameTeam.AddNew(dto);
Assert.IsTrue(addResult.IsSuccess);
var item = GameTeam.GetGameTeam(seedGameId, seedTeamId);
Assert.IsNotNull(item);
Assert.AreEqual(seedTeamId, item.TeamId);
Assert.AreEqual(seedGameId, item.GameId);
dto.GameTeamId = item.GameTeamId;
dto.DeleteDate = DateTime.UtcNow;
var updateResult = GameTeam.Update(dto);
Assert.IsTrue(updateResult.IsSuccess);
item = GameTeam.GetGameTeam(seedGameId, seedTeamId);
Assert.IsNotNull(item);
Assert.IsNotNull(item.DeleteDate);
dto.DeleteDate = null;
updateResult = GameTeam.Update(dto);
Assert.IsTrue(updateResult.IsSuccess);
var items = GameTeam.GetGameTeams(seedGameId);
Assert.IsTrue(items.Count >= 1);
item = items.FirstOrDefault(x => x.TeamId == seedTeamId);
Assert.IsNotNull(item);
var removeResult = GameTeam.Remove(seedGameId, seedTeamId);
Assert.IsTrue(removeResult.IsSuccess);
item = GameTeam.GetGameTeam(seedGameId, seedTeamId);
Assert.IsNull(item);
DeleteSeededGame(seedGameId);
DeleteSeededTeam(seedTeamId);
}
private void InsertGameTeam(GameTeamDto gameTeam)
{
string insertQuery = @"INSERT INTO GameTeam
(GameTeamId, GameId, TeamId, DeleteDate)
VALUES(
@GameTeamId,
@GameId,
@TeamId,
@DeleteDate)";
Connection.BeginTransaction();
Connection.Execute(insertQuery, gameTeam);
Connection.Commit();
}
public Guid SeedGameTeam(Guid gameId, Guid teamId, int battingSequence)
{
Guid gameTeamId = Guid.NewGuid();
GameTeamDto dto = new GameTeamDto()
{
GameId = gameId,
TeamId = teamId,
GameTeamId = gameTeamId,
TeamBattingSequence = battingSequence
};
GameTeam.AddNew(dto);
return(gameTeamId);
}
public GameTeamDto LoadByCompositeKey(Guid gameId, Guid teamId)
{
GameTeamDto gameTeam = null;
Connection.BeginTransaction();
var result = Connection.Query <GameTeamDto>(
SELECT_QUERY + " WHERE GameId = @GameId " +
"AND TeamId = @TeamId",
new { GameId = gameId.ToString(), TeamId = teamId.ToString() });
gameTeam = result.FirstOrDefault();
Connection.Commit();
return(gameTeam);
}
public Guid SeedGameTeam()
{
Guid gameTeamId = Guid.NewGuid();
Guid seedGameId = SeedGame();
Guid seedTeamId = SeedTeam();
GameTeamDto dto = new GameTeamDto()
{
GameTeamId = gameTeamId,
GameId = seedGameId,
TeamId = seedTeamId
};
GameTeam.AddNew(dto);
return(gameTeamId);
}
public void Update(GameTeamDto gameTeam)
{
UpdateGameTeam(gameTeam);
}
public void AddNew(GameTeamDto gameTeam)
{
InsertGameTeam(gameTeam);
}
