public Model.Event GetEvent(Guid globalId) { using (DataContext context = new DataContext()) { return context.Events.FirstOrDefault(e => e.GlobalId == globalId); } }
public Model.Player GetPlayer(Guid globalId) { using (DataContext context = new DataContext()) { return context.Players.FirstOrDefault(p => p.GlobalId == globalId); } }
public Model.Events GetAllEvents() { using (DataContext context = new DataContext()) { var query = context.Events.OrderBy(e => e.Date); if (query.Count() > 0) return new Model.Events(query); } return new Model.Events(); }
public Model.Players GetAllPlayers() { using (DataContext context = new DataContext()) { var query = context.Players.OrderBy(p => p.Name); if (query.Count() > 0) return new Model.Players(query); } return new Model.Players(); }
public void Save(Model.Event _event) { using (DataContext context = new DataContext()) { if (_event.Id == 0) { context.Events.Add(_event); } else { context.Entry(_event).State = EntityState.Modified; } context.SaveChanges(); } }
public void Save(Model.Player player) { using (DataContext context = new DataContext()) { if (player.Id == 0) { context.Players.Add(player); } else { context.Entry(player).State = EntityState.Modified; } context.SaveChanges(); } }