public static int Update(Bracket bracket) { using (BoBEntities bob = new BoBEntities()) { tblBracket row = bob.tblBrackets.FirstOrDefault(c => c.Id == bracket.Id); int results = 0; if (row != null) { row.Name = bracket.Name; row.ModeratorId = bracket.Moderator.Id; row.ImageSource = bracket.ImageSource; row.OriginalRoundCount = bracket.OriginalRoundCount; row.Game = bracket.Game; row.CurrentDivision = bracket.CurrentDivision; results = bob.SaveChanges(); } else { throw new Exception("Row was not found"); } return(results); } }
public static int Insert(Bracket bracket) { using (BoBEntities bob = new BoBEntities()) { tblBracket row = new tblBracket { Id = Guid.NewGuid(), Name = bracket.Name, ImageSource = bracket.ImageSource, ModeratorId = bracket.Moderator.Id, Game = bracket.Game, OriginalRoundCount = bracket.OriginalRoundCount, CurrentDivision = bracket.CurrentDivision }; bracket.Id = row.Id; if (bracket.Matches.Count > 0) { bracket.Matches.ForEach(m => MatchManager.Insert(m, bracket.Id)); } bob.tblBrackets.Add(row); return(bob.SaveChanges()); } }