public UpdateTeamRating(int teamId, decimal newTeamRating) { using (var context = new SportsSimulatorDBEntities()) { context.spTeams_UpdateRating(teamId, newTeamRating); } }
public UpdateAwayTeamScore(int matchupId, int teamId, double score) { using (var context = new SportsSimulatorDBEntities()) { context.spMatchupEntries_UpdateAwayScore(matchupId, teamId, score); } }
public UpdateMatchupWinnerID(int matchupId, int winnerId) { using (var context = new SportsSimulatorDBEntities()) { context.spMatchup_UpdateWinnerId(matchupId, winnerId); } }
public WriteTeamRatingsToDB(Team team) { using (var context = new SportsSimulatorDBEntities()) { context.spTeams_UpdateAllRatings(team.id, team.AttackRating, team.DefenseRating); } }
public BiddingController() { _db = new SportsSimulatorDBEntities(); _playerRepository = new PlayerRepository(); _teamRepository = new TeamRepository(); _biddingRespoitory = new BiddingRepository(); }
public UpdateTeamPoints(int teamId, double pointsToAdd) { using (var context = new SportsSimulatorDBEntities()) { context.spTeams_UpdatePoints(teamId, pointsToAdd); } }
public UpdateTeamWins(int teamId) { using (var context = new SportsSimulatorDBEntities()) { context.spTeams_UpdateWins(teamId); } }
public UpdateTeamPointsForAgainst(int teamId, double pointsFor, double pointsAgainst) { using (var context = new SportsSimulatorDBEntities()) { context.spTeams_UpdatePointsForAgainst(teamId, pointsFor, pointsAgainst); } }
private List <Event> GetAllEvents() { using (var context = new SportsSimulatorDBEntities()) { List <Event> events = (from e in context.Events select e).ToList(); return(events); } }
//TODO - Call when hitting 'Add teams' on LeagueEntries controller private void PopulateLeagueEntries(League league) { foreach (LeagueEntry entry in league.LeagueEntries) { using (var context = new SportsSimulatorDBEntities()) { System.Data.Entity.Core.Objects.ObjectParameter id = new System.Data.Entity.Core.Objects.ObjectParameter("id", typeof(Int32)); entry.id = context.spLeagueEntries_Insert(league.id, entry.TeamId, id); } } }
private Event GetEventFromDB(string eventType) { using (var context = new SportsSimulatorDBEntities()) { var eventName = context.Events .Where(e => e.EventName == eventType) .Select(e => e).First(); return(eventName); } }
public SaveMatchupEventsToDB(OrderedDictionary combinedEventTimings, int matchupId) { using (var context = new SportsSimulatorDBEntities()) { for (int i = 0; i < combinedEventTimings.Count; i++) { var _eventTiming = (TimeSpan)combinedEventTimings.Cast <DictionaryEntry>().ElementAt(i).Key; var _events = (List <Event>)combinedEventTimings.Cast <DictionaryEntry>().ElementAt(i).Value; for (int j = 0; j < _events.Count; j++) { context.spEventTimings_Insert(matchupId, _eventTiming, _events[j].id); } } } }
public ActionResult SimulateRound(int?id) { League league = _db.Leagues.Find(id); int currentRound = league.CurrentRound; Round round = (from r in league.Rounds.OfType <Round>() where r.RoundNumber == currentRound select r).FirstOrDefault(); SimulationLogic sim = new SimulationLogic(); sim.SimulateRound(round); foreach (Matchup matchup in round.Matchups) { RatingSystemLogic rating = new RatingSystemLogic(matchup); } using (var context = new SportsSimulatorDBEntities()) { currentRound = context.spLeagues_UpdateCurrentRound(league.id); } return(RedirectToAction("Index")); }
private void SaveLeagueRounds(League league) { foreach (Round round in league.Rounds) { using (var context = new SportsSimulatorDBEntities()) { System.Data.Entity.Core.Objects.ObjectParameter id = new System.Data.Entity.Core.Objects.ObjectParameter("id", typeof(Int32)); context.spRounds_Insert(league.id, round.RoundNumber, id); round.id = Convert.ToInt32(id.Value); } foreach (Matchup matchup in round.Matchups) { using (var context = new SportsSimulatorDBEntities()) { System.Data.Entity.Core.Objects.ObjectParameter id = new System.Data.Entity.Core.Objects.ObjectParameter("id", typeof(Int32)); context.spMatchups_Insert(round.id, id); matchup.id = Convert.ToInt32(id.Value); } foreach (MatchupEntry entry in matchup.MatchupEntries) { using (var context = new SportsSimulatorDBEntities()) { System.Data.Entity.Core.Objects.ObjectParameter id = new System.Data.Entity.Core.Objects.ObjectParameter("id", typeof(Int32)); context.spMatchupEntries_Insert(matchup.id, entry.TeamCompetingId, id); entry.id = Convert.ToInt32(id.Value); } } } } }
public BiddingRepository() { _context = new SportsSimulatorDBEntities(); }
public PlayersController() { _context = new SportsSimulatorDBEntities(); }
public TeamRepository() { _context = new SportsSimulatorDBEntities(); }
public LeaguesController() { _context = new SportsSimulatorDBEntities(); }
public PlayerRepository() { _context = new SportsSimulatorDBEntities(); }