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