// POST tables/Player
public async Task PostPlayer(Player item)
{
//Player current = await InsertAsync(item);
//return CreatedAtRoute("Tables", new { id = current.Id }, current);
using (var context = new TekkersContext())
{
Team theTeam = context.Teams.Single(t => t.Id == item.PlayersTeam.Id);
item.PlayersTeam = null;
item.PlayersTeam = theTeam;
//context.Players.Add(item);
theTeam.TeamPlayers.Add(item);
try
{
await context.SaveChangesAsync();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = String.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
public ICollection <Test> GetAllTestsForPlayerAsync(string playerid)
{
TekkersContext conn = new TekkersContext();
ICollection <Test> listOfTests = conn.Tests.Where(t => t.PlayerTest.Id == playerid).ToList();
return(listOfTests);
}
public List <Player> GetPlayerByParent(string name)
{
var conn = new TekkersContext();
var parents = conn.Players.Where(p => p.ParentFName == name).ToList();
return(parents);
}
public List <Player> GetPlayerByName(string name)
{
TekkersContext conn = new TekkersContext();
List <Player> playersWithName = conn.Players.Where(p => (p.LastName.Contains(name) || p.FirstName.Contains(name)) && p.Deleted == false).ToList();
return(playersWithName);
}
public async Task PutAssessmentScore(string id, int score)
{
var conn = new TekkersContext();
var assessment = conn.Assessments.Single(ass => ass.Id == id);
assessment.AssessmentScore = score;
try
{
await conn.SaveChangesAsync();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = String.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
return;
}
protected override void Initialize(HttpControllerContext controllerContext)
{
base.Initialize(controllerContext);
TekkersContext context = new TekkersContext();
DomainManager = new EntityDomainManager <Team>(context, Request);
}
protected override void Initialize(HttpControllerContext controllerContext)
{
base.Initialize(controllerContext);
TekkersContext context = new TekkersContext();
DomainManager = new EntityDomainManager <Player>(context, Request, enableSoftDelete: true);
}
public List <Team> GetAllTeams()
{
var conn = new TekkersContext();
List <Team> allteams = conn.Teams.ToList();
return(allteams);
}
public List <Player> GetPlayersOnTeam(string id)
{
var conn = new TekkersContext();
var team = conn.Teams.Single(t => t.Id == id);
var playersOnTeam = team.TeamPlayers.ToList();
return(playersOnTeam);
}
public async Task PutAsync(string testid, int score)
{
TekkersContext conn = new TekkersContext();
var theTest = conn.Tests.Single(t => t.Id == testid);
theTest.TestScore = score;
await conn.SaveChangesAsync();
}
public ICollection <Test> GetTestsByAssessment(string assessid)
{
TekkersContext conn = new TekkersContext();
Assessment theAssessment = conn.Assessments.Single(a => a.Id.Equals(assessid));
Player thePlayer = theAssessment.Player;
ICollection <Test> assessmentTests = conn.Tests.Where(t => t.AssessmentTest.Id.Equals(assessid) && t.PlayerTest.Id == thePlayer.Id).ToList();
return(assessmentTests);
}
public List <Assessment> GetTopAssessmentsByAge(int agegroup)
{
var conn = new TekkersContext();
var assessments = conn.Assessments.Where(a => a.Player.AgeGroup == agegroup && a.Deleted == false)
.OrderByDescending(x => x.AssessmentScore)
.Take(5)
.ToList();
return(assessments);
}
public ICollection <Player> GetPlayersByAge(int age)
{
TekkersContext conn = new TekkersContext();
ICollection <Player> allPlayers = conn.Players.ToList();
foreach (var p in allPlayers)
{
p.AgeGroup = DateTime.Now.Year - p.DateOfBirth.Year;
}
ICollection <Player> listOfPlayersByAge = conn.Players.Where(t => t.AgeGroup == age).ToList();
return(listOfPlayersByAge);
}
// DELETE tables/Team/48D68C86-6EA6-4C25-AA33-223FC9A27959
public async Task DeleteTeam(string id)
{
var conn = new TekkersContext();
var team = conn.Teams.Single(t => t.Id == id);
var playersOnTeam = team.TeamPlayers.ToList(); //conn.Players.Where(p => p.PlayersTeam.Id == id);
foreach (var p in playersOnTeam)
{
p.PlayersTeam = null;
}
conn.Teams.Remove(team);
await conn.SaveChangesAsync();
return;
}
public async Task PostAssessment(Assessment item)
{
using (var context = new TekkersContext())
{
Player thePlayer = context.Players.Single(p => p.Id == item.Player.Id);
item.Player = null;
item.Player = thePlayer;
foreach (Test t in item.Tests)
{
t.PlayerTest = thePlayer;
}
thePlayer.PlayerAssessments.Add(item);
await context.SaveChangesAsync();
}
}
public ICollection <Test> GetAllTestsForTeamAsync(string teamid)
{
TekkersContext conn = new TekkersContext();
IEnumerable <Test> teamsTests = new List <Test>();
teamsTests = from test in conn.Tests
join player in conn.Players
on test.PlayerTest.Id equals player.Id
join team in conn.Teams
on player.PlayersTeam.Id equals team.Id
where team.Id == teamid
select test;
return(teamsTests.ToList());
}
// DELETE tables/Player/DeletePlayer/48D68C86-6EA6-4C25-AA33-223FC9A27959
public async Task DeletePlayer(string id)
{
var conn = new TekkersContext();
Player player = conn.Players.SingleOrDefault(p => p.Id == id);
//Team playersteam = new Team();
//Team playersteam = conn.Teams.Single(t => t.TeamPlayers.Contains(player));
if (player != null)
{
//REMOVE THE PLAYER FROM THE TEAM
Team playersteam = player.PlayersTeam;
List <Player> theTeamsPlayers = playersteam.TeamPlayers.ToList();
theTeamsPlayers.Remove(player);
playersteam.TeamPlayers = theTeamsPlayers;
await conn.SaveChangesAsync();
//DELETE THE PLAYERS ASSESSMENTS AND TESTS
if (player.PlayerAssessments.Count > 0 || player.PlayerAssessments != null)
{
List <Assessment> assessments = new List <Assessment>();
assessments = conn.Assessments.Where(p => p.Player.Id == id).ToList();
foreach (var a in assessments)
{
if (a.Tests.Count > 0)
{
List <Test> tests = new List <Test>();
tests = conn.Tests.Where(t => t.AssessmentTest.Id == a.Id).ToList();
foreach (var t in tests)
{
conn.Tests.Remove(t);
await conn.SaveChangesAsync();
}
conn.Assessments.Remove(a);
await conn.SaveChangesAsync();
}
}
}
//DELETE THE PLAYER
await DeleteAsync(id);
return;
}
else
{
return;
}
}
// GET tables/Player
public List <Player> GetAllPlayer()
{
TekkersContext conn = new TekkersContext();
List <Player> playerList = conn.Players.Where(p => p.Deleted == false).ToList();
//IF THE PLAYER HAS BEEN ADDED WITHOUT BEING ASSIGNED A TEAM OR THE TEAM HAS BEEN REMOVED SET PLAYER AS "NO TEAM" OR "UNASSIGNED"
Team team = new Team();
team.TeamName = "Unassigned";
foreach (var p in playerList)
{
if (p.PlayersTeam == null)
{
p.PlayersTeam = team;
}
}
return(playerList);
}
public List <Assessment> GetAllAssessmentsForPlayer(string playerId)
{
var conn = new TekkersContext();
List <Assessment> theAssessments = new List <Assessment>();
var assessments = conn.Assessments.Where(a => a.Player.Id == playerId && a.Deleted == false)
.OrderBy(x => x.AssessmentDate)
.ToList();
if (assessments.Count > 0)
{
theAssessments = assessments;
}
else if (assessments.Count == 0)
{
theAssessments = null;
}
return(theAssessments);
}
public Assessment GetMostRecentAssessmentForPlayer(string id)
{
var conn = new TekkersContext();
Assessment pa = new Assessment();
//var assessments = conn.Assessments.Any(a => a.Player.Id == id);
var assessment = conn.Assessments.Where(a => a.Player.Id == id && a.Deleted == false)
.OrderByDescending(x => x.AssessmentDate)
.Take(1)
.ToList();
if (assessment.Count == 1)
{
pa = assessment[0];
}
else if (assessment.Count == 0)
{
pa = null;
}
return(pa);
}
// PATCH tables/Player/48D68C86-6EA6-4C25-AA33-223FC9A27959
public async Task PutPlayer(string id, Player p)
{
//return UpdateAsync(id, p);
using (var conn = new TekkersContext())
{
Player thePlayer = conn.Players.Single(x => x.Id == p.Id);
Team theTeam = conn.Teams.Single(t => t.Id == p.PlayersTeam.Id);
thePlayer.PlayersTeam = null;
thePlayer.FirstName = p.FirstName;
thePlayer.LastName = p.LastName;
thePlayer.ParentFName = p.ParentFName;
thePlayer.ParentLName = p.ParentLName;
thePlayer.Email = p.Email;
thePlayer.DateOfBirth = p.DateOfBirth;
thePlayer.AgeGroup = p.DateOfBirth.Year;
thePlayer.PhoneNum = p.PhoneNum;
thePlayer.PlayersTeam = theTeam;
try
{
await conn.SaveChangesAsync();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = String.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
}
