public PlayerEvaluation GetPlayerEvaluation(long evaluationId)
{
String sqlStr = "select id, sport_id, player_id, name_id, type_id, value, eval_date from player_eval where id = @evalId";
MySqlCommand cmd = new MySqlCommand(sqlStr, conn);
cmd.Parameters.AddWithValue("evalId", evaluationId);
MySqlDataReader sqlReader = cmd.ExecuteReader();
PlayerEvaluation pp = null;
if (sqlReader.Read())
{
pp = new PlayerEvaluation();
pp.id = sqlReader.GetInt32(0);
pp.sportId = sqlReader.GetInt32(1);
pp.playerId = sqlReader.GetInt32(2);
pp.perfParaName = new PerformanceParameterName();
pp.perfParaName.id = sqlReader.GetInt32(3);
pp.selectedType = new PerformanceParameterType();
pp.selectedType.id = sqlReader.GetInt32(4);
pp.value = sqlReader.GetString(5);
}
sqlReader.Close();
return(pp);
}
public void Post_Valid_Test()
{
// Arrange
PlayerEvaluation PlayerEvaluationObjAsInput = new PlayerEvaluation();
PlayerEvaluationObjAsInput.sportId = 1;
PlayerEvaluationObjAsInput.playerId = 1;
PlayerEvaluationObjAsInput.perfParaName = new PerformanceParameterName();
PlayerEvaluationObjAsInput.perfParaName.id = 1;
PlayerEvaluationObjAsInput.selectedType = new PerformanceParameterType();
PlayerEvaluationObjAsInput.selectedType.id = 1;
PlayerEvaluationObjAsInput.value = "100";
var mockRepository = new Mock <IPlayerEvaluationRepository>();
mockRepository.Setup(x => x.InsertPlayerEvaluation(PlayerEvaluationObjAsInput))
.Returns(1);
var controller = new PlayerEvaluationController(mockRepository.Object);
controller.Request = new HttpRequestMessage();
controller.Configuration = new HttpConfiguration();
// Act
HttpResponseMessage response = controller.Post(PlayerEvaluationObjAsInput);
// Assert
string responseJSONStr = response.Content.ReadAsStringAsync().Result;
string responseStr = Helper.Deserialize <string>(responseJSONStr);
Assert.IsNotNull(response);
Assert.AreEqual(response.StatusCode, HttpStatusCode.OK);
Assert.AreEqual(responseStr, "PlayerEvaluation added successfully.");
}
// PUT: api/PlayerEvaluation/5
public HttpResponseMessage Put([FromBody] PlayerEvaluation PlayerEvaluation)
{
HttpResponseMessage response;
if (PlayerEvaluation == null)
{
response = Request.CreateResponse(HttpStatusCode.NoContent, "Invalid JSON Passed.");
return(response);
}
if (PlayerEvaluation.id <= 0)
{
response = Request.CreateResponse(HttpStatusCode.NoContent, "Invalid Id Passed.");
return(response);
}
if (PlayerEvaluation.sportId <= 0)
{
response = Request.CreateResponse(HttpStatusCode.PartialContent, "Invalid Sport Id passed.");
return(response);
}
if (PlayerEvaluation.playerId <= 0)
{
response = Request.CreateResponse(HttpStatusCode.PartialContent, "Invalid Player Id passed.");
return(response);
}
if (PlayerEvaluation.perfParaName.id <= 0)
{
response = Request.CreateResponse(HttpStatusCode.PartialContent, "Invalid Name Id passed.");
return(response);
}
if (PlayerEvaluation.selectedType.id <= 0)
{
response = Request.CreateResponse(HttpStatusCode.PartialContent, "Invalid Type Id passed.");
return(response);
}
bool isUpdated = _iPlayerEvaluationRepository.UpdatePlayerEvaluation(PlayerEvaluation);
if (isUpdated)
{
response = Request.CreateResponse(HttpStatusCode.OK, "Updated PlayerEvaluation successfully.");
}
else
{
response = Request.CreateResponse(HttpStatusCode.Conflict, "Invalid PlayerEvaluation id passed.");
}
return(response);
}
public void PerformanceParameterEvaluation_Initialization_Test()
{
try
{
// Arrange and Act
PlayerEvaluation playerEvaluation = new PlayerEvaluation();
// Assert
Assert.IsNotNull(playerEvaluation);
}
catch (Exception)
{
throw new AssertFailedException("PlayerEvaluation initialization failed.");
}
}
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.");
}
}
// POST: api/PlayerEvaluation
public HttpResponseMessage Post([FromBody] PlayerEvaluation PlayerEvaluation)
{
HttpResponseMessage response;
if (PlayerEvaluation == null)
{
response = Request.CreateResponse(HttpStatusCode.NoContent, "Invalid JSON Passed.");
return(response);
}
if (PlayerEvaluation.sportId <= 0)
{
response = Request.CreateResponse(HttpStatusCode.PartialContent, "Invalid Sport Id passed.");
return(response);
}
if (PlayerEvaluation.playerId <= 0)
{
response = Request.CreateResponse(HttpStatusCode.PartialContent, "Invalid Player Id passed.");
return(response);
}
if (PlayerEvaluation.perfParaName.id <= 0)
{
response = Request.CreateResponse(HttpStatusCode.PartialContent, "Invalid Name Id passed.");
return(response);
}
if (PlayerEvaluation.selectedType.id <= 0)
{
response = Request.CreateResponse(HttpStatusCode.PartialContent, "Invalid Type Id passed.");
return(response);
}
long PlayerEvaluationId = _iPlayerEvaluationRepository.InsertPlayerEvaluation(PlayerEvaluation);
if (PlayerEvaluationId != -1)
{
response = Request.CreateResponse(HttpStatusCode.OK, "PlayerEvaluation added successfully.");
}
else
{
response = Request.CreateResponse(HttpStatusCode.Conflict, "Error adding PlayerEvaluation.");
}
return(response);
}
public void PerformanceParameterEvaluation_Property_Set_Test()
{
try
{
// Arrange
PlayerEvaluation playerEvaluation = new PlayerEvaluation();
// Act
playerEvaluation.sportId = 1;
playerEvaluation.playerId = 1;
playerEvaluation.perfParaName = new PerformanceParameterName();
playerEvaluation.perfParaName.id = 1;
playerEvaluation.perfParaName.name = "Perf Para 1";
playerEvaluation.customName = "Custom Name";
playerEvaluation.perfParaTypes = new List <PerformanceParameterType>();
PerformanceParameterType perfParaType = new PerformanceParameterType();
perfParaType.id = 1;
perfParaType.groupId = 1;
perfParaType.name = "Perf Para Type 1";
playerEvaluation.perfParaTypes.Add(perfParaType);
playerEvaluation.selectedType = new PerformanceParameterType();
playerEvaluation.selectedType.id = 1;
playerEvaluation.selectedType.groupId = 1;
playerEvaluation.selectedType.name = "Perf Para Type 1";
playerEvaluation.value = "value";
// Assert
Assert.AreEqual <long>(playerEvaluation.sportId, 1);
Assert.AreEqual <long>(playerEvaluation.perfParaName.id, 1);
Assert.AreEqual <string>(playerEvaluation.perfParaName.name, "Perf Para 1");
Assert.AreEqual <string>(playerEvaluation.customName, "Custom Name");
Assert.AreEqual <long>(playerEvaluation.perfParaTypes[0].id, 1);
Assert.AreEqual <long>(playerEvaluation.perfParaTypes[0].groupId, 1);
Assert.AreEqual <string>(playerEvaluation.perfParaTypes[0].name, "Perf Para Type 1");
Assert.AreEqual <long>(playerEvaluation.selectedType.id, 1);
Assert.AreEqual <long>(playerEvaluation.selectedType.groupId, 1);
Assert.AreEqual <string>(playerEvaluation.selectedType.name, "Perf Para Type 1");
Assert.AreEqual <string>(playerEvaluation.value, "value");
}
catch (Exception)
{
throw new AssertFailedException("Setting PerformanceParameterEvaluation properties failed.");
}
}
public bool UpdatePlayerEvaluation(PlayerEvaluation playerEvaluation)
{
String sqlStr = "SELECT * FROM player_eval WHERE id = " + playerEvaluation.id;
MySqlCommand cmd = new MySqlCommand(sqlStr, conn);
MySqlDataReader sqlReader = cmd.ExecuteReader();
if (sqlReader.Read())
{
sqlReader.Close();
string value = String.IsNullOrWhiteSpace(playerEvaluation.value) ? null : playerEvaluation.value;
sqlStr = "UPDATE player_eval SET sport_id = " + playerEvaluation.sportId + ", player_id = " + playerEvaluation.playerId + ", name_id = " + playerEvaluation.perfParaName.id + ", type_id = " + playerEvaluation.selectedType.id + ", value = '" + value + "' WHERE id = " + playerEvaluation.id;
cmd = new MySqlCommand(sqlStr, conn);
cmd.ExecuteNonQuery();
return(true);
}
else
{
return(false);
}
}
public long InsertPlayerEvaluation(PlayerEvaluation playerEvaluation)
{
String sqlStr = "insert into player_eval(sport_id, player_id, name_id, type_id, value, eval_date) values(@sportId, @playerId, @nameId, @typeId, @value, @currentDate)";
MySqlCommand cmd = new MySqlCommand(sqlStr, conn);
cmd.Parameters.AddWithValue("sportId", playerEvaluation.sportId);
cmd.Parameters.AddWithValue("playerId", playerEvaluation.playerId);
cmd.Parameters.AddWithValue("nameId", playerEvaluation.perfParaName.id);
cmd.Parameters.AddWithValue("typeId", playerEvaluation.selectedType.id);
cmd.Parameters.AddWithValue("value", String.IsNullOrWhiteSpace(playerEvaluation.value) ? null : playerEvaluation.value);
cmd.Parameters.AddWithValue("currentDate", DateTime.Now);
try
{
cmd.ExecuteNonQuery();
return(cmd.LastInsertedId);
}
catch (Exception)
{
return(-1);
}
}
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.");
}
}
public ArrayList GetPlayerEvaluations(long sportsId, long playerId)
{
String sqlStr = "select pp.id, pp.sport_id, pp.name_id, ppn.name, pp.custom_name, pp.group_id from perf_para pp join perf_para_name ppn on pp.name_id = ppn.id where pp.sport_id = @sportId";
MySqlCommand cmd = new MySqlCommand(sqlStr, conn);
cmd.Parameters.AddWithValue("sportId", sportsId);
MySqlDataReader sqlReader = cmd.ExecuteReader();
ArrayList playerEvaluations = new ArrayList();
PlayerEvaluation pp = null;
List <int> groupIds = new List <int>();
while (sqlReader.Read())
{
pp = new PlayerEvaluation();
pp.id = sqlReader.GetInt32(0);
pp.sportId = sqlReader.GetInt32(1);
pp.playerId = playerId;
pp.perfParaName = new PerformanceParameterName();
pp.perfParaName.id = sqlReader.GetInt32(2);
pp.perfParaName.name = sqlReader.GetString(3);
pp.customName = sqlReader.GetString(4);
groupIds.Add(sqlReader.GetInt32(5));
playerEvaluations.Add(pp);
}
sqlReader.Close();
for (int groupIdIndex = 0; groupIdIndex < groupIds.Count; groupIdIndex++)
{
int groupId = groupIds[groupIdIndex];
sqlStr = "select id, group_id, name from perf_para_type where group_id = @groupId";
cmd = new MySqlCommand(sqlStr, conn);
cmd.Parameters.AddWithValue("groupId", groupId);
MySqlDataReader perfParaTypeSqlReader = cmd.ExecuteReader();
List <PerformanceParameterType> perfParaTypes = new List <PerformanceParameterType>();
PerformanceParameterType perfParaType = null;
while (perfParaTypeSqlReader.Read())
{
perfParaType = new PerformanceParameterType();
perfParaType.id = perfParaTypeSqlReader.GetInt32(0);
perfParaType.groupId = perfParaTypeSqlReader.GetInt32(1);
perfParaType.name = perfParaTypeSqlReader.GetString(2);
perfParaTypes.Add(perfParaType);
}
perfParaTypeSqlReader.Close();
((PlayerEvaluation)playerEvaluations[groupIdIndex]).perfParaTypes = perfParaTypes;
foreach (PerformanceParameterType paraType in perfParaTypes)
{
sqlStr = "select pe.type_id, ppt.group_id, ppt.name, pe.value from player_eval pe join perf_para_type ppt on pe.type_id = ppt.id where pe.sport_id = @sportId and pe.player_id = @playerId and pe.type_id = @typeId and pe.eval_date = current_date()";
cmd = new MySqlCommand(sqlStr, conn);
cmd.Parameters.AddWithValue("sportId", sportsId);
cmd.Parameters.AddWithValue("playerId", playerId);
cmd.Parameters.AddWithValue("typeId", paraType.id);
cmd.Parameters.AddWithValue("currentDate", DateTime.Now);
MySqlDataReader playerEvalSqlReader = cmd.ExecuteReader();
if (playerEvalSqlReader.Read())
{
((PlayerEvaluation)playerEvaluations[groupIdIndex]).selectedType = new PerformanceParameterType();
((PlayerEvaluation)playerEvaluations[groupIdIndex]).selectedType.id = playerEvalSqlReader.GetInt32(0);
((PlayerEvaluation)playerEvaluations[groupIdIndex]).selectedType.groupId = playerEvalSqlReader.GetInt32(1);
((PlayerEvaluation)playerEvaluations[groupIdIndex]).selectedType.name = playerEvalSqlReader.GetString(2);
((PlayerEvaluation)playerEvaluations[groupIdIndex]).value = playerEvalSqlReader.IsDBNull(3) ? string.Empty : playerEvalSqlReader.GetString(3);
playerEvalSqlReader.Close();
break;
}
playerEvalSqlReader.Close();
}
}
return(playerEvaluations);
}
