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