// Optional: sort (default is horse_name)
public List<HorseItem> GetHorseItemList(HorseSort sort = HorseSort.Default)
{
// Case statment for sort column
string sortString;
switch (sort)
{
case HorseSort.Name: sortString = "horse_name"; break;
case HorseSort.CallName: sortString = "horse_alt"; break;
case HorseSort.Owner: sortString = "owner_name, horse_name"; break;
default: sortString = "horse_no"; break;
}
string query = "SELECT horse_no, horse_name, horse_alt, height, owner_name, horse_comment FROM [" + Year +
"_horse] ORDER BY " + sortString + ";";
SQLiteDataReader reader = DoTheReader(ClubConn, query);
List<HorseItem> horseItemList = new List<HorseItem>();
HorseItem item;
reader = DoTheReader(ClubConn, query);
while (reader.Read())
{
item = new HorseItem();
item.No = reader.GetInt32(0);
item.Name = reader.GetString(1);
item.AltName = reader.GetString(2);
item.Height = reader.GetString(3);
item.OwnerName = reader.GetString(4);
item.Comments = reader.GetString(5);
horseItemList.Add(item);
}
reader.Close();
ClubConn.Close();
return horseItemList;
}
public void SortHorses(HorseSort sort)
{
HorseList = Database.GetHorseItemList(sort);
}
