public Player GetPlayerByCOuntyAndFirstOrLastName(CountyTeam county, string firstName, string lastName)
{
if (firstName != null || lastName != null)
{
if (lastName == null)
{
return context.Players
.Where(p => p.CountyTeam == county && p.FirstName == firstName)
.FirstOrDefault();
}
else if (firstName == null)
{
return context.Players
.Where(p => p.CountyTeam == county && p.LastName == lastName)
.FirstOrDefault();
}
else
{
return context.Players
.Where(p => p.CountyTeam == county && p.FirstName == firstName && p.LastName == lastName)
.FirstOrDefault();
}
}
else
{
return null;
}
}
public Player CreatePlayer(string firstName, string lastName, bool isObsolete, CountyTeam countyTeam, ClubTeam clubTeam)
{
Player p = new Player();
p.FirstName = firstName;
p.LastName = lastName;
p.IsObsolete = isObsolete;
p.CountyTeam = countyTeam;
p.ClubTeam = clubTeam;
context.Players.Add(p);
context.SaveChanges();
return p;
}
public County CreateCounty(string name, Enums.Provinces province)
{
CountyTeam ct = new CountyTeam();
ct.Name = name;
County c = new County();
c.Name = name;
c.Province = province.ToString();
c.CountyTeam = ct;
context.Counties.Add(c);
context.SaveChanges();
return c;
}
public Player UpdatePlayer(string firstName, string lastName, bool isObsolete, CountyTeam countyTeam, ClubTeam clubTeam)
{
Player pl = context.Players
.Include("Countyteam")
.Include("ClubTeam")
.Where(p => p.FirstName == firstName && p.LastName == lastName)
.FirstOrDefault();
if (pl != null)
{
pl.FirstName = firstName;
pl.LastName = lastName;
pl.IsObsolete = isObsolete;
pl.CountyTeam = countyTeam;
pl.ClubTeam = clubTeam;
context.SaveChanges();
return pl;
}
else
{
return null;
}
}
public List<Player> GetPlayersByCounty(CountyTeam county)
{
return context.Players
.Where(p => p.CountyTeam == county)
.ToList();
}