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