private IEnumerable<Team> FetchTeamsByConference(Conference conference, Context context)
{
var query = (from teams in context.Teams
where teams.ConfRefNum == conference.RefNum
select teams).ToList();
return query;
}
private IEnumerable<TeamRecord> FetchRecordsByTeams(Conference conference, Context context, string gamePhase)
{
IEnumerable<Team> teamList = FetchTeamsByConference(conference, context);
ICollection<TeamRecord> conferenceRecords = new List<TeamRecord>();
foreach (Team team in teamList)
{
var recordList = (from tr in context.TeamRecords
where tr.TeamRefNum == team.RefNum && tr.GamePhase == gamePhase
select tr).ToList();
if (recordList != null)
{
foreach (var record in recordList)
{
conferenceRecords.Add(record);
}
}
}
return conferenceRecords;
}
//============== Constructors =============//
public ConferenceService(int id)
{
_id = id;
_context = new Context();
_conference = Conference(_context, _id);
}
//============== Constructors =============//
public ConferenceViewModel(int id)
{
_conferenceService = new ConferenceService(id);
_conference = _conferenceService.Conference();
}
