public IHttpActionResult CreateTeam([FromBody]TeamDTO _team) { LeaguesApiController leaguesApiController = new LeaguesApiController(); int leagueId = leaguesApiController.getLeagueIdByTeamId(_team.Id); team t = new team { Name = _team.Name, Description = _team.Description, League = leagueId, Enabled = true, Logo = _team.Logo }; using (var context = new escorcenterdbEntities()) { context.teams.Add(t); context.SaveChanges(); } return Ok(t); }
public IHttpActionResult CreateTeam([FromBody] TeamDTO _team) { LeaguesApiController leaguesApiController = new LeaguesApiController(); int leagueId = leaguesApiController.getLeagueIdByTeamId(_team.Id); team t = new team { Name = _team.Name, Description = _team.Description, League = leagueId, Enabled = true, Logo = _team.Logo }; using (var context = new escorcenterdbEntities()) { context.teams.Add(t); context.SaveChanges(); } return(Ok(t)); }
public IHttpActionResult GetScoreTableResult(int teamId) { scoretableview _scoreTableView = null; LeaguesApiController leagueApi = new LeaguesApiController(); int position = 0; team _team = null; scoretableview[] _scoreTable = null; using (var context = new escorcenterdbEntities()) { _scoreTableView = (from s in context.scoretableviews where s.team == teamId select s).FirstOrDefault <scoretableview>(); _team = (from t in context.teams where t.Id == teamId && t.Enabled == true select t).FirstOrDefault <team>(); long seasonId = leagueApi.GetCurrentSeasonId(_team.League, DateTime.Now); _scoreTable = (from st in context.scoretableviews where st.season == seasonId select st).OrderBy(st => st.GamesWon.Value * 3 + st.GamesDrawn.Value * 1).ToArray <scoretableview>(); } if (_scoreTableView == null) { return(Ok()); } foreach (scoretableview st in _scoreTable) { if (st.team == teamId) { break; } position++; } // scoretableview y ScoreTableResultDTO son incompatibles team del primero es Int32, team del segundo es TeamDTO TeamDTO teamDTO = AutoMapper.Mapper.Map <team, TeamDTO>(_team); ScoreTableResultDTO scoreTableResultDTO = new ScoreTableResultDTO() { League = leagueApi.getLeagueNameById(_team.League), Position = (long)position, GamesDrawn = (long)_scoreTableView.GamesDrawn, GamesLost = (long)_scoreTableView.GamesLost, GamesPlayed = (long)_scoreTableView.GamesPlayed, GamesWined = (long)_scoreTableView.GamesWon, Points = (long)_scoreTableView.ScoreFavor, ScoreFavor = (long)_scoreTableView.ScoreFavor, ScoreDifference = (long)_scoreTableView.ScoreDifference, ScoreAgainst = (long)_scoreTableView.ScoreAgainst, Team = teamDTO }; return(Ok(scoreTableResultDTO)); }
public IHttpActionResult GetScoreTableResult(int teamId) { scoretableview _scoreTableView = null; LeaguesApiController leagueApi = new LeaguesApiController(); int position = 0; team _team = null; scoretableview[] _scoreTable = null; using (var context = new escorcenterdbEntities()) { _scoreTableView = (from s in context.scoretableviews where s.team == teamId select s).FirstOrDefault<scoretableview>(); _team = (from t in context.teams where t.Id == teamId && t.Enabled == true select t).FirstOrDefault<team>(); long seasonId = leagueApi.GetCurrentSeasonId(_team.League, DateTime.Now); _scoreTable = (from st in context.scoretableviews where st.season == seasonId select st).OrderBy(st => st.GamesWon.Value * 3 + st.GamesDrawn.Value * 1).ToArray<scoretableview>(); } if (_scoreTableView == null) return Ok(); foreach (scoretableview st in _scoreTable) { if (st.team == teamId) break; position++; } // scoretableview y ScoreTableResultDTO son incompatibles team del primero es Int32, team del segundo es TeamDTO TeamDTO teamDTO = AutoMapper.Mapper.Map<team, TeamDTO>(_team); ScoreTableResultDTO scoreTableResultDTO = new ScoreTableResultDTO() { League = leagueApi.getLeagueNameById(_team.League), Position = (long)position, GamesDrawn = (long)_scoreTableView.GamesDrawn, GamesLost = (long)_scoreTableView.GamesLost, GamesPlayed = (long)_scoreTableView.GamesPlayed, GamesWined = (long)_scoreTableView.GamesWon, Points = (long)_scoreTableView.ScoreFavor, ScoreFavor = (long)_scoreTableView.ScoreFavor, ScoreDifference = (long)_scoreTableView.ScoreDifference, ScoreAgainst = (long)_scoreTableView.ScoreAgainst, Team = teamDTO }; return Ok(scoreTableResultDTO); }