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