public RaceResultDetailsData GetRaceDetails(String ClubID, String BirdCategory, String RaceCategory, DateTime ReleaseDate, String SearchName, String Sender)
{
DAL.RaceResult raceResult = new DAL.RaceResult();
DataSet dsResult = raceResult.GetRaceDetails(ClubID, BirdCategory, RaceCategory, ReleaseDate, SearchName, Sender);
DataTable dtResult = new DataTable();
RaceResultDetailsData details = new RaceResultDetailsData();
if (dsResult.Tables.Count > 0)
{
dtResult = dsResult.Tables[0];
if (dtResult.Rows.Count > 0)
{
details.locationName = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["LocationName"]);
details.stopTime = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["StopTime"]);
details.stopFrom = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["StopFrom"]);
details.stopTo = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["StopTo"]);
details.coordinates = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["Coordinates"]);
details.latitude = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["Latitude"]);
details.longtitude = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["Longtitude"]);
details.totalBird = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["TotalBird"]);
details.lap = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["Lap"]);
details.sMSCount = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["SMSCount"]);
details.description = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["Description"]);
details.releaseTime = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["ReleaseTime"]);
details.minSpeed = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["MinSpeed"]);
details.birdEntryCount = LWT.Common.LWTSafeTypes.SafeString(dtResult.Rows[0]["BirdEntryCount"]);
}
}
return(details);
}
public DataSet GetRaceResultDetails(String ClubID, String BirdCategory, String RaceCategory, DateTime ReleaseDate, String SearchName, String Sender)
{
try
{
DataSet dsResult = new DataSet();
DAL.RaceResult raceResult = new DAL.RaceResult();
dsResult = raceResult.GetRaceDetails(ClubID, BirdCategory, RaceCategory, ReleaseDate, SearchName, Sender);
return(dsResult);
}
catch (Exception ex)
{
throw ex;
}
}