public DbError AddMatch(MatchModel match) { try { MatchModel _match = new MatchModel(); _match = match; _match.Challenger = context.TournamentUserModels.Find(match.ChallengerID); _match.Defender = context.TournamentUserModels.Find(match.DefenderID); //context.Challengers.Add(new Challenger() { TournamentUserID = _match.ChallengerID, MatchID = _match.MatchID }); //context.Defenders.Add(new Defender() { TournamentUserID = _match.DefenderID, MatchID = _match.MatchID }); //context.Matches.Load(); //context.Users.Load(); context.MatchModels.Add(_match); context.Entry(_match).CurrentValues.SetValues(match); context.SaveChanges(); //bracket.Matches.Add(_match); //context.SaveChanges(); //context.Tournaments.Include(x => x.Brackets).Load(); //context.Users.Include(x => x.UserID).Load(); //context.SaveChanges(); } catch (Exception ex) { interfaceException = ex; WriteException(ex); return(DbError.ERROR); } return(DbError.SUCCESS); }
/// <summary> /// Updates an item in the database. /// </summary> /// <param name="entity"> The entity to be updated. </param> public void Update(TEntity entity) { if (context.Entry(entity).State == EntityState.Detached) { dbSet.Attach(entity); } //context.Entry(entity).CurrentValues.SetValues(entity); context.Entry(entity).State = EntityState.Modified; }
public DbError UpdateTournament(TournamentModel tournament) { using (var db = new VictoriousEntities()) { try { TournamentModel _tournament = db.TournamentModels.Find(tournament.TournamentID); db.Entry(_tournament).CurrentValues.SetValues(tournament); //foreach (var bracket in _tournament.Brackets) //{ // foreach (var match in bracket.Matches) // { // match.Challenger = db.TournamentUserModels.Find(match.ChallengerID); // match.Defender = db.TournamentUserModels.Find(match.DefenderID); // } //} } catch (Exception ex) { exception = ex; WriteException(ex); return(DbError.FAILED_TO_UPDATE); } return(DbError.SUCCESS); } }
public DbError UpdateGame(GameModel game) { try { GameModel _game = context.GameModels.Find(game.GameID); context.Entry(_game).CurrentValues.SetValues(game); if (_game.ChallengerID != game.ChallengerID || _game.DefenderID != game.DefenderID) { _game.ChallengerID = game.ChallengerID; _game.DefenderID = game.DefenderID; } if (_game.ChallengerID != _game.Match.ChallengerID || _game.DefenderID != _game.Match.DefenderID) { _game.ChallengerID = game.Match.ChallengerID; _game.DefenderID = game.Match.DefenderID; } context.SaveChanges(); } catch (Exception ex) { interfaceException = ex; WriteException(ex); return(DbError.FAILED_TO_UPDATE); } return(DbError.SUCCESS); }
public DbError UpdateBracketType(BracketTypeModel bracketType) { try { BracketTypeModel _bracketType = context.BracketTypeModels.Find(bracketType.BracketTypeID); context.Entry(_bracketType).CurrentValues.SetValues(bracketType); context.SaveChanges(); } catch (Exception ex) { interfaceException = ex; WriteException(ex); return(DbError.FAILED_TO_UPDATE); } return(DbError.SUCCESS); }
public DbError UpdatePlatform(PlatformModel platform) { try { PlatformModel _platform = context.PlatformModels.Find(platform.PlatformID); context.Entry(_platform).CurrentValues.SetValues(platform); context.SaveChanges(); } catch (Exception ex) { interfaceException = ex; WriteException(ex); return(DbError.FAILED_TO_UPDATE); } return(DbError.SUCCESS); }
public DbError UpdateAccount(AccountModel account) { try { AccountModel _account = context.AccountModels.Find(account.AccountID); context.Entry(_account).CurrentValues.SetValues(account); context.SaveChanges(); } catch (Exception ex) { exception = ex; WriteException(ex); return(DbError.FAILED_TO_UPDATE); } return(DbError.SUCCESS); }
public DbError UpdateGameType(GameTypeModel gameType) { try { GameTypeModel _gameType = context.GameTypeModels.Find(gameType.GameTypeID); context.Entry(_gameType).CurrentValues.SetValues(gameType); context.SaveChanges(); } catch (Exception ex) { interfaceException = ex; WriteException(ex); return(DbError.FAILED_TO_UPDATE); } return(DbError.SUCCESS); }
public DbError UpdateBracket(BracketModel bracket) { try { BracketModel _bracket = context.BracketModels.Find(bracket.BracketID); context.Entry(_bracket).CurrentValues.SetValues(bracket); foreach (var match in _bracket.Matches) { match.Challenger = context.TournamentUserModels.Find(match.ChallengerID); match.Defender = context.TournamentUserModels.Find(match.DefenderID); } context.SaveChanges(); } catch (Exception ex) { interfaceException = ex; WriteException(ex); return(DbError.FAILED_TO_UPDATE); } return(DbError.SUCCESS); }