public Player GetPlayerByClubAndFirstOrLastName(ClubTeam club, string firstName, string lastName)
{
if (firstName != null || lastName != null)
{
if (lastName == null)
{
return context.Players
.Where(p => p.ClubTeam == club && p.FirstName == firstName)
.FirstOrDefault();
}
else if (firstName == null)
{
return context.Players
.Where(p => p.ClubTeam == club && p.LastName == lastName)
.FirstOrDefault();
}
else
{
return context.Players
.Where(p => p.ClubTeam == club && 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 ActionResult CreateClubTeam(ClubTeamsForm model)
{
var team = new Team();
if (model.IsNew)
{
team.Title = model.TeamName.Trim();
teamRepo.Create(team);
}
else if (model.TeamId != 0 && !model.IsNew)
{
team = teamRepo.GetById(model.TeamId, model.SeasonId);
}
else
{
TempData["ErrExist"] = Messages.TeamNotFound;
return(RedirectToAction(nameof(ClubTeams), new { clubId = model.ClubId, seasonId = model.CurrentSeasonId, sectionId = model.SectionId }));
}
var clubTeam = new ClubTeam
{
ClubId = model.ClubId,
TeamId = team.TeamId,
SeasonId = model.CurrentSeasonId
};
var isExistClubTeam = clubsRepo.IsExistClubTeamForCurrentSeason(clubTeam.ClubId, clubTeam.TeamId, clubTeam.SeasonId);
if (isExistClubTeam)
{
TempData["ErrExist"] = Messages.TeamExists;
return(RedirectToAction(nameof(ClubTeams), new { clubId = clubTeam.ClubId, seasonId = model.CurrentSeasonId, sectionId = model.SectionId }));
}
clubsRepo.CreateTeamClub(clubTeam);
clubsRepo.Save();
return(RedirectToAction(nameof(ClubTeams), new { clubId = clubTeam.ClubId, seasonId = model.CurrentSeasonId, sectionId = model.SectionId }));
}
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> GetPlayersByClub(ClubTeam club)
{
return context.Players
.Where(p => p.ClubTeam == club)
.ToList();
}
public void RemoveTemClub(ClubTeam item)
{
db.ClubTeams.Remove(item);
}
public void CreateTeamClub(ClubTeam clubTeam)
{
db.ClubTeams.Add(clubTeam);
}
