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 DataTable GetRaceEntry(String ClubID, String BirdCategory, String RaceCategory, DateTime ReleaseDate, String SearchName, String Sender) { DAL.RaceResult raceResult = new DAL.RaceResult(); DataSet dsResult = raceResult.GetRaceEntry(ClubID, BirdCategory, RaceCategory, ReleaseDate, SearchName, Sender); DataTable dtResult = new DataTable(); if (dsResult.Tables.Count > 0) { dtResult = dsResult.Tables[1]; } return(dtResult); }
public DataTable Forecast(string ClubID, String Mobilenumber) { DAL.RaceResult raceResult = new DAL.RaceResult(); DataSet dsResult = raceResult.Forecast(ClubID, Mobilenumber, "Forecast"); DataTable dtResult = new DataTable(); if (dsResult.Tables.Count > 0) { dtResult = dsResult.Tables[0]; } return(dtResult); }
public DataTable SendSticker(string ClubID, String Mobilenumber, string StickerNumber) { DAL.RaceResult raceResult = new DAL.RaceResult(); DataSet dsResult = raceResult.SendSticker(ClubID, Mobilenumber, StickerNumber); DataTable dtResult = new DataTable(); if (dsResult.Tables.Count > 0) { dtResult = dsResult.Tables[0]; } return(dtResult); }
public DataTable GetGroupCategory(String ClubID) { DAL.RaceResult raceResult = new DAL.RaceResult(); DataSet dsResult = raceResult.GetGroupCategory(ClubID); DataTable dtResult = new DataTable(); if (dsResult.Tables.Count > 0) { dtResult = dsResult.Tables[0]; } return(dtResult); }
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; } }
public DataSet GetGroupCategory(String ClubID) { try { DataSet dsResult = new DataSet(); DAL.RaceResult raceResult = new DAL.RaceResult(); dsResult = raceResult.GetGroupCategory(ClubID); return(dsResult); } catch (Exception ex) { throw ex; } }
public DataSet ViewClubRace() { try { raceResult = new DAL.RaceResult(); DataSet dataResult = new DataSet(); PopulateDataLayer(); dataResult = raceResult.ViewClubRace(); return(dataResult); } catch (Exception ex) { throw ex; } }
public DataSet RaceResultAddFromBackup(string source) { try { raceResult = new DAL.RaceResult(); DataSet dataResult = new DataSet(); PopulateDataLayer(); dataResult = raceResult.RaceResultAddFromBackup(source); return(dataResult); } catch (Exception ex) { throw ex; } }
public DataSet RaceResultGetByScheduleCategory() { try { raceResult = new DAL.RaceResult(); DataSet dataResult = new DataSet(); PopulateDataLayer(); dataResult = raceResult.RaceResultGetByScheduleCategory(); return(dataResult); } catch (Exception ex) { throw ex; } }
public DataTable GetBirdCategory(String ClubID) { if (ClubID == null) { ClubID = ""; } DAL.RaceResult raceResult = new DAL.RaceResult(); DataSet dsResult = raceResult.GetBirdCategory(ClubID); DataTable dtResult = new DataTable(); if (dsResult.Tables.Count > 0) { dtResult = dsResult.Tables[0]; } return(dtResult); }
public DataTable GetRaceEntry(String ClubID, String BirdCategory, String RaceCategory, DateTime ReleaseDate, String SearchName, String Sender, String Source = "") { DAL.RaceResult raceResult = new DAL.RaceResult(); if (string.IsNullOrEmpty(BirdCategory)) { BirdCategory = "All"; } if (string.IsNullOrEmpty(RaceCategory)) { RaceCategory = "All"; } DataSet dsResult = raceResult.GetRaceEntry(ClubID, BirdCategory, RaceCategory, ReleaseDate, SearchName, Sender, Source); DataTable dtResult = new DataTable(); if (dsResult.Tables.Count > 0) { dtResult = dsResult.Tables[1]; } return(dtResult); }
public List <ClubData> GetClubList(String UserID) { DAL.RaceResult raceResult = new DAL.RaceResult(); DataSet dtResult = raceResult.GetClubList(UserID); List <ClubData> lClubData = new List <ClubData>(); if (dtResult.Tables.Count > 0) { foreach (DataRow item in dtResult.Tables[0].Rows) { ClubData iClubData = new ClubData(); iClubData.clubID = LWT.Common.LWTSafeTypes.SafeString(item["Club ID"]); iClubData.clubName = LWT.Common.LWTSafeTypes.SafeString(item["Club Name"]); iClubData.clubAbbreviation = LWT.Common.LWTSafeTypes.SafeString(item["Club Abbreviation"]); iClubData.accessNumber = LWT.Common.LWTSafeTypes.SafeString(item["AccessNumber"]); iClubData.daysRemaining = LWT.Common.LWTSafeTypes.SafeString(item["DaysRemaining"]); lClubData.Add(iClubData); } } return(lClubData); }