public BackNumber(string clubID, int year)
{
Database = new DBDriver(1);
this.ClubID = clubID;
this.Year = year;
Number = -1;
BackNoList = Database.GetBackNoItemList();
HorseList = Database.GetHorseItemList(HorseSort.Name);
RiderList = Database.GetRiderItemList();
}
public Horse(string clubID, int year)
{
Database = new DBDriver(1);
this.ClubID = clubID;
this.Year = year;
Number = Database.GetNextIndex(ItemType.Horse);
BackNoList = Database.GetBackNoItemList(BackNoFilter.Horse, Number);
HorseList = Database.GetHorseItemList(HorseSort.Name);
RiderList = Database.GetRiderItemList();
}
public Horse(string clubID, int year, int horseNo)
{
Database = new DBDriver(1);
this.ClubID = clubID;
this.Year = year;
this.Number = horseNo;
SetHorseData();
BackNoList = Database.GetBackNoItemList(BackNoFilter.Horse, Number);
HorseList = Database.GetHorseItemList();
RiderList = Database.GetRiderItemList();
}
public Rider(string clubID, int year)
{
Database = new DBDriver(1);
this.ClubID = clubID;
this.Year = year;
Number = Database.GetNextIndex(ItemType.Rider);
Birthdate = (DateTime.Now);
BackNoList = Database.GetBackNoItemList(BackNoFilter.Rider, Number);
HorseList = Database.GetHorseItemList();
RiderList = Database.GetRiderItemList();
}
public BackNumber(string clubID, int year, int backNo)
{
Database = new DBDriver(1);
this.ClubID = clubID;
this.Year = year;
this.Number = backNo;
SetBackNoData();
BackNoList = Database.GetBackNoItemList();
HorseList = Database.GetHorseItemList(HorseSort.Name);
ResultList = Database.GetResultItemList(ResultFilter.BackNo, backNo);
RiderList = Database.GetRiderItemList();
}
// To be implemented at a later date:
//public bool isTimed { get; private set; }
//public bool isPayout { get; private set; }
//public bool isJackpot { get; private set; }
//public decimal fee { get; private set; }
public ClassInstance(string clubID, int year, int showNo, int classNo)
{
database = new DBDriver(1);
this.clubID = clubID;
this.year = year;
this.classNo = classNo;
this.showNo = showNo;
qualifier = "s.show_no = " + showNo + " AND s.class_no = " + classNo;
classList = database.GetClassItemList(clubID, year, String.Empty);
backNoList = database.GetBackNoItemList(clubID, year, String.Empty);
// entryList = database.GetEntryList(clubID, year, String.Empty, qualifier);
// placingList = database.GetEntryList(clubID, year, "place", "place IS NOT NULL AND show_no = " + showNo +
// " AND class_no = " + classNo);
className = database.GetValueString(clubID, year + "_class_list", "name", "class_no = " + classNo);
showDate = database.GetValueString(clubID, year + "_show_list", "date", "show_no = " + showNo);
// entryCount = database.CountValue(clubID, year + "_results", "back_no", "class_no = " + classNo + " AND show_no = " + showNo);
}
// To be implemented at a later date:
//public bool isTimed { get; private set; }
//public bool isPayout { get; private set; }
//public bool isJackpot { get; private set; }
//public decimal fee { get; private set; }
public Result(string clubID, int year, int showNo, int classNo)
{
Database = new DBDriver(1);
ActiveSettings = new Settings(clubID, year);
this.ClubID = clubID;
this.Year = year;
this.ClassNo = classNo;
this.ShowNo = showNo;
ClassList = Database.GetClassItemList();
BackNoList = Database.GetBackNoItemList();
// entryList = database.GetEntryList(clubID, year, String.Empty, qualifier);
// placingList = database.GetEntryList(clubID, year, "place", "place IS NOT NULL AND show_no = " + showNo +
// " AND class_no = " + classNo);
// className = database.GetValueString(clubID, year + "_class_list", "name", "class_no = " + classNo);
// showDate = database.GetValueString(clubID, year + "_show_list", "date", "show_no = " + showNo);
// entryCount = database.CountValue(clubID, year + "_results", "back_no", "class_no = " + classNo + " AND show_no = " + showNo);
}
