/// <summary> /// Gets a rank by ID /// </summary> /// <param name="output"></param> /// <param name="id"></param> /// <returns></returns> public static bool FetchById(ref Rank output, int id) { SQLiteDataReader reader = DBI.DoPreparedQuery( "SELECT * FROM Rank WHERE id = @id LIMIT 1;", new Tuple <string, object>("@id", id)); if (reader != null && reader.Read()) { output = Rank.Factory(reader); return(true); } return(false); }
/// <summary> /// Gets a rank by name /// </summary> /// <param name="output"></param> /// <param name="name"></param> /// <returns></returns> public static bool FetchByName(ref Rank output, string name) { SQLiteDataReader reader = DBI.DoPreparedQuery( "SELECT * FROM Rank WHERE name = @name LIMIT 1;", new Tuple <string, object>("@name", name)); if (reader != null && reader.Read()) { output = Rank.Factory(reader); return(true); } return(false); }
/// <summary> /// Returns all possible ranks /// </summary> /// <param name="output"></param> /// <returns></returns> public static bool FetchAll(ref List <Rank> output) { output = new List <Rank>(); SQLiteDataReader reader = DBI.DoQuery( "SELECT * FROM Rank ORDER BY ordering ASC"); while (reader != null && reader.Read()) { output.Add(Rank.Factory(reader)); } return(true); }