public DbError AddBracket(BracketModel bracket)
{
try
{
context.BracketModels.Add(bracket);
context.SaveChanges();
}
catch (Exception ex)
{
interfaceException = ex;
WriteException(ex);
return(DbError.FAILED_TO_ADD);
}
return(DbError.SUCCESS);
}
public BracketModel GetBracket(int id)
{
BracketModel bracket = new BracketModel();
try
{
bracket = context.BracketModels.Single(b => b.BracketID == id);
foreach (var match in bracket.Matches)
{
match.Challenger = context.TournamentUserModels.Find(match.ChallengerID);
match.Defender = context.TournamentUserModels.Find(match.DefenderID);
}
}
catch (Exception ex)
{
interfaceException = ex;
WriteException(ex);
bracket = null;
}
return(bracket);
}
public DbError DeleteBracket(int id)
{
try
{
BracketModel _bracket = context.BracketModels.Find(id);
// TODO: implement delete for matches
//foreach (var match in _bracket.Matches.ToList())
//{
// DeleteMatch(match.MatchID);
//}
context.BracketModels.Remove(_bracket);
context.SaveChanges();
}
catch (Exception ex)
{
interfaceException = ex;
WriteException(ex);
return(DbError.FAILED_TO_DELETE);
}
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);
}