/// <summary> /// Save a Team to the Database /// </summary> /// <param name="team">Teamobject to Save</param> /// <returns>1 if successfull, otherwise 0</returns> public int SaveTeam(FluffTailRanking.BusinessLayer.BusinessObjects.Team team) { try { using (KickerEntities context = new KickerEntities()) { FluffTailRanking.BusinessLayer.Persistence.Team current = new FluffTailRanking.BusinessLayer.Persistence.Team() { teamname = team.Name, eloid = team.ELOID, playerone = team.Players[0].ID, playertwo = team.Players[2].ID, id = team.ID, wins = team.Wins }; context.Team.Add(current); context.SaveChanges(); } return(1); } catch (Exception ex) { return(0); } }
/// <summary> /// Get a specific Team with its Team ID /// </summary> /// <param name="tid">ID of Team</param> /// <returns>A team with the ID</returns> public FluffTailRanking.BusinessLayer.BusinessObjects.Team GetTeamById(int tid) { FluffTailRanking.BusinessLayer.BusinessObjects.Team team = new FluffTailRanking.BusinessLayer.BusinessObjects.Team(); using (KickerEntities context = new KickerEntities()) { var query = from tm in context.Team where tm.id == tid select new { tn = tm.teamname, w = tm.wins, eloid = tm.eloid, p1id = tm.playerone, p2id = tm.playertwo, id = tm.id }; foreach (var matches in query) { FluffTailRanking.BusinessLayer.BusinessObjects.Player p1 = GetPlayerById(matches.p1id), p2 = GetPlayerById(matches.p2id); team.Players.Add(p1); team.Players.Add(p2); team.ID = matches.id; team.TeamName = matches.tn; team.EloRatingNumber = matches.eloid; team.Name = matches.tn; team.Wins = (int)(p1.Wins + p2.Wins); } return(team); } }
/// <summary> /// Checks if a player is in a team /// </summary> /// <param name="team">(Team) Team to proof</param> /// <param name="player">(Player) Player to proof</param> /// <returns>(Bool) True or False</returns> public bool IsPlayerInTeam(FluffTailRanking.BusinessLayer.BusinessObjects.Team team, FluffTailRanking.BusinessLayer.BusinessObjects.Player player) { if (team.Players[0].ID == player.ID || team.Players[1].ID == player.ID) { return(true); } return(false); }
/// <summary> /// Get all wins of a team /// </summary> /// <param name="t">Team to get wins</param> /// <returns>Integer counting wins</returns> public int GetWinsOfTeam(FluffTailRanking.BusinessLayer.BusinessObjects.Team t) { int wins = 0; IEnumerable <FluffTailRanking.BusinessLayer.BusinessObjects.Game> games = GetAllGames(); foreach (var that in games) { if (that.Winner.ID == t.ID) { wins++; } } return(wins); }
/// <summary> /// Get all Teams from the Database /// </summary> /// <returns>List with Teamobjects</returns> public List <FluffTailRanking.BusinessLayer.BusinessObjects.Team> GetAllTeams() { List <FluffTailRanking.BusinessLayer.BusinessObjects.Team> teams = new List <FluffTailRanking.BusinessLayer.BusinessObjects.Team>(); using (KickerEntities contex = new KickerEntities()) { var query = from team in contex.Team select new { id = team.id }; foreach (var matches in query) { FluffTailRanking.BusinessLayer.BusinessObjects.Team team = GetTeamById(matches.id); teams.Add(team); } return(teams); } }
public int GetTeamWins(Team t) { return persistentManager.GetWinsOfTeam(t); }
public int SaveTeam(Team team) { throw new NotImplementedException(); }
public int GetWinsOfTeam(Team team) { throw new NotImplementedException(); }
/// <summary> /// Get a specific Team with its Team ID /// </summary> /// <param name="tid">ID of Team</param> /// <returns>A team with the ID</returns> public FluffTailRanking.BusinessLayer.BusinessObjects.Team GetTeamById(int tid) { FluffTailRanking.BusinessLayer.BusinessObjects.Team team = new FluffTailRanking.BusinessLayer.BusinessObjects.Team(); using (KickerEntities context = new KickerEntities()) { var query = from tm in context.Team where tm.id == tid select new { tn = tm.teamname, w = tm.wins, eloid = tm.eloid, p1id = tm.playerone, p2id = tm.playertwo, id = tm.id }; foreach (var matches in query) { FluffTailRanking.BusinessLayer.BusinessObjects.Player p1 = GetPlayerById(matches.p1id), p2 = GetPlayerById(matches.p2id); team.Players.Add(p1); team.Players.Add(p2); team.ID = matches.id; team.TeamName = matches.tn; team.EloRatingNumber = matches.eloid; team.Name = matches.tn; team.Wins = (int)(p1.Wins + p2.Wins); } return team; } }