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