public static Sport GetOrCreate(string name) { try { validateName(name); Sport sport; using (var db = new MyDbContext()) { sport = db.Sport.Where(p => p.Name == name).FirstOrDefault(); if (sport == null) { sport = new Sport(); sport.Name = name; db.Sport.Add(sport); db.SaveChanges(); } return sport; } } catch (Exception e) { throw new DomainException("Could not find or create sport", e); } }
public static void Add(JoinedUser joinedUser) { try { using (var db = new MyDbContext()) { db.JoinedUser.Add(joinedUser); db.SaveChanges(); } } catch (Exception e) { throw new DomainException("Could not add joined user", e); } }
public static void Register(User user) { try { using (var db = new MyDbContext()) { db.User.Add(user); db.SaveChanges(); } } catch (Exception e) { throw new DomainException("Could not create user", e); } }
public static void Create(Suggestion suggestion) { try { using (var db = new MyDbContext()) { db.JoinedUser.Add(suggestion.JoinedUsers[0]); db.Suggestion.Add(suggestion); db.SaveChanges(); } } catch (Exception e) { throw new DomainException("Could not create suggestion", e); } }
public static void Update(Suggestion updatedSuggestion) { try { using (var db = new MyDbContext()) { var suggestion = db.Suggestion.Single((i => i.Id == updatedSuggestion.Id)); updatedSuggestion.CreatorId = suggestion.CreatorId; db.Entry(suggestion).CurrentValues.SetValues(updatedSuggestion); db.SaveChanges(); } } catch (Exception e) { throw new DomainException("Could not update suggestion", e); } }
public static void Update(User newUser) { try { using (var db = new MyDbContext()) { User dbUser = db.User.Single(i => i.Id == newUser.Id); dbUser.Area = newUser.Area; dbUser.BirthDate = newUser.BirthDate; dbUser.FirstName = newUser.FirstName; dbUser.Gender = newUser.Gender; dbUser.LastName = newUser.LastName; dbUser.PhoneNumber = newUser.PhoneNumber; dbUser.State = newUser.State; dbUser.StreetAddress = newUser.StreetAddress; dbUser.Password = newUser.Password; db.SaveChanges(); } } catch (Exception e) { throw new DomainException("Could not update user", e); } }