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