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