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