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