public List <LapInformation> GetRaceLapTimes(string _raceId)
{
List <LapInformation> retValue = new List <LapInformation>();
int intRaceId;
if (int.TryParse(_raceId, out intRaceId))
{
using (CX418DataAccess.cx418timingEntities context = new CX418DataAccess.cx418timingEntities())
{
var laps = (from t in context.LapTimes
where t.RaceId == intRaceId
select t);
foreach (var lapEntity in laps)
{
LapInformation newLapInfo = new LapInformation(lapEntity);
retValue.Add(newLapInfo);
}
}
}
return(retValue);
}
public int AddLapTime(LapInformation _lapInfo)
{
int curLapTimeSeconds = 0;
using (CX418DataAccess.cx418timingEntities context = new CX418DataAccess.cx418timingEntities())
{
//context.LapTimes.Add(new CX418DataAccess.LapTime { bib = _bib.ToString(), LapTime1 = DateTime.Now, RaceId = _raceId });
//context.LapTimes.Add(new CX418DataAccess.LapTime { bib = _lapInfo.BibId.ToString(), LapTime1 = _lapInfo.LapTime, RaceId = _lapInfo.RaceId });
curLapTimeSeconds = context.sp_InsertLapTime(_lapInfo.BibId, _lapInfo.RaceId, _lapInfo.LapEndTime);
//rowChange = context.SaveChanges();
}
return(curLapTimeSeconds); // rowChange == 1 ? true : false;
}
public LapInformation GetLastLapTime(string _racerBid, string _raceId)
{
int intRaceId;
LapInformation retValue = null;
if (int.TryParse(_raceId, out intRaceId))
{
using (CX418DataAccess.cx418timingEntities context = new CX418DataAccess.cx418timingEntities())
{
var lapInfo = (from t in context.LapTimes
where t.RaceId == intRaceId && t.bib == _racerBid
select t).FirstOrDefault();
if (lapInfo != null)
{
retValue = new LapInformation(lapInfo);
}
}
}
return(retValue);
}
