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 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 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(); }
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(); }
// 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(); }
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); }
static void Main() { // Startup process: Check DB, create trot_trax.trax if necessary. // Check for existence of initial tables. DBDriver database = new DBDriver(); if (database.Connected) { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); // Check for an existing club if (database.HasCurrent()) Application.Run(new ShowYearForm(1)); else Application.Run(new ShowYearForm()); return; } else { DialogResult confirm = MessageBox.Show("Fatal error: Unable to contact database.", "TrotTrax Alert", MessageBoxButtons.OK); return; } }
public YearChooserForm() { database = new DBDriver(0); InitializeComponent(); }
public ClubChooserForm() { database = new DBDriver(); InitializeComponent(); }