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();
}
