public CategoryItem GetCategoryItem(int catNo) { // Construct and execute the query SQLiteCommand query = new SQLiteCommand(); query.CommandText = "SELECT category_no, category_name, timed FROM [" + Year + "_category] WHERE category_no = @noparam;"; query.CommandType = System.Data.CommandType.Text; query.Parameters.Add(new SQLiteParameter("@noparam", catNo)); query.Connection = ClubConn; SQLiteDataReader reader = DoTheReader(query); // Read the results CategoryItem item = new CategoryItem(); while (reader.Read()) { item.No = reader.GetInt32(0); item.Name = reader.GetString(1); item.Timed = (bool)IntToBool(reader.GetInt32(2)); } reader.Close(); ClubConn.Close(); return item; }
// Optional: sort (default is category_no) public List<CategoryItem> GetCategoryItemList(string database, int year, string sort) { MySqlDataReader reader; CategoryItem item; List<CategoryItem> CatItemList = new List<CategoryItem>(); if (sort == String.Empty) sort = "category_no"; reader = GetReader(database, year + "_category", "category_no, category_name, timed", String.Empty, sort); while (reader.Read()) { item = new CategoryItem(); item.no = reader.GetInt32(0); item.name = reader.GetString(1); item.timed = reader.GetBoolean(2); CatItemList.Add(item); } reader.Close(); connection.Close(); return CatItemList; }
public CategoryItem GetCategoryItem(string database, int year, int catNo) { MySqlDataReader reader; CategoryItem item = new CategoryItem(); reader = GetReader(database, year + "_category", "category_no, category_name, timed", "category_no=" + catNo, "category_no"); while (reader.Read()) { item.no = reader.GetInt32(0); item.name = reader.GetString(1); item.timed = reader.GetBoolean(2); } reader.Close(); connection.Close(); return item; }
// Optional: sort (default is category_no) public List<CategoryItem> GetCategoryItemList(CategorySort sort = CategorySort.Default) { // Case statment for sort column string sortString; switch (sort) { case CategorySort.Name: sortString = "category_name"; break; case CategorySort.Timed: sortString = "timed"; break; default: sortString = "category_no"; break; } // Construct and execute the query string query = "SELECT category_no, category_name, timed FROM [" + Year + "_category] ORDER BY " + sortString + ";"; SQLiteDataReader reader = DoTheReader(ClubConn, query); List<CategoryItem> catItemList = new List<CategoryItem>(); CategoryItem item; // Read the results while (reader.Read()) { item = new CategoryItem(); item.No = reader.GetInt32(0); item.Name = reader.GetString(1); item.Timed = (bool)IntToBool(reader.GetInt32(2)); catItemList.Add(item); } reader.Close(); ClubConn.Close(); return catItemList; }