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