public IList<Position> GetPositions(List<string> positionNames)
{
using (var context = new BaseballContext())
{
var positions = context.Positions.Where(p => positionNames.Contains(p.Alias)).ToList();
return positions;
}
}
public IEnumerable<Player> GetPlayers()
{
using (var context = new BaseballContext())
{
var players = context.Players.Include(player => player.Person.PersonType).Include(p => p.Positions).ToList();
return players;
}
}
public Player GetPlayer(string firstName, string lastName)
{
using (var context = new BaseballContext())
{
var player = context.Players
.Include(p => p.Person.PersonType)
.FirstOrDefault(p => p.Person.FirstName.ToLower() == firstName.ToLower() && p.Person.LastName.ToLower() == lastName.ToLower());
return player;
}
}
public void AddPlayer(Player player)
{
using (var context = new BaseballContext())
{
foreach (var position in player.Positions)
{
context.Positions.Attach(position);
}
context.Players.Add(player);
context.SaveChanges();
}
}
