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