public void Repository_Initialization_Test()
{
try
{
// Arrange and Act
PlayerEvaluationRepository PlayerEvaluationRepository = new PlayerEvaluationRepository();
// Assert
Assert.IsNotNull(PlayerEvaluationRepository);
}
catch (Exception)
{
throw new AssertFailedException("Unable to initialize PlayerEvaluationRepository.");
}
}
public void Repository_Insert_Update_Delete_PlayerEvaluation_Test()
{
try
{
// Arrange
PlayerEvaluationRepository PlayerEvaluationRepository = new PlayerEvaluationRepository();
PlayerEvaluation PlayerEvaluationToSave = new PlayerEvaluation();
PlayerEvaluationToSave.sportId = 1;
PlayerEvaluationToSave.playerId = 1;
PlayerEvaluationToSave.perfParaName = new PerformanceParameterName();
PlayerEvaluationToSave.perfParaName.id = 1;
PlayerEvaluationToSave.selectedType = new PerformanceParameterType();
PlayerEvaluationToSave.selectedType.id = 1;
PlayerEvaluationToSave.value = "100";
PlayerEvaluation PlayerEvaluationToUpdate = new PlayerEvaluation();
PlayerEvaluationToUpdate.sportId = 1;
PlayerEvaluationToUpdate.playerId = 1;
PlayerEvaluationToUpdate.perfParaName = new PerformanceParameterName();
PlayerEvaluationToUpdate.perfParaName.id = 1;
PlayerEvaluationToUpdate.selectedType = new PerformanceParameterType();
PlayerEvaluationToUpdate.selectedType.id = 2;
PlayerEvaluationToUpdate.value = "200";
// Act
long PlayerEvaluationId = PlayerEvaluationRepository.InsertPlayerEvaluation(PlayerEvaluationToSave);
PlayerEvaluationToUpdate.id = PlayerEvaluationId;
bool isUpdated = PlayerEvaluationRepository.UpdatePlayerEvaluation(PlayerEvaluationToUpdate);
PlayerEvaluation PlayerEvaluationFromDb = PlayerEvaluationRepository.GetPlayerEvaluation(PlayerEvaluationId);
// Assert
Assert.IsTrue(isUpdated);
Assert.IsNotNull(PlayerEvaluationFromDb);
Assert.AreEqual(PlayerEvaluationToUpdate.sportId, PlayerEvaluationFromDb.sportId);
Assert.AreEqual(PlayerEvaluationToUpdate.playerId, PlayerEvaluationFromDb.playerId);
Assert.AreEqual(PlayerEvaluationToUpdate.perfParaName.id, PlayerEvaluationFromDb.perfParaName.id);
Assert.AreEqual(PlayerEvaluationToUpdate.selectedType.id, PlayerEvaluationFromDb.selectedType.id);
Assert.AreEqual(PlayerEvaluationToUpdate.value, PlayerEvaluationFromDb.value);
// Cleanup
bool isDeleted = PlayerEvaluationRepository.DeletePlayerEvaluation(PlayerEvaluationId);
Assert.IsTrue(isDeleted);
}
catch (Exception ex)
{
throw new AssertFailedException("Unable to add/fetch/update/delete player evaluation.");
}
}
public void Repository_Insert_Get_All_Delete_PlayerEvaluation_Test()
{
try
{
// Arrange
PlayerEvaluationRepository PlayerEvaluationRepository = new PlayerEvaluationRepository();
PlayerEvaluation PlayerEvaluationToSave = new PlayerEvaluation();
PlayerEvaluationToSave.sportId = 1;
PlayerEvaluationToSave.playerId = 1;
PlayerEvaluationToSave.perfParaName = new PerformanceParameterName();
PlayerEvaluationToSave.perfParaName.id = 1;
PlayerEvaluationToSave.selectedType = new PerformanceParameterType();
PlayerEvaluationToSave.selectedType.id = 1;
PlayerEvaluationToSave.value = "100";
// Act
long PlayerEvaluationId = PlayerEvaluationRepository.InsertPlayerEvaluation(PlayerEvaluationToSave);
ArrayList PlayerEvaluationsFromDb = PlayerEvaluationRepository.GetPlayerEvaluations(PlayerEvaluationToSave.sportId, PlayerEvaluationToSave.playerId);
// Assert
Assert.IsTrue(PlayerEvaluationsFromDb.Count > 0);
Assert.AreEqual(((PlayerEvaluation)PlayerEvaluationsFromDb[0]).sportId, PlayerEvaluationToSave.sportId);
Assert.AreEqual(((PlayerEvaluation)PlayerEvaluationsFromDb[0]).playerId, PlayerEvaluationToSave.playerId);
Assert.AreEqual(((PlayerEvaluation)PlayerEvaluationsFromDb[0]).perfParaName.id, PlayerEvaluationToSave.perfParaName.id);
Assert.AreEqual(((PlayerEvaluation)PlayerEvaluationsFromDb[0]).selectedType.id, PlayerEvaluationToSave.selectedType.id);
Assert.AreEqual(((PlayerEvaluation)PlayerEvaluationsFromDb[0]).value, PlayerEvaluationToSave.value);
// Cleanup
bool isDeleted = PlayerEvaluationRepository.DeletePlayerEvaluation(PlayerEvaluationId);
Assert.IsTrue(isDeleted);
}
catch (Exception)
{
throw new AssertFailedException("Unable to add/fetch all/detete player evaluation.");
}
}
