public Show(string clubID, int year)
{
Database = new DBDriver(1);
this.Year = year;
this.ClubID = clubID;
Number = Database.GetNextIndex(ItemType.Show);
ClassList = Database.GetClassItemList();
ShowList = Database.GetShowItemList();
}
public Show(string clubID, int year, int number)
{
Database = new DBDriver(1);
this.Year = year;
this.ClubID = clubID;
this.Number = number;
SetShowData();
ClassList = Database.GetClassItemList();
ShowList = Database.GetShowItemList();
}
// Existing category item.
public Category(string clubID, int year, int number)
{
Database = new DBDriver(1);
this.ClubID = clubID;
this.Year = year;
this.Number = number;
SetCategoryData();
ClassList = Database.GetClassItemList();
CatList = Database.GetCategoryItemList();
}
// New category item.
public Category(string clubID, int year)
{
Database = new DBDriver(1);
this.ClubID = clubID;
this.Year = year;
// If this is a new item, pull in the next number from the database.
Number = Database.GetNextIndex(ItemType.Category);
ClassList = Database.GetClassItemList();
CatList = Database.GetCategoryItemList();
}
// 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);
}
