public static List<TourneyDogSummary> DogSummary(int tournamentTeamID)
{
FlyballDB db = new FlyballDB();
StoredProcedure sp = db.Tournament_DogSummary();
sp.Command.AddParameter("@tournamentTeamID", tournamentTeamID, DbType.Int64);
sp.Execute();
IDataReader rdr = sp.ExecuteReader();
List<TourneyDogSummary> summary = new List<TourneyDogSummary>();
while (rdr.Read())
{
TourneyDogSummary tdogSum = new TourneyDogSummary();
tdogSum.CRN = rdr["crn"].ToString();
tdogSum.Handler = rdr["handler"].ToString();
tdogSum.Heats = rdr["Heats"].ToString();
tdogSum.Name = rdr["Name"].ToString();
tdogSum.Points = rdr["Points"].ToString();
summary.Add(tdogSum);
}
return summary;
}
