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; }
public static List<TournamentTeamRace> TeamRaces(int tournamentTeamID) { FlyballDB db = new FlyballDB(); StoredProcedure sp = db.Tournament_Races(); sp.Command.AddParameter("@tournamentTeamID", tournamentTeamID, DbType.Int64); sp.Execute(); IDataReader rdr = sp.ExecuteReader(); List<TournamentTeamRace> races = new List<TournamentTeamRace>(); while (rdr.Read()) { TournamentTeamRace race = new TournamentTeamRace(); race.RaceNumber= rdr["RaceNumber"].ToString(); race.Opponent = rdr["Opponent"].ToString(); race.NumberOfHeats = rdr["NumberOfHeats"].ToString(); race.RaceID = rdr["RaceID"].ToString(); races.Add(race); } return races; }
private static List<decimal> AllStartTimes(int crn, int tournamentTeamID) { FlyballDB db = new FlyballDB(); StoredProcedure sp = db.Dog_StartDogTimesWithStartByTournament(); sp.Command.AddParameter("@crn", crn, DbType.Int64); sp.Command.AddParameter("@tournamentTeamID", tournamentTeamID, DbType.Int64); sp.Execute(); IDataReader rdr = sp.ExecuteReader(); List<decimal> times = new List<decimal>(); while (rdr.Read()) { if (rdr[1] != DBNull.Value) { times.Add(Convert.ToDecimal(rdr[1])); } } return times; }
public static string OverallAverageTime(int tournamentTeamID) { FlyballDB db = new FlyballDB(); StoredProcedure sp = db.TournamentDog_AverageTime(); sp.Command.AddParameter("@tournamentteamdogid", tournamentTeamID, DbType.Int64); sp.Execute(); IDataReader rdr = sp.ExecuteReader(); string time = null; while (rdr.Read()) { time = rdr["avgTime"].ToString(); } return time; }
public static List<TournamentStats> TournamentStats(int tournamentTeamID) { FlyballDB db = new FlyballDB(); StoredProcedure sp = db.Tournament_DogTimes(); sp.Command.AddParameter("@tournamentTeamID", tournamentTeamID, DbType.Int64); sp.Execute(); IDataReader reader = sp.ExecuteReader(); List<TournamentStats> stats = new List<TournamentStats>(); while (reader.Read()) { TournamentStats stat = new TournamentStats(); stat.DogName = reader["Name"].ToString(); stat.CRN = reader["CRN"].ToString(); stat.AverageStartTime = reader["AvgStartTime"].ToString(); stat.AverageLineToLine = reader["DogAverageLineToLine"].ToString(); stat.AverageStartDogTime = reader["AvgStartDog"].ToString(); stat.AverageTime = reader["AverageDog"].ToString(); stat.FastestStartTime = reader["FastestStartTime"].ToString(); stat.FastestLineToLine = reader["DogFastestLineToLine"].ToString(); stat.FastestStartDogTime = reader["FastestStartDog"].ToString(); stat.FastestTime = reader["FastestDog"].ToString(); stats.Add(stat); } return stats; }