public override IReadOnlyList <TrainingRun> Translate(SqlCommand command, IDataRowReader reader) { var trainingRuns = new List <TrainingRun>(); if (!reader.Read()) { return(null); } do { int averageHR = 0; if (!reader.IsDbNull("AvgHeartRate")) { averageHR = reader.GetValue <int>("AvgHeartRate"); } int isArchived = 0; if (!reader.IsDbNull("isArchived")) { isArchived = reader.GetValue <int>("isArchived"); } trainingRuns.Add(new TrainingRun( reader.GetInt32("TrainingRunId"), runnerId, reader.GetValue <DateTime>("Date"), reader.GetInt32("Distance"), reader.GetInt32("Time"), averageHR, isArchived )); } while (reader.Read()); return(trainingRuns); }
public override Team Translate(SqlCommand command, IDataRowReader reader) { int EndYear = 0; if (reader.Read()) { if (!reader.IsDbNull("EndYear")) { EndYear = reader.GetInt32("EndYear"); } return(new Team( reader.GetInt32("TeamId"), reader.GetInt32("CoachId"), name, reader.GetInt32("StartYear"), EndYear, reader.GetValue <DateTimeOffset>("CreatedOn"), reader.GetValue <DateTimeOffset>("UpdatedOn") )); } else { return(null); } }
public override IReadOnlyList <Team> Translate(SqlCommand command, IDataRowReader reader) { var teams = new List <Team>(); if (!reader.Read()) { return(null); } do { int EndYear = 0; if (!reader.IsDbNull("EndYear")) { EndYear = reader.GetInt32("EndYear"); } teams.Add(new Team( reader.GetInt32("TeamId"), coachId, reader.GetString("Name"), reader.GetInt32("StartYear"), EndYear, reader.GetValue <DateTimeOffset>("CreatedOn"), reader.GetValue <DateTimeOffset>("UpdatedOn") )); } while (reader.Read()); return(teams); }
public override Runner Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { return(null); } int endYear = 0; if (!reader.IsDbNull("EndYear")) { endYear = reader.GetInt32("EndYear"); } return(new Runner( runnerId, reader.GetInt32("TeamId"), reader.GetInt32("StartYear"), endYear)); }
public override IReadOnlyList <Runner> Translate(SqlCommand command, IDataRowReader reader) { var runners = new List <Runner>(); while (reader.Read()) { int endYear = 0; if (!reader.IsDbNull("EndYear")) { endYear = reader.GetInt32("EndYear"); } runners.Add(new Runner( reader.GetInt32("RunnerId"), teamId, reader.GetInt32("StartYear"), endYear)); } return(runners); }
public override Coach Translate(SqlCommand command, IDataRowReader reader) { if (!reader.Read()) { return(null); } int endYear = 0; if (!reader.IsDbNull("EndYear")) { endYear = reader.GetInt32("EndYear"); } return(new Coach( coachId, reader.GetInt32("StartYear"), endYear )); }
public override IReadOnlyList <RunnerNameAndTeam> Translate(SqlCommand command, IDataRowReader reader) { var runners = new List <RunnerNameAndTeam>(); if (!reader.Read()) { return(null); } do { int EndYear = 0; if (!reader.IsDbNull("EndYear")) { EndYear = reader.GetInt32("EndYear"); } runners.Add(new RunnerNameAndTeam( reader.GetString("RunnerName"), reader.GetString("TeamName"), reader.GetInt32("StartYear"), EndYear)); } while (reader.Read()); return(runners); }