public CoachModel GetCoachModelSelectTeam(int teamID)
{
CoachModel coachModel = new CoachModel();
using (NetballEntities context = new NetballEntities())
{
coachModel = context.Coaches
.Include(c => c.Person)
.Include(c => c.Team)
.Where(c => c.TeamID == teamID)
.Select(c => new CoachModel
{
personID = c.CoachID,
teamID = c.TeamID,
firstName = c.Person.FirstName,
middleName = c.Person.MiddleName,
lastName = c.Person.LastName,
mobile = c.Person.Mobile,
email = c.Person.Email,
emergencyContact = c.Person.EmergencyContact,
emergencyContactNo = c.Person.EmergencyContactNo,
teamName = c.Team.TeamName,
coachName = c.Person.FirstName + " " + c.Person.LastName,
activeInd = c.ActiveInd
})
.FirstOrDefault();
}
return(coachModel);
}
public IList <CoachModel> GetCoachModelListByLastName(string lastName)
{
IList <CoachModel> coachModelList = new List <CoachModel>();
if (!string.IsNullOrEmpty(lastName))
{
using (NetballEntities context = new NetballEntities())
{
coachModelList = context.Teams
.Include(c => c.Person)
.Where(c => c.Person.LastName.ToLower().StartsWith(lastName.ToLower()))
.Select(c => new CoachModel
{
personID = c.Person.PersonID,
teamID = c.TeamID,
firstName = c.Person.FirstName,
middleName = c.Person.MiddleName,
lastName = c.Person.LastName,
email = c.Person.Email,
emergencyContact = c.Person.EmergencyContact,
emergencyContactNo = c.Person.EmergencyContactNo,
coachName = c.Person.FirstName + " " + c.Person.LastName,
teamName = c.TeamName,
captainID = c.CaptainID,
divisionID = c.DivisionID
})
.ToList();
}
}
return(coachModelList);
}
public IList <TeamModel> GetTeamModelList(string teamName)
{
IList <TeamModel> teamModelList = new List <TeamModel>();
using (NetballEntities context = new NetballEntities())
{
teamModelList = context.Teams
.AsNoTracking()
.Where(t => t.TeamName.ToLower().Contains(teamName.ToLower()))
.Select(t => new TeamModel
{
teamID = t.TeamID,
teamName = t.TeamName,
coachName = t.Person.FirstName + " " + t.Person.LastName,
coachPersonID = t.CoachID ?? 0,
divisionID = t.DivisionID ?? 0,
divisionName = t.Division.Division1,
captainID = t.CaptainID ?? 0,
captainName = t.Person1.FirstName + " " + t.Person1.LastName
})
.OrderBy(t => t.teamName)
.ToList();
}
return(teamModelList);
}
public IList <GameTeam> GetGameTeamList(int gameID,
int playerID)
{
IList <GameTeam> gameTeamList = new List <GameTeam>();
try
{
using (NetballEntities context = new NetballEntities())
{
context.Configuration.ProxyCreationEnabled = false;
gameTeamList = context.GamePlayers
.Include(g => g.GameTeam)
.Include(g => g.GameTeam.Team)
.Where(g => g.PlayerID == playerID)
.Where(g => g.GameTeam.GameID == gameID)
.Select(g => new GameTeam
{
GameTeamID = g.GameTeamID,
GameID = g.GameTeam.GameID,
TeamID = g.GameTeam.TeamID,
CaptainID = g.GameTeam.CaptainID,
CoachID = g.GameTeam.CoachID,
PrimaryCarerID = g.GameTeam.PrimaryCarerID,
FinalScore = g.GameTeam.FinalScore
})
.ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(gameTeamList);
}
public IList <CoachModel> GetCoachModelListByMobile(string mobile)
{
IList <CoachModel> coachModelList = new List <CoachModel>();
using (NetballEntities context = new NetballEntities())
{
coachModelList = context.Teams
.Include(c => c.Person)
.Where(c => c.Person.Mobile.Contains(mobile))
.Select(c => new CoachModel
{
captainID = c.CaptainID,
coachName = c.Person.FirstName + " " + c.Person.LastName,
divisionID = c.DivisionID,
email = c.Person.Email,
emergencyContact = c.Person.EmergencyContact,
emergencyContactNo = c.Person.EmergencyContactNo,
firstName = c.Person.FirstName,
lastName = c.Person.LastName,
middleName = c.Person.MiddleName,
mobile = c.Person.Mobile,
personID = c.Person.PersonID,
teamID = c.TeamID,
teamName = c.TeamName
})
.ToList();
}
return(coachModelList);
}
public CoachModel GetCoach(int coachID)
{
CoachModel coachModel = new CoachModel();
using (NetballEntities context = new NetballEntities())
{
coachModel = context.Coaches
.Include(c => c.Person)
.Include(c => c.Team.Division)
.Include(c => c.Team)
.Select(c => new CoachModel
{
coachName = c.Person.FirstName + " " + c.Person.LastName,
divisionID = c.Team.DivisionID,
division = c.Team.Division.Division1,
email = c.Person.Email,
//emergencyContact = c.
firstName = c.Person.FirstName,
lastName = c.Person.LastName,
middleName = c.Person.MiddleName,
mobile = c.Person.Mobile,
personID = c.CoachPersonID,
teamID = c.TeamID,
teamName = c.Team.TeamName
})
.FirstOrDefault();
}
return(coachModel);
}
public IList <CoachModel> GetCoachModelListByEmail(string email)
{
IList <CoachModel> coachModelList = new List <CoachModel>();
using (NetballEntities context = new NetballEntities())
{
coachModelList = context.Teams
.Include(t => t.Person)
.Where(t => t.Person.Email.ToLower().Contains(email.ToLower()))
.Select(t => new CoachModel
{
captainID = t.CaptainID,
coachName = t.Person.FirstName + " " + t.Person.LastName,
divisionID = t.DivisionID,
email = t.Person.Email,
emergencyContact = t.Person.EmergencyContact,
emergencyContactNo = t.Person.EmergencyContactNo,
firstName = t.Person.FirstName,
lastName = t.Person.LastName,
middleName = t.Person.MiddleName,
mobile = t.Person.Mobile,
personID = t.Person.PersonID,
teamID = t.TeamID,
teamName = t.TeamName
})
.ToList();
}
return(coachModelList);
}
public void PersonRemove(int personID)
{
Person person = new Person();
try
{
using (NetballEntities context = new NetballEntities())
{
person = context.People
.Where(p => p.PersonID == personID)
.FirstOrDefault();
if (person != null)
{
context.Entry(person).State = EntityState.Deleted;
context.SaveChanges();
}
else
{
throw new Exception("Person could not be found for personID " + personID.ToString());
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public IList <GameMatchModel> GetGameMatchModelList(int playerID)
{
IList <GameMatchModel> gameMatchModelList = new List <GameMatchModel>();
using (NetballEntities context = new NetballEntities())
{
gameMatchModelList = context.GamePlayers
.Include(g => g.GameTeam)
.Include(g => g.GameTeam.Game)
.Where(g => g.PlayerID == playerID)
.Select(g => new GameMatchModel
{
gameID = g.GameTeam.GameID,
courtID = g.GameTeam.Game.CourtID,
courtName = "",
tournamentID = g.GameTeam.Game.TournamentID,
tournamentName = "",
matchNo = g.GameTeam.Game.MatchNo,
venue = g.GameTeam.Game.Venue,
datePlayed = g.GameTeam.Game.DatePlayed,
primaryUmpireID = g.GameTeam.Game.PrimaryUmpireID,
secondaryUmpireID = g.GameTeam.Game.SecondaryUmpireID,
reserveUmpireID = g.GameTeam.Game.ReserveUmpireID
})
.ToList();
}
return(PopulateMatchDetails(gameMatchModelList, playerID));
}
public IList <TeamModel> GetTeamModeListBasicsByDivision(int divisionID)
{
IList <TeamModel> teamModelList = new List <TeamModel>();
try
{
using (NetballEntities context = new NetballEntities())
{
teamModelList = context.TeamPlayers
.AsNoTracking()
.Include(t => t.Team)
.Include(t => t.Person)
.Include(t => t.Team.Division)
.Where(t => t.Team.DivisionID == divisionID)
.Where(t => t.Team.CaptainID == t.Person.PersonID ||
t.Team.CoachID == t.Person.PersonID)
.Select(t => new TeamModel
{
teamID = t.TeamID,
playerID = t.PlayerID,
teamName = t.Team.TeamName,
coachPersonID = t.Team.CoachID ?? 0,
divisionID = t.Team.DivisionID ?? 0,
divisionName = t.Team.Division.Division1,
captainID = t.Team.CaptainID ?? 0,
playerName = t.Person.FirstName + " " + t.Person.LastName
})
.OrderBy(t => t.playerName)
.ToList();
}
foreach (TeamModel teamModel in teamModelList)
{
if (teamModel.coachPersonID != 0)
{
Person coach = new Person();
coach = _personSelect.GetPerson(teamModel.coachPersonID);
if (coach != null)
{
teamModel.coachName = coach.FirstName + " " + coach.LastName;
}
}
if (teamModel.captainID != 0)
{
Person captain = new Person();
captain = _personSelect.GetPerson(teamModel.captainID);
if (captain != null)
{
teamModel.captainName = captain.FirstName + " " + captain.LastName;
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(teamModelList);
}
public IList <GameModel> GetGameModelListByDivision(int divisionID)
{
IList <GameModel> gameModelList = new List <GameModel>();
using (NetballEntities context = new NetballEntities())
{
gameModelList = context.GameTeams
.AsNoTracking()
.Include(g => g.Team)
.Include(g => g.Game)
.Include(g => g.Game.Court)
.Include(g => g.Game.Division)
.Include(g => g.Game.Person)
.Include(g => g.Game.Person1)
.Include(g => g.Game.Person2)
.Include(g => g.Game.Person3)
.Include(g => g.Game.Person4)
.Include(g => g.Game.Person5)
.Include(g => g.Game.Person6)
.Include(g => g.Game.Division)
.Where(g => g.Game.DivisionID == divisionID)
.Select(g => new GameModel
{
gameID = g.GameID,
courtID = g.Game.CourtID,
courtName = g.Game.Court.Court1,
tournamentID = g.Game.TournamentID,
tournamentName = g.Game.Tournament.Tournament1,
matchNo = g.Game.MatchNo,
venue = g.Game.Venue,
datePlayed = g.Game.DatePlayed,
primaryUmpireID = g.Game.PrimaryUmpireID,
primaryUmpire = g.Game.Person.FirstName + " " + g.Game.Person.LastName,
secondaryUmpireID = g.Game.SecondaryUmpireID,
secondaryUmpire = g.Game.Person1.FirstName + " " + g.Game.Person1.LastName,
reserveUmpireID = g.Game.ReserveUmpireID,
reserveUmpire = g.Game.Person2.FirstName + " " + g.Game.Person2.LastName,
startTime = g.Game.StartTime,
fullTime = g.Game.FullTime,
extraTimeEnd = g.Game.ExtraTimeEnd,
scorer1ID = g.Game.Scorer1ID,
scorer1 = g.Game.Person3.FirstName + " " + g.Game.Person3.LastName,
scorer2ID = g.Game.Scorer2ID,
scorer2 = g.Game.Person4.FirstName + " " + g.Game.Person4.LastName,
timeKeeper1ID = g.Game.TimeKeeper1ID,
timeKeeper1 = g.Game.Person5.FirstName + " " + g.Game.Person5.LastName,
timeKeeper2ID = g.Game.TimeKeeper2ID,
timeKeeper2 = g.Game.Person6.FirstName + " " + g.Game.Person6.LastName,
divisionID = g.Game.DivisionID,
division = g.Game.Division.Division1
})
.ToList();
}
return(gameModelList);
}
internal async Task <IList <Award> > GetAwardList()
{
IList <Award> awardList = new List <Award>();
using (NetballEntities context = new NetballEntities())
{
awardList = await context.Awards
.ToListAsync();
}
return(awardList);
}
public GameModel GetGameModel(int courtID,
DateTime datePlayed,
TimeSpan startTime)
{
GameModel gameModel = new GameModel();
try
{
using (NetballEntities context = new NetballEntities())
{
gameModel = context.Games
.Include(g => g.Court)
.Include(g => g.Division)
.Include(g => g.Tournament)
.Where(g => g.CourtID == courtID &&
g.DatePlayed == datePlayed &&
g.StartTime == startTime)
.Select(g => new GameModel
{
gameID = g.GameID,
courtID = g.CourtID,
courtName = g.Court.Court1,
tournamentID = g.TournamentID,
tournamentName = g.Tournament.Tournament1,
matchNo = g.MatchNo,
venue = g.Venue,
datePlayed = g.DatePlayed,
primaryUmpireID = g.PrimaryUmpireID,
secondaryUmpireID = g.SecondaryUmpireID,
reserveUmpireID = g.ReserveUmpireID,
startTime = g.StartTime,
fullTime = g.FullTime,
extraTimeEnd = g.ExtraTimeEnd,
scorer1ID = g.Scorer1ID,
scorer2ID = g.Scorer2ID,
timeKeeper1ID = g.TimeKeeper1ID,
timeKeeper2ID = g.TimeKeeper2ID,
divisionID = g.DivisionID,
division = g.Division.Division1,
})
.FirstOrDefault();
}
if (gameModel != null)
{
gameModel = _gameModelDetailLogic.GetGameModelDetail(gameModel);
}
}
catch (Exception ex)
{
throw ex;
}
return(gameModel);
}
internal async Task <Award> GetAwardByAwardName(string awardName)
{
Award award = new Award();
using (NetballEntities context = new NetballEntities())
{
award = await context.Awards
.Where(a => a.AwardName.ToLower() == awardName.ToLower())
.FirstOrDefaultAsync();
}
return(award);
}
/// <summary>
/// Get game team player data for a game team ID.
/// </summary>
/// <param name="gameTeamID"></param>
/// <param name="playerID"></param>
/// <returns></returns>
public IList <GameTeamPlayerModel> GetGameTeamPlayerModelList(int gameTeamID)
{
IList <GameTeamPlayerModel> gameTeamPlayerList = new List <GameTeamPlayerModel>();
using (NetballEntities context = new NetballEntities())
{
gameTeamPlayerList = context.GamePlayers
.Include(g => g.GameTeam)
.Include(g => g.GameTeam.Game)
.Include(g => g.GameTeam.Game.Person)
.Include(g => g.GameTeam.Game.Person1)
.Include(g => g.GameTeam.Game.Person2)
.Include(g => g.GameTeam.Game.Person3)
//.Include(g => g.GameTeam.Game.Person4)
//.Include(g => g.GameTeam.Game.Person5)
//.Include(g => g.GameTeam.Game.Person6)
.Include(g => g.GameTeam.Team)
.Include(g => g.GameTeam.Game.Court)
.Include(g => g.GameTeam.Game.Tournament)
.Include(g => g.Person)
.Where(g => g.GameTeamID == gameTeamID)
.Select(g => new GameTeamPlayerModel
{
gamePlayerID = g.GamePlayerID,
teamID = g.GameTeam.TeamID,
gameTeamID = g.GameTeamID,
teamName = g.GameTeam.Team.TeamName,
gameID = g.GameTeam.GameID,
courtID = g.GameTeam.Game.CourtID,
courtName = g.GameTeam.Game.Court.Court1,
tournamentID = g.GameTeam.Game.TournamentID,
tournamentName = g.GameTeam.Game.Tournament.Tournament1,
matchNo = g.GameTeam.Game.MatchNo,
venue = g.GameTeam.Game.Venue,
datePlayed = g.GameTeam.Game.DatePlayed,
primaryUmpireID = g.GameTeam.Game.PrimaryUmpireID,
primaryUmpire = g.GameTeam.Game.Person1 != null ? g.GameTeam.Game.Person1.FirstName + " " + g.GameTeam.Game.Person1.LastName : string.Empty,
secondaryUmpireID = g.GameTeam.Game.SecondaryUmpireID,
secondaryUmpire = g.GameTeam.Game.Person2 != null ? g.GameTeam.Game.Person2.FirstName + " " + g.GameTeam.Game.Person2.LastName : string.Empty,
reserveUmpireID = g.GameTeam.Game.ReserveUmpireID,
reserveUmpire = g.GameTeam.Game.Person3 != null ? g.GameTeam.Game.Person3.FirstName + " " + g.GameTeam.Game.Person3.LastName : string.Empty,
playerID = g.PlayerID,
playerName = g.Person.FirstName + " " + g.Person.LastName,
firstQuarterInd = g.FirstQuarterInd,
secondQuarterInd = g.SecondQuarterInd,
thirdQuarterInd = g.ThirdQuarterInd,
fourthQuarterInd = g.FourthQuarterInd
})
.OrderBy(g => g.playerName)
.ToList();
}
return(gameTeamPlayerList);
}
internal async Task <IList <Award> > GetAwardList(bool?activeInd)
{
IList <Award> awardList = new List <Award>();
using (NetballEntities context = new NetballEntities())
{
awardList = await context.Awards
.Where(a => a.ActiveInd == activeInd)
.ToListAsync();
}
return(awardList);
}
internal IList <AwardPerson> GetAwardPersonList()
{
IList <AwardPerson> awardPersonList = new List <AwardPerson>();
using (NetballEntities context = new NetballEntities())
{
awardPersonList = context.AwardPersons
.Include(a => a.Person)
.Include(a => a.Award)
.ToList();
}
return(awardPersonList);
}
internal async Task <Award> GetAward(int awardID)
{
Award award = new Award();
using (NetballEntities context = new NetballEntities())
{
award = await context.Awards
.Where(a => a.AwardID == awardID)
.FirstOrDefaultAsync();
}
return(award);
}
/// <summary>
/// Deletes a given Division object.
/// </summary>
/// <param name="Division"></param>
public void DivisionRemove(Division division)
{
try
{
using (NetballEntities context = new NetballEntities())
{
context.Entry(division).State = EntityState.Deleted; context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Deletes a given Court object.
/// </summary>
/// <param name="Court"></param>
public void CourtRemove(Court court)
{
try
{
using (NetballEntities context = new NetballEntities())
{
context.Entry(court).State = EntityState.Deleted; context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary> /// Deletes a given Game object.
/// </summary>
/// <param name="Game"></param>
public void GameRemove(Game game)
{
try
{
using (NetballEntities context = new NetballEntities())
{
context.Entry(game).State = EntityState.Deleted; context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Deletes a given Team object.
/// </summary>
/// <param name="Team"></param>
public void TeamRemove(Team team)
{
try
{
using (NetballEntities context = new NetballEntities())
{
context.Entry(team).State = EntityState.Deleted;
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void AwardDeleteTransaction(Award award)
{
try
{
using (NetballEntities context = new NetballEntities())
{
context.Entry(award).State = EntityState.Deleted;
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Deletes a given QuarterType object.
/// </summary>
/// <param name="QuarterType"></param>
public void QuarterTypeRemove(QuarterType quartertype)
{
try
{
using (NetballEntities context = new NetballEntities())
{
context.Entry(quartertype).State = EntityState.Deleted;
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void TeamPlayerInsert(TeamPlayer teamPlayer)
{
try
{
using (NetballEntities context = new NetballEntities())
{
context.Entry(teamPlayer).State = EntityState.Added;
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void GamePlayerRemove(int gamePlayerID)
{
GamePlayer gamePlayer = new GamePlayer();
using (NetballEntities context = new NetballEntities())
{
gamePlayer = context.GamePlayers
.Where(g => g.GamePlayerID == gamePlayerID)
.FirstOrDefault();
if (gamePlayer != null)
{
GamePlayerRemove(gamePlayer);
}
}
}
public void AwardDeleteTransaction(int awardID)
{
Award award = new Award();
using (NetballEntities context = new NetballEntities())
{
award = context.Awards
.Where(g => g.AwardID == awardID)
.FirstOrDefault();
if (award != null)
{
AwardDeleteTransaction(award);
}
}
}
public IList <QuarterType> GetQuarterTypeList()
{
IList <QuarterType> quartertypeList = new List <QuarterType>();
try
{
using (NetballEntities context = new NetballEntities())
{
quartertypeList = context.QuarterTypes
.ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(quartertypeList);
}
public IList <GameQuarter> GetGameQuarterList()
{
IList <GameQuarter> gamequarterList = new List <GameQuarter>();
try
{
using (NetballEntities context = new NetballEntities())
{
gamequarterList = context.GameQuarters
.ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(gamequarterList);
}
public GameTeamModel GetGameTeamModel(int gameTeamID)
{
GameTeamModel gameTeamModel = new GameTeamModel();
using (NetballEntities context = new NetballEntities())
{
gameTeamModel = context.GameTeams
.Include(g => g.Game)
.Include(g => g.Game.Court)
.Include(g => g.Game.Tournament)
.Include(g => g.Game.Person)
.Include(g => g.Game.Person1)
.Include(g => g.Game.Person2)
.Include(g => g.Game.Person3)
.Include(g => g.Game.Person4)
.Include(g => g.Game.Person5)
.Include(g => g.Game.Person6)
.Include(g => g.Team)
.Where(g => g.GameTeamID == gameTeamID)
.Select(g => new GameTeamModel
{
gameTeamID = g.GameTeamID,
gameID = g.GameID,
courtID = g.Game.CourtID,
courtName = g.Game.Court.Court1,
tournamentID = g.Game.Tournament.TournamentID,
tournamentName = g.Game.Tournament.Tournament1,
matchNo = g.Game.MatchNo,
venue = g.Game.Venue,
datePlayed = g.Game.DatePlayed,
primaryUmpireID = g.Game.Person.PersonID,
primaryUmpire = g.Game.Person.FirstName + " " + g.Game.Person.LastName,
secondaryUmpireID = g.Game.Person1.PersonID,
secondaryUmpire = g.Game.Person1.FirstName + " " + g.Game.Person1.LastName,
reserveUmpireID = g.Game.Person2.PersonID,
reserveUmpire = g.Game.Person2.FirstName + " " + g.Game.Person2.LastName,
teamID = g.TeamID,
teamName = g.Team.TeamName,
finalScore = g.FinalScore ?? 0
})
.FirstOrDefault();
}
return(gameTeamModel);
}