public ClassItem GetClassItem(int classNo) { // Construct and execute the query SQLiteCommand query = new SQLiteCommand(); query.CommandText = "SELECT class_no, category_no, class_name, fee FROM [" + Year + "_class] WHERE class_no = @noparam;"; query.CommandType = System.Data.CommandType.Text; query.Parameters.Add(new SQLiteParameter("@noparam", classNo)); query.Connection = ClubConn; SQLiteDataReader reader = DoTheReader(query); // Read the results ClassItem item = new ClassItem(); while (reader.Read()) { item.No = reader.GetInt32(0); item.CatNo = reader.GetInt32(1); item.Name = reader.GetString(2); item.Fee = reader.GetDecimal(3); } reader.Close(); ClubConn.Close(); return item; }
//Optional: sort (default is class_name) public List<ClassItem> GetClassItemList(string database, int year, string sort) { MySqlDataReader reader; ClassItem item; List<ClassItem> classItemList = new List<ClassItem>(); if (sort == String.Empty) sort = "class_no"; reader = GetReader(database, year + "_class", "class_no, category_no, class_name, fee", String.Empty, sort); while (reader.Read()) { item = new ClassItem(); item.no = reader.GetInt32(0); item.catNo = reader.GetInt32(1); item.name = reader.GetString(2); item.fee = reader.GetDecimal(3); classItemList.Add(item); } reader.Close(); connection.Close(); return classItemList; }
public ClassItem GetClassItem(string database, int year, int classNo) { MySqlDataReader reader; ClassItem item = new ClassItem(); reader = GetReader(database, year + "_class", "class_no, category_no, class_name, fee", "class_no=" + classNo, "class_no"); while(reader.Read()) { item.no = reader.GetInt32(0); item.catNo = reader.GetInt32(1); item.name = reader.GetString(2); item.fee = reader.GetDecimal(3); } reader.Close(); connection.Close(); return item; }
//Optional: sort (default is class_no) public List<ClassItem> GetClassItemList(ClassSort sort = ClassSort.Default) { // Case statment for sort column string sortString; switch (sort) { case ClassSort.Name: sortString = "class_name"; break; case ClassSort.Category: sortString = "category_no"; break; default: sortString = "class_no"; break; } // Construct and execute the query string query = "SELECT class_no, category_no, class_name, fee FROM [" + Year + "_class] ORDER BY " + sortString + ";"; SQLiteDataReader reader = DoTheReader(ClubConn, query); List<ClassItem> classItemList = new List<ClassItem>(); ClassItem item; // Read the results reader = DoTheReader(ClubConn, query); while (reader.Read()) { item = new ClassItem(); item.No = reader.GetInt32(0); item.CatNo = reader.GetInt32(1); item.Name = reader.GetString(2); item.Fee = reader.GetDecimal(3); classItemList.Add(item); } reader.Close(); ClubConn.Close(); return classItemList; }