public HorseItem GetHorseItem(int horseNo) { SQLiteCommand query = new SQLiteCommand(); query.CommandText = "SELECT horse_no, horse_name, horse_alt, height, owner_name, horse_comment FROM [" + Year + "_horse] WHERE horse_no = @noparam;"; query.CommandType = System.Data.CommandType.Text; query.Parameters.Add(new SQLiteParameter("@noparam", horseNo)); query.Connection = ClubConn; SQLiteDataReader reader = DoTheReader(query); HorseItem item = new HorseItem(); 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); } reader.Close(); ClubConn.Close(); return item; }
// 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; }
// Optional: sort (default is horse_name) public List<HorseItem> GetHorseItemList(string database, int year, string sort) { MySqlDataReader reader; HorseItem item; List<HorseItem> horseItemList = new List<HorseItem>(); if (sort == String.Empty) sort = "horse_name"; reader = GetReader(database, year + "_horse", "horse_no, horse_name, horse_call, height, owner_name", String.Empty, sort); while (reader.Read()) { item = new HorseItem(); item.no = reader.GetInt32(0); item.name = reader.GetString(1); item.callName = reader.GetString(2); item.height = reader.GetDecimal(3); item.ownerName = reader.GetString(4); horseItemList.Add(item); } reader.Close(); connection.Close(); return horseItemList; }