public Team Save(Team entity) { _context.Teams.Add(entity); _context.SaveChanges(); return(entity); }
public IActionResult EnrollPlayer(int IdTeam, PlayerDTO playerDTO) { Team team = leagueContext.Teams.Find(IdTeam); if (team == null) { return(BadRequest("No team found!")); } Player player = leagueContext.Players .Where(p => p.FirstName.Equals(playerDTO.FirstName)) .Where(p => p.LastName.Equals(playerDTO.LastName)) .Where(p => p.DateOfBirth.Equals(playerDTO.DateOfBirth)).First(); if (player == null) { return(BadRequest("No player found!")); } var _link = leagueContext.PlayerTeams.Where(pt => pt.Player.Equals(player)).First(); if (_link != null) { return(BadRequest("Player unavailable!")); } PlayerTeam PlayerTeam = new PlayerTeam(); PlayerTeam.Player = player; PlayerTeam.Team = team; leagueContext.PlayerTeams.Add(PlayerTeam); leagueContext.SaveChanges(); return(Ok(playerDTO)); }
private static async Task Tick(string leagueDbName) { // Load statistic sets and check for recalculation interval using (var dbContext = new LeagueDbContext(leagueDbName)) { var statisticSets = dbContext.Set <StatisticSetEntity>().ToList(); var checkStatisticSets = statisticSets.Where(x => IsDueTick(x.UpdateTime, TimeSpanConverter.Convert(x.UpdateInterval))).OrderBy(x => GetTypePriority(x)); dbContext.Configuration.LazyLoadingEnabled = false; foreach (var statisticSet in checkStatisticSets) { await statisticSet.CheckRequireRecalculationAsync(dbContext); if (statisticSet.RequiresRecalculation) { await statisticSet.LoadRequiredDataAsync(dbContext); statisticSet.Calculate(dbContext); } } dbContext.Configuration.LazyLoadingEnabled = true; dbContext.SaveChanges(); } GC.Collect(); }
static void Main(string[] args) { // Create season statistic set //using (var dbContext = new LeagueDbContext("SkippyCup_leagueDb")) //{ // var season = dbContext.Seasons.Find(1); // var seasonStatistics = new SeasonStatisticSetEntity(); // season.SeasonStatistics.Add(seasonStatistics); // var sprintScoring = dbContext.Set<ScoringEntity>().Find(7); // var enduranceScoring = dbContext.Set<ScoringEntity>().Find(8); // seasonStatistics.Scorings.Add(sprintScoring); // seasonStatistics.Scorings.Add(enduranceScoring); // dbContext.SaveChanges(); //} // Calculate season statistics using (var dbContext = new LeagueDbContext("SkippyCup_leagueDb")) { var seasonStatistics = dbContext.Set <SeasonStatisticSetEntity>().ToList(); dbContext.Configuration.LazyLoadingEnabled = false; seasonStatistics.ForEach(x => x.LoadRequiredDataAsync(dbContext).Wait()); seasonStatistics.ForEach(x => x.Calculate(dbContext)); dbContext.SaveChanges(); } // Create league statistic set //using (var dbContext = new LeagueDbContext("SkippyCup_leagueDb")) //{ // var leagueStatistic = new LeagueStatisticSetEntity(); // dbContext.LeagueStatistics.Add(leagueStatistic); // leagueStatistic.StatisticSets.Add(dbContext.Seasons.First().SeasonStatistics.First()); // leagueStatistic.StatisticSets.Add(dbContext.Seasons.First().SeasonStatistics.Last()); // dbContext.SaveChanges(); //} // Calculate league statistics using (var dbContext = new LeagueDbContext("SkippyCup_leagueDb")) { var leagueStatistic = dbContext.Set <LeagueStatisticSetEntity>().First(); dbContext.Configuration.LazyLoadingEnabled = false; leagueStatistic.LoadRequiredDataAsync(dbContext).Wait(); leagueStatistic.Calculate(dbContext); dbContext.SaveChanges(); } //Console.Read(); }
public IHttpActionResult PostLeague([FromUri] string leagueName, [FromUri] string fullName = "") { // check for empty body and invalid data if (string.IsNullOrEmpty(leagueName)) { return(BadRequestEmptyParameter(nameof(leagueName))); } if (string.IsNullOrEmpty(fullName)) { fullName = leagueName; } base.CheckLeagueRole(User, leagueName); var dbName = GetDatabaseNameFromLeagueName(leagueName); var register = LeagueRegister.Get(); var league = register.GetLeague(leagueName); if (league == null) { // check current number of leagues for that user string userId = User.Identity.GetUserId(); var leagueCount = register.Leagues.Count(x => x.CreatorId.ToString() == userId); var maxLeagues = 3; if (leagueCount >= maxLeagues) { return(BadRequest($"Create league failed. Maximum numbers of {maxLeagues} leagues per user reached.")); } using (var dbContext = new LeagueDbContext(dbName, createDb: true)) { var seasons = dbContext.Seasons; if (seasons == null || seasons.Count() == 0) { seasons.Add(new iRLeagueDatabase.Entities.SeasonEntity() { SeasonName = "First Season", CreatedByUserName = User.Identity.Name, CreatedByUserId = User.Identity.GetUserId(), LastModifiedByUserName = User.Identity.Name, LastModifiedByUserId = User.Identity.GetUserId() }); dbContext.SaveChanges(); // Create new entry in league register return(Ok($"New League {leagueName} with database {dbName} created!")); } UpdateLeague(leagueName, User); return(BadRequest($"League {leagueName} already exists!")); } } // if league exists just update fullname league.PrettyName = fullName; register.Save(); return(Ok("League information updated")); }
public Player Save(Player entity) { _context.Players.Add(entity); _context.SaveChanges(); return(entity); }
public int Commit() { return(db.SaveChanges()); }
public void Update() { _dal.SaveChanges(); }