public Run FindById(int raceId, int runNo)
{
return(template.QueryById("select * from Run where raceId=@raceId and runNo=@runNo",
MapRowToRun,
new QueryParameter("@raceId", raceId),
new QueryParameter("@runNo", runNo)));
}
public StartListMember FindByIds(int raceId, int skierId, int runNo)
{
return(template.QueryById(
@"select * from startlist where raceId=@raceId and skierId=@skierId and runNo=@runNo",
MapRowToStartList,
new QueryParameter("@raceId", raceId),
new QueryParameter("@skierId", skierId),
new QueryParameter("@runNo", runNo)));
}
public SplitTime FindByIds(int raceDataId, int runNo, int splittimeNo)
{
return(template.QueryById(
@"select * from Splittime where racedataId=@raceDataId and runNo=@runNo and splittimeNo=@splittimeNo",
MapRowToSplittime,
new QueryParameter("@raceDataId", raceDataId),
new QueryParameter("@runNo", runNo),
new QueryParameter("@splittimeNo", splittimeNo)));
}
public RaceData FindById(int id)
{
return(template.QueryById("select * from RaceData where id=@id",
MapRowToRaceData,
new QueryParameter("@id", id)));
}
public Skier FindById(int id)
{
return(template.QueryById("select * from skier where id=@id",
MapRowToSkier,
new QueryParameter("@id", id)));
}
public Race FindById(int id)
{
return(template.QueryById("select * from race where id=@id and deleted = 0",
MapRowToRace,
new QueryParameter("@id", id)));
}
public Status FindById(int id)
{
return(template.QueryById("select * from Status where id=@id",
MapRowToStatus,
new QueryParameter("@id", id)));
}